| 1 |
0.96 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 = ?
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 = '19';
|
| 2 |
0.22 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 = ?
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 = 19;
|
| 3 |
0.24 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 = ?
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 = 19;
|
| 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 = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM laboratory t0 WHERE t0.id = 8;
|
| 5 |
0.44 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 = ?
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 = 67;
|
| 6 |
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 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 = 56;
|
| 7 |
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 = ?
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 = 68;
|
| 8 |
0.28 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 = ?
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 = 69;
|
| 9 |
0.14 ms |
SELECT t0.id AS id_1, t0.budget_category AS budget_category_2 FROM budget t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.budget_category AS budget_category_2 FROM budget t0 WHERE t0.id = 1;
|
| 10 |
0.36 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
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 = 19 ORDER BY t0.funding_category_id ASC;
|
| 11 |
0.13 ms |
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM funding t0 WHERE t0.id = 16;
|
| 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 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 = 16;
|
| 13 |
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 funding_organization_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_organization_translation t0 WHERE t0.translatable_id = 22;
|
| 14 |
0.25 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 = ?
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 = 47;
|
| 15 |
0.26 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 = ?
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 = 19;
|
| 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 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 = 13;
|
| 17 |
0.31 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 = ?
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 = 19;
|
| 18 |
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 = ?
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;
|
| 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 = ?
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 = 46;
|
| 20 |
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 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 = 47;
|
| 21 |
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 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 = 54;
|
| 22 |
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 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 = 62;
|
| 23 |
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 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 = 64;
|
| 24 |
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 = ?
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 = 19;
|
| 25 |
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 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 = 45;
|
| 26 |
0.25 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 = ?
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 = 19;
|
| 27 |
0.25 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 = ?
SELECT t0.id AS id_1, t0.academic_partner_category_id AS academic_partner_category_id_2 FROM academic_partner t0 WHERE t0.id = 68;
|
| 28 |
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 = ?
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 = 68;
|
| 29 |
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 = ?
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 = 38;
|
| 30 |
0.11 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 = ?
SELECT t0.id AS id_1, t0.academic_partner_category_id AS academic_partner_category_id_2 FROM academic_partner t0 WHERE t0.id = 90;
|
| 31 |
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 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 = 90;
|
| 32 |
0.24 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 = ?
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 = 121;
|
| 33 |
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 = ?
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 = 75;
|
| 34 |
0.29 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
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 = 19 ORDER BY t0.practitioner_partner_id ASC;
|
| 35 |
0.12 ms |
SELECT t0.id AS id_1 FROM practitioner_partner t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM practitioner_partner t0 WHERE t0.id = 10;
|
| 36 |
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 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 = 10;
|
| 37 |
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_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 sub_practitioner_partner_translation t0 WHERE t0.translatable_id = 95;
|
| 38 |
0.16 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
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 = 19 ORDER BY t0.thematic_id ASC;
|
| 39 |
0.12 ms |
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = 7;
|
| 40 |
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 = ?
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;
|
| 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 sub_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 sub_thematic_translation t0 WHERE t0.translatable_id = 43;
|
| 42 |
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 = ?
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 = 22;
|
| 43 |
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 = ?
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 = 37;
|
| 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 = ?
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 = 38;
|
| 45 |
0.09 ms |
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = 10;
|
| 46 |
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 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 = 10;
|
| 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 sub_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 sub_thematic_translation t0 WHERE t0.translatable_id = 66;
|
| 48 |
0.09 ms |
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = 12;
|
| 49 |
0.08 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 = ?
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 = 12;
|
| 50 |
0.08 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 = ?
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 = 76;
|
| 51 |
0.08 ms |
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = ?
SELECT t0.id AS id_1 FROM thematic t0 WHERE t0.id = 13;
|
| 52 |
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 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 = 13;
|
| 53 |
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 = ?
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 = 89;
|
| 54 |
0.08 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 = ?
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 = 90;
|
| 55 |
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 = ?
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 = 93;
|