Query Metrics
16
Database Queries
9
Different statements
5.65 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.42 ms (25.16%) |
6 |
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
]
|
|
1.03 ms (18.33%) |
1 |
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:
[] |
|
0.91 ms (16.15%) |
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
Parameters:
[
8
]
|
|
0.55 ms (9.73%) |
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 = ? AND u0_.last_name = ? LIMIT 1
Parameters:
[ "Александр" "Орлов" ] |
|
0.47 ms (8.38%) |
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
Parameters:
[
"Учитель"
]
|
|
0.47 ms (8.36%) |
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.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
]
|
|
0.39 ms (6.94%) |
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 = ?
Parameters:
[
1
]
|
|
0.22 ms (3.88%) |
1 |
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
]
|
|
0.17 ms (3.07%) |
1 |
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
]
|
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 |
|
| 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. |