| 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 = ?
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 = '10';
|
| 2 |
0.19 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 = 10;
|
| 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 = ?
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 = 10;
|
| 4 |
0.16 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 = 7;
|
| 5 |
0.42 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 = 30;
|
| 6 |
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 = ?
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 = 42;
|
| 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 = 31;
|
| 8 |
0.13 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;
|
| 9 |
0.39 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 = 10 ORDER BY t0.funding_category_id ASC;
|
| 10 |
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 = 19;
|
| 11 |
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 = ?
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 = 19;
|
| 12 |
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 = ?
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 = 65;
|
| 13 |
0.29 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 = 10;
|
| 14 |
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 = ?
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 = 21;
|
| 15 |
0.29 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 = 10;
|
| 16 |
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 = ?
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 = 41;
|
| 17 |
0.30 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 = 10;
|
| 18 |
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 = ?
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 = 33;
|
| 19 |
0.24 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 = 10;
|
| 20 |
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 = 57;
|
| 21 |
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 = ?
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 = 57;
|
| 22 |
0.34 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 = 27;
|
| 23 |
0.33 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 = 10 ORDER BY t0.practitioner_partner_id ASC;
|
| 24 |
0.15 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 = 10 ORDER BY t0.thematic_id ASC;
|
| 25 |
0.18 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;
|
| 26 |
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;
|
| 27 |
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;
|
| 28 |
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;
|
| 29 |
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 = 41;
|
| 30 |
0.26 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 = 42;
|
| 31 |
0.13 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;
|
| 32 |
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 = ?
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;
|
| 33 |
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 = 93;
|