Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.district_name AS district_name_2,
  t0.event_type AS event_type_3,
  t0.event_state AS event_state_4
FROM
  rookie_district t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.district_name AS district_name_2, t0.event_type AS event_type_3, t0.event_state AS event_state_4 FROM rookie_district t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.open_at AS open_at_2,
  r0_.close_at AS close_at_3,
  r0_.work_from AS work_from_4,
  r0_.work_to AS work_to_5,
  r0_.comment AS comment_6,
  r0_.rookie_district_id AS rookie_district_id_7,
  r0_.rookie_time_slot_state_id AS rookie_time_slot_state_id_8
FROM
  rookie_time_slot r0_
  LEFT JOIN rookie_district r1_ ON r0_.rookie_district_id = r1_.id
  LEFT JOIN rookie_time_slot_state r2_ ON r0_.rookie_time_slot_state_id = r2_.id
WHERE
  r1_.id = 1
  AND r0_.id NOT IN (9, 60)
  AND r2_.id = 1
ORDER BY
  r0_.open_at ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.open_at AS open_at_2, r0_.close_at AS close_at_3, r0_.work_from AS work_from_4, r0_.work_to AS work_to_5, r0_.comment AS comment_6, r0_.rookie_district_id AS rookie_district_id_7, r0_.rookie_time_slot_state_id AS rookie_time_slot_state_id_8 FROM rookie_time_slot r0_ LEFT JOIN rookie_district r1_ ON r0_.rookie_district_id = r1_.id LEFT JOIN rookie_time_slot_state r2_ ON r0_.rookie_time_slot_state_id = r2_.id WHERE r1_.id = 1 AND r0_.id NOT IN (9, 60) AND r2_.id = 1 ORDER BY r0_.open_at ASC;

SELECT
  t0.id AS id_1,
  t0.optional_name AS optional_name_2,
  t0.director_mail AS director_mail_3,
  t0.is_visible AS is_visible_4,
  t0.rookie_district_id AS rookie_district_id_5,
  t0.school_id AS school_id_6,
  t0.rookie_time_slot_id AS rookie_time_slot_id_7
FROM
  rookie_school t0
WHERE
  t0.rookie_time_slot_id = ?

SELECT t0.id AS id_1, t0.optional_name AS optional_name_2, t0.director_mail AS director_mail_3, t0.is_visible AS is_visible_4, t0.rookie_district_id AS rookie_district_id_5, t0.school_id AS school_id_6, t0.rookie_time_slot_id AS rookie_time_slot_id_7 FROM rookie_school t0 WHERE t0.rookie_time_slot_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 370;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 374;

SELECT
  t0.id AS id_1,
  t0.optional_name AS optional_name_2,
  t0.director_mail AS director_mail_3,
  t0.is_visible AS is_visible_4,
  t0.rookie_district_id AS rookie_district_id_5,
  t0.school_id AS school_id_6,
  t0.rookie_time_slot_id AS rookie_time_slot_id_7
FROM
  rookie_school t0
WHERE
  t0.rookie_time_slot_id = ?

SELECT t0.id AS id_1, t0.optional_name AS optional_name_2, t0.director_mail AS director_mail_3, t0.is_visible AS is_visible_4, t0.rookie_district_id AS rookie_district_id_5, t0.school_id AS school_id_6, t0.rookie_time_slot_id AS rookie_time_slot_id_7 FROM rookie_school t0 WHERE t0.rookie_time_slot_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 299;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 300;

SELECT
  t0.id AS id_1,
  t0.optional_name AS optional_name_2,
  t0.director_mail AS director_mail_3,
  t0.is_visible AS is_visible_4,
  t0.rookie_district_id AS rookie_district_id_5,
  t0.school_id AS school_id_6,
  t0.rookie_time_slot_id AS rookie_time_slot_id_7
FROM
  rookie_school t0
WHERE
  t0.rookie_time_slot_id = ?

SELECT t0.id AS id_1, t0.optional_name AS optional_name_2, t0.director_mail AS director_mail_3, t0.is_visible AS is_visible_4, t0.rookie_district_id AS rookie_district_id_5, t0.school_id AS school_id_6, t0.rookie_time_slot_id AS rookie_time_slot_id_7 FROM rookie_school t0 WHERE t0.rookie_time_slot_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 330;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 362;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 381;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.school_number AS school_number_3,
  t0.url AS url_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.communication_id AS communication_id_7,
  t0.address_id AS address_id_8,
  t9.id AS id_10,
  t9.uuid AS uuid_11,
  t9.name AS name_12,
  t9.description AS description_13,
  t9.training_information AS training_information_14,
  t9.certificate_information AS certificate_information_15,
  t9.url AS url_16,
  t9.click_count AS click_count_17,
  t9.is_visible AS is_visible_18,
  t9.logo_style AS logo_style_19,
  t9.school_id AS school_id_20,
  t9.communication_id AS communication_id_21,
  t9.gallery_id AS gallery_id_22,
  t9.video_gallery_id AS video_gallery_id_23,
  t9.document_gallery_id AS document_gallery_id_24,
  t9.contact_gallery_id AS contact_gallery_id_25,
  t9.profile_picture_id AS profile_picture_id_26,
  t9.header_picture_id AS header_picture_id_27,
  t9.profile_link_id AS profile_link_id_28
FROM
  school t0
  LEFT JOIN school_profile t9 ON t9.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = 304;