GET https://back.digitalcompetences.org/api/referent/3/availabilities

Query Metrics

8 Database Queries
7 Different statements
9.51 ms Query time
2 Invalid entities
30 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.13 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 1.00 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.54 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.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:
[
  3
]
5 1.56 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 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "diagnosis"
]
6 1.68 ms
SELECT t0.id AS id_1, t0.starts_at AS starts_at_2, t0.ends_at AS ends_at_3, t0.is_unavailable AS is_unavailable_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7, t0.events_model_id AS events_model_id_8 FROM availabilities t0 WHERE t0.user_id = ?
Parameters:
[
  3
]
7 1.05 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:
[
  14
]
8 1.13 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:
[
  14
]

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\Availability 20
App\Entity\Role 4
App\Entity\User 2
App\Entity\Structure 1
App\Entity\CandidateFilesSafe 1
App\Entity\EventsType 1
App\Entity\EventsModel 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.