Query Metrics
8
Database Queries
4
Different statements
4.28 ms
Query time
0
Invalid entities
19
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.11 ms (49.40%) |
5 |
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
]
|
|
1.39 ms (32.53%) |
1 |
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 ] |
|
0.47 ms (10.98%) |
1 |
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"
]
|
|
0.30 ms (7.08%) |
1 |
SELECT count(*) AS sclr_0 FROM Demande d0_ WHERE d0_.status <> ?
Parameters:
[
"deleted"
]
|
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. |