GET https://h2o.ldiro-softwares.dev/projets

Query Metrics

452 Database Queries
32 Different statements
45.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.71 ms
(16.84%)
93
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:
[
  49
]
6.19 ms
(13.52%)
52
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:
[
  7
]
5.66 ms
(12.37%)
52
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:
[
  7
]
5.66 ms
(12.35%)
52
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:
[
  7
]
4.08 ms
(8.91%)
46
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:
[
  1
]
3.50 ms
(7.64%)
36
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
]
2.57 ms
(5.62%)
27
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:
[
  26
]
1.86 ms
(4.06%)
21
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:
[
  18
]
1.16 ms
(2.54%)
11
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
]
0.89 ms
(1.95%)
1
SELECT p0_.id AS id_0, p0_.year_start AS year_start_1, p0_.year_end AS year_end_2, p0_.number_of_theses AS number_of_theses_3, p0_.number_of_masters AS number_of_masters_4, p0_.link AS link_5, p0_.image AS image_6, p0_.studied_zone AS studied_zone_7, p0_.budget_id AS budget_id_8 FROM project p0_ INNER JOIN project_researcher p2_ ON p0_.id = p2_.project_id INNER JOIN researcher r1_ ON r1_.id = p2_.researcher_id
Parameters:
[]
0.75 ms
(1.63%)
8
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
]
0.66 ms
(1.43%)
7
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
]
0.58 ms
(1.27%)
5
SELECT t0.id AS id_1 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.51 ms
(1.11%)
5
SELECT t0.id AS id_1 FROM continent t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.50 ms
(1.10%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM domain_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.48 ms
(1.05%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM continent_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
0.47 ms
(1.02%)
5
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:
[
  6
]
0.37 ms
(0.81%)
3
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_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
0.32 ms
(0.70%)
2
SELECT t0.id AS id_1 FROM academic_partner_category t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.30 ms
(0.66%)
3
SELECT t0.id AS id_1 FROM compartment_category t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.21 ms
(0.45%)
2
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_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
0.20 ms
(0.43%)
1
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.image AS image_2 FROM laboratory l0_
Parameters:
[]
0.14 ms
(0.31%)
1
SELECT a0_.id AS id_0, a0_.academic_partner_category_id AS academic_partner_category_id_1 FROM academic_partner a0_ INNER JOIN academic_partner_category a1_ ON a0_.academic_partner_category_id = a1_.id INNER JOIN academic_partner_category_translation a2_ ON a1_.id = a2_.translatable_id INNER JOIN academic_partner_translation a3_ ON a0_.id = a3_.translatable_id ORDER BY a2_.name ASC, a3_.name ASC
Parameters:
[]
0.14 ms
(0.31%)
1
SELECT s0_.id AS id_0, s0_.domain_id AS domain_id_1 FROM sub_domain s0_
Parameters:
[]
0.13 ms
(0.29%)
1
SELECT c0_.id AS id_0, c0_.continent_id AS continent_id_1 FROM country c0_
Parameters:
[]
0.12 ms
(0.27%)
1
SELECT a0_.id AS id_0 FROM approach a0_
Parameters:
[]
0.12 ms
(0.26%)
1
SELECT r0_.id AS id_0, r0_.country_id AS country_id_1 FROM region r0_
Parameters:
[]
0.12 ms
(0.26%)
1
SELECT c0_.id AS id_0, c0_.compartment_category_id AS compartment_category_id_1 FROM compartment c0_
Parameters:
[]
0.11 ms
(0.24%)
1
SELECT p0_.id AS id_0 FROM practitioner_partner p0_
Parameters:
[]
0.10 ms
(0.22%)
1
SELECT b0_.id AS id_0, b0_.budget_category AS budget_category_1 FROM budget b0_
Parameters:
[]
0.09 ms
(0.19%)
1
SELECT t0_.id AS id_0 FROM thematic t0_
Parameters:
[]
0.09 ms
(0.19%)
1
SELECT f0_.id AS id_0 FROM funding f0_
Parameters:
[]

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.