Query Metrics
5
Database Queries
5
Different statements
9.55 ms
Query time
1
Invalid entities
3
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
3.55 ms (37.14%) |
1 |
UPDATE DocumentType SET originalEmailName = ? WHERE id = ?
Parameters:
[ "Copie ou original de la pré-visite technique (datée et signée par le client)" 88 ] |
|
2.99 ms (31.28%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.38 ms (14.44%) |
1 |
SELECT t0.username AS username_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.last_login AS last_login_5, t0.confirmation_token AS confirmation_token_6, t0.password_requested_at AS password_requested_at_7, t0.roles AS roles_8, t0.password AS password_9, t0.scope AS scope_10, t0.isArchived AS isArchived_11, t0.import AS import_12, t0.id AS id_13, t0.nom AS nom_14, t0.prenom AS prenom_15, t0.fonction AS fonction_16, t0.tel AS tel_17, t0.mobile AS mobile_18, t0.activation AS activation_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.optin AS optin_22, t0.dateActivation AS dateActivation_23, t0.emailValidatedDateTime AS emailValidatedDateTime_24, t0.emailCreatedDateTime AS emailCreatedDateTime_25, t0.mobileCreatedDatetime AS mobileCreatedDatetime_26, t0.sendEmail AS sendEmail_27, t0.email_canonical AS email_canonical_28, t0.username_canonical AS username_canonical_29, t0.oblige_id AS oblige_id_30 FROM ObligeUser t0 WHERE t0.id = ?
Parameters:
[
420
]
|
|
0.89 ms (9.35%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.originalEmailName AS originalEmailName_4, t0.created_datetime AS created_datetime_5, t0.weight AS weight_6, t0.originalNeeded AS originalNeeded_7, t0.allowedUniverSign AS allowedUniverSign_8, t0.description AS description_9 FROM DocumentType t0 WHERE t0.id = ?
Parameters:
[
"88"
]
|
|
0.74 ms (7.79%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\ObligeUser | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 1 |
| Consoneo\Bundle\ObligeBundle\Entity\DocumentType | 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\UserBundle\Entity\ObligeUser | No 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. |
| Consoneo\Bundle\ObligeBundle\Entity\DocumentType | No errors. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |
| Consoneo\Bundle\ObligeBundle\Entity\DocumentType |
|