GET https://back.digitalcompetences.org/api/event/37

Query Metrics

27 Database Queries
17 Different statements
9.48 ms Query time
2 Invalid entities
45 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.80 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.41 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.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.location AS location_7, t0.seats AS seats_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.events_model_id AS events_model_id_11, t0.parent_id AS parent_id_12, t0.author_id AS author_id_13 FROM events t0 WHERE t0.id = ?
Parameters:
[
  "37"
]
4 0.44 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
]
5 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.author_id AS author_id_7, t0.parent_id AS parent_id_8 FROM events_models t0 WHERE t0.id = ?
Parameters:
[
  9
]
6 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7 FROM events_types t0 INNER JOIN events_model_events_type ON t0.id = events_model_events_type.events_type_id WHERE events_model_events_type.events_model_id = ?
Parameters:
[
  9
]
7 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7 FROM events_types t0 INNER JOIN events_eventstypes ON t0.id = events_eventstypes.eventstype_id WHERE events_eventstypes.event_id = ?
Parameters:
[
  37
]
8 0.30 ms
SELECT t0.id AS id_1, t0.attendance AS attendance_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.course_id AS course_id_5, t0.event_id AS event_id_6 FROM registrations t0 WHERE t0.event_id = ?
Parameters:
[
  37
]
9 0.37 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 events_subfields ON t0.id = events_subfields.subfield_id WHERE events_subfields.event_id = ?
Parameters:
[
  37
]
10 0.43 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 INNER JOIN events_users ON t0.id = events_users.user_id WHERE events_users.event_id = ?
Parameters:
[
  37
]
11 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.starts_at AS starts_at_4, t0.ends_at AS ends_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.candidate_id AS candidate_id_8, t0.prescriber_id AS prescriber_id_9, t0.referent_id AS referent_id_10, t0.courses_type_id AS courses_type_id_11 FROM courses t0 WHERE t0.id = ?
Parameters:
[
  13
]
12 0.36 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:
[
  88
]
13 0.32 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.event_id = ?
Parameters:
[
  37
]
14 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.location AS location_7, t0.seats AS seats_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.events_model_id AS events_model_id_11, t0.parent_id AS parent_id_12, t0.author_id AS author_id_13 FROM events t0 WHERE t0.parent_id = ?
Parameters:
[
  37
]
15 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.status AS status_4, t0.version AS version_5, t0.open_time AS open_time_6, t0.close_time AS close_time_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.evaluation_mode AS evaluation_mode_10, t0.surveys_type_id AS surveys_type_id_11, t0.author_id AS author_id_12 FROM surveys t0 INNER JOIN survey_events_type ON t0.id = survey_events_type.survey_id WHERE survey_events_type.events_type_id = ?
Parameters:
[
  1
]
16 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.status AS status_4, t0.version AS version_5, t0.open_time AS open_time_6, t0.close_time AS close_time_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.evaluation_mode AS evaluation_mode_10, t0.surveys_type_id AS surveys_type_id_11, t0.author_id AS author_id_12 FROM surveys t0 INNER JOIN survey_events_model ON t0.id = survey_events_model.survey_id WHERE survey_events_model.events_model_id = ?
Parameters:
[
  9
]
17 0.58 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.owner_id AS owner_id_6 FROM surveys_types t0 WHERE t0.id = ?
Parameters:
[
  4
]
18 0.36 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:
[
  1
]
19 0.27 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.survey_id = ?
Parameters:
[
  5
]
20 0.29 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.owner_id AS owner_id_6 FROM surveys_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
21 0.27 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.survey_id = ?
Parameters:
[
  6
]
22 0.27 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.owner_id AS owner_id_6 FROM surveys_types t0 WHERE t0.id = ?
Parameters:
[
  7
]
23 0.28 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.survey_id = ?
Parameters:
[
  8
]
24 0.25 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.owner_id AS owner_id_6 FROM surveys_types t0 WHERE t0.id = ?
Parameters:
[
  9
]
25 0.26 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.survey_id = ?
Parameters:
[
  9
]
26 0.24 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.owner_id AS owner_id_6 FROM surveys_types t0 WHERE t0.id = ?
Parameters:
[
  6
]
27 0.26 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.survey_id = ?
Parameters:
[
  10
]

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\Response 12
App\Entity\User 9
App\Entity\Survey 5
App\Entity\SurveysType 5
App\Entity\Event 4
App\Entity\CandidateFilesSafe 2
App\Entity\Structure 1
App\Entity\Role 1
App\Entity\EventsModel 1
App\Entity\EventsType 1
App\Entity\Registration 1
App\Entity\Course 1
App\Entity\SubField 1
App\Entity\ActivityField 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\EventsType No errors.
App\Entity\Registration No errors.
App\Entity\ActivityField No errors.
App\Entity\CoursesType No errors.
App\Entity\SurveysType No errors.
App\Entity\Section No errors.
App\Entity\Answer No errors.