GET https://h2o.ldiro-softwares.dev/projet/25

Query Metrics

44 Database Queries
27 Different statements
8.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 ms
SELECT t0.id AS id_1, t0.year_start AS year_start_2, t0.year_end AS year_end_3, t0.number_of_theses AS number_of_theses_4, t0.number_of_masters AS number_of_masters_5, t0.link AS link_6, t0.image AS image_7, t0.studied_zone AS studied_zone_8, t0.budget_id AS budget_id_9 FROM project t0 WHERE t0.id = ?
Parameters:
[
  "25"
]
2 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM project_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  25
]
3 0.27 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.workplace AS workplace_4, t0.ordre AS ordre_5, t0.laboratory_id AS laboratory_id_6 FROM researcher t0 INNER JOIN project_researcher ON t0.id = project_researcher.researcher_id WHERE project_researcher.project_id = ?
Parameters:
[
  25
]
4 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  32
]
5 0.39 ms
SELECT t0.id AS id_1, t0.domain_id AS domain_id_2 FROM sub_domain t0 INNER JOIN researcher_sub_domain ON t0.id = researcher_sub_domain.sub_domain_id WHERE researcher_sub_domain.researcher_id = ?
Parameters:
[
  91
]
6 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  69
]
7 0.33 ms
SELECT t0.id AS id_1, t0.funding_category_id AS funding_category_id_2 FROM funding_organization t0 INNER JOIN project_funding_organization ON t0.id = project_funding_organization.funding_organization_id WHERE project_funding_organization.project_id = ? ORDER BY t0.funding_category_id ASC
Parameters:
[
  25
]
8 0.15 ms
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  18
]
9 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
10 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_organization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  38
]
11 0.16 ms
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  20
]
12 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
13 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM funding_organization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  66
]
14 0.27 ms
SELECT t0.id AS id_1 FROM approach t0 INNER JOIN project_approach ON t0.id = project_approach.approach_id WHERE project_approach.project_id = ?
Parameters:
[
  25
]
15 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM approach_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
16 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM approach_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
17 0.27 ms
SELECT t0.id AS id_1, t0.compartment_category_id AS compartment_category_id_2 FROM compartment t0 INNER JOIN project_compartment ON t0.id = project_compartment.compartment_id WHERE project_compartment.project_id = ?
Parameters:
[
  25
]
18 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM compartment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  34
]
19 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM compartment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  46
]
20 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM compartment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  54
]
21 0.26 ms
SELECT t0.id AS id_1, t0.continent_id AS continent_id_2 FROM country t0 INNER JOIN project_country ON t0.id = project_country.country_id WHERE project_country.project_id = ?
Parameters:
[
  25
]
22 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM country_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  27
]
23 0.23 ms
SELECT t0.id AS id_1, t0.country_id AS country_id_2 FROM region t0 INNER JOIN project_region ON t0.id = project_region.region_id WHERE project_region.project_id = ?
Parameters:
[
  25
]
24 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM region_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
25 0.23 ms
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.academic_partner_id AS academic_partner_id_3 FROM project_academic_partner_domain t0 WHERE t0.project_id = ?
Parameters:
[
  25
]
26 0.24 ms
SELECT t0.id AS id_1, t0.academic_partner_category_id AS academic_partner_category_id_2 FROM academic_partner t0 WHERE t0.id = ?
Parameters:
[
  76
]
27 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  76
]
28 0.26 ms
SELECT t0.id AS id_1, t0.domain_id AS domain_id_2 FROM sub_domain t0 INNER JOIN project_academic_partner_domain_sub_domain ON t0.id = project_academic_partner_domain_sub_domain.sub_domain_id WHERE project_academic_partner_domain_sub_domain.project_academic_partner_domain_id = ?
Parameters:
[
  47
]
29 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  91
]
30 0.19 ms
SELECT t0.id AS id_1, t0.academic_partner_category_id AS academic_partner_category_id_2 FROM academic_partner t0 WHERE t0.id = ?
Parameters:
[
  77
]
31 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  77
]
32 0.20 ms
SELECT t0.id AS id_1, t0.domain_id AS domain_id_2 FROM sub_domain t0 INNER JOIN project_academic_partner_domain_sub_domain ON t0.id = project_academic_partner_domain_sub_domain.sub_domain_id WHERE project_academic_partner_domain_sub_domain.project_academic_partner_domain_id = ?
Parameters:
[
  48
]
33 0.27 ms
SELECT t0.id AS id_1, t0.practitioner_partner_id AS practitioner_partner_id_2 FROM sub_practitioner_partner t0 INNER JOIN project_sub_practitioner_partner ON t0.id = project_sub_practitioner_partner.sub_practitioner_partner_id WHERE project_sub_practitioner_partner.project_id = ? ORDER BY t0.practitioner_partner_id ASC
Parameters:
[
  25
]
34 0.12 ms
SELECT t0.id AS id_1, t0.thematic_id AS thematic_id_2 FROM sub_thematic t0 INNER JOIN project_sub_thematic ON t0.id = project_sub_thematic.sub_thematic_id WHERE project_sub_thematic.project_id = ? ORDER BY t0.thematic_id ASC
Parameters:
[
  25
]
35 0.15 ms
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
Parameters:
[
  9
]
36 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
37 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  51
]
38 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  59
]
39 0.13 ms
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
Parameters:
[
  13
]
40 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
41 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  95
]
42 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  96
]
43 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  99
]
44 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sub_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  93
]

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.