Symfony Profiler

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
  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,
  t0.invoice_id AS invoice_id_20
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, t0.invoice_id AS invoice_id_20 FROM candidate t0 WHERE t0.id = 1634;

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.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.id = 29;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.status AS status_3,
  t0.name AS name_4,
  t0.description AS description_5
FROM
  finance_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.name AS name_4, t0.description AS description_5 FROM finance_category t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.candidate_review_is_not_required AS candidate_review_is_not_required_5,
  t0.free_calendar_events_access AS free_calendar_events_access_6,
  t7.id AS id_8,
  t7.first_name AS first_name_9,
  t7.last_name AS last_name_10,
  t7.phone AS phone_11,
  t7.email AS email_12,
  t7.comment AS comment_13,
  t7.last_name2 AS last_name2_14,
  t7.telegram_user_id AS telegram_user_id_15,
  t7.can_send_telegram_campaigns AS can_send_telegram_campaigns_16,
  t7.is_student AS is_student_17,
  t7.is_subscriber AS is_subscriber_18,
  t7.surname AS surname_19,
  t7.created_at AS created_at_20,
  t7.student_id AS student_id_21,
  t7.city_id AS city_id_22,
  t7.image_id AS image_id_23,
  t7.message_receiver_id AS message_receiver_id_24
FROM
  student t0
  LEFT JOIN person t7 ON t7.student_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.level AS level_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.candidate_review_is_not_required AS candidate_review_is_not_required_5, t0.free_calendar_events_access AS free_calendar_events_access_6, t7.id AS id_8, t7.first_name AS first_name_9, t7.last_name AS last_name_10, t7.phone AS phone_11, t7.email AS email_12, t7.comment AS comment_13, t7.last_name2 AS last_name2_14, t7.telegram_user_id AS telegram_user_id_15, t7.can_send_telegram_campaigns AS can_send_telegram_campaigns_16, t7.is_student AS is_student_17, t7.is_subscriber AS is_subscriber_18, t7.surname AS surname_19, t7.created_at AS created_at_20, t7.student_id AS student_id_21, t7.city_id AS city_id_22, t7.image_id AS image_id_23, t7.message_receiver_id AS message_receiver_id_24 FROM student t0 LEFT JOIN person t7 ON t7.student_id = t0.id WHERE t0.id = 3;

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.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.can_view_persons_balance AS can_view_persons_balance_34,
  t0.can_view_finance_categories AS can_view_finance_categories_35,
  t0.can_edit_finance_categories AS can_edit_finance_categories_36,
  t0.can_view_invoices AS can_view_invoices_37,
  t0.start_calendar_events_date AS start_calendar_events_date_38,
  t0.end_calendar_events_date AS end_calendar_events_date_39,
  t0.calendar_events_date_range_name AS calendar_events_date_range_name_40
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.can_view_persons_balance AS can_view_persons_balance_34, t0.can_view_finance_categories AS can_view_finance_categories_35, t0.can_edit_finance_categories AS can_edit_finance_categories_36, t0.can_view_invoices AS can_view_invoices_37, t0.start_calendar_events_date AS start_calendar_events_date_38, t0.end_calendar_events_date AS end_calendar_events_date_39, t0.calendar_events_date_range_name AS calendar_events_date_range_name_40 FROM user_settings t0 WHERE t0.id = 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_
WHERE
  c0_.end_date >= ?
  AND c0_.end_date <= ?
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_ WHERE c0_.end_date >= '2016-03-11' AND c0_.end_date <= '2036-03-11' ORDER BY c0_.start_date ASC;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.comment AS comment_6,
  t0.last_name2 AS last_name2_7,
  t0.telegram_user_id AS telegram_user_id_8,
  t0.can_send_telegram_campaigns AS can_send_telegram_campaigns_9,
  t0.is_student AS is_student_10,
  t0.is_subscriber AS is_subscriber_11,
  t0.surname AS surname_12,
  t0.created_at AS created_at_13,
  t0.student_id AS student_id_14,
  t0.city_id AS city_id_15,
  t0.image_id AS image_id_16,
  t0.message_receiver_id AS message_receiver_id_17
FROM
  person t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.comment AS comment_6, t0.last_name2 AS last_name2_7, t0.telegram_user_id AS telegram_user_id_8, t0.can_send_telegram_campaigns AS can_send_telegram_campaigns_9, t0.is_student AS is_student_10, t0.is_subscriber AS is_subscriber_11, t0.surname AS surname_12, t0.created_at AS created_at_13, t0.student_id AS student_id_14, t0.city_id AS city_id_15, t0.image_id AS image_id_16, t0.message_receiver_id AS message_receiver_id_17 FROM person t0 WHERE t0.id = 3;

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
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.status AS status_2,
  i0_.amount AS amount_3,
  i0_.candidate_id AS candidate_id_4,
  i0_.finance_category_id AS finance_category_id_5,
  i0_.person_id AS person_id_6
FROM
  invoice i0_
WHERE
  i0_.status IN (?, ?)

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.status AS status_2, i0_.amount AS amount_3, i0_.candidate_id AS candidate_id_4, i0_.finance_category_id AS finance_category_id_5, i0_.person_id AS person_id_6 FROM invoice i0_ WHERE i0_.status IN ('new', 'paid');

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