GET https://preprod.postlab.fr/equipe/national-center-for-biotechnology-information-ncbi-fv5vksll

Query Metrics

24 Database Queries
15 Different statements
6.34 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.64 ms
(25.93%)
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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "national-center-for-biotechnology-information-ncbi-fv5vksll"
]
0.94 ms
(14.82%)
4
SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?)
Parameters:
[
  70
]
0.86 ms
(13.50%)
4
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 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ?
Parameters:
[
  70
]
0.62 ms
(9.80%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?)
Parameters:
[
  70
]
0.44 ms
(6.99%)
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_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
Parameters:
[
  493
]
0.24 ms
(3.79%)
1
SELECT t0.id AS id_1, t0.original_team_id AS original_team_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.description AS description_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.logo AS logo_16, t3.linked_in AS linked_in_17, t3.twitter AS twitter_18, t3.facebook AS facebook_19, t3.instagram AS instagram_20, t3.youtube AS youtube_21, t3.research_gate AS research_gate_22, t3.academia AS academia_23, t3.members AS members_24, t3.review AS review_25, t3.geolocation_id AS geolocation_id_26, t0.edited_team_id AS edited_team_id_27, t28.id AS id_29, t28.name AS name_30, t28.acronym AS acronym_31, t28.description AS description_32, t28.translation AS translation_33, t28.slug AS slug_34, t28.status AS status_35, t28.created_at AS created_at_36, t28.website AS website_37, t28.github AS github_38, t28.gitlab AS gitlab_39, t28.bitbucket AS bitbucket_40, t28.logo AS logo_41, t28.linked_in AS linked_in_42, t28.twitter AS twitter_43, t28.facebook AS facebook_44, t28.instagram AS instagram_45, t28.youtube AS youtube_46, t28.research_gate AS research_gate_47, t28.academia AS academia_48, t28.members AS members_49, t28.review AS review_50, t28.geolocation_id AS geolocation_id_51 FROM team_copy t0 LEFT JOIN team t3 ON t0.original_team_id = t3.id LEFT JOIN team t28 ON t0.edited_team_id = t28.id WHERE t0.edited_team_id = ?
Parameters:
[
  493
]
0.21 ms
(3.36%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.address AS address_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.website AS website_10, t0.github AS github_11, t0.gitlab AS gitlab_12, t0.bitbucket AS bitbucket_13, t0.logo AS logo_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.instagram AS instagram_18, t0.youtube AS youtube_19, t0.research_gate AS research_gate_20, t0.academia AS academia_21, t0.review AS review_22 FROM lab t0 INNER JOIN lab_team ON t0.id = lab_team.lab_id WHERE lab_team.team_id = ?
Parameters:
[
  493
]
0.21 ms
(3.31%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.address AS address_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.logo AS logo_10, t0.linked_in AS linked_in_11, t0.twitter AS twitter_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.review AS review_16 FROM institution t0 INNER JOIN institution_team ON t0.id = institution_team.institution_id WHERE institution_team.team_id = ?
Parameters:
[
  493
]
0.19 ms
(2.93%)
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 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
Parameters:
[
  493
]
0.19 ms
(2.93%)
1
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM domain t0 INNER JOIN team_domain ON t0.id = team_domain.domain_id WHERE team_domain.team_id = ?
Parameters:
[
  493
]
0.18 ms
(2.90%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_software ON t0.id = media_software.media_id WHERE media_software.software_id = ?
Parameters:
[
  71
]
0.18 ms
(2.79%)
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 INNER JOIN team_contact_user ON t0.id = team_contact_user.user_id WHERE team_contact_user.team_id = ?
Parameters:
[
  493
]
0.16 ms
(2.45%)
1
SELECT t0.id AS id_1, t0.discipline AS discipline_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM discipline t0 INNER JOIN team_discipline ON t0.id = team_discipline.discipline_id WHERE team_discipline.team_id = ?
Parameters:
[
  493
]
0.15 ms
(2.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.review AS review_6, t0.author_id AS author_id_7 FROM keyword t0 INNER JOIN keyword_team ON t0.id = keyword_team.keyword_id WHERE keyword_team.team_id = ?
Parameters:
[
  493
]
0.14 ms
(2.18%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
Parameters:
[
  493
]

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\Team No errors.
App\Entity\Geolocation No errors.
App\Entity\Software No errors.
App\Entity\Domain No errors.
App\Entity\Discipline No errors.
App\Entity\Lab No errors.
App\Entity\Institution No errors.
App\Entity\Container No errors.
App\Entity\Comment No errors.
App\Entity\SoftwareData No errors.
App\Entity\DemoSoftwareData No errors.
App\Entity\CollectedData No errors.
App\Entity\Media No errors.
App\Entity\Keyword No errors.
App\Entity\Tag No errors.
App\Entity\License No errors.
App\Entity\SoftwareCopy No errors.
App\Entity\ProgrammingLanguage No errors.
App\Entity\DataType No 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\Article No errors.
App\Entity\Skill No errors.
App\Entity\Training No errors.
App\Entity\Page No errors.
App\Entity\TeamCopy No errors.