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

Query Metrics

10 Database Queries
4 Different statements
2.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM conselho_municipal c0_ WHERE c0_.ano = ? LIMIT 1
Parameters:
[
  "2021"
]
2 0.27 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:
[
  "2021"
]
3 0.42 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:
[
  4
]
4 0.24 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:
[
  4
]
5 0.22 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:
[
  6
]
6 0.22 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:
[
  6
]
7 0.23 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:
[
  11
]
8 0.18 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:
[
  11
]
9 0.18 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:
[
  12
]
10 0.17 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:
[
  12
]

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