GET http://verdelandia.tpontes.com.br/conselho/municipal/conselhos?ano=2019&pagina=1

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
37.94 ms
(63.83%)
2
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:
[
  8
]
15.39 ms
(25.89%)
1
SELECT COUNT(c0_.id) AS sclr_0 FROM conselho_municipal c0_ WHERE c0_.ano = ? LIMIT 1
Parameters:
[
  "2019"
]
5.00 ms
(8.41%)
2
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:
[
  8
]
1.11 ms
(1.87%)
1
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:
[
  "2019"
]

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