GET https://preprod.postlab.fr/cartographie/equipes

Query Metrics

1112 Database Queries
20 Different statements
156.52 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
31.27 ms
(19.98%)
244
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:
[
  49
]
30.48 ms
(19.47%)
244
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:
[
  196
]
28.52 ms
(18.22%)
244
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:
[
  49
]
18.68 ms
(11.93%)
100
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:
[
  20
]
18.37 ms
(11.73%)
102
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:
[
  20
]
12.18 ms
(7.78%)
100
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:
[
  20
]
3.88 ms
(2.48%)
27
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:
[
  21
]
3.32 ms
(2.12%)
1
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.acronym AS acronym_2, l0_.description AS description_3, l0_.address AS address_4, l0_.translation AS translation_5, l0_.slug AS slug_6, l0_.status AS status_7, l0_.created_at AS created_at_8, l0_.website AS website_9, l0_.github AS github_10, l0_.gitlab AS gitlab_11, l0_.bitbucket AS bitbucket_12, l0_.logo AS logo_13, l0_.linked_in AS linked_in_14, l0_.twitter AS twitter_15, l0_.facebook AS facebook_16, l0_.instagram AS instagram_17, l0_.youtube AS youtube_18, l0_.research_gate AS research_gate_19, l0_.academia AS academia_20, l0_.review AS review_21, t1_.id AS id_22, t1_.name AS name_23, t1_.acronym AS acronym_24, t1_.description AS description_25, t1_.translation AS translation_26, t1_.slug AS slug_27, t1_.status AS status_28, t1_.created_at AS created_at_29, t1_.website AS website_30, t1_.github AS github_31, t1_.gitlab AS gitlab_32, t1_.bitbucket AS bitbucket_33, t1_.logo AS logo_34, t1_.linked_in AS linked_in_35, t1_.twitter AS twitter_36, t1_.facebook AS facebook_37, t1_.instagram AS instagram_38, t1_.youtube AS youtube_39, t1_.research_gate AS research_gate_40, t1_.academia AS academia_41, t1_.members AS members_42, t1_.review AS review_43, t1_.geolocation_id AS geolocation_id_44 FROM lab l0_ INNER JOIN lab_team l2_ ON l0_.id = l2_.lab_id INNER JOIN team t1_ ON t1_.id = l2_.team_id WHERE l0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY l0_.acronym ASC
Parameters:
[]
1.75 ms
(1.12%)
10
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:
[
  72
]
1.65 ms
(1.06%)
10
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:
[
  72
]
1.42 ms
(0.91%)
1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.acronym AS acronym_2, t0_.description AS description_3, t0_.translation AS translation_4, t0_.slug AS slug_5, t0_.status AS status_6, t0_.created_at AS created_at_7, t0_.website AS website_8, t0_.github AS github_9, t0_.gitlab AS gitlab_10, t0_.bitbucket AS bitbucket_11, t0_.logo AS logo_12, t0_.linked_in AS linked_in_13, t0_.twitter AS twitter_14, t0_.facebook AS facebook_15, t0_.instagram AS instagram_16, t0_.youtube AS youtube_17, t0_.research_gate AS research_gate_18, t0_.academia AS academia_19, t0_.members AS members_20, t0_.review AS review_21, t0_.geolocation_id AS geolocation_id_22 FROM team t0_ WHERE t0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY t0_.name ASC
Parameters:
[]
1.40 ms
(0.89%)
10
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:
[
  132
]
1.12 ms
(0.71%)
10
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:
[
  132
]
0.80 ms
(0.51%)
1
SELECT g0_.id AS id_0, g0_.continent AS continent_1, g0_.country AS country_2, g0_.region AS region_3, g0_.department AS department_4, g0_.city AS city_5, g0_.status AS status_6, g0_.created_at AS created_at_7, g0_.zip_code AS zip_code_8, g0_.address AS address_9, g0_.department_num AS department_num_10, t1_.id AS id_11, t1_.name AS name_12, t1_.acronym AS acronym_13, t1_.description AS description_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.website AS website_19, t1_.github AS github_20, t1_.gitlab AS gitlab_21, t1_.bitbucket AS bitbucket_22, t1_.logo AS logo_23, t1_.linked_in AS linked_in_24, t1_.twitter AS twitter_25, t1_.facebook AS facebook_26, t1_.instagram AS instagram_27, t1_.youtube AS youtube_28, t1_.research_gate AS research_gate_29, t1_.academia AS academia_30, t1_.members AS members_31, t1_.review AS review_32, t1_.geolocation_id AS geolocation_id_33 FROM geolocation g0_ INNER JOIN team t1_ ON g0_.id = t1_.geolocation_id
Parameters:
[]
0.56 ms
(0.36%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.display_level AS display_level_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.action AS action_8, t0.result_file_path AS result_file_path_9, t0.result_display_path AS result_display_path_10, t0.container_id AS container_id_11, t0.script_id AS script_id_12, t0.output_type_id AS output_type_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t14.status AS status_18, t14.created_at AS created_at_19 FROM command t0 LEFT JOIN output_type t14 ON t0.output_type_id = t14.id WHERE t0.container_id IN (?)
Parameters:
[
  9
]
0.32 ms
(0.21%)
1
SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.acronym AS acronym_8, t1_.description AS description_9, t1_.translation AS translation_10, t1_.slug AS slug_11, t1_.status AS status_12, t1_.created_at AS created_at_13, t1_.website AS website_14, t1_.github AS github_15, t1_.gitlab AS gitlab_16, t1_.bitbucket AS bitbucket_17, t1_.logo AS logo_18, t1_.linked_in AS linked_in_19, t1_.twitter AS twitter_20, t1_.facebook AS facebook_21, t1_.instagram AS instagram_22, t1_.youtube AS youtube_23, t1_.research_gate AS research_gate_24, t1_.academia AS academia_25, t1_.members AS members_26, t1_.review AS review_27, d0_.parent_id AS parent_id_28, d0_.author_id AS author_id_29, t1_.geolocation_id AS geolocation_id_30 FROM discipline d0_ INNER JOIN team_discipline t2_ ON d0_.id = t2_.discipline_id INNER JOIN team t1_ ON t1_.id = t2_.team_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[]
0.28 ms
(0.18%)
1
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:
[
  516
  130
]
0.20 ms
(0.13%)
1
SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.acronym AS acronym_8, t1_.description AS description_9, t1_.translation AS translation_10, t1_.slug AS slug_11, t1_.status AS status_12, t1_.created_at AS created_at_13, t1_.website AS website_14, t1_.github AS github_15, t1_.gitlab AS gitlab_16, t1_.bitbucket AS bitbucket_17, t1_.logo AS logo_18, t1_.linked_in AS linked_in_19, t1_.twitter AS twitter_20, t1_.facebook AS facebook_21, t1_.instagram AS instagram_22, t1_.youtube AS youtube_23, t1_.research_gate AS research_gate_24, t1_.academia AS academia_25, t1_.members AS members_26, t1_.review AS review_27, d0_.parent_id AS parent_id_28, d0_.author_id AS author_id_29, t1_.geolocation_id AS geolocation_id_30 FROM domain d0_ INNER JOIN team_domain t2_ ON d0_.id = t2_.domain_id INNER JOIN team t1_ ON t1_.id = t2_.team_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[]
0.18 ms
(0.12%)
1
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:
[
  516
  130
]
0.14 ms
(0.09%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.display_level AS display_level_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.action AS action_8, t0.result_file_path AS result_file_path_9, t0.result_display_path AS result_display_path_10, t0.container_id AS container_id_11, t0.script_id AS script_id_12, t0.output_type_id AS output_type_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t14.status AS status_18, t14.created_at AS created_at_19 FROM command t0 LEFT JOIN output_type t14 ON t0.output_type_id = t14.id WHERE t0.container_id IN (?, ?, ?)
Parameters:
[
  1
  2
  8
]

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\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\Skill No errors.
App\Entity\Institution No errors.
App\Entity\Comment No errors.
App\Entity\Media No errors.
App\Entity\Keyword No errors.
App\Entity\Tag No errors.
App\Entity\LabCopy 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\Container No errors.
App\Entity\SoftwareData No errors.
App\Entity\DemoSoftwareData No errors.
App\Entity\CollectedData No errors.
App\Entity\License No errors.
App\Entity\SoftwareCopy No errors.
App\Entity\ProgrammingLanguage No errors.
App\Entity\DataType No errors.
App\Entity\Article No errors.
App\Entity\UserSoftware No errors.
App\Entity\Training No errors.
App\Entity\Page No errors.
App\Entity\Email No errors.
App\Entity\Category 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\Notification No errors.
App\Entity\Invitation No errors.
App\Entity\Messages No errors.
App\Entity\Calendar No errors.
App\Entity\Command No errors.
App\Entity\Parameter No errors.
App\Entity\UserApiKey No errors.
App\Entity\Volume No errors.
App\Entity\UserSSHKey No errors.
App\Entity\Conversation No errors.
App\Entity\TeamCopy No errors.