Query Metrics
56
Database Queries
5
Different statements
114.75 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 22.21 ms |
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
Parameters:
[] |
2 | 18.02 ms |
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
Parameters:
[ [ 1 2 3 4 5 6 7 8 9 ] ] |
3 | 1.16 ms |
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 = ?
Parameters:
[ 1 1 ] |
4 | 0.72 ms |
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
Parameters:
[ 1 1 ] |
5 | 0.54 ms |
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))
Parameters:
[ 1 1 ] |
6 | 4.82 ms |
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 = ?
Parameters:
[ 2 2 ] |
7 | 0.55 ms |
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
Parameters:
[ 2 2 ] |
8 | 0.37 ms |
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))
Parameters:
[ 2 2 ] |
9 | 1.47 ms |
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 = ?
Parameters:
[ 5 5 ] |
10 | 15.92 ms |
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
Parameters:
[ 5 5 ] |
11 | 0.48 ms |
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))
Parameters:
[ 5 5 ] |
12 | 0.46 ms |
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 = ?
Parameters:
[ 6 6 ] |
13 | 0.36 ms |
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
Parameters:
[ 6 6 ] |
14 | 0.33 ms |
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))
Parameters:
[ 6 6 ] |
15 | 0.36 ms |
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 = ?
Parameters:
[ 14 14 ] |
16 | 0.39 ms |
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
Parameters:
[ 14 14 ] |
17 | 0.37 ms |
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))
Parameters:
[ 14 14 ] |
18 | 0.36 ms |
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 = ?
Parameters:
[ 15 15 ] |
19 | 0.38 ms |
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
Parameters:
[ 15 15 ] |
20 | 0.33 ms |
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))
Parameters:
[ 15 15 ] |
21 | 0.35 ms |
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 = ?
Parameters:
[ 16 16 ] |
22 | 0.34 ms |
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
Parameters:
[ 16 16 ] |
23 | 0.46 ms |
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))
Parameters:
[ 16 16 ] |
24 | 1.41 ms |
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 = ?
Parameters:
[ 17 17 ] |
25 | 0.44 ms |
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
Parameters:
[ 17 17 ] |
26 | 4.54 ms |
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))
Parameters:
[ 17 17 ] |
27 | 4.82 ms |
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 = ?
Parameters:
[ 31 31 ] |
28 | 0.44 ms |
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
Parameters:
[ 31 31 ] |
29 | 0.33 ms |
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))
Parameters:
[ 31 31 ] |
30 | 0.75 ms |
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 = ?
Parameters:
[ 32 32 ] |
31 | 0.49 ms |
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
Parameters:
[ 32 32 ] |
32 | 0.33 ms |
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))
Parameters:
[ 32 32 ] |
33 | 0.38 ms |
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 = ?
Parameters:
[ 38 38 ] |
34 | 0.33 ms |
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
Parameters:
[ 38 38 ] |
35 | 0.32 ms |
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))
Parameters:
[ 38 38 ] |
36 | 0.32 ms |
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 = ?
Parameters:
[ 39 39 ] |
37 | 20.55 ms |
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
Parameters:
[ 39 39 ] |
38 | 0.61 ms |
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))
Parameters:
[ 39 39 ] |
39 | 0.40 ms |
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 = ?
Parameters:
[ 43 43 ] |
40 | 0.40 ms |
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
Parameters:
[ 43 43 ] |
41 | 0.35 ms |
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))
Parameters:
[ 43 43 ] |
42 | 0.30 ms |
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 = ?
Parameters:
[ 44 44 ] |
43 | 0.41 ms |
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
Parameters:
[ 44 44 ] |
44 | 0.32 ms |
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))
Parameters:
[ 44 44 ] |
45 | 0.79 ms |
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 = ?
Parameters:
[ 45 45 ] |
46 | 0.34 ms |
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
Parameters:
[ 45 45 ] |
47 | 0.73 ms |
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))
Parameters:
[ 45 45 ] |
48 | 0.44 ms |
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 = ?
Parameters:
[ 46 46 ] |
49 | 0.40 ms |
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
Parameters:
[ 46 46 ] |
50 | 0.36 ms |
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))
Parameters:
[ 46 46 ] |
51 | 0.36 ms |
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 = ?
Parameters:
[ 47 47 ] |
52 | 0.52 ms |
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
Parameters:
[ 47 47 ] |
53 | 0.45 ms |
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))
Parameters:
[ 47 47 ] |
54 | 0.64 ms |
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 = ?
Parameters:
[ 48 48 ] |
55 | 0.41 ms |
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
Parameters:
[ 48 48 ] |
56 | 0.34 ms |
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))
Parameters:
[ 48 48 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Supply | No errors. |
App\Entity\Versement | No errors. |
App\Entity\Invoice | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\Commande | No errors. |
App\Entity\Client | No errors. |
App\Entity\InvoiceDetails | No errors. |
App\Entity\PaymentFrom | No errors. |
App\Entity\Mode | No errors. |
App\Entity\PaymentType | No errors. |
App\Entity\TypeFacturation | No errors. |
App\Entity\Ville | No errors. |
App\Entity\User | No errors. |
App\Entity\Pays | No errors. |
App\Entity\TypeClient | No errors. |
App\Entity\Colis | No errors. |