Query Metrics

2 Database Queries
2 Different statements
48.92 ms Query time
0 Invalid entities
40 Managed entities

Grouped Statements

Show all queries

Time Count Info
38.09 ms
(77.85%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.picture AS picture_3, a0_.active AS active_4, a0_.slug AS slug_5, a0_.template AS template_6, a0_.views AS views_7, a0_.item_type AS item_type_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.deleted_at AS deleted_at_11, a1_.id AS id_12, a1_.title AS title_13, a1_.slug AS slug_14, a1_.active AS active_15, a1_.created_at AS created_at_16, a1_.updated_at AS updated_at_17, a1_.deleted_at AS deleted_at_18, a0_.author_id AS author_id_19 FROM a_article a0_ LEFT JOIN article_article_category a2_ ON a0_.id = a2_.article_id LEFT JOIN a_category a1_ ON a1_.id = a2_.article_category_id WHERE (a0_.active = ?) AND (a0_.deleted_at IS NULL) ORDER BY a0_.id ASC
Parameters:
[
  1
]
10.84 ms
(22.15%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM a_category t0 WHERE t0.active = ?
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\Article 32
App\Entity\ArticleCategory 7
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\ArticleCategory No errors.
App\Entity\Article No errors.
App\Entity\User No errors.
App\Entity\ArticlePhoto No errors.