GET https://bigpizzamario.de/mario/list

Query Metrics

171 Database Queries
4 Different statements
169.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.