Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.numero_ec AS numero_ec_1,
          e0_.exploitant_nom AS exploitant_nom_2,
          e0_.direction AS direction_3,
          e0_.adresse AS adresse_4,
          e0_.emplacement_titre_foncier AS emplacement_titre_foncier_5,
          e0_.nature_exploitant AS nature_exploitant_6,
          e0_.classe AS classe_7,
          e0_.surface_couverte AS surface_couverte_8,
          e0_.surface_equipes AS surface_equipes_9,
          e0_.surface_non_equipes AS surface_non_equipes_10,
          e0_.positionnement AS positionnement_11,
          e0_.date_demande AS date_demande_12,
          e0_.numero_autorisation AS numero_autorisation_13,
          e0_.date_autorisation AS date_autorisation_14,
          e0_.arrete_pdf_path AS arrete_pdf_path_15,
          e0_.created_at AS created_at_16,
          e0_.updated_at AS updated_at_17
        FROM
          etablissement e0_
        ORDER BY
          e0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.numero_ec AS numero_ec_1, e0_.exploitant_nom AS exploitant_nom_2, e0_.direction AS direction_3, e0_.adresse AS adresse_4, e0_.emplacement_titre_foncier AS emplacement_titre_foncier_5, e0_.nature_exploitant AS nature_exploitant_6, e0_.classe AS classe_7, e0_.surface_couverte AS surface_couverte_8, e0_.surface_equipes AS surface_equipes_9, e0_.surface_non_equipes AS surface_non_equipes_10, e0_.positionnement AS positionnement_11, e0_.date_demande AS date_demande_12, e0_.numero_autorisation AS numero_autorisation_13, e0_.date_autorisation AS date_autorisation_14, e0_.arrete_pdf_path AS arrete_pdf_path_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17 FROM etablissement e0_ ORDER BY e0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.numero_ec AS numero_ec_1,
          e0_.exploitant_nom AS exploitant_nom_2,
          e0_.direction AS direction_3,
          e0_.adresse AS adresse_4,
          e0_.emplacement_titre_foncier AS emplacement_titre_foncier_5,
          e0_.nature_exploitant AS nature_exploitant_6,
          e0_.classe AS classe_7,
          e0_.surface_couverte AS surface_couverte_8,
          e0_.surface_equipes AS surface_equipes_9,
          e0_.surface_non_equipes AS surface_non_equipes_10,
          e0_.positionnement AS positionnement_11,
          e0_.date_demande AS date_demande_12,
          e0_.numero_autorisation AS numero_autorisation_13,
          e0_.date_autorisation AS date_autorisation_14,
          e0_.arrete_pdf_path AS arrete_pdf_path_15,
          e0_.created_at AS created_at_16,
          e0_.updated_at AS updated_at_17
        FROM
          etablissement e0_
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.numero_ec AS numero_ec_1, e0_.exploitant_nom AS exploitant_nom_2, e0_.direction AS direction_3, e0_.adresse AS adresse_4, e0_.emplacement_titre_foncier AS emplacement_titre_foncier_5, e0_.nature_exploitant AS nature_exploitant_6, e0_.classe AS classe_7, e0_.surface_couverte AS surface_couverte_8, e0_.surface_equipes AS surface_equipes_9, e0_.surface_non_equipes AS surface_non_equipes_10, e0_.positionnement AS positionnement_11, e0_.date_demande AS date_demande_12, e0_.numero_autorisation AS numero_autorisation_13, e0_.date_autorisation AS date_autorisation_14, e0_.arrete_pdf_path AS arrete_pdf_path_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17 FROM etablissement e0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 20;

SELECT
  e0_.id AS id_0,
  e0_.numero_ec AS numero_ec_1,
  e0_.exploitant_nom AS exploitant_nom_2,
  e0_.direction AS direction_3,
  e0_.adresse AS adresse_4,
  e0_.emplacement_titre_foncier AS emplacement_titre_foncier_5,
  e0_.nature_exploitant AS nature_exploitant_6,
  e0_.classe AS classe_7,
  e0_.surface_couverte AS surface_couverte_8,
  e0_.surface_equipes AS surface_equipes_9,
  e0_.surface_non_equipes AS surface_non_equipes_10,
  e0_.positionnement AS positionnement_11,
  e0_.date_demande AS date_demande_12,
  e0_.numero_autorisation AS numero_autorisation_13,
  e0_.date_autorisation AS date_autorisation_14,
  e0_.arrete_pdf_path AS arrete_pdf_path_15,
  e0_.created_at AS created_at_16,
  e0_.updated_at AS updated_at_17
FROM
  etablissement e0_
WHERE
  e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.numero_ec AS numero_ec_1, e0_.exploitant_nom AS exploitant_nom_2, e0_.direction AS direction_3, e0_.adresse AS adresse_4, e0_.emplacement_titre_foncier AS emplacement_titre_foncier_5, e0_.nature_exploitant AS nature_exploitant_6, e0_.classe AS classe_7, e0_.surface_couverte AS surface_couverte_8, e0_.surface_equipes AS surface_equipes_9, e0_.surface_non_equipes AS surface_non_equipes_10, e0_.positionnement AS positionnement_11, e0_.date_demande AS date_demande_12, e0_.numero_autorisation AS numero_autorisation_13, e0_.date_autorisation AS date_autorisation_14, e0_.arrete_pdf_path AS arrete_pdf_path_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17 FROM etablissement e0_ WHERE e0_.id IN (5700, 5698, 5697, 5696, 5695, 5694, 5693, 5692, 5691, 5690, 5689, 5688, 5687, 5686, 5685, 5684, 5683, 5682, 5681, 5680) ORDER BY e0_.id DESC;

SELECT
  COUNT(*)
FROM
  etablissement t0

SELECT COUNT(*) FROM etablissement t0;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  etablissement e0_
WHERE
  e0_.arrete_pdf_path IS NOT NULL
  AND e0_.arrete_pdf_path <> ?

SELECT COUNT(e0_.id) AS sclr_0 FROM etablissement e0_ WHERE e0_.arrete_pdf_path IS NOT NULL AND e0_.arrete_pdf_path <> '';

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  etablissement e0_
WHERE
  e0_.classe = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM etablissement e0_ WHERE e0_.classe = '1ere';

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  etablissement e0_
WHERE
  e0_.classe = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM etablissement e0_ WHERE e0_.classe = '2eme';

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  etablissement e0_
WHERE
  e0_.classe = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM etablissement e0_ WHERE e0_.classe = '3eme';