Query Metrics
4
Database Queries
3
Different statements
5.26 ms
Query time
0
Invalid entities
24
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.15 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.forename AS forename_3, u0_.fullname AS fullname_4, u0_.plain_password AS plain_password_5, u0_.password AS password_6, u0_.roles AS roles_7, u0_.IP AS IP_8, u0_.telephone AS telephone_9, u0_.logincount AS logincount_10, u0_.first_login AS first_login_11, u0_.last_login AS last_login_12, u0_.photo AS photo_13, u0_.titre AS titre_14, u0_.enabled AS enabled_15, u0_.autorisationmail AS autorisationmail_16, u0_.autorisationsms AS autorisationsms_17, u0_.pseudo AS pseudo_18, u0_.salt AS salt_19 FROM user u0_ WHERE u0_.roles LIKE ? AND u0_.enabled = ?
Parameters:
[ "%"ROLE_PROPRIETAIRE"%" 1 ] |
| 2 | 1.77 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.forename AS forename_3, u0_.fullname AS fullname_4, u0_.plain_password AS plain_password_5, u0_.password AS password_6, u0_.roles AS roles_7, u0_.IP AS IP_8, u0_.telephone AS telephone_9, u0_.logincount AS logincount_10, u0_.first_login AS first_login_11, u0_.last_login AS last_login_12, u0_.photo AS photo_13, u0_.titre AS titre_14, u0_.enabled AS enabled_15, u0_.autorisationmail AS autorisationmail_16, u0_.autorisationsms AS autorisationsms_17, u0_.pseudo AS pseudo_18, u0_.salt AS salt_19 FROM user u0_ WHERE u0_.roles LIKE ? AND u0_.enabled = ?
Parameters:
[ "%"ROLE_PROPRIETAIRE"%" 1 ] |
| 3 | 0.56 ms |
SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
1
]
|
| 4 | 0.78 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = ?
Parameters:
[
4
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Style | 20 |
| App\Entity\User | 2 |
| App\Entity\Parametres | 1 |
| App\Entity\Theme | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Fil | No errors. |
| App\Entity\Fildonnees | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Messagedonnees | No errors. |
| App\Entity\Vuproduits | No errors. |
| App\Entity\Questionchallenge | No errors. |
| App\Entity\Questionvu | No errors. |
| App\Entity\Quizzreponse | No errors. |
| App\Entity\Questionmembre | No errors. |
| App\Entity\Questionmembrevu | No errors. |
| App\Entity\Quizz | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\Parametres | No errors. |
| App\Entity\Theme | No errors. |