Query Metrics
7
Database Queries
7
Different statements
20.26 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
13.31 ms (65.71%) |
1 |
"COMMIT"
Parameters:
[] |
|
5.16 ms (25.49%) |
1 |
SELECT m0_.firstname AS firstname_0, m0_.lastname AS lastname_1, m0_.email AS email_2, m0_.phone AS phone_3, m0_.mobile AS mobile_4, m0_.alias AS alias_5, m0_.id_intranet AS id_intranet_6, m0_.createdAt AS createdAt_7, m0_.updatedAt AS updatedAt_8, m0_.deletedAt AS deletedAt_9, m0_.id AS id_10, m0_.photo AS photo_11, m0_.pseudo AS pseudo_12 FROM model m0_ WHERE m0_.id_intranet = ?
Parameters:
[
4752
]
|
|
0.42 ms (2.10%) |
1 |
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.email AS email_3, t0.phone AS phone_4, t0.mobile AS mobile_5, t0.alias AS alias_6, t0.id_intranet AS id_intranet_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deletedAt AS deletedAt_10, t0.id AS id_11, t0.photo AS photo_12, t0.pseudo AS pseudo_13, t14.id AS id_15, t14.name AS name_16, t14.alias AS alias_17, t14.createdAt AS createdAt_18, t14.updatedAt AS updatedAt_19, t14.deletedAt AS deletedAt_20, t14.parent_id AS parent_id_21, t14.customer_id AS customer_id_22, t14.model_id AS model_id_23 FROM model t0 LEFT JOIN folder t14 ON t14.model_id = t0.id WHERE t0.id = ?
Parameters:
[
1836
]
|
|
0.40 ms (1.99%) |
1 |
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.email AS email_3, t0.phone AS phone_4, t0.mobile AS mobile_5, t0.alias AS alias_6, t0.id_intranet AS id_intranet_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.deletedAt AS deletedAt_10, t0.id AS id_11, t0.password AS password_12, t0.docusignUserId AS docusignUserId_13, t0.roles AS roles_14, t0.refreshToken AS refreshToken_15, t0.accessToken AS accessToken_16, t0.tokenExpireAt AS tokenExpireAt_17, t0.eurosignRefreshToken AS eurosignRefreshToken_18, t0.eurosignAccessToken AS eurosignAccessToken_19, t0.eurosignTokenExpireAt AS eurosignTokenExpireAt_20 FROM administrator t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"hugo@biyn.media"
]
|
|
0.40 ms (1.97%) |
1 |
UPDATE model SET photo = ? WHERE id = ?
Parameters:
[ "photo_4752_142097.jpg" 1836 ] |
|
0.33 ms (1.65%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.deletedAt AS deletedAt_6, t0.parent_id AS parent_id_7, t0.customer_id AS customer_id_8, t0.model_id AS model_id_9 FROM folder t0 WHERE t0.model_id = ?
Parameters:
[
1836
]
|
|
0.22 ms (1.09%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| intranet | doctrine.dbal.intranet_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\Folder | 2 |
| App\Entity\Administrator | 1 |
| App\Entity\Model | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BaseUser | No errors. |
| App\Entity\Administrator | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Folder | No errors. |
| App\Entity\Customer | No errors. |