POST https://loanhub.fhw.crowbyte.org/admin/loan/new

Query Metrics

10 Database Queries
7 Different statements
5.23 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.shibboleth_id AS shibboleth_id_7, t0.enabled AS enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.62 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.inventory_number AS inventory_number_2, a0_.image AS image_3, a0_.description AS description_4, a0_.notes AS notes_5, a0_.status AS status_6, a0_.restrict_to_role AS restrict_to_role_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.article_type_id AS article_type_id_10, a0_.category_id AS category_id_11, a0_.created_by_id AS created_by_id_12 FROM article a0_ WHERE a0_.id IN (?)
Parameters:
[
  "99"
]
3 0.33 ms
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.first_name AS first_name_2, a0_.last_name AS last_name_3, a0_.roles AS roles_4, a0_.password AS password_5, a0_.shibboleth_id AS shibboleth_id_6, a0_.enabled AS enabled_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.last_login_at AS last_login_at_10 FROM app_user a0_ WHERE a0_.id IN (?)
Parameters:
[
  "5"
]
4 0.59 ms
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.first_name AS first_name_2, a0_.last_name AS last_name_3, a0_.roles AS roles_4, a0_.password AS password_5, a0_.shibboleth_id AS shibboleth_id_6, a0_.enabled AS enabled_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.last_login_at AS last_login_at_10 FROM app_user a0_ WHERE a0_.id IN (?)
Parameters:
[
  "2"
]
5 0.30 ms
"START TRANSACTION"
Parameters:
[]
6 0.98 ms
INSERT INTO loan (start_date, due_date, actual_return_date, status, notes, extension_requested, extension_requested_until, extension_note, created_at, updated_at, article_id, user_id, handed_out_by_id, returned_to_id, created_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-06-01 00:00:00"
  "2026-06-22 00:00:00"
  null
  "active"
  null
  0
  null
  null
  "2026-06-11 18:57:09"
  "2026-06-11 18:57:09"
  99
  5
  2
  null
  1
]
7 0.75 ms
"COMMIT"
Parameters:
[]
8 0.20 ms
"START TRANSACTION"
Parameters:
[]
9 0.43 ms
INSERT INTO audit_log (action, entity_type, entity_id, ip_address, created_at, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "loan.created"
  "App\Entity\Loan"
  1
  "84.58.93.235"
  "2026-06-11 18:57:09"
  1
]
10 0.40 ms
"COMMIT"
Parameters:
[]

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\User 3
App\Entity\Article 1
App\Entity\ArticleType 1
App\Entity\Category 1
App\Entity\Loan 1
App\Entity\AuditLog 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Loan No errors.
App\Entity\Article No errors.
App\Entity\ArticleType No errors.
App\Entity\Category No errors.
App\Entity\AttributeValue No errors.
App\Entity\AuditLog No errors.