GET https://back.digitalcompetences.org/api/user/3

Query Metrics

5 Database Queries
4 Different statements
2.28 ms Query time
2 Invalid entities
17 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "sophie@dapres.fr"
]
2 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN roles_users ON t0.id = roles_users.role_id WHERE roles_users.user_id = ?
Parameters:
[
  92
]
3 0.45 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = ?
Parameters:
[
  "3"
]
4 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN roles_users ON t0.id = roles_users.role_id WHERE roles_users.user_id = ?
Parameters:
[
  3
]
5 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.acivityfield_id AS acivityfield_id_6, t0.owner_id AS owner_id_7 FROM sub_fields t0 INNER JOIN user_sub_field ON t0.id = user_sub_field.sub_field_id WHERE user_sub_field.user_id = ?
Parameters:
[
  3
]

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\SubField 5
App\Entity\Role 4
App\Entity\ActivityField 4
App\Entity\User 2
App\Entity\Structure 1
App\Entity\CandidateFilesSafe 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Structure No errors.
App\Entity\CandidateFilesSafe No errors.
App\Entity\Role No errors.
App\Entity\Event
  • The mappings App\Entity\Event#responses and App\Entity\Response#event are inconsistent with each other.
App\Entity\Course
  • The association App\Entity\Course#documents refers to the owning side field App\Entity\Document#courses which does not exist.
App\Entity\Availability No errors.
App\Entity\EventsModel No errors.
App\Entity\SubField No errors.
App\Entity\Survey No errors.
App\Entity\Response No errors.
App\Entity\Document No errors.
App\Entity\Agreement No errors.
App\Entity\Certification No errors.
App\Entity\Claim No errors.
App\Entity\ClaimsReply No errors.
App\Entity\Notification No errors.
App\Entity\ActivityField No errors.