POST https://tc-suivi.topcrono.com/operation/new

Query Metrics

121 Database Queries
17 Different statements
139.93 ms Query time
0 Invalid entities
11357 Managed entities

Grouped Statements

Show all queries

Time Count Info
56.78 ms
(40.57%)
35
INSERT INTO ext_log_entries (action, logged_at, object_id, object_class, version, data, username) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "create"
  "2026-08-12 10:07:52"
  null
  "App\Entity\Client"
  1
  "a:34:{s:4:"name";s:7:"MOHAMED";s:9:"firstname";s:6:"ISBATH";s:11:"phoneNumber";s:10:"0162789056";s:11:"companyName";N;s:10:"numberCard";N;s:14:"dateExpiration";N;s:14:"statusGenerate";b:0;s:4:"type";s:11:"Particulier";s:4:"logo";N;s:8:"standard";N;s:6:"mobile";N;s:3:"fax";N;s:2:"bp";N;s:9:"clientWeb";N;s:11:"numeroCarre";N;s:6:"maison";N;s:5:"email";N;s:12:"anniversaire";N;s:3:"tva";N;s:3:"ifu";N;s:11:"observation";N;s:8:"civilite";N;s:5:"nomDg";N;s:8:"password";N;s:12:"regimeFiscal";N;s:10:"codeClient";N;s:6:"direct";N;s:15:"adressePhysique";N;s:15:"personneContact";N;s:4:"zone";N;s:8:"activite";N;s:8:"quartier";N;s:8:"clientDe";N;s:15:"categorieClient";N;}"
  "franchille.setchegbe@topchrono.com"
]
42.11 ms
(30.09%)
1
SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.heure_livraison AS heure_livraison_3, t0.nombre_plis AS nombre_plis_4, t0.poids AS poids_5, t0.date_retour_boredereau AS date_retour_boredereau_6, t0.nom_receptionnaire_accueil AS nom_receptionnaire_accueil_7, t0.type_operation AS type_operation_8, t0.instruction_particuliere AS instruction_particuliere_9, t0.destinataire AS destinataire_10, t0.adresse_livraison AS adresse_livraison_11, t0.intruction_particuliere_livraison AS intruction_particuliere_livraison_12, t0.statut_livraison AS statut_livraison_13, t0.price AS price_14, t0.number_bordereau AS number_bordereau_15, t0.nom_client_retour_bordereau AS nom_client_retour_bordereau_16, t0.date AS date_17, t0.receptionnaire_colis AS receptionnaire_colis_18, t0.non_transmis_commentaire AS non_transmis_commentaire_19, t0.appel AS appel_20, t0.frais_appel AS frais_appel_21, t0.plis AS plis_22, t0.nom_categorie_client AS nom_categorie_client_23, t0.nombre_colis AS nombre_colis_24, t0.nombre_avis_passage AS nombre_avis_passage_25, t0.nombre_feuillet AS nombre_feuillet_26, t0.reference AS reference_27, t0.observation AS observation_28, t0.numero_facture AS numero_facture_29, t0.code_produit AS code_produit_30, t0.nombre_corporate AS nombre_corporate_31, t0.date_enlevement AS date_enlevement_32, t0.heure_enlevement AS heure_enlevement_33, t0.nombre_ticket AS nombre_ticket_34, t0.reference_bordereau AS reference_bordereau_35, t0.nombre_plis_courant AS nombre_plis_courant_36, t0.price_complement AS price_complement_37, t0.comment_retour_int AS comment_retour_int_38, t0.comment_abandon_int AS comment_abandon_int_39, t0.comment_destruction_int AS comment_destruction_int_40, t0.comment_refus_reception_int AS comment_refus_reception_int_41, t0.statut_representant AS statut_representant_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.deleted_at AS deleted_at_45, t0.created_by AS created_by_46, t0.updated_by AS updated_by_47, t0.client_id AS client_id_48, t0.coursier_id AS coursier_id_49, t0.produit_id AS produit_id_50, t0.operation_type_id AS operation_type_id_51, t0.ville_id AS ville_id_52, t0.bordereau_parent_id AS bordereau_parent_id_53, t0.bordereau_complement_parent_id AS bordereau_complement_parent_id_54, t0.ville_complement_id AS ville_complement_id_55, t0.motif_id AS motif_id_56, t0.representant_id AS representant_id_57 FROM bordereau t0 ORDER BY t0.id DESC
Parameters:
[]
11.97 ms
(8.55%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.phone_number AS phone_number_4, t0.company_name AS company_name_5, t0.number_card AS number_card_6, t0.date_expiration AS date_expiration_7, t0.status_generate AS status_generate_8, t0.type AS type_9, t0.logo AS logo_10, t0.standard AS standard_11, t0.mobile AS mobile_12, t0.fax AS fax_13, t0.bp AS bp_14, t0.client_web AS client_web_15, t0.numero_carre AS numero_carre_16, t0.maison AS maison_17, t0.email AS email_18, t0.anniversaire AS anniversaire_19, t0.tva AS tva_20, t0.ifu AS ifu_21, t0.observation AS observation_22, t0.civilite AS civilite_23, t0.nom_dg AS nom_dg_24, t0.password AS password_25, t0.regime_fiscal AS regime_fiscal_26, t0.code_client AS code_client_27, t0.direct AS direct_28, t0.adresse_physique AS adresse_physique_29, t0.personne_contact AS personne_contact_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.deleted_at AS deleted_at_33, t0.created_by AS created_by_34, t0.updated_by AS updated_by_35, t0.zone_id AS zone_id_36, t0.activite_id AS activite_id_37, t0.quartier_id AS quartier_id_38, t0.client_de_id AS client_de_id_39, t0.categorie_client_id AS categorie_client_id_40 FROM client t0 WHERE t0.phone_number = ? AND t0.company_name IS NULL
Parameters:
[
  "0162789056"
]
7.98 ms
(5.70%)
34
UPDATE ext_log_entries SET object_id = ? WHERE id = ?
Parameters:
[
  "4729"
  392338
]
6.72 ms
(4.80%)
1
SELECT v0_.id AS id_0, v0_.nom_ville AS nom_ville_1, v0_.code_ville AS code_ville_2, v0_.tarif_puclic_courrier AS tarif_puclic_courrier_3, v0_.tarif_perso_courrier AS tarif_perso_courrier_4, v0_.delai AS delai_5, v0_.observation AS observation_6, v0_.nombre_ticket AS nombre_ticket_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.deleted_at AS deleted_at_10, v0_.created_by AS created_by_11, v0_.updated_by AS updated_by_12, v0_.pays_id AS pays_id_13 FROM ville v0_ WHERE v0_.id IN (?)
Parameters:
[
  "61"
]
5.85 ms
(4.18%)
32
INSERT INTO notification (status, operation_id, client_id, client_name, client_firstname, amount, poid, user_id, destination_id, date, raison_sociale, created_at, updated_at, deleted_at, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  6778
  4729
  "MOHAMED"
  "ISBATH"
  2000.0
  0.2
  1
  null
  "2026-08-12"
  null
  "2026-08-12 10:07:53"
  "2026-08-12 10:07:53"
  null
  "franchille.setchegbe@topchrono.com"
  "franchille.setchegbe@topchrono.com"
]
1.87 ms
(1.33%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.corpate AS corpate_7, t0.active AS active_8, t0.date_embauche AS date_embauche_9, t0.date_depart AS date_depart_10, t0.interphone AS interphone_11, t0.date_naissance AS date_naissance_12, t0.code_employer AS code_employer_13, t0.code_pays AS code_pays_14, t0.mobile AS mobile_15, t0.fax AS fax_16, t0.telephone_employer AS telephone_employer_17, t0.email_employer AS email_employer_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.affiliate_id AS affiliate_id_24, t0.service_id AS service_id_25 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  47
]
1.26 ms
(0.90%)
4
"START TRANSACTION"
Parameters:
[]
1.15 ms
(0.82%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.corpate AS corpate_6, u0_.active AS active_7, u0_.date_embauche AS date_embauche_8, u0_.date_depart AS date_depart_9, u0_.interphone AS interphone_10, u0_.date_naissance AS date_naissance_11, u0_.code_employer AS code_employer_12, u0_.code_pays AS code_pays_13, u0_.mobile AS mobile_14, u0_.fax AS fax_15, u0_.telephone_employer AS telephone_employer_16, u0_.email_employer AS email_employer_17, u0_.created_at AS created_at_18, u0_.updated_at AS updated_at_19, u0_.deleted_at AS deleted_at_20, u0_.created_by AS created_by_21, u0_.updated_by AS updated_by_22, u0_.affiliate_id AS affiliate_id_23, u0_.service_id AS service_id_24 FROM `user` u0_ WHERE u0_.roles NOT LIKE ?
Parameters:
[
  "%"ROLE_COURSIER"%"
]
0.90 ms
(0.64%)
4
"COMMIT"
Parameters:
[]
0.74 ms
(0.53%)
1
INSERT INTO bordereau (date_livraison, heure_livraison, nombre_plis, poids, date_retour_boredereau, nom_receptionnaire_accueil, type_operation, instruction_particuliere, destinataire, adresse_livraison, intruction_particuliere_livraison, statut_livraison, price, number_bordereau, nom_client_retour_bordereau, date, receptionnaire_colis, non_transmis_commentaire, appel, frais_appel, plis, nom_categorie_client, nombre_colis, nombre_avis_passage, nombre_feuillet, reference, observation, numero_facture, code_produit, nombre_corporate, date_enlevement, heure_enlevement, nombre_ticket, reference_bordereau, nombre_plis_courant, price_complement, comment_retour_int, comment_abandon_int, comment_destruction_int, comment_refus_reception_int, statut_representant, created_at, updated_at, deleted_at, created_by, updated_by, client_id, coursier_id, produit_id, operation_type_id, ville_id, bordereau_parent_id, bordereau_complement_parent_id, ville_complement_id, motif_id, representant_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  1
  "0.2"
  null
  null
  "NATIONAL"
  "RAS"
  "{"nom":"","prenom":"","telephone":"","adresse":"COTONOU ","raisonsociale":"CONSUL DE LA REPUBLIQUE DE L'ALLEMAGNE PRES LE BENIN "}"
  "COTONOU"
  null
  "en_attente"
  2000.0
  "1059566475"
  null
  "2026-08-12"
  null
  null
  0
  0.0
  1
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "10:35:00"
  null
  null
  1
  null
  null
  null
  null
  null
  1
  "2026-08-12 10:07:52"
  "2026-08-12 10:07:52"
  null
  "franchille.setchegbe@topchrono.com"
  "franchille.setchegbe@topchrono.com"
  4729
  null
  null
  1
  61
  null
  null
  null
  null
  4729
]
0.70 ms
(0.50%)
1
INSERT INTO client (name, firstname, phone_number, company_name, number_card, date_expiration, status_generate, type, logo, standard, mobile, fax, bp, client_web, numero_carre, maison, email, anniversaire, tva, ifu, observation, civilite, nom_dg, password, regime_fiscal, code_client, direct, adresse_physique, personne_contact, created_at, updated_at, deleted_at, created_by, updated_by, zone_id, activite_id, quartier_id, client_de_id, categorie_client_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "MOHAMED"
  "ISBATH"
  "0162789056"
  null
  null
  null
  0
  "Particulier"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  "2026-08-12 10:07:52"
  "2026-08-12 10:07:52"
  null
  "franchille.setchegbe@topchrono.com"
  "franchille.setchegbe@topchrono.com"
  null
  null
  null
  null
  null
]
0.51 ms
(0.37%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.operation_id AS operation_id_3, t0.client_id AS client_id_4, t0.client_name AS client_name_5, t0.client_firstname AS client_firstname_6, t0.amount AS amount_7, t0.poid AS poid_8, t0.user_id AS user_id_9, t0.destination_id AS destination_id_10, t0.date AS date_11, t0.raison_sociale AS raison_sociale_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM notification t0 WHERE t0.status = ? ORDER BY t0.id DESC
Parameters:
[
  1
]
0.45 ms
(0.32%)
1
SELECT n0_.id AS id_0, n0_.status AS status_1, n0_.operation_id AS operation_id_2, n0_.client_id AS client_id_3, n0_.client_name AS client_name_4, n0_.client_firstname AS client_firstname_5, n0_.amount AS amount_6, n0_.poid AS poid_7, n0_.user_id AS user_id_8, n0_.destination_id AS destination_id_9, n0_.date AS date_10, n0_.raison_sociale AS raison_sociale_11, n0_.created_at AS created_at_12, n0_.updated_at AS updated_at_13, n0_.deleted_at AS deleted_at_14, n0_.created_by AS created_by_15, n0_.updated_by AS updated_by_16 FROM notification n0_ WHERE n0_.date < ?
Parameters:
[
  "2026-08-12 00:00:00"
]
0.37 ms
(0.26%)
1
SELECT MAX(e0_.version) AS sclr_0 FROM ext_log_entries e0_ WHERE e0_.object_id = ? AND e0_.object_class = ?
Parameters:
[
  "4729"
  "App\Entity\Client"
]
0.33 ms
(0.24%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM operation_type t0 WHERE t0.code = ?
Parameters:
[
  "Accueil"
]
0.26 ms
(0.19%)
1
UPDATE client SET number_card = ?, date_expiration = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "6518270630"
  "2027-12-06"
  "2026-08-12 10:07:52"
  4729
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Bordereau 6476
App\Entity\Client 4560
App\Entity\Notification 96
App\Entity\Ville 92
App\Entity\User 52
Gedmo\Loggable\Entity\LogEntry 35
App\Entity\OperationType 31
App\Entity\Motif 15