GET https://preprod.postlab.fr/user/mathieu-dehouck-uvtmiiml

Query Metrics

5 Database Queries
5 Different statements
1.20 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.39 ms
(32.14%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "mathieu-dehouck-uvtmiiml"
]
0.24 ms
(19.61%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.logo AS logo_13, t0.linked_in AS linked_in_14, t0.twitter AS twitter_15, t0.facebook AS facebook_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.research_gate AS research_gate_19, t0.academia AS academia_20, t0.members AS members_21, t0.review AS review_22, t0.geolocation_id AS geolocation_id_23 FROM team t0 INNER JOIN user_team ON t0.id = user_team.team_id WHERE user_team.user_id = ?
Parameters:
[
  143
]
0.21 ms
(17.45%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_authorized_users ON t0.id = software_authorized_users.software_id WHERE software_authorized_users.user_id = ?
Parameters:
[
  143
]
0.19 ms
(16.18%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.volume_id AS volume_id_3, t0.path AS path_4, t0.server AS server_5, t0.ssh_key AS ssh_key_6, t0.creator AS creator_7, t0.in_exec_space AS in_exec_space_8, t0.file_system_type AS file_system_type_9, t0.type AS type_10, t0.created_at AS created_at_11 FROM volume t0 INNER JOIN volume_user ON t0.id = volume_user.volume_id WHERE volume_user.user_id = ?
Parameters:
[
  143
]
0.18 ms
(14.62%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.ssh_key AS ssh_key_3, t0.type AS type_4, t0.expiration AS expiration_5, t0.user_id AS user_id_6 FROM user_sshkey t0 WHERE t0.user_id IN (?)
Parameters:
[
  143
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#calendars refers to the owning side field App\Entity\Calendar#user which does not exist.
  • The association App\Entity\User#events refers to the owning side field App\Entity\Calendar#users which does not exist.
  • The mappings App\Entity\User#owners and App\Entity\Calendar#owners are inconsistent with each other.
  • The mappings App\Entity\User#participants and App\Entity\Calendar#participants are inconsistent with each other.
App\Entity\Comment No errors.
App\Entity\Domain No errors.
App\Entity\Discipline No errors.
App\Entity\UserSoftware No errors.
App\Entity\Training No errors.
App\Entity\CollectedData No errors.
App\Entity\Media No errors.
App\Entity\Page No errors.
App\Entity\Email No errors.
App\Entity\Lab No errors.
App\Entity\Team No errors.
App\Entity\Geolocation No errors.
App\Entity\Institution No errors.
App\Entity\Skill No errors.
App\Entity\Keyword No errors.
App\Entity\Article No errors.
App\Entity\License No errors.
App\Entity\ProgrammingLanguage No errors.
App\Entity\Category No errors.
App\Entity\DataType No errors.
App\Entity\Encoding No errors.
App\Entity\Format No errors.
App\Entity\HtmlType No errors.
App\Entity\OutputType No errors.
App\Entity\Script No errors.
App\Entity\Tag No errors.
App\Entity\Software No errors.
App\Entity\Notification No errors.
App\Entity\Invitation No errors.
App\Entity\Messages No errors.
App\Entity\Calendar No errors.
App\Entity\UserApiKey No errors.
App\Entity\Volume No errors.
App\Entity\UserSSHKey No errors.
App\Entity\Conversation No errors.
App\Entity\DemoSoftwareData No errors.