GET https://app.bullsacademy.sk/api/admin/trainings?past=1

Query Metrics

11 Database Queries
8 Different statements
12.78 ms Query time
0 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 4.31 ms
SELECT t0.id AS id_1, t0.token_hash AS token_hash_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.expires_at AS expires_at_5, t0.user_id AS user_id_6 FROM api_token t0 WHERE t0.token_hash = ? LIMIT 1
Parameters:
[
  "94b21c18184353f4acd9c10987b8b92bdc9cec7e3e8b1b13c620029cc2ef7cba"
]
2 1.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.invite_token AS invite_token_8, t0.invite_expires_at AS invite_expires_at_9, t0.created_at AS created_at_10 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  5
]
3 0.33 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.invite_token AS invite_token_8, t0.invite_expires_at AS invite_expires_at_9, t0.created_at AS created_at_10 FROM app_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "jakub.kotrady91@gmail.com"
]
4 2.19 ms
SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.title AS title_2, t0_.description AS description_3, t0_.location AS location_4, t0_.starts_at AS starts_at_5, t0_.ends_at AS ends_at_6, t0_.latitude AS latitude_7, t0_.longitude AS longitude_8, t0_.capacity AS capacity_9, t0_.price_cents AS price_cents_10, t0_.created_at AS created_at_11 FROM training t0_ WHERE COALESCE(t0_.ends_at, t0_.starts_at) < ? AND t0_.type = ? ORDER BY t0_.starts_at DESC LIMIT 30
Parameters:
[
  "2026-08-14 00:48:10"
  "training"
]
5 1.44 ms
SELECT t0.id AS id_1, t0.waitlisted AS waitlisted_2, t0.attended AS attended_3, t0.created_at AS created_at_4, t0.training_id AS training_id_5, t0.child_id AS child_id_6, t0.created_by_id AS created_by_id_7, t0.jersey_id AS jersey_id_8 FROM registration t0 WHERE t0.training_id = ?
Parameters:
[
  5
]
6 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM jersey t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 1.08 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.note AS note_5, t0.internal_note AS internal_note_6, t0.created_at AS created_at_7, t0.archived_at AS archived_at_8, t0.parent_id AS parent_id_9, t0.category_id AS category_id_10 FROM child t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM jersey t0 WHERE t0.id = ?
Parameters:
[
  6
]
10 0.25 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.note AS note_5, t0.internal_note AS internal_note_6, t0.created_at AS created_at_7, t0.archived_at AS archived_at_8, t0.parent_id AS parent_id_9, t0.category_id AS category_id_10 FROM child t0 WHERE t0.id = ?
Parameters:
[
  4
]
11 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM category 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\Registration 2
App\Entity\Child 2
App\Entity\Jersey 2
App\Entity\Category 2
App\Entity\ApiToken 1
App\Entity\User 1
App\Entity\Training 1

Entities Mapping

Class Mapping errors
App\Entity\ApiToken No errors.
App\Entity\User No errors.
App\Entity\Child No errors.
App\Entity\Training No errors.
App\Entity\Registration No errors.
App\Entity\TournamentInvite No errors.
App\Entity\Jersey No errors.
App\Entity\Category No errors.