Query Metrics
2
Database Queries
2
Different statements
137.21 ms
Query time
0
Invalid entities
9
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
77.30 ms (56.33%) |
1 |
SELECT o0_.id AS id_0, o0_.email AS email_1, o0_.enabled AS enabled_2, o0_.salt AS salt_3, o0_.password AS password_4, o0_.last_login AS last_login_5, o0_.confirmation_token AS confirmation_token_6, o0_.password_requested_at AS password_requested_at_7, o0_.roles AS roles_8, o0_.username AS username_9, o0_.nom AS nom_10, o0_.prenom AS prenom_11, o0_.fonction AS fonction_12, o0_.tel AS tel_13, o0_.mobile AS mobile_14, o0_.activation AS activation_15, o0_.createdAt AS createdAt_16, o0_.updatedAt AS updatedAt_17, o0_.optin AS optin_18, o0_.dateActivation AS dateActivation_19, o0_.emailValidatedDateTime AS emailValidatedDateTime_20, o0_.emailCreatedDateTime AS emailCreatedDateTime_21, o0_.mobileCreatedDatetime AS mobileCreatedDatetime_22, o0_.sendEmail AS sendEmail_23, o0_.scope AS scope_24, o0_.isArchived AS isArchived_25, o0_.import AS import_26, o0_.email_canonical AS email_canonical_27, o0_.username_canonical AS username_canonical_28, o0_.oblige_id AS oblige_id_29 FROM ObligeUser o0_ INNER JOIN Oblige o1_ ON o0_.oblige_id = o1_.id WHERE o0_.username = ?
Parameters:
[
"[email protected]"
]
|
|
59.92 ms (43.67%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = ?
Parameters:
[
247
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| read | doctrine.dbal.read_connection |
| stats | doctrine.dbal.stats_connection |
| qrdecode | doctrine.dbal.qrdecode_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| read | doctrine.orm.read_entity_manager |
| stats | doctrine.orm.stats_entity_manager |
| qrdecode | doctrine.orm.qrdecode_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Consoneo\Bundle\UserBundle\Entity\RegleRole | 3 |
| Consoneo\Bundle\UserBundle\Entity\ObligeRole | 3 |
| Consoneo\Bundle\UserBundle\Entity\ObligeUser | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 1 |
| Consoneo\Bundle\UserBundle\Entity\TeteReseau | 1 |
read entity manager
| Class | Amount of managed objects |
|---|
stats entity manager
| Class | Amount of managed objects |
|---|
qrdecode entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
read entity manager
| Class | Mapping errors |
|---|---|
| Consoneo\Bundle\SimulateurBundle\Entity\ZoneClimatique | No errors. |
| Consoneo\Bundle\ObligeBundle\Entity\Configuration | No errors. |
| Consoneo\Bundle\UserBundle\Entity\Oblige | No errors. |
| Consoneo\Bundle\ObligeBundle\Entity\OffreProjet | No errors. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |