https://db.telcom24.pl/warehouse/search?filter=not-assembled&search=A1BB6

Query Metrics

2 Database Queries
2 Different statements
49.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
47.68 ms
(97.18%)
1
SELECT d.id, dm.name, dm.indeks, d.serial_number, d.hangover_date, concat(e.first_name, ' ', e.last_name) as engineer, d.assembled_date, d.notes, d.finished_type
                FROM device d 
                LEFT JOIN device_model dm on d.model = dm.id
                LEFT JOIN engineer e on e.id = d.engineer_id
                WHERE d.serial_number LIKE :serialNumber
                AND d.assembled_date IS NULL
                LIMIT 10
Parameters:
[
  "serialNumber" => "%A1BB6%"
]
1.39 ms
(2.82%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Device No errors.