Log Queries Table Schema (log_queries)


Description

Logged database queries.

log_queries table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
qtype mediumint 5 null

query type constant

sqltext longtext 2147483647 null

query sql

sqlparams longtext 2147483647 null

query parameters

error mediumint 5 0

is error

info longtext 2147483647 null

detailed info such as error text

backtrace longtext 2147483647 null

php execution trace

exectime decimal 10 null

query execution time in seconds as float

timelogged bigint 10 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