GET https://api.aeroknow.xyz/api/public/routes

Query Metrics

25 Database Queries
3 Different statements
9.04 ms Query time
0 Invalid entities
212 Managed entities

Queries

Group similar statements

# Time Info
1 0.75 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.public AS public_2, s0_.updated AS updated_3, s0_.sortBy AS sortBy_4 FROM source s0_ INNER JOIN subject s1_ ON s0_.id = s1_.source_id WHERE s1_.public = 1
Parameters:
[]
2 0.56 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.public = ?
Parameters:
[
  1
]
3 0.53 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:
[
  1
]
4 0.56 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:
[
  2
]
5 0.50 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:
[
  3
]
6 0.41 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:
[
  4
]
7 0.33 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:
[
  5
]
8 0.38 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:
[
  6
]
9 0.30 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:
[
  7
]
10 0.37 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:
[
  8
]
11 0.27 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:
[
  9
]
12 0.25 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:
[
  10
]
13 0.31 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:
[
  11
]
14 0.30 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:
[
  12
]
15 0.31 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:
[
  13
]
16 0.27 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:
[
  14
]
17 0.27 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
]
18 0.25 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
]
19 0.27 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
]
20 0.26 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
]
21 0.36 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
]
22 0.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:
[
  22
]
23 0.32 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:
[
  25
]
24 0.30 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:
[
  32
]
25 0.34 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:
[
  33
]

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 184
App\Entity\Subject 23
App\Entity\Source 5

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.