Symfony Profiler

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.password AS password_6,
  t0.last_name AS last_name_7,
  t0.type AS type_8,
  t0.change_password AS change_password_9,
  t0.contact_id AS contact_id_10,
  t0.region_id AS region_id_11,
  t0.commission_id AS commission_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.id AS id_2, t0.email AS email_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.password AS password_6, t0.last_name AS last_name_7, t0.type AS type_8, t0.change_password AS change_password_9, t0.contact_id AS contact_id_10, t0.region_id AS region_id_11, t0.commission_id AS commission_id_12 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  region t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 1) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 2) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 3) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 4) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 5) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 6) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 7) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 8) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 9) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 10) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 11) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 12) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 13) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 14) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 15) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 16) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 17) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  entreprise e0_
  INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c1_.cotisation_statut_id
  )
  INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id)
  INNER JOIN region r4_ ON (
    r4_.id = d3_.region_id
    AND r4_.id = ?
  )
WHERE
  c1_.year = ?
  AND c2_.id = 1
GROUP BY
  r4_.id

SELECT COUNT(e0_.id) AS sclr_0 FROM entreprise e0_ INNER JOIN cotisation c1_ ON (c1_.entreprise_id = e0_.id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c1_.cotisation_statut_id) INNER JOIN departement d3_ ON (d3_.id = e0_.departement_id) INNER JOIN region r4_ ON (r4_.id = d3_.region_id AND r4_.id = 18) WHERE c1_.year = 2024 AND c2_.id = 1 GROUP BY r4_.id;

SELECT
  COUNT(c0_.id) AS sclr_0,
  c0_.year AS year_1
FROM
  cotisation c0_
  INNER JOIN entreprise e1_ ON (e1_.id = c0_.entreprise_id)
  INNER JOIN cotisation_statut c2_ ON (
    c2_.id = c0_.cotisation_statut_id
  )
WHERE
  c0_.year IN (?, ?, ?)
  AND c2_.id = 1
GROUP BY
  c0_.year
ORDER BY
  c0_.year ASC

SELECT COUNT(c0_.id) AS sclr_0, c0_.year AS year_1 FROM cotisation c0_ INNER JOIN entreprise e1_ ON (e1_.id = c0_.entreprise_id) INNER JOIN cotisation_statut c2_ ON (c2_.id = c0_.cotisation_statut_id) WHERE c0_.year IN (2024, 2023, 2022) AND c2_.id = 1 GROUP BY c0_.year ORDER BY c0_.year ASC;

SELECT
  COUNT(e0_.id) AS sclr_0,
  f1_.name AS name_1
FROM
  entreprise e0_
  INNER JOIN firm_type f1_ ON (f1_.id = e0_.firm_type_id)
WHERE
  e0_.status <> ?
GROUP BY
  e0_.firm_type_id

SELECT COUNT(e0_.id) AS sclr_0, f1_.name AS name_1 FROM entreprise e0_ INNER JOIN firm_type f1_ ON (f1_.id = e0_.firm_type_id) WHERE e0_.status <> 88 GROUP BY e0_.firm_type_id;

SELECT
  COUNT(*)
FROM
  user_question t0
WHERE
  t0.is_new = ?

SELECT COUNT(*) FROM user_question t0 WHERE t0.is_new = 1;

SELECT
  COUNT(*)
FROM
  user_question t0
WHERE
  t0.is_new = ?

SELECT COUNT(*) FROM user_question t0 WHERE t0.is_new = 1;