Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.00 ms Query time

1 Invalid entities

#▲	Time	Info
1	0.41 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	0.44 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"admin_core"`] 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 = 'admin_core' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

0.41 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

0.44 ms

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

Parameters:

[
  "admin_core"
]

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 = 'admin_core'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

0.15 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\UserRoles	No errors.
App\Entity\City	No errors.
App\Entity\AmenityCategory	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\ApiKey	No errors.
App\Entity\Amenity	The association App\Entity\Amenity#hotel refers to the inverse side field App\Entity\Hotel#amenities which does not exist.
App\Entity\ApiKeyStat	No errors.
App\Entity\Hotel	No errors.
App\Entity\User	No errors.
App\Entity\Country	No errors.
App\Entity\UserVerify	No errors.
Admin\Entity\TranslatorDomain	No errors.
Admin\Entity\TranslatorKey	No errors.
Admin\Entity\Admin	No errors.
Admin\Entity\TranslatorLanguage	No errors.
Admin\Entity\TranslatorValue	No errors.
Admin\Entity\AdminRoles	No errors.
Admin\Entity\AdminAvatar	No errors.
Admin\Entity\Menu	No errors.
kvokka\PatchBundle\Entity\Patch	No errors.
Vich\UploaderBundle\Entity\File	No errors.