Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.07 ms Query time

0 Invalid entities

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

#▲

Time

Info

0.09 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

0.89 ms

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

Parameters:

[
  "display_rksk_dk"
]

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

0.10 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\AbstractBaseEntity	No errors.
App\Entity\ScreenLayoutRegions	No errors.
App\Entity\ScreenLayout	No errors.
App\Entity\Template	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\UserRoleTenant	No errors.
App\Entity\Tenant\AbstractTenantScopedEntity	No errors.
App\Entity\Tenant\Playlist	No errors.
App\Entity\Tenant\Slide	No errors.
App\Entity\Tenant\ScreenGroupCampaign	No errors.
App\Entity\Tenant\Media	No errors.
App\Entity\Tenant\UserActivationCode	No errors.
App\Entity\Tenant\Screen	No errors.
App\Entity\Tenant\ScreenCampaign	No errors.
App\Entity\Tenant\Schedule	No errors.
App\Entity\Tenant\FeedSource	No errors.
App\Entity\Tenant\ScreenGroup	No errors.
App\Entity\Tenant\PlaylistScreenRegion	No errors.
App\Entity\Tenant\Theme	No errors.
App\Entity\Tenant\Feed	No errors.
App\Entity\Tenant\InteractiveSlide	No errors.
App\Entity\Tenant\PlaylistSlide	No errors.
App\Entity\Tenant	No errors.
App\Entity\ScreenUser	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.