GET http://verdelandia.tpontes.com.br/conselho/municipal/conselhos?ano=2023

Query Metrics

6 Database Queries
4 Different statements
2.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.17 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM conselho_municipal c0_ WHERE c0_.ano = ? LIMIT 1
Parameters:
[
  "2023"
]
2 0.15 ms
SELECT c0_.id AS id_0, c0_.administracao AS administracao_1, c0_.descricao AS descricao_2, c0_.ano AS ano_3, c0_.secretaria AS secretaria_4, c0_.legislacao AS legislacao_5, c0_.composicao AS composicao_6, c0_.status AS status_7 FROM conselho_municipal c0_ WHERE c0_.ano = ? ORDER BY c0_.id ASC LIMIT 10
Parameters:
[
  "2023"
]
3 1.74 ms
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.documento AS documento_3, t0.data AS data_4, t0.conselho_municipal_id AS conselho_municipal_id_5 FROM conselho_municipal_documento t0 WHERE t0.conselho_municipal_id = ?
Parameters:
[
  1
]
4 0.16 ms
SELECT t0.id AS id_1, t0.contato AS contato_2, t0.telefone AS telefone_3, t0.email AS email_4, t0.classe AS classe_5, t0.cpf AS cpf_6, t0.data_inicial AS data_inicial_7, t0.data_final AS data_final_8, t0.representante AS representante_9, t0.conselho_municipal_id AS conselho_municipal_id_10 FROM conselho_municipal_contato t0 WHERE t0.conselho_municipal_id = ?
Parameters:
[
  1
]
5 0.13 ms
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.documento AS documento_3, t0.data AS data_4, t0.conselho_municipal_id AS conselho_municipal_id_5 FROM conselho_municipal_documento t0 WHERE t0.conselho_municipal_id = ?
Parameters:
[
  5
]
6 0.16 ms
SELECT t0.id AS id_1, t0.contato AS contato_2, t0.telefone AS telefone_3, t0.email AS email_4, t0.classe AS classe_5, t0.cpf AS cpf_6, t0.data_inicial AS data_inicial_7, t0.data_final AS data_final_8, t0.representante AS representante_9, t0.conselho_municipal_id AS conselho_municipal_id_10 FROM conselho_municipal_contato t0 WHERE t0.conselho_municipal_id = ?
Parameters:
[
  5
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping