Symfony Profiler

Query Metrics

13 Database Queries

11 Different statements

11.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.88 ms
(24.66%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.street AS street_2, s0_.number AS number_3, s0_.place AS place_4, s0_.costcentre AS costcentre_5, s0_.care_time_options AS care_time_options_6, s0_.enable_food_attendance AS enable_food_attendance_7, s0_.active AS active_8, s0_.enable_attachment_upload AS enable_attachment_upload_9 FROM school s0_ WHERE s0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.street AS street_2,
  s0_.number AS number_3,
  s0_.place AS place_4,
  s0_.costcentre AS costcentre_5,
  s0_.care_time_options AS care_time_options_6,
  s0_.enable_food_attendance AS enable_food_attendance_7,
  s0_.active AS active_8,
  s0_.enable_attachment_upload AS enable_attachment_upload_9
FROM
  school s0_
WHERE
  s0_.active = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.street AS street_2, s0_.number AS number_3, s0_.place AS place_4, s0_.costcentre AS costcentre_5, s0_.care_time_options AS care_time_options_6, s0_.enable_food_attendance AS enable_food_attendance_7, s0_.active AS active_8, s0_.enable_attachment_upload AS enable_attachment_upload_9 FROM school s0_ WHERE s0_.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\SchoolRepository->findAllActive (line 58)
8	App\Controller\Registration\RegistrationController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 4)

1.45 ms
(12.40%)

INSERT INTO parent_user (id, salutation, last_name, first_name, email, zip, city, street, number, phone, birthday, nationality, single_parent, partner_salutation, partner_last_name, partner_first_name, partner_zip, partner_city, partner_street, partner_number, partner_email, partner_phone, partner_birthday, partner_nationality, work_shift_duty, work_type, work_attachment, partner_work_attachment, partner_work_shift_duty, partner_work_type, bank_iban, bank_bic, bank_holder_name, bank_name, mobile_phone, partner_mobile_phone, landline_phone, partner_landline_phone, updated_at, lang) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  25445
  "f"
  "Bahl"
  "Joanna"
  "Joazut@hotmail.com"
  "41564"
  "Kaarst"
  "Grünstraße "
  "42"
  ""
  "1987-01-02 00:00:00"
  "ger"
  1
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  null
  "ger"
  0
  "full"
  null
  null
  0
  "0"
  "DE80300700240636011900"
  "DEUTDEDBDUE"
  "Joanna Bahl"
  "Deutsche Bank"
  "015773737776"
  ""
  ""
  ""
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO parent_user (
  id, salutation, last_name, first_name,
  email, zip, city, street, number, phone,
  birthday, nationality, single_parent,
  partner_salutation, partner_last_name,
  partner_first_name, partner_zip,
  partner_city, partner_street, partner_number,
  partner_email, partner_phone, partner_birthday,
  partner_nationality, work_shift_duty,
  work_type, work_attachment, partner_work_attachment,
  partner_work_shift_duty, partner_work_type,
  bank_iban, bank_bic, bank_holder_name,
  bank_name, mobile_phone, partner_mobile_phone,
  landline_phone, partner_landline_phone,
  updated_at, lang
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO parent_user (id, salutation, last_name, first_name, email, zip, city, street, number, phone, birthday, nationality, single_parent, partner_salutation, partner_last_name, partner_first_name, partner_zip, partner_city, partner_street, partner_number, partner_email, partner_phone, partner_birthday, partner_nationality, work_shift_duty, work_type, work_attachment, partner_work_attachment, partner_work_shift_duty, partner_work_type, bank_iban, bank_bic, bank_holder_name, bank_name, mobile_phone, partner_mobile_phone, landline_phone, partner_landline_phone, updated_at, lang) VALUES (25445, 'f', 'Bahl', 'Joanna', 'Joazut@hotmail.com', '41564', 'Kaarst', 'Grünstraße ', '42', '', '1987-01-02 00:00:00', 'ger', 1, '', '', '', '', '', '', '', '', '', NULL, 'ger', 0, 'full', NULL, NULL, 0, '0', 'DE80300700240636011900', 'DEUTDEDBDUE', 'Joanna Bahl', 'Deutsche Bank', '015773737776', '', '', '', NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 191)
3	Doctrine\ORM\Persisters\Entity\JoinedSubclassPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 796)
7	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
8	App\Controller\Registration\RegistrationController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 4)

1.40 ms
(12.00%)

INSERT INTO child (id, last_name, first_name, birthday, gender, grade, class, comment, has_sibling, sibling_comment, customer_number, custom_food_fee, custom_refugee, custom_participation_fee, custom_special_support, food_attendance, care_time, updated_at, intern_comment, parent_id, school_group_id, school_id, period_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  25444
  "Bahl"
  "Nikolas"
  "2018-09-22 00:00:00"
  "m"
  "1"
  ""
  ""
  0
  null
  null
  null
  0
  null
  "Nein"
  0
  ""
  null
  null
  25445
  null
  22
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO child (
  id, last_name, first_name, birthday,
  gender, grade, class, comment, has_sibling,
  sibling_comment, customer_number,
  custom_food_fee, custom_refugee,
  custom_participation_fee, custom_special_support,
  food_attendance, care_time, updated_at,
  intern_comment, parent_id, school_group_id,
  school_id, period_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO child (id, last_name, first_name, birthday, gender, grade, class, comment, has_sibling, sibling_comment, customer_number, custom_food_fee, custom_refugee, custom_participation_fee, custom_special_support, food_attendance, care_time, updated_at, intern_comment, parent_id, school_group_id, school_id, period_id) VALUES (25444, 'Bahl', 'Nikolas', '2018-09-22 00:00:00', 'm', '1', '', '', 0, NULL, NULL, NULL, 0, NULL, 'Nein', 0, '', NULL, NULL, 25445, NULL, 22, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 283)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 796)
7	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
8	App\Controller\Registration\RegistrationController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 4)

1.39 ms
(11.93%)

SELECT NEXTVAL('id')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('id')

SELECT NEXTVAL('id');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 65)
3	Doctrine\ORM\Id\SequenceGenerator->generateId (line 1043)
4	Doctrine\ORM\UnitOfWork->persistNew (line 2066)
5	Doctrine\ORM\UnitOfWork->doPersist (line 2023)
6	Doctrine\ORM\UnitOfWork->persist (line 671)
7	Doctrine\ORM\EntityManager->persist (line 793)
8	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
9	App\Controller\Registration\RegistrationController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 4)

1.13 ms
(9.69%)

INSERT INTO registration (id, status, created_at, child_already_in_school, child_switch_in_city, child_switch_outer_city, termination, contract_start, contractstatus, contract_sent, updated_at, special1, special2, special0, special3, special4, special5, special6, special7, special8, special9, archived, imported, child_id, parent_id, school_id, period_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  5586
  "open"
  "2024-11-21 12:55:33"
  0
  0
  0
  null
  "2025-08-01 00:00:00"
  "offen"
  null
  "2024-11-21 12:55:33"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  0
  null
  25444
  25445
  22
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO registration (
  id, status, created_at, child_already_in_school,
  child_switch_in_city, child_switch_outer_city,
  termination, contract_start, contractstatus,
  contract_sent, updated_at, special1,
  special2, special0, special3, special4,
  special5, special6, special7, special8,
  special9, archived, imported, child_id,
  parent_id, school_id, period_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO registration (id, status, created_at, child_already_in_school, child_switch_in_city, child_switch_outer_city, termination, contract_start, contractstatus, contract_sent, updated_at, special1, special2, special0, special3, special4, special5, special6, special7, special8, special9, archived, imported, child_id, parent_id, school_id, period_id) VALUES (5586, 'open', '2024-11-21 12:55:33', 0, 0, 0, NULL, '2025-08-01 00:00:00', 'offen', NULL, '2024-11-21 12:55:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 25444, 25445, 22, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 283)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 796)
7	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
8	App\Controller\Registration\RegistrationController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 4)

0.91 ms
(7.78%)

INSERT INTO symfony_users (id, username, password, roles, salt, password_request_token, reset_expired, enabled, registration_hash, locale, discr) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  25445
  "Joazut@hotmail.com"
  "$2y$13$lGMQNAKepfegB/DyhDVZGuIXjyvfDYfl2Iykp/CPnXEMviBgU6pfq"
  "["ROLE_PARENT"]"
  null
  null
  null
  0
  "8c20398846c9225ef50b1f1472d6b6bc16a84032"
  null
  "parent"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO symfony_users (
  id, username, password, roles, salt,
  password_request_token, reset_expired,
  enabled, registration_hash, locale,
  discr
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO symfony_users (id, username, password, roles, salt, password_request_token, reset_expired, enabled, registration_hash, locale, discr) VALUES (25445, 'Joazut@hotmail.com', '$2y$13$lGMQNAKepfegB/DyhDVZGuIXjyvfDYfl2Iykp/CPnXEMviBgU6pfq', '[\"ROLE_PARENT\"]', NULL, NULL, NULL, 0, '8c20398846c9225ef50b1f1472d6b6bc16a84032', NULL, 'parent');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 162)
3	Doctrine\ORM\Persisters\Entity\JoinedSubclassPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 796)
7	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
8	App\Controller\Registration\RegistrationController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 4)

0.65 ms
(5.53%)

INSERT INTO child_period (child_id, period_id) VALUES (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO child_period (child_id, period_id)
VALUES
  (?, ?)

INSERT INTO child_period (child_id, period_id) VALUES (25444, 14);

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 77)
2	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->update (line 466)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 796)
5	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
6	App\Controller\Registration\RegistrationController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 4)

0.64 ms
(5.49%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 796)
5	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
6	App\Controller\Registration\RegistrationController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 4)

0.62 ms
(5.33%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.start_at AS start_at_2, p0_.end_at AS end_at_3, p0_.current AS current_4, p0_.next AS next_5 FROM period p0_ WHERE p0_.next = true OR p0_.current = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.start_at AS start_at_2,
  p0_.end_at AS end_at_3,
  p0_.current AS current_4,
  p0_.next AS next_5
FROM
  period p0_
WHERE
  p0_.next = true
  OR p0_.current = true

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.start_at AS start_at_2, p0_.end_at AS end_at_3, p0_.current AS current_4, p0_.next AS next_5 FROM period p0_ WHERE p0_.next = true OR p0_.current = true;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 26)
7	App\Repository\PeriodRepository->findOpenPeriods (line 461)
8	App\Controller\Registration\RegistrationController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 4)

0.50 ms
(4.27%)

SELECT NEXTVAL('registration_id_seq')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('registration_id_seq')

SELECT NEXTVAL('registration_id_seq');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 65)
3	Doctrine\ORM\Id\SequenceGenerator->generateId (line 1043)
4	Doctrine\ORM\UnitOfWork->persistNew (line 2066)
5	Doctrine\ORM\UnitOfWork->doPersist (line 2023)
6	Doctrine\ORM\UnitOfWork->persist (line 671)
7	Doctrine\ORM\EntityManager->persist (line 795)
8	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
9	App\Controller\Registration\RegistrationController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 4)

0.11 ms
(0.91%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 428)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 796)
4	App\Controller\Registration\RegistrationController->saveEntireRegistration (line 596)
5	App\Controller\Registration\RegistrationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 4)

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\School	No errors.
App\Entity\SchoolGroup	No errors.
App\Entity\Registration	No errors.
App\Entity\Child	No errors.
App\Entity\Change	No errors.
App\Entity\User	No errors.
App\Entity\Manager	No errors.
App\Entity\Period	No errors.
App\Entity\ParentUser	No errors.

Symfony Profiler

POST http://ganztag.kja-duesseldorf.de/registration/de

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping