Database Collector

Captures SQL queries, parameters, execution time, transactions, and duplicate query detection.

What It Captures

Field	Description
sql	SQL query with parameter placeholders
rawSql	SQL query with parameters inlined
params	Bound parameters array
line	Source file and line of the query call
status	Query status (success or error)
rowsNumber	Number of affected/returned rows
exception	Exception if query failed
transactionId	Associated transaction ID

Data Schema

{
    "queries": [
        {
            "position": 0,
            "transactionId": null,
            "sql": "SELECT * FROM users WHERE id = :id",
            "rawSql": "SELECT * FROM users WHERE id = 42",
            "params": {":id": 42},
            "line": "/app/src/UserRepository.php:35",
            "status": "success",
            "rowsNumber": 1,
            "exception": null,
            "actions": []
        }
    ],
    "transactions": {},
    "duplicates": {
        "groups": [],
        "totalDuplicatedCount": 0
    }
}

Summary (shown in debug entry list):

{
    "db": {
        "queries": {"error": 0, "total": 3},
        "transactions": {"error": 0, "total": 1},
        "duplicateGroups": 0,
        "totalDuplicatedCount": 0
    }
}

Contract

Query lifecycle

use AppDevPanel\Kernel\Collector\DatabaseCollector;

// Option A: start/end pattern
$collector->collectQueryStart(
    id: 'query-1',
    sql: 'SELECT * FROM users WHERE id = :id',
    rawSql: 'SELECT * FROM users WHERE id = 42',
    params: [':id' => 42],
    line: '/app/src/UserRepository.php:35',
);
$collector->collectQueryEnd(id: 'query-1', rowsNumber: 1);

// Option B: single record
use AppDevPanel\Kernel\Collector\QueryRecord;

$collector->logQuery(new QueryRecord(
    sql: 'SELECT * FROM users WHERE id = :id',
    rawSql: 'SELECT * FROM users WHERE id = 42',
    params: [':id' => 42],
    duration: 0.0023,
    line: '/app/src/UserRepository.php:35',
));

Transactions

$collector->collectTransactionStart(isolationLevel: 'READ COMMITTED', line: '...');
$collector->collectTransactionEnd(status: 'commit', line: '...');

INFO

DatabaseCollectorAppDevPanel\Kernel\Collector\DatabaseCollectorCaptures SQL queries and transactions from the application.final Kernel · class · implements SummaryCollectorInterface implements SummaryCollectorInterfaceAppDevPanel\Kernel\Collector\SummaryCollectorInterfaceSummary data collector responsibility is to collect summary data for a collector. Summary is used to display a list of previous requests and select one to display full info. Its data set is specific to the list and is reduced compared to full data collected in {@see CollectorInterface}.Kernel · interface · extends CollectorInterface, depends on TimelineCollectorAppDevPanel\Kernel\Collector\TimelineCollectorCollects Timeline data during application lifecycle.final Kernel · class · implements SummaryCollectorInterface, and uses DuplicateDetectionTraitAppDevPanel\Kernel\Collector\DuplicateDetectionTraitDetects duplicate items in collector data by grouping them by a key.Kernel · trait for detecting repeated queries.

How It Works

Framework adapters intercept database operations through framework-specific hooks:

• Symfony: Doctrine DBAL middleware
• Laravel: DB query listener
• Yii 2: Log target for DB profiling messages
• Yii 3: Query event listeners

Debug Panel

• Query count and total time — summary header with aggregate stats
• SQL syntax highlighting — queries displayed with keyword coloring
• Query type badges — SELECT, INSERT, UPDATE, DELETE color-coded
• Row count and timing — per-query execution metrics
• Explain plan — visual EXPLAIN plan tree for SELECT queries
• Duplicate detection — highlights repeated identical queries
• Transaction grouping — queries grouped by transaction boundaries