Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.72 ms Query time

0 Invalid entities

0 Managed entities

Time▼	Count	Info
1.16 ms (67.35%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"hcrm_app_stage"`] 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 = 'hcrm_app_stage' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
0.56 ms (32.65%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

1.16 ms
(67.35%)

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

Parameters:

[
  "hcrm_app_stage"
]

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

0.56 ms
(32.65%)

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	Amount of managed objects

Class	Mapping errors
App\Entity\Recado	No errors.
App\Entity\Tenant	No errors.
App\Entity\Chat	No errors.
App\Entity\User	No errors.
App\Entity\SolicitacaoAndamento	No errors.
App\Entity\EmailTemplate	No errors.
App\Entity\Configuracao	No errors.
App\Entity\Partido	No errors.
App\Entity\LatitudeLongitude	No errors.
App\Entity\Cidadao	No errors.
App\Entity\Calendario	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Endereco	No errors.
App\Entity\Sugestao	No errors.
App\Entity\Genero	No errors.
App\Entity\Logging	No errors.
App\Entity\Tag	No errors.
App\Entity\Campanha	No errors.
App\Entity\ChatDepartamento	No errors.
App\Entity\SolicitacaoCategoria	No errors.
App\Entity\CampanhaVisita	No errors.
App\Entity\ChatMensagem	No errors.
App\Entity\Solicitacao	No errors.
Vich\UploaderBundle\Entity\File	No errors.