requestSqlQueries

An object representing a list of SQL queries for a single request for Z-Ray.

Parameter

 Type

Count

Description

id

Integer

1

SQL query ID.

transactionId

Integer

1

Common identifier of a transaction for queries that are part of that transaction. A value of -1 means that this query is not a part of any explicit transaction. Depending on implementation, a database may implicitly run a query in a transaction. Note that transactionIds are assigned to any query that is part of the transaction untill it is explicitly committed or rolledback. This means that a transaction that was aborted due to error may still accumulate queries.

fileName

String

1

The full path of the file where the SQL query was called from

lineNumber

Integer

1

The line number in the file where the SQL query was called from

success

String

1

Status of query - One of ‘success’, ‘error’, ‘warning’, 'asynchronous' or ‘unknown’.

affectedRows

Integer

1

The amount of rows affected.

string

String

1

The query string.

queryTime

Integer

1

Microtime for query execution time.

errorMessage

String

1

Attached error or warning message for the query.

backtraceId

Integer

1

Id of the backtrace for the log entry.

Version: 1.8