Query Metrics

13 Database Queries
12 Different statements
3.89 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.82 ms
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:
[
  "algorithmes-principes-et-theories-pour-l-acquisition-de-connaissances-et-l-apprentissage-en-collaboration-ex-ama-analyse-de-donnees-modelisation-et-apprentissage-automatique-aptikal-ex-ama-lig-xtyozvh9-1"
]
2 0.36 ms
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:
[
  159
]
3 0.31 ms
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:
[
  159
]
4 0.28 ms
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:
[
  159
]
5 0.30 ms
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:
[
  159
]
6 0.24 ms
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:
[
  159
]
7 0.27 ms
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:
[
  159
]
8 0.24 ms
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_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ?
Parameters:
[
  14
]
9 0.22 ms
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_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ?
Parameters:
[
  211
]
10 0.25 ms
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:
[
  159
]
11 0.20 ms
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:
[
  159
]
12 0.20 ms
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:
[
  159
]
13 0.20 ms
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:
[
  159
]

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\Lab No errors.
App\Entity\Domain No errors.
App\Entity\Discipline No errors.
App\Entity\Skill No errors.
App\Entity\Comment No errors.
App\Entity\Institution No errors.
App\Entity\Media No errors.
App\Entity\Article 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\License No errors.
App\Entity\Training No errors.
App\Entity\Page No errors.
App\Entity\Keyword No errors.
App\Entity\Tag No errors.
App\Entity\TeamCopy No errors.
App\Entity\LabCopy No errors.