Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.surface AS surface_4,
  t0.lattitude AS lattitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.creele AS creele_8,
  t0.modifiele AS modifiele_9,
  t0.slug AS slug_10,
  t0.area_id AS area_id_11
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10, t0.area_id AS area_id_11 FROM departement t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.surface AS surface_4,
  t0.lattitude AS lattitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.creele AS creele_8,
  t0.modifiele AS modifiele_9,
  t0.slug AS slug_10,
  t0.departement_id AS departement_id_11,
  t0.area_id AS area_id_12
FROM
  arrondissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10, t0.departement_id AS departement_id_11, t0.area_id AS area_id_12 FROM arrondissement t0 WHERE t0.id = 376;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.surface AS surface_4,
  t0.lattitude AS lattitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.creele AS creele_8,
  t0.modifiele AS modifiele_9,
  t0.slug AS slug_10
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10 FROM region t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.raisonsocialeentreprise AS raisonsocialeentreprise_2,
  t0.telephoneentreprise AS telephoneentreprise_3,
  t0.emailentreprise AS emailentreprise_4,
  t0.boiteposteentreprise AS boiteposteentreprise_5,
  t0.faxentreprise AS faxentreprise_6,
  t0.agrement AS agrement_7,
  t0.delivrance AS delivrance_8,
  t0.renouvellement AS renouvellement_9,
  t0.valide AS valide_10,
  t0.publie AS publie_11,
  t0.vue AS vue_12,
  t0.gerant AS gerant_13,
  t0.accredite AS accredite_14,
  t0.creele AS creele_15,
  t0.modifiele AS modifiele_16,
  t0.area_id AS area_id_17,
  t0.depart_id AS depart_id_18,
  t0.arrondissement_id AS arrondissement_id_19,
  t0.metier_id AS metier_id_20
FROM
  agent_promoteuret_syndic t0

SELECT t0.id AS id_1, t0.raisonsocialeentreprise AS raisonsocialeentreprise_2, t0.telephoneentreprise AS telephoneentreprise_3, t0.emailentreprise AS emailentreprise_4, t0.boiteposteentreprise AS boiteposteentreprise_5, t0.faxentreprise AS faxentreprise_6, t0.agrement AS agrement_7, t0.delivrance AS delivrance_8, t0.renouvellement AS renouvellement_9, t0.valide AS valide_10, t0.publie AS publie_11, t0.vue AS vue_12, t0.gerant AS gerant_13, t0.accredite AS accredite_14, t0.creele AS creele_15, t0.modifiele AS modifiele_16, t0.area_id AS area_id_17, t0.depart_id AS depart_id_18, t0.arrondissement_id AS arrondissement_id_19, t0.metier_id AS metier_id_20 FROM agent_promoteuret_syndic t0;

SELECT
  a0_.id AS id_0,
  a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
  a0_.telephoneentreprise AS telephoneentreprise_2,
  a0_.emailentreprise AS emailentreprise_3,
  a0_.boiteposteentreprise AS boiteposteentreprise_4,
  a0_.faxentreprise AS faxentreprise_5,
  a0_.agrement AS agrement_6,
  a0_.delivrance AS delivrance_7,
  a0_.renouvellement AS renouvellement_8,
  a0_.valide AS valide_9,
  a0_.publie AS publie_10,
  a0_.vue AS vue_11,
  a0_.gerant AS gerant_12,
  a0_.accredite AS accredite_13,
  a0_.creele AS creele_14,
  a0_.modifiele AS modifiele_15,
  a0_.area_id AS area_id_16,
  a0_.depart_id AS depart_id_17,
  a0_.arrondissement_id AS arrondissement_id_18,
  a0_.metier_id AS metier_id_19
FROM
  agent_promoteuret_syndic a0_
WHERE
  a0_.raisonsocialeentreprise IS NOT NULL
  AND a0_.vue = ?
  AND a0_.publie = ?
  AND a0_.metier_id = ?
ORDER BY
  a0_.raisonsocialeentreprise ASC

SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, a0_.area_id AS area_id_16, a0_.depart_id AS depart_id_17, a0_.arrondissement_id AS arrondissement_id_18, a0_.metier_id AS metier_id_19 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1' AND a0_.metier_id = 2 ORDER BY a0_.raisonsocialeentreprise ASC;

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.creele AS creele_5,
  t0.modifiele AS modifiele_6
FROM
  profession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.creele AS creele_5,
  t0.modifiele AS modifiele_6
FROM
  profession t0
WHERE
  t0.identifiant = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.identifiant = 'promoteur' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
          a0_.telephoneentreprise AS telephoneentreprise_2,
          a0_.emailentreprise AS emailentreprise_3,
          a0_.boiteposteentreprise AS boiteposteentreprise_4,
          a0_.faxentreprise AS faxentreprise_5,
          a0_.agrement AS agrement_6,
          a0_.delivrance AS delivrance_7,
          a0_.renouvellement AS renouvellement_8,
          a0_.valide AS valide_9,
          a0_.publie AS publie_10,
          a0_.vue AS vue_11,
          a0_.gerant AS gerant_12,
          a0_.accredite AS accredite_13,
          a0_.creele AS creele_14,
          a0_.modifiele AS modifiele_15
        FROM
          agent_promoteuret_syndic a0_
        WHERE
          a0_.raisonsocialeentreprise IS NOT NULL
          AND a0_.vue = ?
          AND a0_.publie = ?
          AND a0_.metier_id = ?
        ORDER BY
          a0_.raisonsocialeentreprise ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1' AND a0_.metier_id = 2 ORDER BY a0_.raisonsocialeentreprise ASC) dctrn_result) dctrn_table;

SELECT
  r0_.id AS id_0,
  r0_.label AS label_1,
  COUNT(a1_.id) AS sclr_2,
  SUM(
    CASE WHEN a1_.accredite = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  SUM(
    CASE WHEN a1_.accredite = false THEN
      1
    ELSE
      0
    END
  ) AS sclr_4
FROM
  region r0_
  LEFT JOIN agent_promoteuret_syndic a1_ ON r0_.id = a1_.area_id
  AND (
    a1_.raisonsocialeentreprise IS NOT NULL
    AND a1_.vue = ?
  )
WHERE
  a1_.publie = ?
  AND a1_.metier_id = ?
GROUP BY
  r0_.id
ORDER BY
  r0_.label ASC

SELECT r0_.id AS id_0, r0_.label AS label_1, COUNT(a1_.id) AS sclr_2, SUM(CASE WHEN a1_.accredite = true THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN a1_.accredite = false THEN 1 ELSE 0 END) AS sclr_4 FROM region r0_ LEFT JOIN agent_promoteuret_syndic a1_ ON r0_.id = a1_.area_id AND (a1_.raisonsocialeentreprise IS NOT NULL AND a1_.vue = 1) WHERE a1_.publie = '1' AND a1_.metier_id = 2 GROUP BY r0_.id ORDER BY r0_.label ASC;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.publie = ?
    AND a0_.vue = ?
    AND a0_.accredite = ?
  )
  AND a0_.metier_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.publie = 1 AND a0_.vue = 1 AND a0_.accredite = 1) AND a0_.metier_id = 2;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.valide = ?
    AND a0_.vue = ?
  )
  AND a0_.metier_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.valide = 1 AND a0_.vue = 1) AND a0_.metier_id = 2;

SELECT
  a0_.metier_id AS sclr_0,
  p1_.label AS label_1,
  p1_.identifiant AS identifiant_2,
  COUNT(a0_.id) AS sclr_3,
  SUM(
    CASE WHEN a0_.accredite = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN a0_.accredite = false THEN
      1
    ELSE
      0
    END
  ) AS sclr_5
FROM
  agent_promoteuret_syndic a0_
  INNER JOIN profession p1_ ON a0_.metier_id = p1_.id
  AND (
    a0_.raisonsocialeentreprise IS NOT NULL
    AND a0_.vue = ?
    AND a0_.publie = ?
  )
WHERE
  a0_.metier_id = ?
GROUP BY
  a0_.metier_id,
  p1_.label,
  p1_.identifiant
ORDER BY
  p1_.label ASC

SELECT a0_.metier_id AS sclr_0, p1_.label AS label_1, p1_.identifiant AS identifiant_2, COUNT(a0_.id) AS sclr_3, SUM(CASE WHEN a0_.accredite = true THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN a0_.accredite = false THEN 1 ELSE 0 END) AS sclr_5 FROM agent_promoteuret_syndic a0_ INNER JOIN profession p1_ ON a0_.metier_id = p1_.id AND (a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = 1) WHERE a0_.metier_id = 2 GROUP BY a0_.metier_id, p1_.label, p1_.identifiant ORDER BY p1_.label ASC;

SELECT
  a0_.area_id AS sclr_0,
  a0_.arrondissement_id AS sclr_1,
  a0_.id AS id_2
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.area_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
    AND a0_.raisonsocialeentreprise IS NOT NULL
    AND a0_.vue = ?
  )
  AND a0_.publie = ?
  AND a0_.metier_id = ?

SELECT a0_.area_id AS sclr_0, a0_.arrondissement_id AS sclr_1, a0_.id AS id_2 FROM agent_promoteuret_syndic a0_ WHERE (a0_.area_id IN (1, 2, 3, 4, 5, 7, 10, 8, 9) AND a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1) AND a0_.publie = '1' AND a0_.metier_id = 2;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.publie = ?
    AND a0_.vue = ?
  )
  AND a0_.metier_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.publie = 1 AND a0_.vue = 1) AND a0_.metier_id = 2;