Query Metrics

4 Database Queries
4 Different statements
1.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 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_ ORDER BY p0_.starts_at ASC
Parameters:
[]
2 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3 FROM city t0
Parameters:
[]
3 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
Parameters:
[]
4 0.32 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.last_logged_in AS last_logged_in_6, t0.language AS language_7, t0.credit AS credit_8, t0.entry_hash AS entry_hash_9, t0.reset_hash AS reset_hash_10, t0.reset_hash_date AS reset_hash_date_11 FROM user t0
Parameters:
[]

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\PubQuiz No errors.
App\Entity\QuizTemplate No errors.
App\Entity\Venue No errors.
App\Entity\User No errors.
App\Entity\QuizSeason No errors.
App\Entity\Invoice No errors.
App\Entity\Reservation No errors.
App\Entity\City No errors.
App\Entity\VenueTable No errors.
App\Entity\OnlineQuiz No errors.
App\Entity\TeamUser No errors.