Query Metrics
6
Database Queries
6
Different statements
2.49 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.46 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.settings_id AS settings_id_10, t11.id AS id_12, t11.candidate_decline_comments AS candidate_decline_comments_13, t11.candidate_recommendations AS candidate_recommendations_14, t11.user_id AS user_id_15, t16.id AS id_17, t16.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_18, t16.user_id AS user_id_19 FROM user t0 LEFT JOIN reviewer_settings t11 ON t11.user_id = t0.id LEFT JOIN tip_settings t16 ON t16.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.48 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_zoom_report AS can_view_zoom_report_9, t0.can_view_payments_report AS can_view_payments_report_10, t0.can_view_students_personal_data AS can_view_students_personal_data_11, t0.can_view_payments AS can_view_payments_12, t0.can_edit_candidates AS can_edit_candidates_13, t0.can_view_campaigns AS can_view_campaigns_14, t0.can_view_payment_requisites AS can_view_payment_requisites_15, t0.can_send_campaigns AS can_send_campaigns_16, t0.can_use_test_features AS can_use_test_features_17, t0.can_remove_payments AS can_remove_payments_18, t0.can_compare_table AS can_compare_table_19, t0.can_edit_candidate_access_by_receipt AS can_edit_candidate_access_by_receipt_20, t0.can_edit_all_candidate_params AS can_edit_all_candidate_params_21, t0.is_curator AS is_curator_22, t0.can_view_delayed_messages AS can_view_delayed_messages_23, t0.can_view_call_lists AS can_view_call_lists_24, t0.can_edit_call_lists AS can_edit_call_lists_25, t0.can_register_for_calendar_events AS can_register_for_calendar_events_26, t0.can_view_inner_payments AS can_view_inner_payments_27, t0.can_edit_inner_payments AS can_edit_inner_payments_28, t0.start_candidates_calendar_events_date AS start_candidates_calendar_events_date_29, t0.end_candidates_calendar_events_date AS end_candidates_calendar_events_date_30 FROM user_settings t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 0.40 ms |
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.author_id AS author_id_13, t0.person_id AS person_id_14, t0.calendar_event_id AS calendar_event_id_15, t0.image_id AS image_id_16, t0.selected_author_id AS selected_author_id_17, t0.curator_id AS curator_id_18 FROM candidate t0 WHERE t0.id = ?
Parameters:
[
"160"
]
|
| 4 | 0.55 ms |
SELECT p0_.id AS id_0, p0_.amount AS amount_1, p0_.created_at AS created_at_2, p0_.comment AS comment_3, p0_.date_time AS date_time_4, p0_.receipt_file AS receipt_file_5, p0_.type AS type_6, p0_.calendar_event_id AS calendar_event_id_7, p0_.created_by_id AS created_by_id_8, p0_.person_id AS person_id_9 FROM payment p0_ WHERE p0_.person_id = ? AND p0_.calendar_event_id = ? AND p0_.type = ?
Parameters:
[ 1051 13 "inner" ] |
| 5 | 0.34 ms |
SELECT p0_.id AS id_0, p0_.amount AS amount_1, p0_.created_at AS created_at_2, p0_.comment AS comment_3, p0_.date_time AS date_time_4, p0_.receipt_file AS receipt_file_5, p0_.type AS type_6, p0_.calendar_event_id AS calendar_event_id_7, p0_.created_by_id AS created_by_id_8, p0_.person_id AS person_id_9 FROM payment p0_ WHERE p0_.person_id = ? AND p0_.calendar_event_id = ?
Parameters:
[ 1051 13 ] |
| 6 | 0.26 ms |
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 FROM calendar_event t0 WHERE t0.id = ?
Parameters:
[
13
]
|
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\Student | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\CalendarEvent | No errors. |
| App\Entity\Candidate | No errors. |
| App\Entity\TelegramCampaignParticipant | No errors. |
| App\Entity\TelegramCampaign | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\PaymentRequisites | No errors. |
| App\Entity\TelegramCampaignMessage | No errors. |