Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.poste_name AS poste_name_8,
  t0.poste_key AS poste_key_9,
  t0.fonction_name AS fonction_name_10,
  t0.fonction_key AS fonction_key_11,
  t0.address AS address_12,
  t0.cp AS cp_13,
  t0.ville AS ville_14,
  t0.tel AS tel_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.alert_rules AS alert_rules_18,
  t0.first_connection AS first_connection_19,
  t0.reset_token AS reset_token_20,
  t0.img_user_file_id AS img_user_file_id_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.poste_name AS poste_name_8, t0.poste_key AS poste_key_9, t0.fonction_name AS fonction_name_10, t0.fonction_key AS fonction_key_11, t0.address AS address_12, t0.cp AS cp_13, t0.ville AS ville_14, t0.tel AS tel_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.alert_rules AS alert_rules_18, t0.first_connection AS first_connection_19, t0.reset_token AS reset_token_20, t0.img_user_file_id AS img_user_file_id_21 FROM user t0 WHERE t0.id = 4908;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.key AS key_3
FROM
  territoire_energie t0
  INNER JOIN user_territoire_energie ON t0.id = user_territoire_energie.territoire_energie_id
WHERE
  user_territoire_energie.user_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.key AS key_3 FROM territoire_energie t0 INNER JOIN user_territoire_energie ON t0.id = user_territoire_energie.territoire_energie_id WHERE user_territoire_energie.user_id = 4908;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.code_insee AS code_insee_4,
  t0.territoire_id AS territoire_id_5
FROM
  commune t0
  INNER JOIN user_commune ON t0.id = user_commune.commune_id
WHERE
  user_commune.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.code_insee AS code_insee_4, t0.territoire_id AS territoire_id_5 FROM commune t0 INNER JOIN user_commune ON t0.id = user_commune.commune_id WHERE user_commune.user_id = 4908;

SELECT
  s0_.id AS id_0,
  s0_.insee AS insee_1,
  s0_.mtn_total_travaux AS mtn_total_travaux_2,
  s0_.mtn_for_sieds AS mtn_for_sieds_3,
  s0_.detail_projet_id AS detail_projet_id_4
FROM
  suivi_et_histo s0_
  LEFT JOIN projet p1_ ON (s0_.detail_projet_id = p1_.id)
WHERE
  s0_.insee = ?
  AND (
    p1_.id IS NOT NULL
    AND p1_.dcode IS NOT NULL
  )

SELECT s0_.id AS id_0, s0_.insee AS insee_1, s0_.mtn_total_travaux AS mtn_total_travaux_2, s0_.mtn_for_sieds AS mtn_for_sieds_3, s0_.detail_projet_id AS detail_projet_id_4 FROM suivi_et_histo s0_ LEFT JOIN projet p1_ ON (s0_.detail_projet_id = p1_.id) WHERE s0_.insee = '79002' AND (p1_.id IS NOT NULL AND p1_.dcode IS NOT NULL);

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.decision AS decision_3,
  t0.lieu AS lieu_4,
  t0.date_prev AS date_prev_5,
  t0.step AS step_6,
  t0.attestation AS attestation_7,
  t0.fields AS fields_8,
  t0.commune AS commune_9,
  t0.detail_techs AS detail_techs_10,
  t0.signature AS signature_11,
  t0.created_at AS created_at_12,
  t0.dcode AS dcode_13,
  t0.annee_programme AS annee_programme_14,
  t0.nom_programme AS nom_programme_15,
  t0.updated_at AS updated_at_16,
  t0.date_demande AS date_demande_17,
  t0.type_id AS type_id_18,
  t0.type_work_id AS type_work_id_19,
  t0.user_id AS user_id_20
FROM
  projet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = 17077;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.decision AS decision_3,
  t0.lieu AS lieu_4,
  t0.date_prev AS date_prev_5,
  t0.step AS step_6,
  t0.attestation AS attestation_7,
  t0.fields AS fields_8,
  t0.commune AS commune_9,
  t0.detail_techs AS detail_techs_10,
  t0.signature AS signature_11,
  t0.created_at AS created_at_12,
  t0.dcode AS dcode_13,
  t0.annee_programme AS annee_programme_14,
  t0.nom_programme AS nom_programme_15,
  t0.updated_at AS updated_at_16,
  t0.date_demande AS date_demande_17,
  t0.type_id AS type_id_18,
  t0.type_work_id AS type_work_id_19,
  t0.user_id AS user_id_20
FROM
  projet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = 17078;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.decision AS decision_3,
  t0.lieu AS lieu_4,
  t0.date_prev AS date_prev_5,
  t0.step AS step_6,
  t0.attestation AS attestation_7,
  t0.fields AS fields_8,
  t0.commune AS commune_9,
  t0.detail_techs AS detail_techs_10,
  t0.signature AS signature_11,
  t0.created_at AS created_at_12,
  t0.dcode AS dcode_13,
  t0.annee_programme AS annee_programme_14,
  t0.nom_programme AS nom_programme_15,
  t0.updated_at AS updated_at_16,
  t0.date_demande AS date_demande_17,
  t0.type_id AS type_id_18,
  t0.type_work_id AS type_work_id_19,
  t0.user_id AS user_id_20
FROM
  projet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = 17935;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.decision AS decision_3,
  t0.lieu AS lieu_4,
  t0.date_prev AS date_prev_5,
  t0.step AS step_6,
  t0.attestation AS attestation_7,
  t0.fields AS fields_8,
  t0.commune AS commune_9,
  t0.detail_techs AS detail_techs_10,
  t0.signature AS signature_11,
  t0.created_at AS created_at_12,
  t0.dcode AS dcode_13,
  t0.annee_programme AS annee_programme_14,
  t0.nom_programme AS nom_programme_15,
  t0.updated_at AS updated_at_16,
  t0.date_demande AS date_demande_17,
  t0.type_id AS type_id_18,
  t0.type_work_id AS type_work_id_19,
  t0.user_id AS user_id_20
FROM
  projet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = 19052;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.decision AS decision_3,
  t0.lieu AS lieu_4,
  t0.date_prev AS date_prev_5,
  t0.step AS step_6,
  t0.attestation AS attestation_7,
  t0.fields AS fields_8,
  t0.commune AS commune_9,
  t0.detail_techs AS detail_techs_10,
  t0.signature AS signature_11,
  t0.created_at AS created_at_12,
  t0.dcode AS dcode_13,
  t0.annee_programme AS annee_programme_14,
  t0.nom_programme AS nom_programme_15,
  t0.updated_at AS updated_at_16,
  t0.date_demande AS date_demande_17,
  t0.type_id AS type_id_18,
  t0.type_work_id AS type_work_id_19,
  t0.user_id AS user_id_20
FROM
  projet t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.decision AS decision_3, t0.lieu AS lieu_4, t0.date_prev AS date_prev_5, t0.step AS step_6, t0.attestation AS attestation_7, t0.fields AS fields_8, t0.commune AS commune_9, t0.detail_techs AS detail_techs_10, t0.signature AS signature_11, t0.created_at AS created_at_12, t0.dcode AS dcode_13, t0.annee_programme AS annee_programme_14, t0.nom_programme AS nom_programme_15, t0.updated_at AS updated_at_16, t0.date_demande AS date_demande_17, t0.type_id AS type_id_18, t0.type_work_id AS type_work_id_19, t0.user_id AS user_id_20 FROM projet t0 WHERE t0.id = 20422;

SELECT
  COUNT(*)
FROM
  projet t0
WHERE
  t0.status = ?
  AND t0.user_id = ?
  AND (
    t0.dcode IN (?)
    OR t0.dcode IS NULL
  )

SELECT COUNT(*) FROM projet t0 WHERE t0.status = 'En cours de saisie' AND t0.user_id = 4908 AND (t0.dcode IN (NULL) OR t0.dcode IS NULL);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.phone AS phone_2,
  c0_.code_insee AS code_insee_3,
  c0_.territoire_id AS territoire_id_4
FROM
  commune c0_
  LEFT JOIN user_commune u2_ ON c0_.id = u2_.commune_id
  LEFT JOIN user u1_ ON u1_.id = u2_.user_id
WHERE
  u1_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.phone AS phone_2, c0_.code_insee AS code_insee_3, c0_.territoire_id AS territoire_id_4 FROM commune c0_ LEFT JOIN user_commune u2_ ON c0_.id = u2_.commune_id LEFT JOIN user u1_ ON u1_.id = u2_.user_id WHERE u1_.id = 4908;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.actif AS actif_3,
  t0.name AS name_4,
  t0.type AS type_5
FROM
  link t0
WHERE
  t0.actif = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.actif AS actif_3, t0.name AS name_4, t0.type AS type_5 FROM link t0 WHERE t0.actif = 1 AND t0.type = 'enquete';

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.actif AS actif_3,
  t0.name AS name_4,
  t0.type AS type_5
FROM
  link t0
WHERE
  t0.actif = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.actif AS actif_3, t0.name AS name_4, t0.type AS type_5 FROM link t0 WHERE t0.actif = 1 AND t0.type = 'inscription';

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.intro AS intro_3,
  t0.contenu AS contenu_4,
  t0.button AS button_5,
  t0.text_btn AS text_btn_6,
  t0.url_btn AS url_btn_7,
  t0.type AS type_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.img_useful_file_id AS img_useful_file_id_11,
  t0.img_contenu_file_id AS img_contenu_file_id_12,
  t0.img_intro_file_id AS img_intro_file_id_13
FROM
  contenu t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.intro AS intro_3, t0.contenu AS contenu_4, t0.button AS button_5, t0.text_btn AS text_btn_6, t0.url_btn AS url_btn_7, t0.type AS type_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.img_useful_file_id AS img_useful_file_id_11, t0.img_contenu_file_id AS img_contenu_file_id_12, t0.img_intro_file_id AS img_intro_file_id_13 FROM contenu t0 WHERE t0.type = 'Information';

SELECT
  a0_.id AS id_0,
  a0_.vu AS vu_1,
  a0_.jour_vu AS jour_vu_2,
  a0_.user_id AS user_id_3,
  a0_.alert_id AS alert_id_4
FROM
  alerts_user a0_
  LEFT JOIN alert a1_ ON a0_.alert_id = a1_.id
WHERE
  a1_.type IN (NULL)
  AND a0_.user_id = ?
ORDER BY
  a1_.created_at DESC

SELECT a0_.id AS id_0, a0_.vu AS vu_1, a0_.jour_vu AS jour_vu_2, a0_.user_id AS user_id_3, a0_.alert_id AS alert_id_4 FROM alerts_user a0_ LEFT JOIN alert a1_ ON a0_.alert_id = a1_.id WHERE a1_.type IN (NULL) AND a0_.user_id = 4908 ORDER BY a1_.created_at DESC;

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.decision AS decision_2,
  p0_.lieu AS lieu_3,
  p0_.date_prev AS date_prev_4,
  p0_.step AS step_5,
  p0_.attestation AS attestation_6,
  p0_.fields AS fields_7,
  p0_.commune AS commune_8,
  p0_.detail_techs AS detail_techs_9,
  p0_.signature AS signature_10,
  p0_.created_at AS created_at_11,
  p0_.dcode AS dcode_12,
  p0_.annee_programme AS annee_programme_13,
  p0_.nom_programme AS nom_programme_14,
  p0_.updated_at AS updated_at_15,
  p0_.date_demande AS date_demande_16,
  p0_.type_id AS type_id_17,
  p0_.type_work_id AS type_work_id_18,
  p0_.user_id AS user_id_19
FROM
  projet p0_
WHERE
  p0_.status IN ('En cours de saisie')
  AND p0_.commune = ?

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.decision AS decision_2, p0_.lieu AS lieu_3, p0_.date_prev AS date_prev_4, p0_.step AS step_5, p0_.attestation AS attestation_6, p0_.fields AS fields_7, p0_.commune AS commune_8, p0_.detail_techs AS detail_techs_9, p0_.signature AS signature_10, p0_.created_at AS created_at_11, p0_.dcode AS dcode_12, p0_.annee_programme AS annee_programme_13, p0_.nom_programme AS nom_programme_14, p0_.updated_at AS updated_at_15, p0_.date_demande AS date_demande_16, p0_.type_id AS type_id_17, p0_.type_work_id AS type_work_id_18, p0_.user_id AS user_id_19 FROM projet p0_ WHERE p0_.status IN ('En cours de saisie') AND p0_.commune = 'Adilly';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.info AS info_4,
  t0.keyword AS keyword_5
FROM
  type_of_project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.info AS info_4, t0.keyword AS keyword_5 FROM type_of_project t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.info AS info_4,
  t0.keyword AS keyword_5
FROM
  type_of_project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.info AS info_4, t0.keyword AS keyword_5 FROM type_of_project t0 WHERE t0.id = 6965;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.info AS info_4,
  t0.keyword AS keyword_5
FROM
  type_of_project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.info AS info_4, t0.keyword AS keyword_5 FROM type_of_project t0 WHERE t0.id = 6944;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.actif AS actif_3,
  t0.info AS info_4,
  t0.keyword AS keyword_5
FROM
  type_of_project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.info AS info_4, t0.keyword AS keyword_5 FROM type_of_project t0 WHERE t0.id = 6941;

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.decision AS decision_2,
  p0_.lieu AS lieu_3,
  p0_.date_prev AS date_prev_4,
  p0_.step AS step_5,
  p0_.attestation AS attestation_6,
  p0_.fields AS fields_7,
  p0_.commune AS commune_8,
  p0_.detail_techs AS detail_techs_9,
  p0_.signature AS signature_10,
  p0_.created_at AS created_at_11,
  p0_.dcode AS dcode_12,
  p0_.annee_programme AS annee_programme_13,
  p0_.nom_programme AS nom_programme_14,
  p0_.updated_at AS updated_at_15,
  p0_.date_demande AS date_demande_16,
  p0_.type_id AS type_id_17,
  p0_.type_work_id AS type_work_id_18,
  p0_.user_id AS user_id_19
FROM
  projet p0_
WHERE
  p0_.status IN ('En cours de saisie')
  AND p0_.commune = ?

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.decision AS decision_2, p0_.lieu AS lieu_3, p0_.date_prev AS date_prev_4, p0_.step AS step_5, p0_.attestation AS attestation_6, p0_.fields AS fields_7, p0_.commune AS commune_8, p0_.detail_techs AS detail_techs_9, p0_.signature AS signature_10, p0_.created_at AS created_at_11, p0_.dcode AS dcode_12, p0_.annee_programme AS annee_programme_13, p0_.nom_programme AS nom_programme_14, p0_.updated_at AS updated_at_15, p0_.date_demande AS date_demande_16, p0_.type_id AS type_id_17, p0_.type_work_id AS type_work_id_18, p0_.user_id AS user_id_19 FROM projet p0_ WHERE p0_.status IN ('En cours de saisie') AND p0_.commune = 'Adilly';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.keyword AS keyword_3,
  t0.actif AS actif_4,
  t0.type_of_project_id AS type_of_project_id_5,
  t6.id AS id_7,
  t6.structure AS structure_8,
  t6.type_of_work_id AS type_of_work_id_9
FROM
  type_of_work t0
  LEFT JOIN details_tech_form t6 ON t6.type_of_work_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.keyword AS keyword_3, t0.actif AS actif_4, t0.type_of_project_id AS type_of_project_id_5, t6.id AS id_7, t6.structure AS structure_8, t6.type_of_work_id AS type_of_work_id_9 FROM type_of_work t0 LEFT JOIN details_tech_form t6 ON t6.type_of_work_id = t0.id WHERE t0.id = 68;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.keyword AS keyword_3,
  t0.actif AS actif_4,
  t0.type_of_project_id AS type_of_project_id_5,
  t6.id AS id_7,
  t6.structure AS structure_8,
  t6.type_of_work_id AS type_of_work_id_9
FROM
  type_of_work t0
  LEFT JOIN details_tech_form t6 ON t6.type_of_work_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.keyword AS keyword_3, t0.actif AS actif_4, t0.type_of_project_id AS type_of_project_id_5, t6.id AS id_7, t6.structure AS structure_8, t6.type_of_work_id AS type_of_work_id_9 FROM type_of_work t0 LEFT JOIN details_tech_form t6 ON t6.type_of_work_id = t0.id WHERE t0.id = 95;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.keyword AS keyword_3,
  t0.actif AS actif_4,
  t0.type_of_project_id AS type_of_project_id_5,
  t6.id AS id_7,
  t6.structure AS structure_8,
  t6.type_of_work_id AS type_of_work_id_9
FROM
  type_of_work t0
  LEFT JOIN details_tech_form t6 ON t6.type_of_work_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.keyword AS keyword_3, t0.actif AS actif_4, t0.type_of_project_id AS type_of_project_id_5, t6.id AS id_7, t6.structure AS structure_8, t6.type_of_work_id AS type_of_work_id_9 FROM type_of_work t0 LEFT JOIN details_tech_form t6 ON t6.type_of_work_id = t0.id WHERE t0.id = 66;