GET https://www.devis.groupe-furnotel.com/admin/demande

Query Metrics

8 Database Queries
4 Different statements
4.28 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

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.