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

Response
200 OK
IP
216.73.216.27
Profiled on
Token
c97946

Query Metrics

31 Database Queries
4 Different statements
72.44 ms Query time
0 Invalid entities
2649 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.04 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: 
[
  "4"
]
View formatted query    View runnable query    Explain query
2 7.22 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: 
[
  "4"
  null
]
View formatted query    View runnable query    Explain query
3 2.28 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: 
[
  17
]
View formatted query    View runnable query    Explain query
4 2.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: 
[
  92
]
View formatted query    View runnable query    Explain query
5 0.97 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: 
[
  20
]
View formatted query    View runnable query    Explain query
6 3.98 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: 
[
  102
]
View formatted query    View runnable query    Explain query
7 4.69 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: 
[
  103
]
View formatted query    View runnable query    Explain query
8 4.82 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: 
[
  104
]
View formatted query    View runnable query    Explain query
9 3.01 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: 
[
  105
]
View formatted query    View runnable query    Explain query
10 1.70 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: 
[
  106
]
View formatted query    View runnable query    Explain query
11 1.68 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: 
[
  110
]
View formatted query    View runnable query    Explain query
12 2.05 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: 
[
  111
]
View formatted query    View runnable query    Explain query
13 1.20 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: 
[
  113
]
View formatted query    View runnable query    Explain query
14 1.31 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: 
[
  114
]
View formatted query    View runnable query    Explain query
15 1.54 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: 
[
  115
]
View formatted query    View runnable query    Explain query
16 3.82 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: 
[
  116
]
View formatted query    View runnable query    Explain query
17 1.00 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: 
[
  117
]
View formatted query    View runnable query    Explain query
18 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: 
[
  22
]
View formatted query    View runnable query    Explain query
19 0.63 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: 
[
  119
]
View formatted query    View runnable query    Explain query
20 1.06 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: 
[
  120
]
View formatted query    View runnable query    Explain query
21 1.16 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: 
[
  121
]
View formatted query    View runnable query    Explain query
22 2.65 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: 
[
  122
]
View formatted query    View runnable query    Explain query
23 1.25 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: 
[
  123
]
View formatted query    View runnable query    Explain query
24 1.91 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: 
[
  124
]
View formatted query    View runnable query    Explain query
25 5.63 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: 
[
  125
]
View formatted query    View runnable query    Explain query
26 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: 
[
  126
]
View formatted query    View runnable query    Explain query
27 1.97 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: 
[
  127
]
View formatted query    View runnable query    Explain query
28 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: 
[
  133
]
View formatted query    View runnable query    Explain query
29 2.42 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: 
[
  134
]
View formatted query    View runnable query    Explain query
30 2.18 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: 
[
  135
]
View formatted query    View runnable query    Explain query
31 1.44 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: 
[
  136
]
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 1089
App\Entity\Follow 1026
App\Entity\Focus 503
App\Entity\Topic 26
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.