Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.manager AS manager_2,
  t0.name AS name_3,
  t0.firstname AS firstname_4,
  t0.email AS email_5,
  t0.is_admin AS is_admin_6,
  t0.orcid AS orcid_7,
  t0.expertise_type_id AS expertise_type_id_8,
  t0.country_id AS country_id_9
FROM
  expert t0

SELECT t0.id AS id_1, t0.manager AS manager_2, t0.name AS name_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.is_admin AS is_admin_6, t0.orcid AS orcid_7, t0.expertise_type_id AS expertise_type_id_8, t0.country_id AS country_id_9 FROM expert t0;

SELECT
  count(DISTINCT e0_.country_id) AS sclr_0
FROM
  expert e0_

SELECT count(DISTINCT e0_.country_id) AS sclr_0 FROM expert e0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  specie t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM specie t0;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  general_skill t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM general_skill t0;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  specie_area t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM specie_area t0;

SELECT
  e0_.id AS id_0,
  e0_.manager AS manager_1,
  e0_.name AS name_2,
  e0_.firstname AS firstname_3,
  e0_.email AS email_4,
  e0_.is_admin AS is_admin_5,
  e0_.orcid AS orcid_6,
  count(e0_.id) AS sclr_7,
  e0_.expertise_type_id AS expertise_type_id_8,
  e0_.country_id AS country_id_9
FROM
  expert e0_
GROUP BY
  e0_.country_id
ORDER BY
  sclr_7 DESC

SELECT e0_.id AS id_0, e0_.manager AS manager_1, e0_.name AS name_2, e0_.firstname AS firstname_3, e0_.email AS email_4, e0_.is_admin AS is_admin_5, e0_.orcid AS orcid_6, count(e0_.id) AS sclr_7, e0_.expertise_type_id AS expertise_type_id_8, e0_.country_id AS country_id_9 FROM expert e0_ GROUP BY e0_.country_id ORDER BY sclr_7 DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 76;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 110;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 218;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 86;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 107;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 230;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 83;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM country t0 WHERE t0.id = 158;

SELECT
  e0_.id AS id_0,
  count(DISTINCT e0_.expert_id) AS sclr_1,
  e0_.expert_id AS expert_id_2,
  e0_.specie_id AS specie_id_3,
  e0_.specie_area_id AS specie_area_id_4
FROM
  expert_area_specie e0_
GROUP BY
  e0_.specie_id
ORDER BY
  sclr_1 DESC

SELECT e0_.id AS id_0, count(DISTINCT e0_.expert_id) AS sclr_1, e0_.expert_id AS expert_id_2, e0_.specie_id AS specie_id_3, e0_.specie_area_id AS specie_area_id_4 FROM expert_area_specie e0_ GROUP BY e0_.specie_id ORDER BY sclr_1 DESC;