Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.email = 'judicaeltokiniaina@gmail.com' LIMIT 1;

SELECT
  p.locat AS project,
  COUNT(*) AS count
FROM
  promesse AS p
  LEFT JOIN fos_user u ON u.id = p.idClient
WHERE
  1 = 1
  AND (
    p.statPDV IS NULL
    OR p.statPDV != 'Annuler'
  )
GROUP BY
  p.locat
ORDER BY
  count DESC,
  p.locat ASC

SELECT p.locat AS project, COUNT(*) AS count
            FROM promesse AS p
            LEFT JOIN fos_user u ON u.id = p.idClient
            
            WHERE 1=1 AND (p.statPDV IS NULL OR p.statPDV != 'Annuler')
            GROUP BY p.locat
            ORDER BY count DESC, p.locat ASC;

SELECT
  p.id,
  p.idghost,
  u.lastname,
  u.firstname,
  p.locat,
  p.DatePDV,
  p.prixpdv,
  p.statPDV
FROM
  promesse AS p
  LEFT JOIN fos_user u ON u.id = p.idClient
WHERE
  1 = 1
  AND (
    p.statPDV IS NULL
    OR p.statPDV != 'Annuler'
  )
ORDER BY
  p.id DESC
LIMIT
  20 OFFSET 0

SELECT p.id, p.idghost, u.lastname, u.firstname, p.locat, p.DatePDV, p.prixpdv, p.statPDV
            FROM promesse AS p
            LEFT JOIN fos_user u ON u.id = p.idClient
            
            WHERE 1=1 AND (p.statPDV IS NULL OR p.statPDV != 'Annuler')
            ORDER BY p.id DESC
            LIMIT 20 OFFSET 0;

SELECT
  pl.idPdv AS idpdv,
  pl.Montant AS montant,
  pl.restap AS restap,
  pl.`first` AS is_first,
  pl.DatedP AS datedp
FROM
  plande_p pl
WHERE
  pl.idPdv IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND (
    pl.enabled IS NULL
    OR pl.enabled = 1
  )
ORDER BY
  pl.DatedP ASC,
  pl.id ASC

SELECT pl.idPdv AS idpdv, pl.Montant AS montant, pl.restap AS restap, pl.`first` AS is_first, pl.DatedP AS datedp
             FROM plande_p pl
             WHERE pl.idPdv IN ('HVT24-30/MIS2026', 'HVT71/MIS2026', 'HVT09/MIS2026', 'HVT08/MIS2026', 'HVT40-41-42-43/MIS2026', 'HVT53/MIS2026', 'HVT74/MIS2026', 'HVT72/MIS2026', 'HVT56-57/MIS2026', 'HVT64/MIS2026', 'HVT66/MIS2026', 'HVT58/MIS2026', 'HVT67/MIS2026', 'HVT62/MIS2026', 'HVT63/MIS2026', 'HVT69/MIS2026', 'HVT07/MIS2026', 'HVT04/MIS2026', 'HVT48-49-50/MIS2026', 'VTR02/MIS2026')
               AND (pl.enabled IS NULL OR pl.enabled = 1)
             ORDER BY pl.DatedP ASC, pl.id ASC;

SELECT
  COUNT(*) AS c
FROM
  promesse AS p
  LEFT JOIN fos_user u ON u.id = p.idClient
WHERE
  1 = 1
  AND (
    p.statPDV IS NULL
    OR p.statPDV != 'Annuler'
  )

SELECT COUNT(*) AS c
            FROM promesse AS p
            LEFT JOIN fos_user u ON u.id = p.idClient
            
            WHERE 1=1 AND (p.statPDV IS NULL OR p.statPDV != 'Annuler');

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1393
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1392
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1391
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1390
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1389
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1388
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1387
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1386
        ;

SELECT
  CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
  (
    SELECT
      COUNT(*)
    FROM
      offre_promesse op
    WHERE
      op.promesse_id = p.id
  ) AS offres,
  (
    SELECT
      COUNT(*)
    FROM
      negociation n
    WHERE
      n.compromis_id = p.id
      AND (
        n.archived = 0
        OR n.archived IS NULL
      )
  ) AS negociations,
  (
    SELECT
      COUNT(*)
    FROM
      dossier_client dc
    WHERE
      dc.compromis_id = p.id
  ) AS dossiers,
  CASE WHEN (
    p.nextcloud_path IS NOT NULL
    AND p.nextcloud_path <> ''
  )
  OR (
    p.nextcloud_share_url IS NOT NULL
    AND p.nextcloud_share_url <> ''
  ) THEN 1 ELSE 0 END AS nextcloud,
  (
    (
      SELECT
        COUNT(*)
      FROM
        ndcu u
      WHERE
        u.promesse_id = p.id
    ) + (
      SELECT
        COUNT(*)
      FROM
        note_de_credit ndc
      WHERE
        ndc.compromis_id = p.id
    )
  ) AS ndc,
  (
    SELECT
      COUNT(*)
    FROM
      plande_p pl
    WHERE
      pl.pdv_id = p.id
      AND pl.avenant = 1
  ) AS avenants
FROM
  promesse p
WHERE
  p.id = ?

SELECT
                CASE WHEN p.statPDV = 'Annuler' THEN 1 ELSE 0 END AS annuler,
                (SELECT COUNT(*) FROM offre_promesse op WHERE op.promesse_id = p.id) AS offres,
                (SELECT COUNT(*) FROM negociation n WHERE n.compromis_id = p.id AND (n.archived = 0 OR n.archived IS NULL)) AS negociations,
                (SELECT COUNT(*) FROM dossier_client dc WHERE dc.compromis_id = p.id) AS dossiers,
                CASE
                    WHEN (p.nextcloud_path IS NOT NULL AND p.nextcloud_path <> '')
                      OR (p.nextcloud_share_url IS NOT NULL AND p.nextcloud_share_url <> '')
                    THEN 1 ELSE 0
                END AS nextcloud,
                (
                    (SELECT COUNT(*) FROM ndcu u WHERE u.promesse_id = p.id)
                    + (SELECT COUNT(*) FROM note_de_credit ndc WHERE ndc.compromis_id = p.id)
                ) AS ndc,
                (SELECT COUNT(*) FROM plande_p pl WHERE pl.pdv_id = p.id AND pl.avenant = 1) AS avenants
            FROM promesse p
            WHERE p.id = 1385
        ;