Query Metrics

5 Database Queries
5 Different statements
1.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.24 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.website AS website_3, t0.name AS name_4, t0.is_deleted AS is_deleted_5, t0.is_visible AS is_visible_6, t0.city_id AS city_id_7 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  "3939"
]
2 0.34 ms
SELECT p0_.id AS id_0, p0_.starts_at AS starts_at_1, p0_.template_id AS template_id_2, p0_.venue_id AS venue_id_3, p0_.moderator_id AS moderator_id_4, p0_.season_id AS season_id_5, p0_.invoice_id AS invoice_id_6 FROM pub_quiz p0_ WHERE p0_.venue_id = ? AND p0_.starts_at > ? ORDER BY p0_.starts_at ASC LIMIT 5
Parameters:
[
  3939
  "2025-12-20 03:54:46"
]
3 0.28 ms
SELECT q0_.id AS id_0, q0_.name AS name_1, q0_.starts_at AS starts_at_2, q0_.finishes_at AS finishes_at_3, q0_.is_visible AS is_visible_4 FROM quiz_season q0_ INNER JOIN quiz_season_venue q2_ ON q0_.id = q2_.quiz_season_id INNER JOIN venue v1_ ON v1_.id = q2_.venue_id WHERE q0_.is_visible = 1 AND v1_.id = ? ORDER BY q0_.starts_at DESC
Parameters:
[
  3939
]
4 0.22 ms
SELECT q0_.id AS id_0, q0_.name AS name_1, q0_.starts_at AS starts_at_2, q0_.finishes_at AS finishes_at_3, q0_.is_visible AS is_visible_4 FROM quiz_season q0_ WHERE q0_.starts_at <= ? AND q0_.finishes_at >= ? AND q0_.is_visible = 1 ORDER BY q0_.starts_at DESC
Parameters:
[
  "2025-12-20 03:54:46"
  "2025-12-20 03:54:46"
]
5 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3 FROM city t0 WHERE t0.id = ?
Parameters:
[
  351
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Venue No errors.
App\Entity\City No errors.
App\Entity\User No errors.
App\Entity\PubQuiz No errors.
App\Entity\VenueTable No errors.
App\Entity\QuizSeason No errors.
App\Entity\QuizTemplate No errors.
App\Entity\Invoice No errors.