POST https://bigpizzamario.de/schichtplaner/ajax

Query Metrics

22 Database Queries
8 Different statements
731.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

mario connection

Time▼ Count Info
2.41 ms
(0.33%)
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 WHERE t0.name = ?
Parameters:
[
  "Guest"
]

schichtplaner connection

Time▼ Count Info
521.47 ms
(71.29%)
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.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"
]
120.67 ms
(16.50%)
7
SELECT DISTINCT r0_.did AS did_0 FROM result r0_ WHERE r0_.date BETWEEN ? AND ? ORDER BY r0_.sortn ASC
Parameters:
[
  "2026-09-28"
  "2026-10-04"
]
29.78 ms
(4.07%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3 FROM holiday t0
Parameters:
[]
26.01 ms
(3.56%)
1
SELECT r0_.id AS id_0, r0_.did AS did_1, r0_.date AS date_2, r0_.status AS status_3, r0_.temp_sdate AS temp_sdate_4, r0_.temp_edate AS temp_edate_5, r0_.sdate AS sdate_6, r0_.edate AS edate_7, r0_.created_at AS created_at_8, r0_.sortn AS sortn_9, r0_.auto AS auto_10, r0_.amount AS amount_11, r0_.MuserId AS MuserId_12, r0_.name AS name_13, r0_.slipId AS slipId_14, r0_.extra AS extra_15, r0_.extrastatus AS extrastatus_16, r0_.abrechnungstatus AS abrechnungstatus_17, r0_.fineamount AS fineamount_18, r0_.uberstatus AS uberstatus_19 FROM result r0_ WHERE r0_.date BETWEEN ? AND ? ORDER BY r0_.sortn ASC
Parameters:
[
  "2026-09-28"
  "2026-10-04"
]
24.61 ms
(3.36%)
9
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.id = ?
Parameters:
[
  16
]
4.06 ms
(0.56%)
1
SELECT h0_.id AS id_0, h0_.date AS date_1, h0_.status AS status_2 FROM holiday h0_ WHERE h0_.date BETWEEN ? AND ?
Parameters:
[
  "2026-09-28"
  "2026-10-04"
]
2.47 ms
(0.34%)
1
SELECT r0_.id AS id_0, r0_.did AS did_1, r0_.date AS date_2, r0_.status AS status_3, r0_.temp_sdate AS temp_sdate_4, r0_.temp_edate AS temp_edate_5, r0_.sdate AS sdate_6, r0_.edate AS edate_7, r0_.created_at AS created_at_8, r0_.sortn AS sortn_9, r0_.auto AS auto_10, r0_.amount AS amount_11, r0_.MuserId AS MuserId_12, r0_.name AS name_13, r0_.slipId AS slipId_14, r0_.extra AS extra_15, r0_.extrastatus AS extrastatus_16, r0_.abrechnungstatus AS abrechnungstatus_17, r0_.fineamount AS fineamount_18, r0_.uberstatus AS uberstatus_19 FROM result r0_ WHERE r0_.did = ? AND (r0_.date BETWEEN ? AND ?) ORDER BY r0_.date ASC
Parameters:
[
  1
  "2026-09-28"
  "2026-10-04"
]

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.

schichtplaner entity manager

Class Mapping errors
App\Entity\Schichtplaner\driver No errors.
App\Entity\Schichtplaner\result No errors.
App\Entity\Schichtplaner\holiday No errors.

lohnuebersicht entity manager

No loaded entities.

pos entity manager

No loaded entities.

storno entity manager

No loaded entities.