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 = ?
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 = 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
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 = 7 ORDER BY t0.thematic_id ASC;
|
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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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
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;
|
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 = ?
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 = 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 = ?
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 = 7;
|
0.58 ms (1.27%)
|
5 |
SELECT t0.id AS id_1 FROM domain t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM domain t0 WHERE t0.id = 1;
|
0.51 ms (1.11%)
|
5 |
SELECT t0.id AS id_1 FROM continent t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM continent t0 WHERE t0.id = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 4;
|
0.32 ms (0.70%)
|
2 |
SELECT t0.id AS id_1 FROM academic_partner_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM academic_partner_category t0 WHERE t0.id = 3;
|
0.30 ms (0.66%)
|
3 |
SELECT t0.id AS id_1 FROM compartment_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM compartment_category t0 WHERE t0.id = 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 = ?
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 = 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_
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.image AS image_2 FROM laboratory l0_;
|
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
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;
|
0.14 ms (0.31%)
|
1 |
SELECT s0_.id AS id_0, s0_.domain_id AS domain_id_1 FROM sub_domain s0_
SELECT s0_.id AS id_0, s0_.domain_id AS domain_id_1 FROM sub_domain s0_;
|
0.13 ms (0.29%)
|
1 |
SELECT c0_.id AS id_0, c0_.continent_id AS continent_id_1 FROM country c0_
SELECT c0_.id AS id_0, c0_.continent_id AS continent_id_1 FROM country c0_;
|
0.12 ms (0.27%)
|
1 |
SELECT a0_.id AS id_0 FROM approach a0_
SELECT a0_.id AS id_0 FROM approach a0_;
|
0.12 ms (0.26%)
|
1 |
SELECT r0_.id AS id_0, r0_.country_id AS country_id_1 FROM region r0_
SELECT r0_.id AS id_0, r0_.country_id AS country_id_1 FROM region r0_;
|
0.12 ms (0.26%)
|
1 |
SELECT c0_.id AS id_0, c0_.compartment_category_id AS compartment_category_id_1 FROM compartment c0_
SELECT c0_.id AS id_0, c0_.compartment_category_id AS compartment_category_id_1 FROM compartment c0_;
|
0.11 ms (0.24%)
|
1 |
SELECT p0_.id AS id_0 FROM practitioner_partner p0_
SELECT p0_.id AS id_0 FROM practitioner_partner p0_;
|
0.10 ms (0.22%)
|
1 |
SELECT b0_.id AS id_0, b0_.budget_category AS budget_category_1 FROM budget b0_
SELECT b0_.id AS id_0, b0_.budget_category AS budget_category_1 FROM budget b0_;
|
0.09 ms (0.19%)
|
1 |
SELECT t0_.id AS id_0 FROM thematic t0_
SELECT t0_.id AS id_0 FROM thematic t0_;
|
0.09 ms (0.19%)
|
1 |
SELECT f0_.id AS id_0 FROM funding f0_
SELECT f0_.id AS id_0 FROM funding f0_;
|