Query Metrics
171
Database Queries
4
Different statements
169.28 ms
Query time
0
Invalid entities
Grouped Statements
mario connection
| Time▼ | Count | Info |
|---|---|---|
|
44.64 ms (26.37%) |
56 |
SELECT h0_.id AS id_0, h0_.did AS did_1, h0_.in_time AS in_time_2, h0_.out_time AS out_time_3, h0_.rate AS rate_4, h0_.adjust AS adjust_5, h0_.km AS km_6, h0_.breakstart AS breakstart_7, h0_.breakend AS breakend_8 FROM history h0_ WHERE h0_.did = ? AND (h0_.in_time BETWEEN ? AND ?) AND (h0_.out_time BETWEEN ? AND ?)
Parameters:
[ 1 "2026-07-31 08:00:00" "2026-08-01 08:00:00" "2026-07-31 08:00:00" "2026-08-01 08:00:00" ] |
|
0.76 ms (0.45%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.in_time AS in_time_6, t0.out_time AS out_time_7, t0.rate AS rate_8, t0.adjust AS adjust_9, t0.km AS km_10, t0.break AS break_11, t0.breakstart AS breakstart_12, t0.breakend AS breakend_13, t0.nickName AS nickName_14, t0.code AS code_15, t0.status AS status_16, t0.app AS app_17 FROM driver t0
Parameters:
[] |
schichtplaner connection
| Time▼ | Count | Info |
|---|---|---|
|
111.05 ms (65.60%) |
57 |
SELECT t0.id AS id_1, t0.did AS did_2, t0.date AS date_3, t0.status AS status_4, t0.temp_sdate AS temp_sdate_5, t0.temp_edate AS temp_edate_6, t0.sdate AS sdate_7, t0.edate AS edate_8, t0.created_at AS created_at_9, t0.sortn AS sortn_10, t0.auto AS auto_11, t0.amount AS amount_12, t0.MuserId AS MuserId_13, t0.name AS name_14, t0.slipId AS slipId_15, t0.extra AS extra_16, t0.extrastatus AS extrastatus_17, t0.abrechnungstatus AS abrechnungstatus_18, t0.fineamount AS fineamount_19, t0.uberstatus AS uberstatus_20 FROM result t0 WHERE t0.did = ? AND t0.date = ? AND t0.status = ?
Parameters:
[ 1 "2026-07-31" 4 ] |
|
12.83 ms (7.58%) |
57 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.email AS email_6, t0.sortn AS sortn_7, t0.comment AS comment_8, t0.nickName AS nickName_9, t0.status AS status_10 FROM driver t0 WHERE t0.name = ?
Parameters:
[
"Guest"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| mario | doctrine.dbal.mario_connection |
| schichtplaner | doctrine.dbal.schichtplaner_connection |
| lohnuebersicht | doctrine.dbal.lohnuebersicht_connection |
| pos | doctrine.dbal.pos_connection |
| storno | doctrine.dbal.storno_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| mario | doctrine.orm.mario_entity_manager |
| schichtplaner | doctrine.orm.schichtplaner_entity_manager |
| lohnuebersicht | doctrine.orm.lohnuebersicht_entity_manager |
| pos | doctrine.orm.pos_entity_manager |
| storno | doctrine.orm.storno_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
No loaded entities.
mario entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Mario\driver | No errors. |
| App\Entity\Mario\history | No errors. |
schichtplaner entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Schichtplaner\driver | No errors. |
| App\Entity\Schichtplaner\result | No errors. |
lohnuebersicht entity manager
No loaded entities.
pos entity manager
No loaded entities.
storno entity manager
No loaded entities.