log_queries table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||
| qtype | MEDIUMINT | 7 | null |
|
|
query type constant |
||
| sqltext | LONGTEXT | 2147483647 | null |
|
|
query sql |
||
| sqlparams | LONGTEXT | 2147483647 | √ | null |
|
|
query parameters |
|
| error | MEDIUMINT | 7 | 0 |
|
|
is error |
||
| info | LONGTEXT | 2147483647 | √ | null |
|
|
detailed info such as error text |
|
| backtrace | LONGTEXT | 2147483647 | √ | null |
|
|
php execution trace |
|
| exectime | DECIMAL | 10,5 | null |
|
|
query execution time in seconds as float |
||
| timelogged | BIGINT | 19 | null |
|
|
timestamp when log info stored into db |
Table contained -1 rows
log_queries table indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |