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.id = ?

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.id = 8;

SELECT
  h0_.id AS id_0,
  h0_.datemodif AS datemodif_1,
  h0_.description AS description_2
FROM
  historique h0_
WHERE
  h0_.description = ?
ORDER BY
  h0_.datemodif DESC OFFSET 0
ROWS
  FETCH NEXT 1
ROWS
  ONLY

SELECT h0_.id AS id_0, h0_.datemodif AS datemodif_1, h0_.description AS description_2 FROM historique h0_ WHERE h0_.description = 'Mise à jour' ORDER BY h0_.datemodif DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.user_id AS user_id_3,
  t0.user_id AS user_id_4
FROM
  specification t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.user_id AS user_id_3, t0.user_id AS user_id_4 FROM specification t0 WHERE t0.user_id = 8;

SELECT
  o0_.numjobpf AS numjobpf_0,
  o0_.compteclient AS compteclient_1,
  o0_.numcommandepf AS numcommandepf_2,
  o0_.statutfinal_id AS statutfinal_id_3,
  o0_.numlabo AS numlabo_4,
  o0_.medeledescription AS medeledescription_5,
  o0_.numcommandeclient AS numcommandeclient_6,
  o0_.codechorus AS codechorus_7,
  o0_.quantite AS quantite_8,
  o0_.numariteck AS numariteck_9,
  o0_.numbliteck AS numbliteck_10,
  o0_.creele AS creele_11,
  o0_.majle AS majle_12,
  o0_.batenvoile AS batenvoile_13,
  o0_.groupe AS groupe_14,
  o0_.codelivraison AS codelivraison_15,
  o0_.ldm AS ldm_16,
  o0_.statutfinal_id AS statutfinal_id_17
FROM
  ops o0_
WHERE
  o0_.compteclient = ?
ORDER BY
  o0_.creele DESC OFFSET 0
ROWS
  FETCH NEXT 500
ROWS
  ONLY

SELECT o0_.numjobpf AS numjobpf_0, o0_.compteclient AS compteclient_1, o0_.numcommandepf AS numcommandepf_2, o0_.statutfinal_id AS statutfinal_id_3, o0_.numlabo AS numlabo_4, o0_.medeledescription AS medeledescription_5, o0_.numcommandeclient AS numcommandeclient_6, o0_.codechorus AS codechorus_7, o0_.quantite AS quantite_8, o0_.numariteck AS numariteck_9, o0_.numbliteck AS numbliteck_10, o0_.creele AS creele_11, o0_.majle AS majle_12, o0_.batenvoile AS batenvoile_13, o0_.groupe AS groupe_14, o0_.codelivraison AS codelivraison_15, o0_.ldm AS ldm_16, o0_.statutfinal_id AS statutfinal_id_17 FROM ops o0_ WHERE o0_.compteclient = '479112' ORDER BY o0_.creele DESC OFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY;

SELECT
  p2.numCommande,
  p2.nbCommandeTotal,
  p1.nbCommande,
  p1.nbColis,
  p3.nbLivre,
  p3.nbCommandeLivre
FROM
  (
    SELECT
      ops.numcommandeclient as numCommande,
      COUNT(DISTINCT unl.[refexp1]) as nbCommande,
      COUNT(DISTINCT unl.[numcolis]) as nbColis
    FROM
      [SUIVI_BDD].[dbo].[unl] unl
      JOIN [SUIVI_BDD].[dbo].[ops] ops ON unl.refexp1 = ops.numjobpf
    WHERE
      ops.numcommandeclient is not null
    GROUP BY
      ops.numcommandeclient
  ) p1
  RIGHT JOIN (
    SELECT
      ops.numcommandeclient as numCommande,
      COUNT(ops.numcommandeclient) as nbCommandeTotal
    FROM
      [SUIVI_BDD].[dbo].[ops] ops
    WHERE
      ops.numcommandeclient is not null
    GROUP BY
      ops.numcommandeclient
    HAVING
      COUNT(ops.numcommandeclient) > 1
  ) p2 ON p1.numCommande = p2.numCommande
  LEFT JOIN (
    SELECT
      ops2.numcommandeclient as numCommande,
      COUNT(unl2.statut) as nbLivre,
      COUNT(DISTINCT unl2.refexp1) as nbCommandeLivre
    FROM
      [SUIVI_BDD].[dbo].[unl] unl2
      JOIN [SUIVI_BDD].[dbo].[ops] ops2 ON unl2.refexp1 = ops2.numjobpf
    WHERE
      ops2.numcommandeclient is not null
      AND (
        unl2.statut = '40'
        OR unl2.statut = '400'
      )
    GROUP BY
      ops2.numcommandeclient
  ) p3 ON p3.numCommande = p1.numCommande

SELECT p2.numCommande, p2.nbCommandeTotal, p1.nbCommande, p1.nbColis, p3.nbLivre, p3.nbCommandeLivre
        FROM 
            (SELECT ops.numcommandeclient as numCommande,  COUNT(DISTINCT unl.[refexp1]) as nbCommande, COUNT(DISTINCT unl.[numcolis]) as nbColis
            FROM [SUIVI_BDD].[dbo].[unl] unl
            JOIN [SUIVI_BDD].[dbo].[ops] ops
            ON unl.refexp1 = ops.numjobpf
            WHERE ops.numcommandeclient is not null
            GROUP BY ops.numcommandeclient) p1
        RIGHT JOIN
            (SELECT ops.numcommandeclient as numCommande,  COUNT(ops.numcommandeclient) as nbCommandeTotal
            FROM [SUIVI_BDD].[dbo].[ops] ops
            WHERE ops.numcommandeclient is not null
            GROUP BY ops.numcommandeclient
            HAVING COUNT(ops.numcommandeclient) > 1) p2
        ON p1.numCommande = p2.numCommande
        LEFT JOIN (SELECT ops2.numcommandeclient as numCommande, COUNT(unl2.statut) as nbLivre, COUNT(DISTINCT unl2.refexp1) as nbCommandeLivre
                FROM [SUIVI_BDD].[dbo].[unl] unl2
                JOIN [SUIVI_BDD].[dbo].[ops] ops2
                ON unl2.refexp1 = ops2.numjobpf
                WHERE ops2.numcommandeclient is not null
                AND (unl2.statut='40' OR unl2.statut='400')
                GROUP BY ops2.numcommandeclient) p3
        ON p3.numCommande = p1.numCommande
        ;

SELECT
  h0_.id AS id_0,
  h0_.datemodif AS datemodif_1,
  h0_.description AS description_2
FROM
  historique h0_
WHERE
  h0_.description = ?
ORDER BY
  h0_.datemodif DESC OFFSET 0
ROWS
  FETCH NEXT 1
ROWS
  ONLY

SELECT h0_.id AS id_0, h0_.datemodif AS datemodif_1, h0_.description AS description_2 FROM historique h0_ WHERE h0_.description = 'Mise à jour' ORDER BY h0_.datemodif DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1
FROM
  statutfinal s0_

SELECT s0_.id AS id_0, s0_.nom AS nom_1 FROM statutfinal s0_;

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.actif AS actif_2,
  t0_.commentaire AS commentaire_3
FROM
  typeaction t0_

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.actif AS actif_2, t0_.commentaire AS commentaire_3 FROM typeaction t0_;

SELECT
  t0.id AS id_1,
  t0.commentaire AS commentaire_2,
  t0.commande_id AS commande_id_3,
  t0.typeaction_id AS typeaction_id_4,
  t0.ops_id AS ops_id_5,
  t0.date_m AS date_m_6,
  t0.daterealisation AS daterealisation_7,
  t0.numcolis AS numcolis_8,
  t0.typeaction_id AS typeaction_id_9,
  t0.commande_id AS commande_id_10,
  t0.ops_id AS ops_id_11
FROM
  action t0
WHERE
  t0.ops_id = ?
ORDER BY
  t0.date_m DESC

SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.commande_id AS commande_id_3, t0.typeaction_id AS typeaction_id_4, t0.ops_id AS ops_id_5, t0.date_m AS date_m_6, t0.daterealisation AS daterealisation_7, t0.numcolis AS numcolis_8, t0.typeaction_id AS typeaction_id_9, t0.commande_id AS commande_id_10, t0.ops_id AS ops_id_11 FROM action t0 WHERE t0.ops_id = '3961147' ORDER BY t0.date_m DESC;

SELECT
  t0.id AS id_1,
  t0.opsjob AS opsjob_2,
  t0.idcolis AS idcolis_3,
  t0.etat AS etat_4,
  t0.url AS url_5,
  t0.opsjob AS opsjob_6
FROM
  etatfinal t0
WHERE
  t0.opsjob = ?

SELECT t0.id AS id_1, t0.opsjob AS opsjob_2, t0.idcolis AS idcolis_3, t0.etat AS etat_4, t0.url AS url_5, t0.opsjob AS opsjob_6 FROM etatfinal t0 WHERE t0.opsjob = '3961147';

SELECT
  t0.id AS id_1,
  t0.commentaire AS commentaire_2,
  t0.commande_id AS commande_id_3,
  t0.typeaction_id AS typeaction_id_4,
  t0.ops_id AS ops_id_5,
  t0.date_m AS date_m_6,
  t0.daterealisation AS daterealisation_7,
  t0.numcolis AS numcolis_8,
  t0.typeaction_id AS typeaction_id_9,
  t0.commande_id AS commande_id_10,
  t0.ops_id AS ops_id_11
FROM
  action t0
WHERE
  t0.ops_id = ?
ORDER BY
  t0.date_m DESC

SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.commande_id AS commande_id_3, t0.typeaction_id AS typeaction_id_4, t0.ops_id AS ops_id_5, t0.date_m AS date_m_6, t0.daterealisation AS daterealisation_7, t0.numcolis AS numcolis_8, t0.typeaction_id AS typeaction_id_9, t0.commande_id AS commande_id_10, t0.ops_id AS ops_id_11 FROM action t0 WHERE t0.ops_id = '3960364' ORDER BY t0.date_m DESC;

SELECT
  t0.id AS id_1,
  t0.opsjob AS opsjob_2,
  t0.idcolis AS idcolis_3,
  t0.etat AS etat_4,
  t0.url AS url_5,
  t0.opsjob AS opsjob_6
FROM
  etatfinal t0
WHERE
  t0.opsjob = ?

SELECT t0.id AS id_1, t0.opsjob AS opsjob_2, t0.idcolis AS idcolis_3, t0.etat AS etat_4, t0.url AS url_5, t0.opsjob AS opsjob_6 FROM etatfinal t0 WHERE t0.opsjob = '3960364';

SELECT
  t0.id AS id_1,
  t0.commentaire AS commentaire_2,
  t0.commande_id AS commande_id_3,
  t0.typeaction_id AS typeaction_id_4,
  t0.ops_id AS ops_id_5,
  t0.date_m AS date_m_6,
  t0.daterealisation AS daterealisation_7,
  t0.numcolis AS numcolis_8,
  t0.typeaction_id AS typeaction_id_9,
  t0.commande_id AS commande_id_10,
  t0.ops_id AS ops_id_11
FROM
  action t0
WHERE
  t0.ops_id = ?
ORDER BY
  t0.date_m DESC

SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.commande_id AS commande_id_3, t0.typeaction_id AS typeaction_id_4, t0.ops_id AS ops_id_5, t0.date_m AS date_m_6, t0.daterealisation AS daterealisation_7, t0.numcolis AS numcolis_8, t0.typeaction_id AS typeaction_id_9, t0.commande_id AS commande_id_10, t0.ops_id AS ops_id_11 FROM action t0 WHERE t0.ops_id = '3961159' ORDER BY t0.date_m DESC;

SELECT
  t0.id AS id_1,
  t0.opsjob AS opsjob_2,
  t0.idcolis AS idcolis_3,
  t0.etat AS etat_4,
  t0.url AS url_5,
  t0.opsjob AS opsjob_6
FROM
  etatfinal t0
WHERE
  t0.opsjob = ?

SELECT t0.id AS id_1, t0.opsjob AS opsjob_2, t0.idcolis AS idcolis_3, t0.etat AS etat_4, t0.url AS url_5, t0.opsjob AS opsjob_6 FROM etatfinal t0 WHERE t0.opsjob = '3961159';

SELECT
  t0.id AS id_1,
  t0.commentaire AS commentaire_2,
  t0.commande_id AS commande_id_3,
  t0.typeaction_id AS typeaction_id_4,
  t0.ops_id AS ops_id_5,
  t0.date_m AS date_m_6,
  t0.daterealisation AS daterealisation_7,
  t0.numcolis AS numcolis_8,
  t0.typeaction_id AS typeaction_id_9,
  t0.commande_id AS commande_id_10,
  t0.ops_id AS ops_id_11
FROM
  action t0
WHERE
  t0.ops_id = ?
ORDER BY
  t0.date_m DESC

SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.commande_id AS commande_id_3, t0.typeaction_id AS typeaction_id_4, t0.ops_id AS ops_id_5, t0.date_m AS date_m_6, t0.daterealisation AS daterealisation_7, t0.numcolis AS numcolis_8, t0.typeaction_id AS typeaction_id_9, t0.commande_id AS commande_id_10, t0.ops_id AS ops_id_11 FROM action t0 WHERE t0.ops_id = '3905867' ORDER BY t0.date_m DESC;

SELECT
  t0.id AS id_1,
  t0.opsjob AS opsjob_2,
  t0.idcolis AS idcolis_3,
  t0.etat AS etat_4,
  t0.url AS url_5,
  t0.opsjob AS opsjob_6
FROM
  etatfinal t0
WHERE
  t0.opsjob = ?

SELECT t0.id AS id_1, t0.opsjob AS opsjob_2, t0.idcolis AS idcolis_3, t0.etat AS etat_4, t0.url AS url_5, t0.opsjob AS opsjob_6 FROM etatfinal t0 WHERE t0.opsjob = '3905867';

SELECT
  t0.id AS id_1,
  t0.commentaire AS commentaire_2,
  t0.commande_id AS commande_id_3,
  t0.typeaction_id AS typeaction_id_4,
  t0.ops_id AS ops_id_5,
  t0.date_m AS date_m_6,
  t0.daterealisation AS daterealisation_7,
  t0.numcolis AS numcolis_8,
  t0.typeaction_id AS typeaction_id_9,
  t0.commande_id AS commande_id_10,
  t0.ops_id AS ops_id_11
FROM
  action t0
WHERE
  t0.ops_id = ?
ORDER BY
  t0.date_m DESC

SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.commande_id AS commande_id_3, t0.typeaction_id AS typeaction_id_4, t0.ops_id AS ops_id_5, t0.date_m AS date_m_6, t0.daterealisation AS daterealisation_7, t0.numcolis AS numcolis_8, t0.typeaction_id AS typeaction_id_9, t0.commande_id AS commande_id_10, t0.ops_id AS ops_id_11 FROM action t0 WHERE t0.ops_id = '3744237' ORDER BY t0.date_m DESC;

SELECT
  t0.id AS id_1,
  t0.opsjob AS opsjob_2,
  t0.idcolis AS idcolis_3,
  t0.etat AS etat_4,
  t0.url AS url_5,
  t0.opsjob AS opsjob_6
FROM
  etatfinal t0
WHERE
  t0.opsjob = ?

SELECT t0.id AS id_1, t0.opsjob AS opsjob_2, t0.idcolis AS idcolis_3, t0.etat AS etat_4, t0.url AS url_5, t0.opsjob AS opsjob_6 FROM etatfinal t0 WHERE t0.opsjob = '3744237';