Console
A seleção atual não contém uma única coluna. As funções edição em grade, checkbox, editar, copiar e apagar não estão disponíveis. Mostrando registros 0 - 19 (20 no total, Consulta levou 1.7280 segundos.)
SELECT * FROM `x$session`
| Filtrar linhas: |
| thd_id | conn_id | user | db | command | state | time | current_statement | execution_engine | statement_latency | progress | lock_latency | cpu_latency | rows_examined | rows_sent | rows_affected | tmp_tables | tmp_disk_tables | full_scan | last_statement | last_statement_latency | current_memory | last_wait | last_wait_latency | source | trx_latency | trx_state | trx_autocommit | pid | program_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47734 | 45975 | phpmyadmin@localhost | phpmyadmin | Sleep | NULL | 2 | NULL | PRIMARY | NULL | NULL | 4000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SELECT CONCAT(`db_name`, '.', `table_name`, '.', `... | 342590000 | 1066523 | NULL | NULL | NULL | 136307000 | COMMITTED | YES | NULL | NULL | |
| 47736 | 45977 | phpmyadmin@localhost | phpmyadmin | Sleep | NULL | 2 | NULL | PRIMARY | NULL | NULL | 7000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SELECT CONCAT(`db_name`, '.', `table_name`, '.', `... | 603736000 | 1066523 | NULL | NULL | NULL | 235592000 | COMMITTED | YES | NULL | NULL | |
| 47735 | 45976 | fiscco@localhost | sys | Query | executing | 1 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | PRIMARY | 1507331234000 | NULL | 2000000 | 0 | 0 | 0 | 0 | 1 | 0 | YES | NULL | NULL | 1132732 | NULL | NULL | NULL | 259591000 | COMMITTED | YES | NULL | NULL | |
| 47758 | 45998 | fiscco@localhost | mysql | Query | statistics | 1 | SHOW SESSION VARIABLES LIKE 'character_set_server' | PRIMARY | 787097905000 | NULL | 4000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | NULL | NULL | 1132734 | NULL | NULL | NULL | 15296453000 | COMMITTED | YES | NULL | NULL | |
| 47757 | 45997 | phpmyadmin@localhost | NULL | Sleep | NULL | 1 | NULL | PRIMARY | NULL | NULL | 6000000 | 0 | 1 | 1 | 0 | 0 | 0 | NO | SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... | 2258424000 | 30208 | NULL | NULL | NULL | 129361000 | COMMITTED | YES | NULL | NULL | |
| 47756 | 45996 | fiscco@localhost | sys | Query | Creating tmp table | 1 | SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... | PRIMARY | 762939928000 | NULL | 8000000 | 0 | 0 | 0 | 0 | 0 | 0 | YES | NULL | NULL | 2753086 | NULL | NULL | NULL | 761840313000 | ACTIVE | YES | NULL | NULL | |
| 47755 | 45995 | phpmyadmin@localhost | NULL | Sleep | NULL | 1 | NULL | PRIMARY | NULL | NULL | 3000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SELECT `master_field`, `foreig... |
37262536000 | 17872 | NULL | NULL | NULL | 36313228000 | COMMITTED | YES | NULL | NULL | |
| 47750 | 45994 | fiscco@localhost | sys | Query | Opening tables | 1 | SHOW TABLES LIKE 'session' | PRIMARY | 616679092000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NO | NULL | NULL | 441969 | NULL | NULL | NULL | 886003000 | COMMITTED | YES | NULL | NULL | |
| 47749 | 45989 | fiscco@localhost | sys | Query | executing | 1 | SELECT * FROM `x$session` LIMIT 0, 25 | PRIMARY | 1584076421000 | NULL | 17681000000 | 0 | 0 | 0 | 0 | 4 | 0 | YES | NULL | NULL | 9016820 | NULL | NULL | NULL | 11129675000 | COMMITTED | YES | NULL | NULL | |
| 47748 | 45988 | phpmyadmin@localhost | phpmyadmin | Sleep | NULL | 1 | NULL | PRIMARY | NULL | NULL | 4000000 | 0 | 1 | 1 | 0 | 0 | 0 | NO | SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... | 3936766000 | 1085003 | NULL | NULL | NULL | 77213000 | COMMITTED | YES | NULL | NULL | |
| 47746 | 45986 | phpmyadmin@localhost | phpmyadmin | Sleep | NULL | 1 | NULL | PRIMARY | NULL | NULL | 4000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SELECT `prefs` FROM `phpmyadmin`.`pma__table_uipre... | 5870831000 | 1106120 | NULL | NULL | NULL | 4048074000 | COMMITTED | YES | NULL | NULL | |
| 47737 | 45978 | fiscco@localhost | sys | Query | statistics | 1 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | PRIMARY | 1498185326000 | NULL | 4000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | NULL | NULL | 1132732 | NULL | NULL | NULL | 432643000 | COMMITTED | YES | NULL | NULL | |
| 47747 | 45987 | fiscco@localhost | sys | Sleep | NULL | 0 | NULL | PRIMARY | NULL | NULL | 11000000 | 0 | 206 | 101 | 0 | 0 | 0 | NO | SHOW TABLES FROM `sys` | 13689871000 | 1087017 | NULL | NULL | NULL | 7299774000 | COMMITTED | YES | NULL | NULL | |
| 47745 | 45985 | phpmyadmin@localhost | phpmyadmin | Query | freeing items | 0 | SELECT `display_field` FROM `phpmy... |
PRIMARY | 1146722000 | NULL | 4000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | NULL | NULL | 1087640 | NULL | NULL | NULL | 58766000 | COMMITTED | YES | NULL | NULL | |
| 47751 | 45990 | phpmyadmin@localhost | phpmyadmin | Sleep | NULL | 0 | NULL | PRIMARY | NULL | NULL | 5000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SELECT `master_field`, `foreig... |
16728894000 | 1087640 | NULL | NULL | NULL | 15796421000 | COMMITTED | YES | NULL | NULL | |
| 47753 | 45991 | fiscco@localhost | information_schema | Query | statistics | 0 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | PRIMARY | 369650236000 | NULL | 4000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | NULL | NULL | 1173424 | NULL | NULL | NULL | 557233000 | COMMITTED | YES | NULL | NULL | |
| 47744 | 45999 | phpmyadmin@localhost | information_schema | Query | Opening tables | 0 | SHOW TABLES FROM `phpmyadmin` | PRIMARY | 346425874000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NO | NULL | NULL | 216848 | NULL | NULL | NULL | 660329000 | COMMITTED | YES | NULL | NULL | |
| 47741 | 45982 | fiscco@localhost | sys | Sleep | NULL | 0 | NULL | PRIMARY | NULL | NULL | 3000000 | 0 | 6 | 1 | 0 | 0 | 0 | NO | SELECT TABLE_NAME FROM information_sch... |
1038031000 | 1491004 | NULL | NULL | NULL | 190362000 | COMMITTED | YES | NULL | NULL | |
| 47740 | 45981 | phpmyadmin@localhost | phpmyadmin | Sleep | NULL | 0 | NULL | PRIMARY | NULL | NULL | 5000000 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SELECT CONCAT(`db_name`, '.', `table_name`, '.', `... | 499825000 | 1066523 | NULL | NULL | NULL | 222570000 | COMMITTED | YES | NULL | NULL | |
| 47759 | 46000 | fiscco@localhost | NULL | Sleep | NULL | 0 | NULL | PRIMARY | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NO | SET lc_messages = 'en_US' | 313694000 | 46269 | NULL | NULL | NULL | 6280481000 | COMMITTED | YES | NULL | NULL |
| Filtrar linhas: |