Query Metrics
8
Database Queries
5
Different statements
2.31 ms
Query time
0
Invalid entities
15
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.58 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.is_active AS is_active_3, l0_.is_default AS is_default_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.deleted_at AS deleted_at_7 FROM language l0_ WHERE l0_.is_active = 1 ORDER BY l0_.is_default DESC, l0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||
| 2 | 0.60 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.locale AS locale_8, t0.deletion_requested_at AS deletion_requested_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t13.id AS id_14, t13.code AS code_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.birth_date AS birth_date_18, t13.nationality AS nationality_19, t13.phone AS phone_20, t13.marital_status AS marital_status_21, t13.address AS address_22, t13.current_step AS current_step_23, t13.status_eligible AS status_eligible_24, t13.status_visa_eligible AS status_visa_eligible_25, t13.status_visa_non_eligible AS status_visa_non_eligible_26, t13.eligibility_pay AS eligibility_pay_27, t13.visa_eligible_step1_pay AS visa_eligible_step1_pay_28, t13.visa_eligible_step2_pay AS visa_eligible_step2_pay_29, t13.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_30, t13.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_31, t13.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_32, t13.payment_instructions AS payment_instructions_33, t13.rejection_reason AS rejection_reason_34, t13.agreement_sent_at AS agreement_sent_at_35, t13.agreement_validated_at AS agreement_validated_at_36, t13.created_at AS created_at_37, t13.updated_at AS updated_at_38, t13.deleted_at AS deleted_at_39, t13.user_id AS user_id_40, t13.birth_certificate_id AS birth_certificate_id_41, t13.passport_id AS passport_id_42, t43.id AS id_44, t43.code AS code_45, t43.first_name AS first_name_46, t43.last_name AS last_name_47, t43.birth_date AS birth_date_48, t43.nationality AS nationality_49, t43.phone AS phone_50, t43.marital_status AS marital_status_51, t43.address AS address_52, t43.gender AS gender_53, t43.citizenship AS citizenship_54, t43.number_of_children AS number_of_children_55, t43.current_immigration_status AS current_immigration_status_56, t43.application_type AS application_type_57, t43.language_test AS language_test_58, t43.language_test_score AS language_test_score_59, t43.has_family_in_canada AS has_family_in_canada_60, t43.current_step AS current_step_61, t43.status_eligible AS status_eligible_62, t43.status_visa_eligible AS status_visa_eligible_63, t43.status_visa_non_eligible AS status_visa_non_eligible_64, t43.eligibility_pay AS eligibility_pay_65, t43.visa_eligible_step1_pay AS visa_eligible_step1_pay_66, t43.visa_eligible_step2_pay AS visa_eligible_step2_pay_67, t43.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_68, t43.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_69, t43.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_70, t43.payment_instructions AS payment_instructions_71, t43.rejection_reason AS rejection_reason_72, t43.agreement_sent_at AS agreement_sent_at_73, t43.agreement_validated_at AS agreement_validated_at_74, t43.created_at AS created_at_75, t43.updated_at AS updated_at_76, t43.deleted_at AS deleted_at_77, t43.user_id AS user_id_78, t43.cv_id AS cv_id_79, t43.diploma_id AS diploma_id_80, t43.identity_photo_id AS identity_photo_id_81, t43.passport_id AS passport_id_82 FROM `user` t0 LEFT JOIN student t13 ON t13.user_id = t0.id LEFT JOIN worker t43 ON t43.user_id = t0.id WHERE t0.id = ?
Parameters:
[
8
]
|
||||||||||||||||||||||||||
| 3 | 0.29 ms |
SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.site_url AS site_url_3, t0.copyright_text AS copyright_text_4, t0.meta_description AS meta_description_5, t0.email AS email_6, t0.email_sender AS email_sender_7, t0.email_sender_name AS email_sender_name_8, t0.telephone AS telephone_9, t0.whatsapp AS whatsapp_10, t0.address AS address_11, t0.facebook_url AS facebook_url_12, t0.instagram_url AS instagram_url_13, t0.primary_color AS primary_color_14, t0.secondary_color AS secondary_color_15, t0.theme AS theme_16, t0.flash_library AS flash_library_17, t0.flash_position AS flash_position_18, t0.flash_duration AS flash_duration_19, t0.is_captcha_login_enabled AS is_captcha_login_enabled_20, t0.is_captcha_register_enabled AS is_captcha_register_enabled_21, t0.is_captcha_contact_enabled AS is_captcha_contact_enabled_22, t0.student_code_prefix AS student_code_prefix_23, t0.worker_code_prefix AS worker_code_prefix_24, t0.bank_details AS bank_details_25, t0.currency AS currency_26, t0.student_eligibility_fee AS student_eligibility_fee_27, t0.student_eligible_advance AS student_eligible_advance_28, t0.student_eligible_balance AS student_eligible_balance_29, t0.student_non_eligible_advance1 AS student_non_eligible_advance1_30, t0.student_non_eligible_advance2 AS student_non_eligible_advance2_31, t0.student_non_eligible_balance AS student_non_eligible_balance_32, t0.worker_eligibility_fee AS worker_eligibility_fee_33, t0.worker_eligible_advance AS worker_eligible_advance_34, t0.worker_eligible_balance AS worker_eligible_balance_35, t0.worker_non_eligible_advance1 AS worker_non_eligible_advance1_36, t0.worker_non_eligible_advance2 AS worker_non_eligible_advance2_37, t0.worker_non_eligible_balance AS worker_non_eligible_balance_38, t0.logo_dark_id AS logo_dark_id_39, t0.logo_light_id AS logo_light_id_40, t0.favicon_id AS favicon_id_41, t0.email_img_id AS email_img_id_42 FROM setting t0 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||
| 4 | 0.21 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.status AS status_4, t0.method AS method_5, t0.paid_at AS paid_at_6, t0.reference AS reference_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.receipt_id AS receipt_id_12 FROM payment t0 WHERE t0.user_id = ?
Parameters:
[
8
]
|
||||||||||||||||||||||||||
| 5 | 0.18 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.extension AS extension_3, t0.directory AS directory_4 FROM media t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||
| 6 | 0.14 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.extension AS extension_3, t0.directory AS directory_4 FROM media t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||
| 7 | 0.13 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.extension AS extension_3, t0.directory AS directory_4 FROM media t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||
| 8 | 0.18 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.is_active AS is_active_3, l0_.is_default AS is_default_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.deleted_at AS deleted_at_7 FROM language l0_ WHERE l0_.is_active = 1 ORDER BY l0_.is_default DESC, l0_.name ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Media | 8 |
| App\Entity\Language | 2 |
| App\Entity\Payment | 2 |
| App\Entity\User | 1 |
| App\Entity\Student | 1 |
| App\Entity\Setting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Language | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Student | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Worker | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\StudentParent | No errors. |
| App\Entity\AcademicRecord | No errors. |
| App\Entity\Setting | No errors. |