GET https://api.aeroknow.xyz/source/2

Response
200 OK
IP
216.73.216.27
Profiled on
Token
416b22

Query Metrics

21 Database Queries
4 Different statements
51.26 ms Query time
0 Invalid entities
486 Managed entities

Queries

Group similar statements

#▲ Time Info
1 6.70 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 = ? ORDER BY t0.sortBy ASC LIMIT 1
Parameters: 
[
  "2"
]
View formatted query    View runnable query    Explain query
2 2.36 ms 
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.public AS public_2, s0_.updated AS updated_3, s0_.source_id AS source_id_4 FROM subject s0_ INNER JOIN source s1_ ON s0_.source_id = s1_.id INNER JOIN topic t2_ ON s0_.id = t2_.subject_id LEFT JOIN subject_user s4_ ON s0_.id = s4_.subject_id LEFT JOIN fos_user f3_ ON f3_.id = s4_.user_id WHERE s1_.id = ? AND (s0_.public = 1 OR (s0_.public = 0 AND f3_.id = ?))
Parameters: 
[
  "2"
  null
]
View formatted query    View runnable query    Explain query
3 0.46 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
]
View formatted query    View runnable query    Explain query
4 3.43 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: 
[
  90
]
View formatted query    View runnable query    Explain query
5 3.84 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: 
[
  93
]
View formatted query    View runnable query    Explain query
6 4.22 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: 
[
  94
]
View formatted query    View runnable query    Explain query
7 1.02 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: 
[
  95
]
View formatted query    View runnable query    Explain query
8 2.13 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: 
[
  96
]
View formatted query    View runnable query    Explain query
9 2.07 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: 
[
  99
]
View formatted query    View runnable query    Explain query
10 2.64 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: 
[
  100
]
View formatted query    View runnable query    Explain query
11 3.83 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: 
[
  101
]
View formatted query    View runnable query    Explain query
12 6.39 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
]
View formatted query    View runnable query    Explain query
13 0.84 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: 
[
  19
]
View formatted query    View runnable query    Explain query
14 1.02 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: 
[
  97
]
View formatted query    View runnable query    Explain query
15 1.04 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: 
[
  98
]
View formatted query    View runnable query    Explain query
16 0.67 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: 
[
  21
]
View formatted query    View runnable query    Explain query
17 3.13 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: 
[
  107
]
View formatted query    View runnable query    Explain query
18 2.37 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: 
[
  109
]
View formatted query    View runnable query    Explain query
19 0.73 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: 
[
  112
]
View formatted query    View runnable query    Explain query
20 1.07 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: 
[
  118
]
View formatted query    View runnable query    Explain query
21 1.30 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: 
[
  128
]
View formatted query    View runnable query    Explain query

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\Question 193
App\Entity\Follow 193
App\Entity\Focus 79
App\Entity\Topic 16
App\Entity\Subject 3
App\Entity\Source 1
App\Entity\User 1

Entities Mapping

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