https://portal.wep-erziehungshilfe.de/notes/serverNotes?_=1773762015770&columns%5B0%5D%5Bdata%5D=id&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=note&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=created_at&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=status&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=user&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=id&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=false&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&draw=1&family=142&length=10&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=asc&search%5Bvalue%5D=&search%5Bregex%5D=false&start=0

Query Metrics

7 Database Queries
4 Different statements
10.57 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.34 ms
(50.54%)
1
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:
[]
4.26 ms
(40.34%)
4
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
]
0.55 ms
(5.21%)
1
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:
[]
0.41 ms
(3.91%)
1
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
]

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
  • The mappings App\Entity\Family#datenschutzFiles and App\Entity\DatenschutzFile#family are inconsistent with each other.
  • The mappings App\Entity\Family#bildungs and App\Entity\Bildung#family are inconsistent with each other.
  • The mappings App\Entity\Family#leistungstragers and App\Entity\Leistungstrager#family are inconsistent with each other.
App\Entity\AktenFile No errors.
App\Entity\DatenschutzFile
  • The association App\Entity\DatenschutzFile#family refers to the inverse side field App\Entity\Family#datenschutzs which does not exist.
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
  • The association App\Entity\Bildung#family refers to the inverse side field App\Entity\Family#schules which does not exist.
  • The mappings App\Entity\Bildung#familyMember and App\Entity\FamilyMember#bildung are inconsistent with each other.
App\Entity\Leistungstrager
  • The association App\Entity\Leistungstrager#family refers to the inverse side field App\Entity\Family#Leistungstragers which does not exist.
App\Entity\Gesundheit
  • The mappings App\Entity\Gesundheit#familyMember and App\Entity\FamilyMember#gesundheit are inconsistent with each other.
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.