Symfony Profiler

SELECT
  f0_.id AS id_0,
  f0_.dates_session AS dates_session_1,
  f0_.image AS image_2,
  f0_.prix AS prix_3,
  f0_.devise AS devise_4,
  t1_.nom AS nom_5,
  t2_.nom AS nom_6,
  v3_.nom AS nom_7,
  v3_.pays AS pays_8,
  f0_.created_at AS created_at_9,
  t1_.slug AS slug_10
FROM
  formations f0_
  INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id)
  INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id)
  INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id)
WHERE
  v3_.pays = ?
ORDER BY
  f0_.created_at DESC

SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.image AS image_2, f0_.prix AS prix_3, f0_.devise AS devise_4, t1_.nom AS nom_5, t2_.nom AS nom_6, v3_.nom AS nom_7, v3_.pays AS pays_8, f0_.created_at AS created_at_9, t1_.slug AS slug_10 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id) INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id) WHERE v3_.pays = 'United States' ORDER BY f0_.created_at DESC;

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  formations f0_
  INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id)
  INNER JOIN villes v2_ ON (f0_.ville_id = v2_.id)
  INNER JOIN thematiques t3_ ON (t1_.thematique_id = t3_.id)
WHERE
  v2_.pays = ?

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v2_ ON (f0_.ville_id = v2_.id) INNER JOIN thematiques t3_ ON (t1_.thematique_id = t3_.id) WHERE v2_.pays = 'United States';

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.created_at AS created_at_1
FROM
  formations f0_
  INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id)
  INNER JOIN villes v2_ ON (f0_.ville_id = v2_.id)
  INNER JOIN thematiques t3_ ON (t1_.thematique_id = t3_.id)
WHERE
  v2_.pays = ?
ORDER BY
  f0_.created_at DESC
LIMIT
  12

SELECT DISTINCT f0_.id AS id_0, f0_.created_at AS created_at_1 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v2_ ON (f0_.ville_id = v2_.id) INNER JOIN thematiques t3_ ON (t1_.thematique_id = t3_.id) WHERE v2_.pays = 'United States' ORDER BY f0_.created_at DESC LIMIT 12;

SELECT
  t0.id AS id_1,
  t0.titremen AS titremen_2,
  t0.slug AS slug_3,
  t0.detailmen AS detailmen_4,
  t0.statutmen AS statutmen_5,
  t0.adminsid AS adminsid_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  mentions t0

SELECT t0.id AS id_1, t0.titremen AS titremen_2, t0.slug AS slug_3, t0.detailmen AS detailmen_4, t0.statutmen AS statutmen_5, t0.adminsid AS adminsid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mentions t0;