Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.abreviation AS abreviation_3,
  t0.code AS code_4,
  t0.centroid AS centroid_5,
  t0.position AS position_6
FROM
  region t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3, t0.code AS code_4, t0.centroid AS centroid_5, t0.position AS position_6 FROM region t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.abreviation AS abreviation_3,
  t0.code AS code_4,
  t0.centroid AS centroid_5,
  t0.position AS position_6
FROM
  region t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3, t0.code AS code_4, t0.centroid AS centroid_5, t0.position AS position_6 FROM region t0 ORDER BY t0.nom ASC;

SELECT
  COUNT(o0_.id) AS sclr_0,
  r1_.nom AS nom_1,
  r1_.code AS code_2,
  r1_.centroid AS centroid_3
FROM
  offre o0_
  INNER JOIN departement d2_ ON o0_.departement_id = d2_.id
  AND (o0_.departement_id = d2_.id)
  INNER JOIN region r1_ ON d2_.region_id = r1_.id
  AND (d2_.region_id = r1_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
GROUP BY
  r1_.nom

SELECT COUNT(o0_.id) AS sclr_0, r1_.nom AS nom_1, r1_.code AS code_2, r1_.centroid AS centroid_3 FROM offre o0_ INNER JOIN departement d2_ ON o0_.departement_id = d2_.id AND (o0_.departement_id = d2_.id) INNER JOIN region r1_ ON d2_.region_id = r1_.id AND (d2_.region_id = r1_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 GROUP BY r1_.nom;

SELECT
  MIN(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MIN(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

SELECT
  MAX(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MAX(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.abreviation AS abreviation_2,
  r0_.code AS code_3,
  r0_.centroid AS centroid_4,
  r0_.position AS position_5
FROM
  region r0_
ORDER BY
  r0_.nom ASC

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.abreviation AS abreviation_2, r0_.code AS code_3, r0_.centroid AS centroid_4, r0_.position AS position_5 FROM region r0_ ORDER BY r0_.nom ASC;

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.abreviation AS abreviation_2,
  d0_.numero AS numero_3,
  d0_.region_id AS region_id_4
FROM
  departement d0_

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.abreviation AS abreviation_2, d0_.numero AS numero_3, d0_.region_id AS region_id_4 FROM departement d0_;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 19 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 11 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 16 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 10 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 22 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 21 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 14 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 4 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 6 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 13 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 9 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 7 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 5 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 8 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 12 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 17 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 18 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom

SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ INNER JOIN departement d1_ ON o0_.departement_id = d1_.id AND (o0_.departement_id = d1_.id) INNER JOIN region r2_ ON d1_.region_id = r2_.id AND (d1_.region_id = r2_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 AND r2_.id = 15 GROUP BY r2_.nom;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offre o0_
  INNER JOIN departement d1_ ON o0_.departement_id = d1_.id
  AND (o0_.departement_id = d1_.id)
  INNER JOIN region r2_ ON d1_.region_id = r2_.id
  AND (d1_.region_id = r2_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND r2_.id = ?
GROUP BY
  r2_.nom