Query Metrics
7
Database Queries
6
Different statements
16.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.02 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.photos AS photos_4, t0.description AS description_5, t0.deleted AS deleted_6, t0.tel AS tel_7, t0.email AS email_8 FROM avocats t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"4"
]
|
| 2 | 1.09 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.created AS created_3, t0.horaires AS horaires_4, t0.envoi_conf AS envoi_conf_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.motif AS motif_10, t0.date_fin AS date_fin_11, t0.user_id AS user_id_12, t0.lieux_id AS lieux_id_13, t0.avocats_id AS avocats_id_14, t0.statuts_id AS statuts_id_15 FROM rendez_vous t0 WHERE t0.avocats_id = ?
Parameters:
[
4
]
|
| 3 | 2.93 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.deleted AS deleted_3, t0.adresse AS adresse_4 FROM lieux t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 4 | 0.57 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.deleted AS deleted_3, t0.adresse AS adresse_4 FROM lieux t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 5 | 0.95 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4, t0.lieux_id AS lieux_id_5, t0.avocats_id AS avocats_id_6 FROM jours_fermetures t0 WHERE t0.avocats_id = ?
Parameters:
[
4
]
|
| 6 | 9.66 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.ouvert AS ouvert_3, t0.occupe AS occupe_4, t0.jours_fermetures_id AS jours_fermetures_id_5 FROM tranches t0 WHERE t0.jours_fermetures_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.ouvert = ?
Parameters:
[ 140 141 142 143 144 176 177 328 728 730 735 736 752 753 754 755 757 766 770 775 776 778 779 780 781 782 783 785 822 823 824 825 827 836 837 849 851 853 854 855 869 870 871 872 903 904 905 906 907 908 920 923 924 945 958 960 1073 1074 1075 1076 1077 1 ] |
| 7 | 0.61 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avocats_id AS avocats_id_5 FROM users t0 WHERE t0.id = ?
Parameters:
[
5
]
|
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\RendezVous | No errors. |
| App\Entity\Avocats | No errors. |
| App\Entity\Tranches | No errors. |
| App\Entity\JoursFermetures | No errors. |
| App\Entity\JoursSemaine | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Lieux | No errors. |
| App\Entity\Statuts | No errors. |