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

Query Metrics

50 Database Queries
28 Different statements
9.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 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:
[
  "14"
]
2 0.18 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:
[
  14
]
3 0.26 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:
[
  14
]
4 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  29
]
5 0.45 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:
[
  45
]
6 0.15 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:
[
  89
]
7 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  8
]
8 0.30 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:
[
  46
]
9 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_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  37
]
10 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  28
]
11 0.24 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:
[
  47
]
12 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_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  61
]
13 0.26 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:
[
  48
]
14 0.22 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:
[
  49
]
15 0.22 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:
[
  50
]
16 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_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  56
]
17 0.11 ms
SELECT t0.id AS id_1, t0.budget_category AS budget_category_2 FROM budget t0 WHERE t0.id = ?
Parameters:
[
  3
]
18 0.32 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:
[
  14
]
19 0.13 ms
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  13
]
20 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:
[
  13
]
21 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 funding_organization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
22 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:
[
  14
]
23 0.15 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:
[
  12
]
24 0.30 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:
[
  14
]
25 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 compartment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  54
]
26 0.29 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:
[
  14
]
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 country_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  27
]
28 0.27 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:
[
  14
]
29 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:
[
  20
]
30 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 region_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
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 region_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  28
]
32 0.09 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:
[
  29
]
33 0.09 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:
[
  35
]
34 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 region_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  36
]
35 0.09 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:
[
  30
]
36 0.22 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:
[
  14
]
37 0.21 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:
[
  64
]
38 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:
[
  64
]
39 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:
[
  33
]
40 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:
[
  63
]
41 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 academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  63
]
42 0.23 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:
[
  34
]
43 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_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  41
]
44 0.28 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:
[
  14
]
45 0.13 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:
[
  14
]
46 0.12 ms
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
Parameters:
[
  9
]
47 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 thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
48 0.22 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:
[
  50
]
49 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:
[
  56
]
50 0.09 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:
[
  60
]

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.