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

Query Metrics

86 Database Queries
29 Different statements
18.72 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.20 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:
[
  "56"
]
2 0.34 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:
[
  56
]
3 0.25 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:
[
  56
]
4 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  3
]
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:
[
  231
]
6 0.17 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:
[
  53
]
7 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  13
]
8 0.34 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:
[
  232
]
9 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_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  52
]
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 sub_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  55
]
11 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:
[
  234
]
12 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  30
]
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:
[
  235
]
14 0.27 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:
[
  236
]
15 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:
[
  63
]
16 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = ?
Parameters:
[
  17
]
17 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:
[
  237
]
18 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:
[
  2
]
19 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:
[
  239
]
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 sub_domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  37
]
21 0.25 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:
[
  240
]
22 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:
[
  241
]
23 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:
[
  41
]
24 0.27 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:
[
  242
]
25 0.25 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:
[
  250
]
26 0.14 ms
SELECT t0.id AS id_1, t0.budget_category AS budget_category_2 FROM budget t0 WHERE t0.id = ?
Parameters:
[
  3
]
27 0.35 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:
[
  56
]
28 0.14 ms
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  13
]
29 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 funding_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
30 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 funding_organization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
31 0.11 ms
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  16
]
32 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 funding_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
33 0.27 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:
[
  58
]
34 0.15 ms
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  20
]
35 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:
[
  20
]
36 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 funding_organization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  66
]
37 0.28 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:
[
  56
]
38 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 approach_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
39 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:
[
  21
]
40 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 approach_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
41 0.33 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:
[
  56
]
42 0.18 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:
[
  44
]
43 0.36 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:
[
  56
]
44 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 country_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  28
]
45 0.21 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:
[
  29
]
46 0.30 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:
[
  56
]
47 0.31 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:
[
  127
]
48 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 academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  127
]
49 0.32 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:
[
  112
]
50 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:
[
  126
]
51 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 academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  126
]
52 0.30 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:
[
  113
]
53 0.23 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:
[
  128
]
54 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 academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  128
]
55 0.28 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:
[
  114
]
56 0.23 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:
[
  129
]
57 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:
[
  129
]
58 0.28 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:
[
  115
]
59 0.22 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:
[
  130
]
60 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:
[
  130
]
61 0.28 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:
[
  116
]
62 0.23 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:
[
  131
]
63 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:
[
  131
]
64 0.29 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:
[
  117
]
65 0.26 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:
[
  132
]
66 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 academic_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  132
]
67 0.30 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:
[
  118
]
68 0.35 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:
[
  56
]
69 0.28 ms
SELECT t0.id AS id_1 FROM practitioner_partner t0 WHERE t0.id = ?
Parameters:
[
  7
]
70 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 practitioner_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
71 0.32 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_practitioner_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  80
]
72 0.29 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_practitioner_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  82
]
73 0.14 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:
[
  56
]
74 0.14 ms
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
Parameters:
[
  7
]
75 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 thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
76 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:
[
  32
]
77 0.14 ms
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
Parameters:
[
  10
]
78 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:
[
  10
]
79 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:
[
  72
]
80 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:
[
  74
]
81 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:
[
  63
]
82 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:
[
  66
]
83 0.13 ms
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
Parameters:
[
  11
]
84 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 thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
85 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:
[
  87
]
86 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:
[
  88
]

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.