GET https://conexao.wab.com.br/noticias

Query Metrics

4 Database Queries
4 Different statements
3.43 ms Query time
0 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.16 ms
(33.81%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10 FROM notice n0_ WHERE n0_.type = ? AND n0_.active = ? ORDER BY n0_.date DESC) dctrn_result) dctrn_table
Parameters:
[
  1
  1
]
1.08 ms
(31.39%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM notice n0_ WHERE n0_.type = ? AND n0_.active = ? AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.date DESC
Parameters:
[
  1
  1
  487
  486
  485
  484
  481
  483
  482
  479
  480
  459
  435
  433
]
0.88 ms
(25.62%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10 FROM notice n0_ WHERE n0_.type = ? AND n0_.active = ?) dctrn_result_inner ORDER BY date_2 DESC) dctrn_result LIMIT 12
Parameters:
[
  1
  1
]
0.31 ms
(9.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.type AS type_4 FROM notice_category t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Notice 12
App\Entity\NoticeCategory 1

Entities Mapping

Class Mapping errors
App\Entity\Notice No errors.
App\Entity\NoticeCategory No errors.