Query Metrics
8
Database Queries
4
Different statements
4.28 ms
Query time
0
Invalid entities
19
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.81 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.isActive AS isActive_7, t0.createdAt AS createdAt_8 FROM User t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 2 | 0.47 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.receivedAt AS receivedAt_1 FROM Demande d0_ WHERE d0_.status <> ? ORDER BY d0_.receivedAt DESC LIMIT 20
Parameters:
[
"deleted"
]
|
| 3 | 1.39 ms |
SELECT d0_.id AS id_0, d0_.message AS message_1, d0_.subject AS subject_2, d0_.status AS status_3, d0_.contactFirstname AS contactFirstname_4, d0_.contactLastname AS contactLastname_5, d0_.contact_email AS contact_email_6, d0_.contactPhone AS contactPhone_7, d0_.contactAddress AS contactAddress_8, d0_.contactZipcode AS contactZipcode_9, d0_.contactCity AS contactCity_10, d0_.contactCountry AS contactCountry_11, d0_.contactCompany AS contactCompany_12, d0_.receivedAt AS receivedAt_13, d0_.convertedAt AS convertedAt_14, d0_.notes AS notes_15, d0_.externalId AS externalId_16, d0_.customerType AS customerType_17, d0_.assignedTo_id AS assignedTo_id_18, d0_.quote_id AS quote_id_19, d0_.reseller_id AS reseller_id_20 FROM Demande d0_ WHERE d0_.status <> ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.receivedAt DESC
Parameters:
[ "deleted" 1282 1286 1281 1283 1287 1275 1285 1277 1278 1279 ] |
| 4 | 0.30 ms |
SELECT count(*) AS sclr_0 FROM Demande d0_ WHERE d0_.status <> ?
Parameters:
[
"deleted"
]
|
| 5 | 0.37 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.isActive AS isActive_7, t0.createdAt AS createdAt_8 FROM User t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 6 | 0.28 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.isActive AS isActive_7, t0.createdAt AS createdAt_8 FROM User t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 7 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.isActive AS isActive_7, t0.createdAt AS createdAt_8 FROM User t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 8 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.isActive AS isActive_7, t0.createdAt AS createdAt_8 FROM User t0 WHERE t0.id = ?
Parameters:
[
15
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| sofraca | doctrine.dbal.sofraca_connection |
| furnotel | doctrine.dbal.furnotel_connection |
| nosem | doctrine.dbal.nosem_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\Demande | 10 |
| App\Entity\User | 5 |
| App\Entity\Quote | 3 |
| App\Entity\Customer | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Quote | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\QuoteStatusHistory | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Demande | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Product | No errors. |