GET https://bigpizzamario.de/pos

Query Metrics

8 Database Queries
8 Different statements
4.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

mario connection

Time Count Info
0.65 ms
(14.05%)
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.id IS NULL ORDER BY t0.updated_at DESC
Parameters:
[]

pos connection

Time Count Info
1.16 ms
(24.95%)
1
SELECT m0_.id AS id_0, m0_.amount AS amount_1, m0_.number AS number_2, m0_.message AS message_3 FROM message m0_ WHERE (m0_.date BETWEEN ? AND ?) AND (m0_.rechnungstatus <> 3 AND m0_.rechnungstatus <> 4) AND m0_.message NOT LIKE ? AND m0_.seen = ?
Parameters:
[
  "2026-04-02 08:00:00"
  "2026-04-03 08:00:00"
  "%Abholen%"
  "0"
]
0.65 ms
(13.92%)
1
SELECT p0_.id AS id_0, p0_.did AS did_1, p0_.amount AS amount_2, p0_.number AS number_3 FROM poswinorder p0_ WHERE p0_.status = ? AND (p0_.created_At BETWEEN ? AND ?) ORDER BY p0_.number DESC
Parameters:
[
  0
  "2026-04-02 08:00:00"
  "2026-04-03 08:00:00"
]
0.47 ms
(10.02%)
1
SELECT p0_.id AS id_0, p0_.did AS did_1, p0_.amount AS amount_2, p0_.number AS number_3, p0_.type AS type_4 FROM posbigpizza p0_ WHERE p0_.status = ? AND (p0_.created_At BETWEEN ? AND ?) ORDER BY p0_.number ASC
Parameters:
[
  0
  "2026-04-02 08:00:00"
  "2026-04-03 08:00:00"
]
0.24 ms
(5.10%)
1
SELECT e0_.did AS did_0, e0_.amount AS amount_1 FROM essen e0_ WHERE e0_.created_At BETWEEN ? AND ? ORDER BY e0_.id DESC
Parameters:
[
  "2026-04-02 08:00:00"
  "2026-04-03 08:00:00"
]
0.21 ms
(4.57%)
1
SELECT k0_.id AS id_0, k0_.did AS did_1, k0_.number AS number_2 FROM km k0_ WHERE k0_.status = ? AND (k0_.created_at BETWEEN ? AND ?) ORDER BY k0_.id DESC
Parameters:
[
  0
  "2026-04-02 08:00:00"
  "2026-04-03 08:00:00"
]

lohnuebersicht connection

Time Count Info
0.23 ms
(4.87%)
1
SELECT t0.id AS id_1, t0.sdate AS sdate_2, t0.edate AS edate_3, t0.did AS did_4, t0.krank AS krank_5, t0.status AS status_6 FROM krankanmeldung t0 WHERE t0.did IS NULL ORDER BY t0.id DESC
Parameters:
[]

schichtplaner connection

Time Count Info
1.05 ms
(22.52%)
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_.status = ? AND (r0_.date BETWEEN ? AND ?) ORDER BY r0_.date ASC
Parameters:
[
  null
  4
  "2026-03-30"
  "2026-04-05"
]

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\result No errors.

lohnuebersicht entity manager

Class Mapping errors
App\Entity\Lohnuebersicht\krankanmeldung No errors.

pos entity manager

Class Mapping errors
App\Entity\Pos\poswinorder No errors.
App\Entity\Pos\posbigpizza No errors.
App\Entity\Pos\km No errors.
App\Entity\Pos\essen No errors.
App\Entity\Pos\message No errors.

storno entity manager

No loaded entities.