Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.first_name AS first_name_1,
  p0_.last_name AS last_name_2,
  p0_.phone AS phone_3,
  p0_.email AS email_4,
  p0_.comment AS comment_5,
  p0_.last_name2 AS last_name2_6,
  p0_.telegram_user_id AS telegram_user_id_7,
  p0_.can_send_telegram_campaigns AS can_send_telegram_campaigns_8,
  p0_.is_student AS is_student_9,
  p0_.is_subscriber AS is_subscriber_10,
  p0_.surname AS surname_11,
  p0_.created_at AS created_at_12,
  p0_.student_id AS student_id_13,
  p0_.city_id AS city_id_14,
  p0_.image_id AS image_id_15,
  p0_.message_receiver_id AS message_receiver_id_16
FROM
  person p0_
ORDER BY
  p0_.last_name ASC

SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.phone AS phone_3, p0_.email AS email_4, p0_.comment AS comment_5, p0_.last_name2 AS last_name2_6, p0_.telegram_user_id AS telegram_user_id_7, p0_.can_send_telegram_campaigns AS can_send_telegram_campaigns_8, p0_.is_student AS is_student_9, p0_.is_subscriber AS is_subscriber_10, p0_.surname AS surname_11, p0_.created_at AS created_at_12, p0_.student_id AS student_id_13, p0_.city_id AS city_id_14, p0_.image_id AS image_id_15, p0_.message_receiver_id AS message_receiver_id_16 FROM person p0_ ORDER BY p0_.last_name ASC;

SELECT
  t0_.id AS id_0,
  t0_.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_1,
  t0_.show_calendar_events_period_tip AS show_calendar_events_period_tip_2,
  t0_.user_id AS user_id_3
FROM
  tip_settings t0_
WHERE
  t0_.user_id = ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_1, t0_.show_calendar_events_period_tip AS show_calendar_events_period_tip_2, t0_.user_id AS user_id_3 FROM tip_settings t0_ WHERE t0_.user_id = 8 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.start_date AS start_date_2,
  c0_.end_date AS end_date_3,
  c0_.price AS price_4,
  c0_.from_level AS from_level_5,
  c0_.earn_level AS earn_level_6,
  c0_.start_time AS start_time_7,
  c0_.end_time AS end_time_8,
  c0_.type AS type_9,
  c0_.is_candidate_review_required AS is_candidate_review_required_10,
  c0_.telegram_channel_url AS telegram_channel_url_11,
  c0_.telegram_channel_id AS telegram_channel_id_12,
  c0_.event_dates_approximate AS event_dates_approximate_13,
  c0_.status AS status_14,
  c0_.to_level AS to_level_15,
  c0_.require_student_status AS require_student_status_16,
  c0_.payment_requisites_id AS payment_requisites_id_17,
  c0_.connecting_calendar_event_id AS connecting_calendar_event_id_18,
  c0_.kind_id AS kind_id_19
FROM
  calendar_event c0_
ORDER BY
  c0_.start_date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.start_date AS start_date_2, c0_.end_date AS end_date_3, c0_.price AS price_4, c0_.from_level AS from_level_5, c0_.earn_level AS earn_level_6, c0_.start_time AS start_time_7, c0_.end_time AS end_time_8, c0_.type AS type_9, c0_.is_candidate_review_required AS is_candidate_review_required_10, c0_.telegram_channel_url AS telegram_channel_url_11, c0_.telegram_channel_id AS telegram_channel_id_12, c0_.event_dates_approximate AS event_dates_approximate_13, c0_.status AS status_14, c0_.to_level AS to_level_15, c0_.require_student_status AS require_student_status_16, c0_.payment_requisites_id AS payment_requisites_id_17, c0_.connecting_calendar_event_id AS connecting_calendar_event_id_18, c0_.kind_id AS kind_id_19 FROM calendar_event c0_ ORDER BY c0_.start_date ASC;

SELECT
  r0_.id AS id_0,
  r0_.candidate_decline_comments AS candidate_decline_comments_1,
  r0_.candidate_recommendations AS candidate_recommendations_2,
  r0_.user_id AS user_id_3
FROM
  reviewer_settings r0_
WHERE
  r0_.user_id = ?
LIMIT
  1

SELECT r0_.id AS id_0, r0_.candidate_decline_comments AS candidate_decline_comments_1, r0_.candidate_recommendations AS candidate_recommendations_2, r0_.user_id AS user_id_3 FROM reviewer_settings r0_ WHERE r0_.user_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.region_id AS region_id_3
FROM
  city t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.region_id AS region_id_3 FROM city t0;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.telegram_user_id AS telegram_user_id_6,
  u0_.telegram_phone AS telegram_phone_7,
  u0_.sort_id AS sort_id_8,
  u0_.status AS status_9,
  u0_.settings_id AS settings_id_10
FROM
  user u0_
WHERE
  u0_.first_name = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.telegram_user_id AS telegram_user_id_6, u0_.telegram_phone AS telegram_phone_7, u0_.sort_id AS sort_id_8, u0_.status AS status_9, u0_.settings_id AS settings_id_10 FROM user u0_ WHERE u0_.first_name = 'Учитель' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.start_date AS start_date_2,
  c0_.end_date AS end_date_3,
  c0_.price AS price_4,
  c0_.from_level AS from_level_5,
  c0_.earn_level AS earn_level_6,
  c0_.start_time AS start_time_7,
  c0_.end_time AS end_time_8,
  c0_.type AS type_9,
  c0_.is_candidate_review_required AS is_candidate_review_required_10,
  c0_.telegram_channel_url AS telegram_channel_url_11,
  c0_.telegram_channel_id AS telegram_channel_id_12,
  c0_.event_dates_approximate AS event_dates_approximate_13,
  c0_.status AS status_14,
  c0_.to_level AS to_level_15,
  c0_.require_student_status AS require_student_status_16,
  c0_.payment_requisites_id AS payment_requisites_id_17,
  c0_.connecting_calendar_event_id AS connecting_calendar_event_id_18,
  c0_.kind_id AS kind_id_19
FROM
  calendar_event c0_
ORDER BY
  c0_.start_date DESC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.start_date AS start_date_2, c0_.end_date AS end_date_3, c0_.price AS price_4, c0_.from_level AS from_level_5, c0_.earn_level AS earn_level_6, c0_.start_time AS start_time_7, c0_.end_time AS end_time_8, c0_.type AS type_9, c0_.is_candidate_review_required AS is_candidate_review_required_10, c0_.telegram_channel_url AS telegram_channel_url_11, c0_.telegram_channel_id AS telegram_channel_id_12, c0_.event_dates_approximate AS event_dates_approximate_13, c0_.status AS status_14, c0_.to_level AS to_level_15, c0_.require_student_status AS require_student_status_16, c0_.payment_requisites_id AS payment_requisites_id_17, c0_.connecting_calendar_event_id AS connecting_calendar_event_id_18, c0_.kind_id AS kind_id_19 FROM calendar_event c0_ ORDER BY c0_.start_date DESC;

SELECT
  e0_.id AS id_0,
  e0_.entity_class AS entity_class_1,
  e0_.type AS type_2,
  e0_.created_at AS created_at_3,
  e0_.field_name AS field_name_4,
  e0_.old_value AS old_value_5,
  e0_.new_value AS new_value_6,
  e0_.entity_id AS entity_id_7,
  e0_.data AS data_8,
  e0_.old_data AS old_data_9,
  e0_.edited_by_id AS edited_by_id_10,
  e0_.student_id AS student_id_11,
  e0_.person_id AS person_id_12,
  e0_.user_settings_id AS user_settings_id_13,
  e0_.candidate_id AS candidate_id_14,
  e0_.payment_id AS payment_id_15
FROM
  entity_log e0_
ORDER BY
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.entity_class AS entity_class_1, e0_.type AS type_2, e0_.created_at AS created_at_3, e0_.field_name AS field_name_4, e0_.old_value AS old_value_5, e0_.new_value AS new_value_6, e0_.entity_id AS entity_id_7, e0_.data AS data_8, e0_.old_data AS old_data_9, e0_.edited_by_id AS edited_by_id_10, e0_.student_id AS student_id_11, e0_.person_id AS person_id_12, e0_.user_settings_id AS user_settings_id_13, e0_.candidate_id AS candidate_id_14, e0_.payment_id AS payment_id_15 FROM entity_log e0_ ORDER BY e0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.created_at AS created_at_3,
  t0.viewer_comment AS viewer_comment_4,
  t0.approved_at AS approved_at_5,
  t0.comment AS comment_6,
  t0.payment_deferment AS payment_deferment_7,
  t0.recommendations AS recommendations_8,
  t0.updated_at AS updated_at_9,
  t0.review_approve_comment AS review_approve_comment_10,
  t0.access_by_receipt AS access_by_receipt_11,
  t0.decline_comment AS decline_comment_12,
  t0.leaved_at AS leaved_at_13,
  t0.author_id AS author_id_14,
  t0.person_id AS person_id_15,
  t0.calendar_event_id AS calendar_event_id_16,
  t0.image_id AS image_id_17,
  t0.selected_author_id AS selected_author_id_18,
  t0.curator_id AS curator_id_19
FROM
  candidate t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.viewer_comment AS viewer_comment_4, t0.approved_at AS approved_at_5, t0.comment AS comment_6, t0.payment_deferment AS payment_deferment_7, t0.recommendations AS recommendations_8, t0.updated_at AS updated_at_9, t0.review_approve_comment AS review_approve_comment_10, t0.access_by_receipt AS access_by_receipt_11, t0.decline_comment AS decline_comment_12, t0.leaved_at AS leaved_at_13, t0.author_id AS author_id_14, t0.person_id AS person_id_15, t0.calendar_event_id AS calendar_event_id_16, t0.image_id AS image_id_17, t0.selected_author_id AS selected_author_id_18, t0.curator_id AS curator_id_19 FROM candidate t0 WHERE t0.id = 132;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.telegram_user_id AS telegram_user_id_7,
  t0.telegram_phone AS telegram_phone_8,
  t0.sort_id AS sort_id_9,
  t0.status AS status_10,
  t0.settings_id AS settings_id_11,
  t12.id AS id_13,
  t12.candidate_decline_comments AS candidate_decline_comments_14,
  t12.candidate_recommendations AS candidate_recommendations_15,
  t12.user_id AS user_id_16,
  t17.id AS id_18,
  t17.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_19,
  t17.show_calendar_events_period_tip AS show_calendar_events_period_tip_20,
  t17.user_id AS user_id_21
FROM
  user t0
  LEFT JOIN reviewer_settings t12 ON t12.user_id = t0.id
  LEFT JOIN tip_settings t17 ON t17.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.telegram_user_id AS telegram_user_id_7, t0.telegram_phone AS telegram_phone_8, t0.sort_id AS sort_id_9, t0.status AS status_10, t0.settings_id AS settings_id_11, t12.id AS id_13, t12.candidate_decline_comments AS candidate_decline_comments_14, t12.candidate_recommendations AS candidate_recommendations_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_19, t17.show_calendar_events_period_tip AS show_calendar_events_period_tip_20, t17.user_id AS user_id_21 FROM user t0 LEFT JOIN reviewer_settings t12 ON t12.user_id = t0.id LEFT JOIN tip_settings t17 ON t17.user_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.can_edit_calendar_events AS can_edit_calendar_events_2,
  t0.can_edit_students AS can_edit_students_3,
  t0.can_view_candidates AS can_view_candidates_4,
  t0.can_edit_payments AS can_edit_payments_5,
  t0.can_review_candidates AS can_review_candidates_6,
  t0.can_view_students AS can_view_students_7,
  t0.can_view_calendar_events AS can_view_calendar_events_8,
  t0.can_view_calendar_event_kinds AS can_view_calendar_event_kinds_9,
  t0.can_edit_calendar_event_kinds AS can_edit_calendar_event_kinds_10,
  t0.can_view_zoom_report AS can_view_zoom_report_11,
  t0.can_view_payments_report AS can_view_payments_report_12,
  t0.can_view_students_personal_data AS can_view_students_personal_data_13,
  t0.can_view_payments AS can_view_payments_14,
  t0.can_edit_candidates AS can_edit_candidates_15,
  t0.can_view_campaigns AS can_view_campaigns_16,
  t0.can_view_payment_requisites AS can_view_payment_requisites_17,
  t0.can_send_campaigns AS can_send_campaigns_18,
  t0.can_use_test_features AS can_use_test_features_19,
  t0.can_remove_payments AS can_remove_payments_20,
  t0.can_compare_table AS can_compare_table_21,
  t0.can_edit_candidate_access_by_receipt AS can_edit_candidate_access_by_receipt_22,
  t0.can_edit_all_candidate_params AS can_edit_all_candidate_params_23,
  t0.is_curator AS is_curator_24,
  t0.can_view_delayed_messages AS can_view_delayed_messages_25,
  t0.can_view_call_lists AS can_view_call_lists_26,
  t0.can_edit_call_lists AS can_edit_call_lists_27,
  t0.can_register_for_calendar_events AS can_register_for_calendar_events_28,
  t0.can_view_inner_payments AS can_view_inner_payments_29,
  t0.can_edit_inner_payments AS can_edit_inner_payments_30,
  t0.can_view_cities AS can_view_cities_31,
  t0.can_edit_cities AS can_edit_cities_32,
  t0.can_view_entity_log AS can_view_entity_log_33,
  t0.start_calendar_events_date AS start_calendar_events_date_34,
  t0.end_calendar_events_date AS end_calendar_events_date_35,
  t0.calendar_events_date_range_name AS calendar_events_date_range_name_36
FROM
  user_settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.can_edit_calendar_events AS can_edit_calendar_events_2, t0.can_edit_students AS can_edit_students_3, t0.can_view_candidates AS can_view_candidates_4, t0.can_edit_payments AS can_edit_payments_5, t0.can_review_candidates AS can_review_candidates_6, t0.can_view_students AS can_view_students_7, t0.can_view_calendar_events AS can_view_calendar_events_8, t0.can_view_calendar_event_kinds AS can_view_calendar_event_kinds_9, t0.can_edit_calendar_event_kinds AS can_edit_calendar_event_kinds_10, t0.can_view_zoom_report AS can_view_zoom_report_11, t0.can_view_payments_report AS can_view_payments_report_12, t0.can_view_students_personal_data AS can_view_students_personal_data_13, t0.can_view_payments AS can_view_payments_14, t0.can_edit_candidates AS can_edit_candidates_15, t0.can_view_campaigns AS can_view_campaigns_16, t0.can_view_payment_requisites AS can_view_payment_requisites_17, t0.can_send_campaigns AS can_send_campaigns_18, t0.can_use_test_features AS can_use_test_features_19, t0.can_remove_payments AS can_remove_payments_20, t0.can_compare_table AS can_compare_table_21, t0.can_edit_candidate_access_by_receipt AS can_edit_candidate_access_by_receipt_22, t0.can_edit_all_candidate_params AS can_edit_all_candidate_params_23, t0.is_curator AS is_curator_24, t0.can_view_delayed_messages AS can_view_delayed_messages_25, t0.can_view_call_lists AS can_view_call_lists_26, t0.can_edit_call_lists AS can_edit_call_lists_27, t0.can_register_for_calendar_events AS can_register_for_calendar_events_28, t0.can_view_inner_payments AS can_view_inner_payments_29, t0.can_edit_inner_payments AS can_edit_inner_payments_30, t0.can_view_cities AS can_view_cities_31, t0.can_edit_cities AS can_edit_cities_32, t0.can_view_entity_log AS can_view_entity_log_33, t0.start_calendar_events_date AS start_calendar_events_date_34, t0.end_calendar_events_date AS end_calendar_events_date_35, t0.calendar_events_date_range_name AS calendar_events_date_range_name_36 FROM user_settings t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.price AS price_5,
  t0.from_level AS from_level_6,
  t0.earn_level AS earn_level_7,
  t0.start_time AS start_time_8,
  t0.end_time AS end_time_9,
  t0.type AS type_10,
  t0.is_candidate_review_required AS is_candidate_review_required_11,
  t0.telegram_channel_url AS telegram_channel_url_12,
  t0.telegram_channel_id AS telegram_channel_id_13,
  t0.event_dates_approximate AS event_dates_approximate_14,
  t0.status AS status_15,
  t0.to_level AS to_level_16,
  t0.require_student_status AS require_student_status_17,
  t0.payment_requisites_id AS payment_requisites_id_18,
  t0.connecting_calendar_event_id AS connecting_calendar_event_id_19,
  t0.kind_id AS kind_id_20
FROM
  calendar_event t0
WHERE
  t0.connecting_calendar_event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.price AS price_5, t0.from_level AS from_level_6, t0.earn_level AS earn_level_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.type AS type_10, t0.is_candidate_review_required AS is_candidate_review_required_11, t0.telegram_channel_url AS telegram_channel_url_12, t0.telegram_channel_id AS telegram_channel_id_13, t0.event_dates_approximate AS event_dates_approximate_14, t0.status AS status_15, t0.to_level AS to_level_16, t0.require_student_status AS require_student_status_17, t0.payment_requisites_id AS payment_requisites_id_18, t0.connecting_calendar_event_id AS connecting_calendar_event_id_19, t0.kind_id AS kind_id_20 FROM calendar_event t0 WHERE t0.connecting_calendar_event_id = 11;

SELECT
  t0.id AS id_1,
  t0.candidate_decline_comments AS candidate_decline_comments_2,
  t0.candidate_recommendations AS candidate_recommendations_3,
  t0.user_id AS user_id_4
FROM
  reviewer_settings t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.candidate_decline_comments AS candidate_decline_comments_2, t0.candidate_recommendations AS candidate_recommendations_3, t0.user_id AS user_id_4 FROM reviewer_settings t0 WHERE t0.user_id = 8;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.telegram_user_id AS telegram_user_id_7,
  t0.telegram_phone AS telegram_phone_8,
  t0.sort_id AS sort_id_9,
  t0.status AS status_10,
  t0.settings_id AS settings_id_11,
  t12.id AS id_13,
  t12.candidate_decline_comments AS candidate_decline_comments_14,
  t12.candidate_recommendations AS candidate_recommendations_15,
  t12.user_id AS user_id_16,
  t17.id AS id_18,
  t17.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_19,
  t17.show_calendar_events_period_tip AS show_calendar_events_period_tip_20,
  t17.user_id AS user_id_21
FROM
  user t0
  LEFT JOIN reviewer_settings t12 ON t12.user_id = t0.id
  LEFT JOIN tip_settings t17 ON t17.user_id = t0.id

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.telegram_user_id AS telegram_user_id_7, t0.telegram_phone AS telegram_phone_8, t0.sort_id AS sort_id_9, t0.status AS status_10, t0.settings_id AS settings_id_11, t12.id AS id_13, t12.candidate_decline_comments AS candidate_decline_comments_14, t12.candidate_recommendations AS candidate_recommendations_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_19, t17.show_calendar_events_period_tip AS show_calendar_events_period_tip_20, t17.user_id AS user_id_21 FROM user t0 LEFT JOIN reviewer_settings t12 ON t12.user_id = t0.id LEFT JOIN tip_settings t17 ON t17.user_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_2,
  t0.show_calendar_events_period_tip AS show_calendar_events_period_tip_3,
  t0.user_id AS user_id_4
FROM
  tip_settings t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_2, t0.show_calendar_events_period_tip AS show_calendar_events_period_tip_3, t0.user_id AS user_id_4 FROM tip_settings t0 WHERE t0.user_id = 8;