GET https://preprod.postlab.fr/laboratoire/laboratoire-d-informatique-du-traitement-de-l-information-et-des-systemes-litis-frwaq5ci-2

Response
200 OK
IP
3.133.123.162
Profiled on
Token
e327a3

Query Metrics

20 Database Queries
14 Different statements
3.93 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.34 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 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "laboratoire-d-informatique-du-traitement-de-l-information-et-des-systemes-litis-frwaq5ci-2"
]
View formatted query    View runnable query    Explain query
2 0.23 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: 
[
  67
]
View formatted query    View runnable query    Explain query
3 0.26 ms 
SELECT t0.id AS id_1, t0.original_lab_id AS original_lab_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.description AS description_7, t3.address AS address_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.created_at AS created_at_12, t3.website AS website_13, t3.github AS github_14, t3.gitlab AS gitlab_15, t3.bitbucket AS bitbucket_16, t3.logo AS logo_17, t3.linked_in AS linked_in_18, t3.twitter AS twitter_19, t3.facebook AS facebook_20, t3.instagram AS instagram_21, t3.youtube AS youtube_22, t3.research_gate AS research_gate_23, t3.academia AS academia_24, t3.review AS review_25, t0.edited_lab_id AS edited_lab_id_26, t27.id AS id_28, t27.name AS name_29, t27.acronym AS acronym_30, t27.description AS description_31, t27.address AS address_32, t27.translation AS translation_33, t27.slug AS slug_34, t27.status AS status_35, t27.created_at AS created_at_36, t27.website AS website_37, t27.github AS github_38, t27.gitlab AS gitlab_39, t27.bitbucket AS bitbucket_40, t27.logo AS logo_41, t27.linked_in AS linked_in_42, t27.twitter AS twitter_43, t27.facebook AS facebook_44, t27.instagram AS instagram_45, t27.youtube AS youtube_46, t27.research_gate AS research_gate_47, t27.academia AS academia_48, t27.review AS review_49 FROM lab_copy t0 LEFT JOIN lab t3 ON t0.original_lab_id = t3.id LEFT JOIN lab t27 ON t0.edited_lab_id = t27.id WHERE t0.edited_lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
4 0.21 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_lab ON t0.id = user_lab.user_id WHERE user_lab.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
5 0.21 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_lab ON t0.id = software_lab.software_id WHERE software_lab.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
6 0.18 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 lab_institution ON t0.id = lab_institution.institution_id WHERE lab_institution.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
7 0.16 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_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
8 0.20 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_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
9 0.18 ms 
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_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.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?)
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
10 0.21 ms 
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_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.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?)
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
11 0.19 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_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ?
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
12 0.21 ms 
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_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.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?)
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
13 0.22 ms 
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_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.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?)
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
14 0.21 ms 
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_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.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?)
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
15 0.18 ms 
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_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.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?)
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
16 0.17 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 INNER JOIN lab_team ON t0.id = lab_team.team_id WHERE lab_team.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
17 0.16 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 lab_domain ON t0.id = lab_domain.domain_id WHERE lab_domain.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
18 0.14 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 lab_discipline ON t0.id = lab_discipline.discipline_id WHERE lab_discipline.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
19 0.10 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_lab ON t0.id = keyword_lab.keyword_id WHERE keyword_lab.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
20 0.15 ms 
SELECT t0.id AS id_1, t0.continent AS continent_2, t0.country AS country_3, t0.region AS region_4, t0.department AS department_5, t0.city AS city_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.zip_code AS zip_code_9, t0.address AS address_10, t0.department_num AS department_num_11 FROM geolocation t0 INNER JOIN lab_geolocation ON t0.id = lab_geolocation.geolocation_id WHERE lab_geolocation.lab_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query

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\Lab No errors.
App\Entity\Software No errors.
App\Entity\Domain No errors.
App\Entity\Discipline No errors.
App\Entity\Skill No errors.
App\Entity\Team No errors.
App\Entity\Institution No errors.
App\Entity\Comment 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\LabCopy No errors.
App\Entity\Geolocation No errors.
App\Entity\InstitutionCopy No errors.