GET http://zeit.elektro-ova.de/recaterminal

Response
200 OK
IP
192.168.2.10
Profiled on
Token
afac78

Query Metrics

22 Database Queries
3 Different statements
18.93 ms Query time
1 Invalid entities
855 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.84 ms 
SELECT r0_.id AS id_0, r0_.item_id AS item_id_1, r0_.name AS name_2, r0_.status AS status_3, r0_.type AS type_4, r0_.kommission AS kommission_5, r0_.module AS module_6, r0_.level AS level_7, r0_.shelf AS shelf_8, r0_.item_update_at AS item_update_at_9, r0_.nextcloud_sync AS nextcloud_sync_10, r0_.reca_automat_id AS reca_automat_id_11, r0_.user_id AS user_id_12 FROM reca_item r0_ ORDER BY r0_.item_update_at DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 3.18 ms 
SELECT p0_.id AS id_0, p0_.projectnumber AS projectnumber_1, p0_.customer_id AS customer_id_2, p0_.name AS name_3, p0_.finishtime AS finishtime_4, p0_.status_id AS status_id_5 FROM project p0_ WHERE p0_.status_id = 3 AND (p0_.finishtime IS NULL OR p0_.finishtime >= ?) ORDER BY p0_.name DESC
Parameters: 
[
  "2026-04-01 10:08:11"
]
View formatted query    View runnable query    Explain query
3 0.65 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
4 0.91 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
5 0.85 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
6 0.92 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
7 0.86 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  49
]
View formatted query    View runnable query    Explain query
8 0.69 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
9 0.72 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
10 0.39 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  39
]
View formatted query    View runnable query    Explain query
11 0.81 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
12 0.81 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
13 0.82 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
14 0.83 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  45
]
View formatted query    View runnable query    Explain query
15 0.62 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  61
]
View formatted query    View runnable query    Explain query
16 0.40 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  92
]
View formatted query    View runnable query    Explain query
17 0.47 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  38
]
View formatted query    View runnable query    Explain query
18 0.35 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query
19 0.37 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
20 0.38 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  85
]
View formatted query    View runnable query    Explain query
21 0.55 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
22 0.50 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.employeenumber AS employeenumber_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.roles AS roles_7, t0.breaktime AS breaktime_8, t0.external_employee AS external_employee_9, t0.exit_date AS exit_date_10, t0.driver_license_serial_number AS driver_license_serial_number_11, t12.id AS id_13, t12.number AS number_14, t12.shortname AS shortname_15, t12.enabled AS enabled_16, t12.user_id AS user_id_17 FROM user t0 LEFT JOIN leader t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Project 431
App\Entity\Reca\RecaItem 397
App\Entity\User 20
App\Entity\Leader 5
App\Entity\Reca\RecaAutomat 2

Entities Mapping

Class Mapping errors
App\Entity\Reca\RecaItem No errors.
App\Entity\Reca\RecaAutomat No errors.
App\Entity\User No errors.
App\Entity\Project No errors.
App\Entity\Leader
  • If association App\Entity\Leader#user is many-to-one, then the inversed side App\Entity\User#leader has to be one-to-many.