GET https://api.aeroknow.xyz/api/question/6180

Query Metrics

5 Database Queries
5 Different statements
2.70 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.token AS token_5, t0.last_login AS last_login_6 FROM fos_user t0 WHERE t0.id = ?
Parameters:
[
  21
]
2 0.82 ms
SELECT q0_.id AS id_0, q0_.label AS label_1, q0_.canonical AS canonical_2, q0_.chapter AS chapter_3, q0_.refImg AS refImg_4, q0_.explaination AS explaination_5, q0_.updated AS updated_6, q0_.topic_id AS topic_id_7 FROM question q0_ LEFT JOIN follow f1_ ON q0_.id = f1_.question_id AND (f1_.user_id = ?) LEFT JOIN focus f2_ ON q0_.id = f2_.question_id AND (f2_.user_id = ?) WHERE q0_.id = ?
Parameters:
[
  21
  21
  "6180"
]
3 0.53 ms
SELECT t0.care AS care_1, t0.question_id AS question_id_2, t0.user_id AS user_id_3 FROM focus t0 WHERE t0.question_id = ?
Parameters:
[
  6180
]
4 0.34 ms
SELECT t0.good AS good_1, t0.wrong AS wrong_2, t0.total AS total_3, t0.question_id AS question_id_4, t0.user_id AS user_id_5 FROM follow t0 WHERE t0.question_id = ?
Parameters:
[
  6180
]
5 0.41 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.good AS good_3, t0.question_id AS question_id_4 FROM answer t0 WHERE t0.question_id = ?
Parameters:
[
  6180
]

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\Answer 4
App\Entity\User 2
App\Entity\Question 1
App\Entity\Topic 1
App\Entity\Follow 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Subject No errors.
App\Entity\Question No errors.
App\Entity\Follow No errors.
App\Entity\Focus No errors.
App\Entity\Topic No errors.
App\Entity\Answer No errors.
App\Entity\Tag No errors.