Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.00 ms Query time

2 Invalid entities

#▲	Time	Info
1	0.25 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	0.49 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"dm"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dm' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	0.26 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

0.25 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

0.49 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "dm"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dm'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

0.26 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\AccountLog	No errors.
App\Entity\Account	No errors.
App\Entity\Dialogue	No errors.
App\Entity\UserLog	No errors.
App\Entity\CompletedDialogue	The association App\Entity\CompletedDialogue#dialogue refers to the inverse side field App\Entity\Dialogue#completedDialogues which does not exist.
App\Entity\Application	No errors.
App\Entity\Parameter	No errors.
App\Entity\Element	No errors.
App\Entity\Media	No errors.
App\Entity\Block	No errors.
App\Entity\AccountBlock	The association App\Entity\AccountBlock#block refers to the inverse side field App\Entity\Block#accountBlocks which does not exist.
App\Entity\Question	No errors.
Vich\UploaderBundle\Entity\File	No errors.