Symfony Profiler

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
  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.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 = 2;

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 = 3;

SELECT
  DISTINCT id_0,
  MIN(sclr_16) AS dctrn_minrownum
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,
      ROW_NUMBER() OVER(
        ORDER BY
          a0_.raisonsocialeentreprise ASC
      ) AS sclr_16
    FROM
      agent_promoteuret_syndic a0_
    WHERE
      a0_.raisonsocialeentreprise IS NOT NULL
      AND a0_.vue = ?
      AND a0_.publie = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  100

SELECT DISTINCT id_0, MIN(sclr_16) AS dctrn_minrownum 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, ROW_NUMBER() OVER(ORDER BY a0_.raisonsocialeentreprise ASC) AS sclr_16 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100;

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_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
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_.id IN (483, 390, 317, 180, 285, 199, 469, 273, 289, 159, 555, 184, 182, 445, 506, 191, 224, 476, 479, 567, 336, 443, 217, 488, 448, 225, 197, 565, 564, 166, 208, 574, 196, 357, 334, 259, 219, 274, 326, 346, 200, 330, 302, 337, 380, 260, 353, 220, 511, 263, 355, 163, 348, 209, 254, 481, 360, 303, 202, 158, 515, 344, 264, 441, 457, 349, 319, 361, 245, 280, 466, 412, 240, 206, 450, 218, 249, 559, 301, 512, 189, 332, 461, 306, 253, 391, 453, 203, 482, 394, 505, 420, 424, 177, 416, 178, 467, 426, 498, 188) ORDER BY a0_.raisonsocialeentreprise ASC;

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 = ?
        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' ORDER BY a0_.raisonsocialeentreprise ASC) dctrn_result) dctrn_table;

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 = ?
  )
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) GROUP BY a0_.metier_id, p1_.label, p1_.identifiant ORDER BY p1_.label ASC;

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

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

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

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

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

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

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

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

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

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

SELECT
  DISTINCT id_0,
  MIN(sclr_16) AS dctrn_minrownum
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,
      ROW_NUMBER() OVER(
        ORDER BY
          a0_.raisonsocialeentreprise ASC
      ) AS sclr_16
    FROM
      agent_promoteuret_syndic a0_
    WHERE
      a0_.raisonsocialeentreprise IS NOT NULL
      AND a0_.vue = ?
      AND a0_.publie = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  100

SELECT DISTINCT id_0, MIN(sclr_16) AS dctrn_minrownum 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, ROW_NUMBER() OVER(ORDER BY a0_.raisonsocialeentreprise ASC) AS sclr_16 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100;

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_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
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_.id IN (483, 390, 317, 180, 285, 199, 469, 273, 289, 159, 555, 184, 182, 445, 506, 191, 224, 476, 479, 567, 336, 443, 217, 488, 448, 225, 197, 565, 564, 166, 208, 574, 196, 357, 334, 259, 219, 274, 326, 346, 200, 330, 302, 337, 380, 260, 353, 220, 511, 263, 355, 163, 348, 209, 254, 481, 360, 303, 202, 158, 515, 344, 264, 441, 457, 349, 319, 361, 245, 280, 466, 412, 240, 206, 450, 218, 249, 559, 301, 512, 189, 332, 461, 306, 253, 391, 453, 203, 482, 394, 505, 420, 424, 177, 416, 178, 467, 426, 498, 188) ORDER BY a0_.raisonsocialeentreprise ASC;