Query Metrics
7
Database Queries
4
Different statements
10.57 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.14 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.phone_number AS phone_number_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.price_hour AS price_hour_11, t0.active AS active_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 2 | 5.34 ms |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.note AS note_2, n0_.status AS status_3, n0_.remarque AS remarque_4, n0_.family_id AS family_id_5, n0_.user_id AS user_id_6 FROM notes n0_ LEFT JOIN family f1_ ON n0_.family_id = f1_.id WHERE 1 = 1 AND n0_.family_id = 142
Parameters:
[] |
| 3 | 0.55 ms |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.note AS note_2, n0_.status AS status_3, n0_.remarque AS remarque_4, n0_.family_id AS family_id_5, n0_.user_id AS user_id_6 FROM notes n0_ LEFT JOIN family f1_ ON n0_.family_id = f1_.id WHERE 1 = 1 AND n0_.family_id = 142 ORDER BY n0_.id ASC LIMIT 10
Parameters:
[] |
| 4 | 0.41 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date_of_birth AS date_of_birth_4, t0.country AS country_5, t0.address AS address_6, t0.place_of_birth AS place_of_birth_7, t0.language AS language_8, t0.tel AS tel_9, t0.photo AS photo_10, t0.arbeitgeber AS arbeitgeber_11, t0.krankenkasse AS krankenkasse_12, t0.familienkasse AS familienkasse_13, t0.vn AS vn_14, t0.kgnr AS kgnr_15, t0.color AS color_16, t0.plz AS plz_17, t0.stadt AS stadt_18, t0.sorgeberechtigte AS sorgeberechtigte_19, t0.berichtszeitraum_date1 AS berichtszeitraum_date1_20, t0.berichtszeitraum_date2 AS berichtszeitraum_date2_21, t0.zusatzleistungen AS zusatzleistungen_22, t0.status AS status_23, t0.particular AS particular_24, t0.uma AS uma_25, t0.clearing AS clearing_26, t0.km AS km_27 FROM family t0 WHERE t0.id = ?
Parameters:
[
142
]
|
| 5 | 0.55 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.phone_number AS phone_number_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.price_hour AS price_hour_11, t0.active AS active_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 6 | 0.28 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.phone_number AS phone_number_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.price_hour AS price_hour_11, t0.active AS active_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 7 | 0.29 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.phone_number AS phone_number_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.price_hour AS price_hour_11, t0.active AS active_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
23
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Notes | No errors. |
| App\Entity\Calendar | No errors. |
| App\Entity\EmployeeFile | No errors. |
| App\Entity\Family |
|
| App\Entity\AktenFile | No errors. |
| App\Entity\DatenschutzFile |
|
| App\Entity\SchriftverkehrFile | No errors. |
| App\Entity\RechnungenFile | No errors. |
| App\Entity\TabelleSundenFile | No errors. |
| App\Entity\TabelleRechnungenFile | No errors. |
| App\Entity\LohneFile | No errors. |
| App\Entity\StundenFamilienFile | No errors. |
| App\Entity\Jugendamt | No errors. |
| App\Entity\Bildung |
|
| App\Entity\Leistungstrager |
|
| App\Entity\Gesundheit |
|
| App\Entity\Rechnungen | No errors. |
| App\Entity\HilfeplanBerichtFile | No errors. |
| App\Entity\Ziele | No errors. |
| App\Entity\Offices | No errors. |
| App\Entity\Situationsberichte | No errors. |
| App\Entity\Files | No errors. |