Query Metrics

7 Database Queries
5 Different statements
1.72 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 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:
[
  "3864"
]
2 0.31 ms
SELECT t0.id AS id_1, t0.starts_at AS starts_at_2, t0.template_id AS template_id_3, t0.venue_id AS venue_id_4, t0.moderator_id AS moderator_id_5, t0.season_id AS season_id_6, t0.invoice_id AS invoice_id_7 FROM pub_quiz t0 WHERE t0.venue_id = ?
Parameters:
[
  3864
]
3 0.26 ms
SELECT t0.has_attended AS has_attended_1, t0.regular_points AS regular_points_2, t0.seasonal_points AS seasonal_points_3, t0.has_won_bonus AS has_won_bonus_4, t0.is_late_registration AS is_late_registration_5, t0.reserved_table_id AS reserved_table_id_6, t0.team_id AS team_id_7, t0.quiz_id AS quiz_id_8 FROM reservation t0 WHERE t0.quiz_id = ?
Parameters:
[
  12
]
4 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_archived AS is_archived_3, t0.is_disbanded AS is_disbanded_4, t0.is_hiring AS is_hiring_5 FROM team t0 WHERE t0.id = ?
Parameters:
[
  43
]
5 0.22 ms
SELECT t0.has_attended AS has_attended_1, t0.regular_points AS regular_points_2, t0.seasonal_points AS seasonal_points_3, t0.has_won_bonus AS has_won_bonus_4, t0.is_late_registration AS is_late_registration_5, t0.reserved_table_id AS reserved_table_id_6, t0.team_id AS team_id_7, t0.quiz_id AS quiz_id_8 FROM reservation t0 WHERE t0.quiz_id = ?
Parameters:
[
  14
]
6 0.18 ms
SELECT t0.has_attended AS has_attended_1, t0.regular_points AS regular_points_2, t0.seasonal_points AS seasonal_points_3, t0.has_won_bonus AS has_won_bonus_4, t0.is_late_registration AS is_late_registration_5, t0.reserved_table_id AS reserved_table_id_6, t0.team_id AS team_id_7, t0.quiz_id AS quiz_id_8 FROM reservation t0 WHERE t0.quiz_id = ?
Parameters:
[
  15
]
7 0.16 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:
[
  343
]

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.
App\Entity\Reservation No errors.
App\Entity\Team No errors.
App\Entity\TeamUser No errors.
App\Entity\TeamApplication No errors.