GET https://govoyage.ekrea.cloud/fr/account

Query Metrics

8 Database Queries
5 Different statements
1.94 ms Query time
0 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.52 ms
(27.03%)
3
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
]
0.44 ms
(22.86%)
1
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
]
0.44 ms
(22.55%)
2
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:
[]
0.29 ms
(14.86%)
1
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:
[]
0.25 ms
(12.70%)
1
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
]

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.