Query Metrics
6
Database Queries
6
Different statements
11.99 ms
Query time
6
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.84 ms (57.04%) |
1 |
"COMMIT"
Parameters:
[] |
1.52 ms (12.70%) |
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.created AS created_5, t0.code AS code_6, t0.active AS active_7, t0.swift AS swift_8, t0.banque AS banque_9, t0.contact_id_id AS contact_id_id_10 FROM lrib t0 WHERE t0.contact_id_id = ? AND t0.active = ? LIMIT 1
Parameters:
[ 11630 1 ] |
1.32 ms (11.04%) |
1 |
UPDATE lcontract SET updated = ? WHERE id = ?
Parameters:
[ "2025-06-06 12:08:37" 11630 ] |
0.92 ms (7.64%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.active AS active_5, t0.date_sortie AS date_sortie_6, t0.motif_sortie AS motif_sortie_7, t0.date_anciennete AS date_anciennete_8, t0.prise_en_charge AS prise_en_charge_9, t0.salairegrille AS salairegrille_10, t0.salaireaffecte AS salaireaffecte_11, t0.ppc AS ppc_12, t0.rpc AS rpc_13, t0.matricule_ancien AS matricule_ancien_14, t0.date_desactiver AS date_desactiver_15, t0.cnss AS cnss_16, t0.date_cnss AS date_cnss_17, t0.cimr AS cimr_18, t0.date_cimr AS date_cimr_19, t0.created AS created_20, t0.updated AS updated_21, t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22, t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23, t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24, t0.stagiaire AS stagiaire_25, t0.employe_id AS employe_id_26, t0.pnature_contract_id AS pnature_contract_id_27, t0.dossier_id AS dossier_id_28, t0.bareme_id AS bareme_id_29, t0.fonction_id AS fonction_id_30, t0.piece_id AS piece_id_31, t0.user_desactiver_id AS user_desactiver_id_32, t0.duree_contract_id AS duree_contract_id_33, t0.user_updated_id AS user_updated_id_34, t0.user_created_id AS user_created_id_35 FROM lcontract t0 WHERE t0.id = ?
Parameters:
[
"11630"
]
|
0.82 ms (6.83%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.57 ms (4.75%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Users | No errors. |
App\Entity\PDossier | No errors. |
App\Entity\HonoraireDetFixe | No errors. |
App\Entity\TCnssA00 | No errors. |
App\Entity\PNotification | No errors. |
App\Entity\LContract |
|
App\Entity\Pemploye |
|
App\Entity\PnatureContract | No errors. |
App\Entity\Pbareme |
|
App\Entity\Pfonction |
|
App\Entity\PPiece | No errors. |
App\Entity\PdureeContract | No errors. |
App\Entity\LcontractFonction | No errors. |
App\Entity\LdossierContract | No errors. |
App\Entity\LmatriculationCoti | No errors. |
App\Entity\Lrib | No errors. |
App\Entity\LelementFixe | No errors. |
App\Entity\PArretTravail | No errors. |
App\Entity\LElementEcheance | No errors. |
App\Entity\PPrelevement | No errors. |
App\Entity\Tbulletin |
|
App\Entity\Probleme | No errors. |
App\Entity\TCnssA02 |
|
App\Entity\TCnssB02 | No errors. |
App\Entity\TCnssB04 | No errors. |