Query Metrics
5
Database Queries
5
Different statements
19.64 ms
Query time
0
Invalid entities
Queries
admin connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.tiers_id AS tiers_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
dev connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.61 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.tiers_id AS tiers_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
gunsmoke connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.76 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.id_role AS id_role_4, t0.password AS password_5, t0.id_tiers AS id_tiers_6, t0.date_crea AS date_crea_7, t0.user_crea AS user_crea_8, t0.date_modif AS date_modif_9, t0.user_modif AS user_modif_10, t0.password_requested_at AS password_requested_at_11, t0.token AS token_12, t0.avatar_user AS avatar_user_13, t0.theme_user AS theme_user_14, t0.is_active AS is_active_15, t0.tiers_id AS tiers_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 10.83 ms |
SELECT d0_.type_document AS type_document_0 FROM document d0_ GROUP BY d0_.type_document
Parameters:
[] |
| 3 | 6.78 ms |
SELECT d0_.id AS id_0, d0_.type_document AS type_document_1, d0_.statut AS statut_2, d0_.reference AS reference_3, d0_.num_piece AS num_piece_4, d0_.date_crea AS date_crea_5, d0_.user_crea AS user_crea_6, d0_.date_modif AS date_modif_7, d0_.user_modif AS user_modif_8, d0_.montant_ht AS montant_ht_9, d0_.montant_tva AS montant_tva_10, d0_.date_envoi AS date_envoi_11, d0_.date_paiement AS date_paiement_12, d0_.date_echeance AS date_echeance_13, d0_.contact AS contact_14, d0_.id_doc_origine AS id_doc_origine_15, d0_.commentaire AS commentaire_16, d0_.date_bdc AS date_bdc_17, d0_.lib_projet AS lib_projet_18, d0_.date_ndf AS date_ndf_19, d0_.libelle AS libelle_20, d0_.condition_reglement AS condition_reglement_21, d0_.projet_id AS projet_id_22, d0_.tiers_id AS tiers_id_23, d0_.adresse_id AS adresse_id_24, d0_.salarie_id AS salarie_id_25 FROM document d0_ LEFT JOIN projet p1_ ON d0_.projet_id = p1_.id WHERE d0_.type_document = ? AND d0_.id_doc_origine IS NOT NULL AND (d0_.date_crea BETWEEN ? AND ?) ORDER BY d0_.date_crea ASC
Parameters:
[ "FACTURE PROFORMA" "2025-01-01" "2025-12-31" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| admin | doctrine.dbal.admin_connection |
| dev | doctrine.dbal.dev_connection |
| gunsmoke | doctrine.dbal.gunsmoke_connection |
| foodandcurious | doctrine.dbal.foodandcurious_connection |
| butterjam | doctrine.dbal.butterjam_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| admin | doctrine.orm.admin_entity_manager |
| dev | doctrine.orm.dev_entity_manager |
| gunsmoke | doctrine.orm.gunsmoke_entity_manager |
| foodandcurious | doctrine.orm.foodandcurious_entity_manager |
| butterjam | doctrine.orm.butterjam_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
No loaded entities.
admin entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tiers | No errors. |
dev entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tiers | No errors. |
gunsmoke entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tiers | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Projet | No errors. |
| App\Entity\Societe | No errors. |
| App\Entity\Adresse | No errors. |
| App\Entity\DocumentLigne | No errors. |
foodandcurious entity manager
No loaded entities.
butterjam entity manager
No loaded entities.