Query Metrics
996
Database Queries
9
Different statements
522.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
495.56 ms (94.83%) |
966 |
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 = ?
Parameters:
[
2
]
|
|
10.36 ms (1.98%) |
16 |
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.start_calendar_events_date AS start_calendar_events_date_39, t0.end_calendar_events_date AS end_calendar_events_date_40, t0.calendar_events_date_range_name AS calendar_events_date_range_name_41 FROM user_settings t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
9.15 ms (1.75%) |
1 |
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
Parameters:
[] |
|
2.12 ms (0.41%) |
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.41 ms (0.27%) |
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
]
|
|
1.37 ms (0.26%) |
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
Parameters:
[] |
|
1.06 ms (0.20%) |
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:
[
14
]
|
|
0.97 ms (0.18%) |
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
Parameters:
[] |
|
0.58 ms (0.11%) |
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:
[
"Учитель"
]
|
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\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\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\TelegramCampaign | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\TelegramCampaignMessage | No errors. |
| App\Entity\EntityLog | No errors. |
| App\Entity\FinanceCategory | No errors. |
| App\Entity\PaymentRequisites | No errors. |
| App\Entity\City | No errors. |
| App\Entity\StudentLevel | No errors. |