GET https://loba.guillaumedevweb.fr/projects/en

Query Metrics

5 Database Queries
4 Different statements
12.26 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 5.15 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.icon AS icon_2, p0_.content AS content_3, p0_.media AS media_4, p0_.available AS available_5, p0_.user_id AS user_id_6 FROM project p0_ INNER JOIN translation t1_ ON p0_.id = t1_.project_id WHERE t1_.keyword = ?
Parameters:
[
  "project.title"
]
2 0.50 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.icon AS icon_2, p0_.content AS content_3, p0_.media AS media_4, p0_.available AS available_5, p0_.user_id AS user_id_6 FROM project p0_ INNER JOIN translation t1_ ON p0_.id = t1_.project_id WHERE t1_.keyword = ?
Parameters:
[
  "project.content"
]
3 0.26 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.icon AS icon_2, p0_.content AS content_3, p0_.media AS media_4, p0_.available AS available_5, p0_.user_id AS user_id_6 FROM project p0_ WHERE p0_.available = 1
Parameters:
[]
4 4.21 ms
SELECT t0.id AS id_1, t0.background1 AS background1_2, t0.background2 AS background2_3 FROM bg_project t0
Parameters:
[]
5 2.14 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\Project 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\BgProject No errors.
App\Entity\Logo No errors.
App\Entity\Introduction No errors.
App\Entity\Section No errors.
App\Entity\Post
  • The association App\Entity\Post#commentaries refers to the owning side field App\Entity\Commentary#post which does not exist.
App\Entity\Like No errors.
App\Entity\Category No errors.
App\Entity\Commentary No errors.