Query Metrics

6 Database Queries
5 Different statements
6.46 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.70 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.available AS available_3, s0_.user_id AS user_id_4 FROM section s0_ INNER JOIN translation t1_ ON s0_.id = t1_.section_id WHERE s0_.available = 1 AND t1_.keyword = ?
Parameters:
[
  "section.title"
]
2 0.31 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.available AS available_3, s0_.user_id AS user_id_4 FROM section s0_ INNER JOIN translation t1_ ON s0_.id = t1_.section_id WHERE s0_.available = 1 AND t1_.keyword = ?
Parameters:
[
  "section.content"
]
3 2.80 ms
SELECT i0_.id AS id_0, i0_.content AS content_1, i0_.background AS background_2, i0_.background2 AS background2_3, i0_.user_id AS user_id_4 FROM introduction i0_ INNER JOIN translation t1_ ON i0_.id = t1_.introduction_id WHERE t1_.keyword = ?
Parameters:
[
  "introduction.content"
]
4 0.18 ms
SELECT i0_.id AS id_0, i0_.content AS content_1, i0_.background AS background_2, i0_.background2 AS background2_3, i0_.user_id AS user_id_4 FROM introduction i0_
Parameters:
[]
5 0.16 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.available AS available_3, s0_.user_id AS user_id_4 FROM section s0_ WHERE s0_.available = 1
Parameters:
[]
6 0.31 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.logo AS logo_2, l0_.available AS available_3 FROM logo l0_ WHERE l0_.available = ?
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.

Entities Mapping

Class Mapping errors
App\Entity\Section No errors.
App\Entity\Translation No errors.
App\Entity\User
  • The association App\Entity\User#commentaries refers to the owning side field App\Entity\Commentary#user which does not exist.
App\Entity\Introduction No errors.
App\Entity\Logo No errors.