Symfony Profiler

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
  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
  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_.classe = ?
  AND 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_.classe = '3eme' AND e0_.id IN (5401, 5399, 5396, 5395, 5394, 5392, 5391, 5390, 5389, 5388, 5387, 3988, 3987, 3986, 3984, 3983, 3982, 3981, 3980, 3979) ORDER BY e0_.id DESC;

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_
        WHERE
          e0_.classe = ?
        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_ WHERE e0_.classe = '3eme' 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_
        WHERE
          e0_.classe = ?
      ) 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_ WHERE e0_.classe = '3eme') dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 20;

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 <> '';