Symfony Profiler

SELECT
  COALESCE(
    SUM(t0_.amount),
    0
  ) AS sclr_0
FROM
  transaction t0_
  INNER JOIN payment_from p1_ ON t0_.payment_from_id = p1_.id
WHERE
  (
    (
      t0_.expediteur = ?
      AND p1_.code = 'EXP'
    )
    OR (
      t0_.recepteur = ?
      AND p1_.code = 'DEST'
    )
  )
  AND t0_.is_facturable = 1

SELECT COALESCE(SUM(t0_.amount), 0) AS sclr_0 FROM transaction t0_ INNER JOIN payment_from p1_ ON t0_.payment_from_id = p1_.id WHERE ((t0_.expediteur = 1 AND p1_.code = 'EXP') OR (t0_.recepteur = 1 AND p1_.code = 'DEST')) AND t0_.is_facturable = 1;

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.id AS id_1
FROM
  versement v0_
  LEFT JOIN transaction t1_ ON v0_.transaction_id = t1_.id
  LEFT JOIN client c2_ ON t1_.expediteur = c2_.id
  LEFT JOIN client c3_ ON t1_.recepteur = c3_.id
  LEFT JOIN invoice i4_ ON v0_.invoice_id = i4_.id
  LEFT JOIN invoice_details i5_ ON i4_.id = i5_.invoice_id
  LEFT JOIN transaction t6_ ON i4_.transaction_id = t6_.id
  LEFT JOIN client c7_ ON t6_.expediteur = c7_.id
  LEFT JOIN client c8_ ON t6_.recepteur = c8_.id
ORDER BY
  v0_.id ASC
LIMIT
  30

SELECT DISTINCT v0_.id AS id_0, v0_.id AS id_1 FROM versement v0_ LEFT JOIN transaction t1_ ON v0_.transaction_id = t1_.id LEFT JOIN client c2_ ON t1_.expediteur = c2_.id LEFT JOIN client c3_ ON t1_.recepteur = c3_.id LEFT JOIN invoice i4_ ON v0_.invoice_id = i4_.id LEFT JOIN invoice_details i5_ ON i4_.id = i5_.invoice_id LEFT JOIN transaction t6_ ON i4_.transaction_id = t6_.id LEFT JOIN client c7_ ON t6_.expediteur = c7_.id LEFT JOIN client c8_ ON t6_.recepteur = c8_.id ORDER BY v0_.id ASC LIMIT 30;

SELECT
  COALESCE(
    SUM(c0_.poids),
    0
  ) AS sclr_0
FROM
  colis c0_
  INNER JOIN transaction t1_ ON c0_.transaction_id = t1_.id
WHERE
  t1_.expediteur = ?
  OR t1_.recepteur = ?

SELECT COALESCE(SUM(c0_.poids), 0) AS sclr_0 FROM colis c0_ INNER JOIN transaction t1_ ON c0_.transaction_id = t1_.id WHERE t1_.expediteur = 1 OR t1_.recepteur = 1;

SELECT
  v0_.id AS id_0,
  v0_.montant AS montant_1,
  v0_.created_at AS created_at_2,
  v0_.date_operation AS date_operation_3,
  t1_.id AS id_4,
  t1_.amount AS amount_5,
  t1_.code AS code_6,
  t1_.tva AS tva_7,
  t1_.is_facturable AS is_facturable_8,
  t1_.is_payed AS is_payed_9,
  t1_.created_at AS created_at_10,
  t1_.date_operation AS date_operation_11,
  c2_.id AS id_12,
  c2_.nom AS nom_13,
  c2_.prenoms AS prenoms_14,
  c2_.tel AS tel_15,
  c2_.entreprise AS entreprise_16,
  c2_.email AS email_17,
  c2_.cni AS cni_18,
  c2_.photo_recto AS photo_recto_19,
  c2_.photo_verso AS photo_verso_20,
  c2_.created_at AS created_at_21,
  c2_.updated_at AS updated_at_22,
  c2_.filename_photo_recto AS filename_photo_recto_23,
  c2_.filename_photo_verso AS filename_photo_verso_24,
  c2_.localisation AS localisation_25,
  c2_.code AS code_26,
  c3_.id AS id_27,
  c3_.nom AS nom_28,
  c3_.prenoms AS prenoms_29,
  c3_.tel AS tel_30,
  c3_.entreprise AS entreprise_31,
  c3_.email AS email_32,
  c3_.cni AS cni_33,
  c3_.photo_recto AS photo_recto_34,
  c3_.photo_verso AS photo_verso_35,
  c3_.created_at AS created_at_36,
  c3_.updated_at AS updated_at_37,
  c3_.filename_photo_recto AS filename_photo_recto_38,
  c3_.filename_photo_verso AS filename_photo_verso_39,
  c3_.localisation AS localisation_40,
  c3_.code AS code_41,
  i4_.id AS id_42,
  i4_.code AS code_43,
  i4_.tva AS tva_44,
  i4_.created_at AS created_at_45,
  i5_.id AS id_46,
  i5_.code AS code_47,
  i5_.libelle AS libelle_48,
  i5_.quantity AS quantity_49,
  i5_.volume AS volume_50,
  i5_.pu AS pu_51,
  i5_.amount AS amount_52,
  t6_.id AS id_53,
  t6_.amount AS amount_54,
  t6_.code AS code_55,
  t6_.tva AS tva_56,
  t6_.is_facturable AS is_facturable_57,
  t6_.is_payed AS is_payed_58,
  t6_.created_at AS created_at_59,
  t6_.date_operation AS date_operation_60,
  c7_.id AS id_61,
  c7_.nom AS nom_62,
  c7_.prenoms AS prenoms_63,
  c7_.tel AS tel_64,
  c7_.entreprise AS entreprise_65,
  c7_.email AS email_66,
  c7_.cni AS cni_67,
  c7_.photo_recto AS photo_recto_68,
  c7_.photo_verso AS photo_verso_69,
  c7_.created_at AS created_at_70,
  c7_.updated_at AS updated_at_71,
  c7_.filename_photo_recto AS filename_photo_recto_72,
  c7_.filename_photo_verso AS filename_photo_verso_73,
  c7_.localisation AS localisation_74,
  c7_.code AS code_75,
  c8_.id AS id_76,
  c8_.nom AS nom_77,
  c8_.prenoms AS prenoms_78,
  c8_.tel AS tel_79,
  c8_.entreprise AS entreprise_80,
  c8_.email AS email_81,
  c8_.cni AS cni_82,
  c8_.photo_recto AS photo_recto_83,
  c8_.photo_verso AS photo_verso_84,
  c8_.created_at AS created_at_85,
  c8_.updated_at AS updated_at_86,
  c8_.filename_photo_recto AS filename_photo_recto_87,
  c8_.filename_photo_verso AS filename_photo_verso_88,
  c8_.localisation AS localisation_89,
  c8_.code AS code_90,
  v0_.transaction_id AS transaction_id_91,
  v0_.invoice_id AS invoice_id_92,
  t1_.expediteur AS expediteur_93,
  t1_.recepteur AS recepteur_94,
  t1_.payment_from_id AS payment_from_id_95,
  t1_.mode_id AS mode_id_96,
  t1_.payment_type_id AS payment_type_id_97,
  t1_.type_facturation_id AS type_facturation_id_98,
  t1_.ville_exp AS ville_exp_99,
  t1_.ville_rec AS ville_rec_100,
  t1_.agent AS agent_101,
  c2_.pays_id AS pays_id_102,
  c2_.type_client_id AS type_client_id_103,
  c3_.pays_id AS pays_id_104,
  c3_.type_client_id AS type_client_id_105,
  i4_.transaction_id AS transaction_id_106,
  i5_.invoice_id AS invoice_id_107,
  t6_.expediteur AS expediteur_108,
  t6_.recepteur AS recepteur_109,
  t6_.payment_from_id AS payment_from_id_110,
  t6_.mode_id AS mode_id_111,
  t6_.payment_type_id AS payment_type_id_112,
  t6_.type_facturation_id AS type_facturation_id_113,
  t6_.ville_exp AS ville_exp_114,
  t6_.ville_rec AS ville_rec_115,
  t6_.agent AS agent_116,
  c7_.pays_id AS pays_id_117,
  c7_.type_client_id AS type_client_id_118,
  c8_.pays_id AS pays_id_119,
  c8_.type_client_id AS type_client_id_120
FROM
  versement v0_
  LEFT JOIN transaction t1_ ON v0_.transaction_id = t1_.id
  LEFT JOIN client c2_ ON t1_.expediteur = c2_.id
  LEFT JOIN client c3_ ON t1_.recepteur = c3_.id
  LEFT JOIN invoice i4_ ON v0_.invoice_id = i4_.id
  LEFT JOIN invoice_details i5_ ON i4_.id = i5_.invoice_id
  LEFT JOIN transaction t6_ ON i4_.transaction_id = t6_.id
  LEFT JOIN client c7_ ON t6_.expediteur = c7_.id
  LEFT JOIN client c8_ ON t6_.recepteur = c8_.id
WHERE
  v0_.id IN (?)
ORDER BY
  v0_.id ASC

SELECT v0_.id AS id_0, v0_.montant AS montant_1, v0_.created_at AS created_at_2, v0_.date_operation AS date_operation_3, t1_.id AS id_4, t1_.amount AS amount_5, t1_.code AS code_6, t1_.tva AS tva_7, t1_.is_facturable AS is_facturable_8, t1_.is_payed AS is_payed_9, t1_.created_at AS created_at_10, t1_.date_operation AS date_operation_11, c2_.id AS id_12, c2_.nom AS nom_13, c2_.prenoms AS prenoms_14, c2_.tel AS tel_15, c2_.entreprise AS entreprise_16, c2_.email AS email_17, c2_.cni AS cni_18, c2_.photo_recto AS photo_recto_19, c2_.photo_verso AS photo_verso_20, c2_.created_at AS created_at_21, c2_.updated_at AS updated_at_22, c2_.filename_photo_recto AS filename_photo_recto_23, c2_.filename_photo_verso AS filename_photo_verso_24, c2_.localisation AS localisation_25, c2_.code AS code_26, c3_.id AS id_27, c3_.nom AS nom_28, c3_.prenoms AS prenoms_29, c3_.tel AS tel_30, c3_.entreprise AS entreprise_31, c3_.email AS email_32, c3_.cni AS cni_33, c3_.photo_recto AS photo_recto_34, c3_.photo_verso AS photo_verso_35, c3_.created_at AS created_at_36, c3_.updated_at AS updated_at_37, c3_.filename_photo_recto AS filename_photo_recto_38, c3_.filename_photo_verso AS filename_photo_verso_39, c3_.localisation AS localisation_40, c3_.code AS code_41, i4_.id AS id_42, i4_.code AS code_43, i4_.tva AS tva_44, i4_.created_at AS created_at_45, i5_.id AS id_46, i5_.code AS code_47, i5_.libelle AS libelle_48, i5_.quantity AS quantity_49, i5_.volume AS volume_50, i5_.pu AS pu_51, i5_.amount AS amount_52, t6_.id AS id_53, t6_.amount AS amount_54, t6_.code AS code_55, t6_.tva AS tva_56, t6_.is_facturable AS is_facturable_57, t6_.is_payed AS is_payed_58, t6_.created_at AS created_at_59, t6_.date_operation AS date_operation_60, c7_.id AS id_61, c7_.nom AS nom_62, c7_.prenoms AS prenoms_63, c7_.tel AS tel_64, c7_.entreprise AS entreprise_65, c7_.email AS email_66, c7_.cni AS cni_67, c7_.photo_recto AS photo_recto_68, c7_.photo_verso AS photo_verso_69, c7_.created_at AS created_at_70, c7_.updated_at AS updated_at_71, c7_.filename_photo_recto AS filename_photo_recto_72, c7_.filename_photo_verso AS filename_photo_verso_73, c7_.localisation AS localisation_74, c7_.code AS code_75, c8_.id AS id_76, c8_.nom AS nom_77, c8_.prenoms AS prenoms_78, c8_.tel AS tel_79, c8_.entreprise AS entreprise_80, c8_.email AS email_81, c8_.cni AS cni_82, c8_.photo_recto AS photo_recto_83, c8_.photo_verso AS photo_verso_84, c8_.created_at AS created_at_85, c8_.updated_at AS updated_at_86, c8_.filename_photo_recto AS filename_photo_recto_87, c8_.filename_photo_verso AS filename_photo_verso_88, c8_.localisation AS localisation_89, c8_.code AS code_90, v0_.transaction_id AS transaction_id_91, v0_.invoice_id AS invoice_id_92, t1_.expediteur AS expediteur_93, t1_.recepteur AS recepteur_94, t1_.payment_from_id AS payment_from_id_95, t1_.mode_id AS mode_id_96, t1_.payment_type_id AS payment_type_id_97, t1_.type_facturation_id AS type_facturation_id_98, t1_.ville_exp AS ville_exp_99, t1_.ville_rec AS ville_rec_100, t1_.agent AS agent_101, c2_.pays_id AS pays_id_102, c2_.type_client_id AS type_client_id_103, c3_.pays_id AS pays_id_104, c3_.type_client_id AS type_client_id_105, i4_.transaction_id AS transaction_id_106, i5_.invoice_id AS invoice_id_107, t6_.expediteur AS expediteur_108, t6_.recepteur AS recepteur_109, t6_.payment_from_id AS payment_from_id_110, t6_.mode_id AS mode_id_111, t6_.payment_type_id AS payment_type_id_112, t6_.type_facturation_id AS type_facturation_id_113, t6_.ville_exp AS ville_exp_114, t6_.ville_rec AS ville_rec_115, t6_.agent AS agent_116, c7_.pays_id AS pays_id_117, c7_.type_client_id AS type_client_id_118, c8_.pays_id AS pays_id_119, c8_.type_client_id AS type_client_id_120 FROM versement v0_ LEFT JOIN transaction t1_ ON v0_.transaction_id = t1_.id LEFT JOIN client c2_ ON t1_.expediteur = c2_.id LEFT JOIN client c3_ ON t1_.recepteur = c3_.id LEFT JOIN invoice i4_ ON v0_.invoice_id = i4_.id LEFT JOIN invoice_details i5_ ON i4_.id = i5_.invoice_id LEFT JOIN transaction t6_ ON i4_.transaction_id = t6_.id LEFT JOIN client c7_ ON t6_.expediteur = c7_.id LEFT JOIN client c8_ ON t6_.recepteur = c8_.id WHERE v0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9) ORDER BY v0_.id ASC;

SELECT
  COALESCE(
    SUM(v0_.montant),
    0
  ) AS sclr_0
FROM
  versement v0_
  INNER JOIN transaction t1_ ON v0_.transaction_id = t1_.id
WHERE
  (
    (t1_.expediteur = ?)
    AND (t1_.payment_from_id = 2)
  )
  OR (
    (t1_.recepteur = ?)
    AND (t1_.payment_from_id = 1)
  )

SELECT COALESCE(SUM(v0_.montant), 0) AS sclr_0 FROM versement v0_ INNER JOIN transaction t1_ ON v0_.transaction_id = t1_.id WHERE ((t1_.expediteur = 1) AND (t1_.payment_from_id = 2)) OR ((t1_.recepteur = 1) AND (t1_.payment_from_id = 1));