Query Metrics
9
Database Queries
5
Different statements
7.83 ms
Query time
0
Invalid entities
Queries
admin connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.51 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:
[
2
]
|
dev connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.59 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:
[
2
]
|
gunsmoke connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.74 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:
[
2
]
|
| 2 | 3.91 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_.contact AS contact_13, d0_.id_doc_origine AS id_doc_origine_14, d0_.commentaire AS commentaire_15, d0_.date_bdc AS date_bdc_16, d0_.lib_projet AS lib_projet_17, d0_.date_ndf AS date_ndf_18, d0_.libelle AS libelle_19, d0_.condition_reglement AS condition_reglement_20, d0_.projet_id AS projet_id_21, d0_.tiers_id AS tiers_id_22, d0_.adresse_id AS adresse_id_23, d0_.salarie_id AS salarie_id_24 FROM document d0_ LEFT JOIN projet p1_ ON d0_.projet_id = p1_.id WHERE d0_.type_document = ? AND d0_.statut = ? AND (d0_.date_envoi BETWEEN ? AND ?) ORDER BY d0_.date_envoi ASC
Parameters:
[ "FACTURE" "envoyé" "2022-01-01 01:07:29" "2025-02-19 01:07:29" ] |
| 3 | 0.65 ms |
SELECT t0.id AS id_1, t0.classe_societe AS classe_societe_2, t0.lib_societe AS lib_societe_3, t0.type_societe AS type_societe_4, t0.sigle_societe AS sigle_societe_5, t0.nb_historique_projet AS nb_historique_projet_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.is_active AS is_active_11, t0.num_tva AS num_tva_12, t0.condition_reglement AS condition_reglement_13 FROM societe t0 WHERE t0.id = ?
Parameters:
[
1046
]
|
| 4 | 0.37 ms |
SELECT t0.id AS id_1, t0.classe_societe AS classe_societe_2, t0.lib_societe AS lib_societe_3, t0.type_societe AS type_societe_4, t0.sigle_societe AS sigle_societe_5, t0.nb_historique_projet AS nb_historique_projet_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.is_active AS is_active_11, t0.num_tva AS num_tva_12, t0.condition_reglement AS condition_reglement_13 FROM societe t0 WHERE t0.id = ?
Parameters:
[
958
]
|
| 5 | 0.35 ms |
SELECT t0.id AS id_1, t0.classe_societe AS classe_societe_2, t0.lib_societe AS lib_societe_3, t0.type_societe AS type_societe_4, t0.sigle_societe AS sigle_societe_5, t0.nb_historique_projet AS nb_historique_projet_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.is_active AS is_active_11, t0.num_tva AS num_tva_12, t0.condition_reglement AS condition_reglement_13 FROM societe t0 WHERE t0.id = ?
Parameters:
[
1149
]
|
| 6 | 0.36 ms |
SELECT t0.id AS id_1, t0.classe_societe AS classe_societe_2, t0.lib_societe AS lib_societe_3, t0.type_societe AS type_societe_4, t0.sigle_societe AS sigle_societe_5, t0.nb_historique_projet AS nb_historique_projet_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.is_active AS is_active_11, t0.num_tva AS num_tva_12, t0.condition_reglement AS condition_reglement_13 FROM societe t0 WHERE t0.id = ?
Parameters:
[
921
]
|
| 7 | 0.35 ms |
SELECT t0.id AS id_1, t0.classe_societe AS classe_societe_2, t0.lib_societe AS lib_societe_3, t0.type_societe AS type_societe_4, t0.sigle_societe AS sigle_societe_5, t0.nb_historique_projet AS nb_historique_projet_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.is_active AS is_active_11, t0.num_tva AS num_tva_12, t0.condition_reglement AS condition_reglement_13 FROM societe t0 WHERE t0.id = ?
Parameters:
[
912
]
|
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.