Symfony Profiler

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;

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;

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;

SELECT
  NEXTVAL('id')

SELECT NEXTVAL('id');

SELECT
  NEXTVAL('id')

SELECT NEXTVAL('id');

SELECT
  NEXTVAL('registration_id_seq')

SELECT NEXTVAL('registration_id_seq');

"START TRANSACTION"

"START TRANSACTION";

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');

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);

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);

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);

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

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

"COMMIT"

"COMMIT";