Query Metrics
4
Database Queries
4
Different statements
6.99 ms
Query time
0
Invalid entities
4
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.32 ms |
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
]
|
| 2 | 2.48 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.id AS id_1 FROM DocumentType d0_ WHERE LOWER(CONCAT(d0_.name, '')) LIKE ? OR LOWER(CONCAT(d0_.slug, '')) LIKE ? OR LOWER(CONCAT(d0_.originalEmailName, '')) LIKE ? ORDER BY d0_.id DESC LIMIT 30
Parameters:
[ "%prévisite%" "%prévisite%" "%prévisite%" ] |
| 3 | 0.94 ms |
SELECT d0_.id AS id_0, d0_.slug AS slug_1, d0_.name AS name_2, d0_.originalEmailName AS originalEmailName_3, d0_.created_datetime AS created_datetime_4, d0_.weight AS weight_5, d0_.originalNeeded AS originalNeeded_6, d0_.allowedUniverSign AS allowedUniverSign_7, d0_.description AS description_8 FROM DocumentType d0_ WHERE (LOWER(CONCAT(d0_.name, '')) LIKE ? OR LOWER(CONCAT(d0_.slug, '')) LIKE ? OR LOWER(CONCAT(d0_.originalEmailName, '')) LIKE ?) AND d0_.id IN (?, ?) ORDER BY d0_.id DESC
Parameters:
[ "%prévisite%" "%prévisite%" "%prévisite%" 225 88 ] |
| 4 | 2.26 ms |
SELECT count(d0_.id) AS sclr_0 FROM DocumentType d0_ WHERE LOWER(CONCAT(d0_.name, '')) LIKE ? OR LOWER(CONCAT(d0_.slug, '')) LIKE ? OR LOWER(CONCAT(d0_.originalEmailName, '')) LIKE ?
Parameters:
[ "%prévisite%" "%prévisite%" "%prévisite%" ] |
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\ObligeBundle\Entity\DocumentType | 2 |
| Consoneo\Bundle\UserBundle\Entity\ObligeUser | 1 |
| Consoneo\Bundle\UserBundle\Entity\Oblige | 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. |
stats entity manager
No loaded entities.
qrdecode entity manager
| Class | Mapping errors |
|---|---|
| C2eCoreBundle\Entity\DocumentQrDecode | No errors. |