GET https://dailyknowledgeserver.academy/api/knowledge

Query Metrics

12 Database Queries
12 Different statements
27.76 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
11.55 ms
(41.61%)
1
SELECT COUNT(k0_.id) AS sclr_0 FROM knowledge k0_
Parameters:
[]
3.69 ms
(13.28%)
1
"COMMIT"
Parameters:
[]
3.39 ms
(12.20%)
1
UPDATE `user` SET last_served_day = ? WHERE id = ?
Parameters:
[
  "2025-12-27"
  19
]
2.56 ms
(9.21%)
1
"START TRANSACTION"
Parameters:
[]
1.44 ms
(5.19%)
1
SELECT l0_.iso_code AS iso_code_0, k1_.name AS name_1 FROM knowledge_translation k1_ INNER JOIN language l0_ ON k1_.language_id = l0_.id WHERE k1_.knowledge_id = ?
Parameters:
[
  12
]
1.28 ms
(4.63%)
1
SELECT k0_.id AS id_0, l1_.iso_code AS iso_code_1, k2_.title AS title_2, k2_.url AS url_3 FROM knowledge_resource k0_ INNER JOIN knowledge k3_ ON k0_.knowledge_id = k3_.id INNER JOIN knowledge_resource_translation k2_ ON (k2_.knowledge_resource_id = k0_.id) INNER JOIN language l1_ ON k2_.language_id = l1_.id WHERE k3_.id = ? ORDER BY k0_.id ASC
Parameters:
[
  12
]
0.91 ms
(3.26%)
1
SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.created_at AS created_at_2, a0_.revoked_at AS revoked_at_3, a0_.user_id AS user_id_4 FROM api_token a0_ WHERE a0_.token = ? AND a0_.revoked_at IS NULL
Parameters:
[
  "eeb99fa8a871ca8b49f10712413095b16e7d32dd4c4155ba0cdd7e5820447962"
]
0.89 ms
(3.19%)
1
INSERT INTO served_knowledge (served_at, user_id, knowledge_id) VALUES (?, ?, ?)
Parameters:
[
  "2025-12-27 23:10:48"
  19
  12
]
0.68 ms
(2.46%)
1
SELECT k0_.id AS id_0 FROM knowledge k0_ ORDER BY k0_.id ASC LIMIT 1 OFFSET 8
Parameters:
[]
0.54 ms
(1.95%)
1
SELECT k0_.type AS type_0 FROM knowledge k0_ WHERE k0_.id = ?
Parameters:
[
  12
]
0.53 ms
(1.91%)
1
SELECT s0_.knowledge_id AS sclr_0 FROM served_knowledge s0_ WHERE s0_.user_id = ? ORDER BY s0_.served_at DESC
Parameters:
[
  19
]
0.31 ms
(1.12%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_served_day AS last_served_day_6, t0.current_daily_streak AS current_daily_streak_7, t0.premium_until AS premium_until_8, t0.selected_types AS selected_types_9 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  19
]

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\ApiToken 1
App\Entity\User 1
App\Entity\Knowledge 1
App\Entity\ServedKnowledge 1

Entities Mapping