GET https://erreala.foro.eus/eu_ES/

Query Metrics

8 Database Queries
5 Different statements
4.65 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.38 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.subject_id IS NULL OR p0_.subject_id = 0
Parameters:
[]
2 0.61 ms
SELECT DISTINCT p0_.id AS id_0, p0_.answer_datetime AS answer_datetime_1 FROM post p0_ WHERE p0_.subject_id IS NULL OR p0_.subject_id = 0 ORDER BY p0_.answer_datetime DESC LIMIT 20
Parameters:
[]
3 0.60 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_datetime AS created_datetime_3, p0_.answer_datetime AS answer_datetime_4, p0_.draft AS draft_5, p0_.visits AS visits_6, p0_.censored AS censored_7, p0_.hidetitle AS hidetitle_8, p0_.inquestcustomanswer AS inquestcustomanswer_9, p0_.user_id AS user_id_10, p0_.subject_id AS subject_id_11, p0_.quote_id AS quote_id_12, p0_.inquestanswer_id AS inquestanswer_id_13 FROM post p0_ WHERE (p0_.subject_id IS NULL OR p0_.subject_id = 0) AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.answer_datetime DESC
Parameters:
[
  5
  4
  2
  1
]
4 0.47 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
Parameters:
[
  5
]
5 0.49 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.publicemailshow AS publicemailshow_3, t0.username AS username_4, t0.avatar AS avatar_5, t0.birddate AS birddate_6, t0.publicbirddateshow AS publicbirddateshow_7, t0.whatsapp AS whatsapp_8, t0.publicwhatsappshow AS publicwhatsappshow_9, t0.aboutyou AS aboutyou_10, t0.signature AS signature_11, t0.registered_datetime AS registered_datetime_12, t0.lastconection AS lastconection_13, t0.roles AS roles_14, t0.password AS password_15, t0.google_id AS google_id_16, t0.google_access_token AS google_access_token_17, t0.is_verified AS is_verified_18, t0.banned AS banned_19 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
Parameters:
[
  4
]
7 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_id = ?
Parameters:
[
  2
]
8 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_datetime AS created_datetime_4, t0.answer_datetime AS answer_datetime_5, t0.draft AS draft_6, t0.visits AS visits_7, t0.censored AS censored_8, t0.hidetitle AS hidetitle_9, t0.inquestcustomanswer AS inquestcustomanswer_10, t0.user_id AS user_id_11, t0.subject_id AS subject_id_12, t0.quote_id AS quote_id_13, t0.inquestanswer_id AS inquestanswer_id_14 FROM post t0 WHERE t0.subject_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.

Entities Mapping

Class Mapping errors
App\Entity\Post
  • The association App\Entity\Post#inquestanswer refers to the inverse side field App\Entity\Inquestoption#insquestanwers which does not exist.
App\Entity\User No errors.
App\Entity\Inquestoption
  • The mappings App\Entity\Inquestoption#inquestanswers and App\Entity\Post#inquestanswer are inconsistent with each other.
App\Entity\Readed No errors.
App\Entity\Startingteam No errors.
App\Entity\Report
  • The association App\Entity\Report#post refers to the inverse side field App\Entity\Post#reports which does not exist.