Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.61 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
2.61 ms (100.00%)	1	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.email = ? LIMIT 1 Parameters: [`"rocco.ciccone@nosem.mc"`] View formatted query View runnable query Explain query 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.email = ? LIMIT 1 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.email = 'rocco.ciccone@nosem.mc' LIMIT 1;

Time▼

Count

Info

2.61 ms
(100.00%)

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.email = ? LIMIT 1

Parameters:

[
  "rocco.ciccone@nosem.mc"
]

View formatted query View runnable query Explain query

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.email = ?
LIMIT
  1

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.email = 'rocco.ciccone@nosem.mc' LIMIT 1;

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\User	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.