Query Metrics
7
Database Queries
7
Different statements
7.40 ms
Query time
0
Invalid entities
3
Managed entities
Queries
default connection
admin connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.82 ms |
SELECT t0.id AS id_1, t0.budget_code AS budget_code_2, t0.budget_libelle AS budget_libelle_3, t0.action_code AS action_code_4, t0.action_libelle AS action_libelle_5, t0.intitule_code AS intitule_code_6, t0.intitule_libelle AS intitule_libelle_7, t0.sous_intitule_code AS sous_intitule_code_8, t0.sous_intitule_libelle AS sous_intitule_libelle_9, t0.educ_code AS educ_code_10, t0.code_analytique AS code_analytique_11, t0.date AS date_12, t0.description AS description_13, t0.prix_unitaire AS prix_unitaire_14, t0.quantite AS quantite_15, t0.total AS total_16, t0.engagement_frais_id AS engagement_frais_id_17 FROM engagement_frais_detail t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
408
]
|
||||||||||||||||||||||||||||||
| 2 | 0.72 ms |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.id = ?
Parameters:
[
142
]
|
||||||||||||||||||||||||||||||
| 3 | 0.61 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 4 | 0.80 ms |
UPDATE engagement_frais SET total = ? WHERE id = ?
Parameters:
[ "64.2" 142 ]
|
||||||||||||||||||||||||||||||
| 5 | 0.66 ms |
DELETE FROM engagement_frais_detail WHERE id = ?
Parameters:
[
408
]
|
||||||||||||||||||||||||||||||
| 6 | 2.63 ms |
"COMMIT"
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| admin | doctrine.dbal.admin_connection |
| fa | doctrine.dbal.fa_connection |
| faold | doctrine.dbal.faold_connection |
| prei | doctrine.dbal.prei_connection |
| contacts | doctrine.dbal.contacts_connection |
| projets | doctrine.dbal.projets_connection |
| bilans | doctrine.dbal.bilans_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| admin | doctrine.orm.admin_entity_manager |
| fa | doctrine.orm.fa_entity_manager |
| faold | doctrine.orm.faold_entity_manager |
| prei | doctrine.orm.prei_entity_manager |
| contacts | doctrine.orm.contacts_entity_manager |
| projets | doctrine.orm.projets_entity_manager |
| bilans | doctrine.orm.bilans_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Main\User | 1 |
admin entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Administration\EngagementsFrais\EngagementFrais | 1 |
| App\Entity\Administration\EngagementsFrais\Collaborateur | 1 |
| App\Entity\Administration\EngagementsFrais\EngagementFraisDetail | 0 |
fa entity manager
| Class | Amount of managed objects |
|---|
faold entity manager
| Class | Amount of managed objects |
|---|
prei entity manager
| Class | Amount of managed objects |
|---|
contacts entity manager
| Class | Amount of managed objects |
|---|
projets entity manager
| Class | Amount of managed objects |
|---|
bilans entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\User | No errors. |
admin entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Administration\EngagementsFrais\EngagementFraisDetail | No errors. |
| App\Entity\Administration\EngagementsFrais\EngagementFrais | No errors. |
| App\Entity\Administration\EngagementsFrais\Collaborateur | No errors. |
fa entity manager
No loaded entities.
faold entity manager
No loaded entities.
prei entity manager
No loaded entities.
contacts entity manager
No loaded entities.
projets entity manager
No loaded entities.
bilans entity manager
No loaded entities.