GET https://api.aeroknow.xyz/topic/156

Query Metrics

5 Database Queries
5 Different statements
2.86 ms Query time
0 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.updated AS updated_3, t0.subject_id AS subject_id_4 FROM topic t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "156"
]
2 0.81 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.canonical AS canonical_3, t0.chapter AS chapter_4, t0.refImg AS refImg_5, t0.explaination AS explaination_6, t0.updated AS updated_7, t0.topic_id AS topic_id_8, t9.care AS care_10, t9.question_id AS question_id_11, t9.user_id AS user_id_12, t13.good AS good_14, t13.wrong AS wrong_15, t13.total AS total_16, t13.question_id AS question_id_17, t13.user_id AS user_id_18 FROM question t0 LEFT JOIN focus t9 ON t9.question_id = t0.id LEFT JOIN follow t13 ON t13.question_id = t0.id WHERE t0.topic_id = ?
Parameters:
[
  156
]
3 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.public AS public_3, t0.updated AS updated_4, t0.source_id AS source_id_5 FROM subject t0 WHERE t0.id = ?
Parameters:
[
  15
]
4 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.updated AS updated_3, t0.subject_id AS subject_id_4 FROM topic t0 WHERE t0.subject_id = ?
Parameters:
[
  15
]
5 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.public AS public_3, t0.updated AS updated_4, t0.sortBy AS sortBy_5 FROM source t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Topic 9
App\Entity\Subject 1
App\Entity\Source 1

Entities Mapping

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