Aplus Framework Docs
Explain
in package
Class Explain.
Tags
Table of Contents
Properties
- $explain : string
- EXPLAIN FORMAT=JSON is a variant of EXPLAIN command that produces output in JSON form.
- $extra : string
- Extra information about this join.
- $filtered : float
- The EXTENDED keyword adds another column, filtered, to the output. This is a percentage estimate of the table rows that will be filtered by the condition.
- $id : int
- Sequence number that shows in which order tables are joined.
- $key : string|null
- The name of the key that is used to retrieve rows. NULL is no key was used.
- $keyLen : string|null
- How many bytes of the key that was used (shows if we are using only parts of the multi-column key).
- $possibleKeys : string|null
- keys in table that could be used to find rows in the table.
- $ref : string|null
- The reference that is used as the key value.
- $rows : string
- An estimate of how many rows we will find in the table for each key lookup.
- $selectType : string
- What kind of SELECT the table comes from.
- $table : string
- Alias name of table. Materialized temporary tables for sub queries are named <subquery#>.
- $type : string
- How rows are found from the table (join type).
Methods
- __construct() : mixed
Properties
$explain
EXPLAIN FORMAT=JSON is a variant of EXPLAIN command that produces output in JSON form.
public
string
$explain
Tags
$extra
Extra information about this join.
public
string
$extra
Tags
$filtered
The EXTENDED keyword adds another column, filtered, to the output. This is a percentage estimate of the table rows that will be filtered by the condition.
public
float
$filtered
Tags
$id
Sequence number that shows in which order tables are joined.
public
int
$id
$key
The name of the key that is used to retrieve rows. NULL is no key was used.
public
string|null
$key
$keyLen
How many bytes of the key that was used (shows if we are using only parts of the multi-column key).
public
string|null
$keyLen
$possibleKeys
keys in table that could be used to find rows in the table.
public
string|null
$possibleKeys
$ref
The reference that is used as the key value.
public
string|null
$ref
$rows
An estimate of how many rows we will find in the table for each key lookup.
public
string
$rows
$selectType
What kind of SELECT the table comes from.
public
string
$selectType
Tags
$table
Alias name of table. Materialized temporary tables for sub queries are named <subquery#>.
public
string
$table
$type
How rows are found from the table (join type).
public
string
$type
Tags
Methods
__construct()
public
__construct(stdClass $result) : mixed
Parameters
- $result : stdClass