https://dev.centr.sariato.ru/developer/error-logs

Query Metrics

16 Database Queries
9 Different statements
5.65 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 ms
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 = ?
Parameters:
[
  1
]
2 1.03 ms
SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.text AS text_2, e0_.trace AS trace_3, e0_.send_status AS send_status_4, e0_.user_id AS user_id_5 FROM error_log e0_ ORDER BY e0_.created_at DESC
Parameters:
[]
3 0.47 ms
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
Parameters:
[
  "Учитель"
]
4 0.22 ms
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 = ?
Parameters:
[
  8
]
5 0.17 ms
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 = ?
Parameters:
[
  8
]
6 0.19 ms
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
Parameters:
[
  8
]
7 0.20 ms
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
Parameters:
[
  8
]
8 0.52 ms
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
Parameters:
[
  8
]
9 0.34 ms
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
Parameters:
[
  8
]
10 0.19 ms
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
Parameters:
[
  8
]
11 0.25 ms
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
Parameters:
[
  8
]
12 0.19 ms
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
Parameters:
[
  1
]
13 0.18 ms
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
Parameters:
[
  1
]
14 0.28 ms
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
Parameters:
[
  1
]
15 0.47 ms
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.can_view_transactions AS can_view_transactions_38, t0.can_view_jobs AS can_view_jobs_39, t0.start_calendar_events_date AS start_calendar_events_date_40, t0.end_calendar_events_date AS end_calendar_events_date_41, t0.calendar_events_date_range_name AS calendar_events_date_range_name_42 FROM user_settings t0 WHERE t0.id = ?
Parameters:
[
  1
]
16 0.55 ms
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 = ? AND u0_.last_name = ? LIMIT 1
Parameters:
[
  "Александр"
  "Орлов"
]

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\LoginHistory
  • The association App\Entity\LoginHistory#user refers to the inverse side field App\Entity\User#loginHistories which does not exist.
App\Entity\User No errors.
App\Entity\UserSettings No errors.
App\Entity\ReviewerSettings No errors.
App\Entity\TipSettings No errors.
App\Entity\Image No errors.
App\Entity\ErrorLog No errors.
App\Entity\Transaction No errors.
App\Entity\Payment No errors.
App\Entity\CalendarEventKind No errors.
App\Entity\CalendarEvent No errors.
App\Entity\Candidate No errors.
App\Entity\Student No errors.
App\Entity\TelegramCampaignParticipant No errors.
App\Entity\TelegramCampaignMessage No errors.
App\Entity\Person No errors.
App\Entity\EntityLog No errors.
App\Entity\FinanceCategory No errors.