Query Metrics
10
Database Queries
6
Different statements
2.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.34 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.id = ?
Parameters:
[
"14"
]
|
| 2 | 0.31 ms |
SELECT v0_.id AS id_0, v0_.number_of_chairs AS number_of_chairs_1, v0_.is_available AS is_available_2, v0_.name AS name_3, v0_.number AS number_4, v0_.venue_id AS venue_id_5 FROM venue_table v0_ WHERE v0_.venue_id = ? ORDER BY v0_.number ASC
Parameters:
[
3864
]
|
| 3 | 0.35 ms |
SELECT r0_.has_attended AS has_attended_0, r0_.regular_points AS regular_points_1, r0_.seasonal_points AS seasonal_points_2, r0_.has_won_bonus AS has_won_bonus_3, r0_.is_late_registration AS is_late_registration_4, t1_.id AS id_5, t1_.name AS name_6, t1_.is_archived AS is_archived_7, t1_.is_disbanded AS is_disbanded_8, t1_.is_hiring AS is_hiring_9, v2_.id AS id_10, v2_.number_of_chairs AS number_of_chairs_11, v2_.is_available AS is_available_12, v2_.name AS name_13, v2_.number AS number_14, p3_.id AS id_15, p3_.starts_at AS starts_at_16, r0_.reserved_table_id AS reserved_table_id_17, r0_.team_id AS team_id_18, r0_.quiz_id AS quiz_id_19, v2_.venue_id AS venue_id_20, p3_.template_id AS template_id_21, p3_.venue_id AS venue_id_22, p3_.moderator_id AS moderator_id_23, p3_.season_id AS season_id_24, p3_.invoice_id AS invoice_id_25 FROM reservation r0_ INNER JOIN team t1_ ON r0_.team_id = t1_.id INNER JOIN venue_table v2_ ON r0_.reserved_table_id = v2_.id INNER JOIN pub_quiz p3_ ON r0_.quiz_id = p3_.id WHERE r0_.quiz_id = ? AND r0_.reserved_table_id = ?
Parameters:
[ 14 2983 ] |
| 4 | 0.29 ms |
SELECT r0_.has_attended AS has_attended_0, r0_.regular_points AS regular_points_1, r0_.seasonal_points AS seasonal_points_2, r0_.has_won_bonus AS has_won_bonus_3, r0_.is_late_registration AS is_late_registration_4, t1_.id AS id_5, t1_.name AS name_6, t1_.is_archived AS is_archived_7, t1_.is_disbanded AS is_disbanded_8, t1_.is_hiring AS is_hiring_9, v2_.id AS id_10, v2_.number_of_chairs AS number_of_chairs_11, v2_.is_available AS is_available_12, v2_.name AS name_13, v2_.number AS number_14, p3_.id AS id_15, p3_.starts_at AS starts_at_16, r0_.reserved_table_id AS reserved_table_id_17, r0_.team_id AS team_id_18, r0_.quiz_id AS quiz_id_19, v2_.venue_id AS venue_id_20, p3_.template_id AS template_id_21, p3_.venue_id AS venue_id_22, p3_.moderator_id AS moderator_id_23, p3_.season_id AS season_id_24, p3_.invoice_id AS invoice_id_25 FROM reservation r0_ INNER JOIN team t1_ ON r0_.team_id = t1_.id INNER JOIN venue_table v2_ ON r0_.reserved_table_id = v2_.id INNER JOIN pub_quiz p3_ ON r0_.quiz_id = p3_.id WHERE r0_.quiz_id = ? AND r0_.reserved_table_id = ?
Parameters:
[ 14 2984 ] |
| 5 | 0.27 ms |
SELECT r0_.has_attended AS has_attended_0, r0_.regular_points AS regular_points_1, r0_.seasonal_points AS seasonal_points_2, r0_.has_won_bonus AS has_won_bonus_3, r0_.is_late_registration AS is_late_registration_4, t1_.id AS id_5, t1_.name AS name_6, t1_.is_archived AS is_archived_7, t1_.is_disbanded AS is_disbanded_8, t1_.is_hiring AS is_hiring_9, v2_.id AS id_10, v2_.number_of_chairs AS number_of_chairs_11, v2_.is_available AS is_available_12, v2_.name AS name_13, v2_.number AS number_14, p3_.id AS id_15, p3_.starts_at AS starts_at_16, r0_.reserved_table_id AS reserved_table_id_17, r0_.team_id AS team_id_18, r0_.quiz_id AS quiz_id_19, v2_.venue_id AS venue_id_20, p3_.template_id AS template_id_21, p3_.venue_id AS venue_id_22, p3_.moderator_id AS moderator_id_23, p3_.season_id AS season_id_24, p3_.invoice_id AS invoice_id_25 FROM reservation r0_ INNER JOIN team t1_ ON r0_.team_id = t1_.id INNER JOIN venue_table v2_ ON r0_.reserved_table_id = v2_.id INNER JOIN pub_quiz p3_ ON r0_.quiz_id = p3_.id WHERE r0_.quiz_id = ? AND r0_.reserved_table_id = ?
Parameters:
[ 14 2985 ] |
| 6 | 0.27 ms |
SELECT r0_.has_attended AS has_attended_0, r0_.regular_points AS regular_points_1, r0_.seasonal_points AS seasonal_points_2, r0_.has_won_bonus AS has_won_bonus_3, r0_.is_late_registration AS is_late_registration_4, t1_.id AS id_5, t1_.name AS name_6, t1_.is_archived AS is_archived_7, t1_.is_disbanded AS is_disbanded_8, t1_.is_hiring AS is_hiring_9, v2_.id AS id_10, v2_.number_of_chairs AS number_of_chairs_11, v2_.is_available AS is_available_12, v2_.name AS name_13, v2_.number AS number_14, p3_.id AS id_15, p3_.starts_at AS starts_at_16, r0_.reserved_table_id AS reserved_table_id_17, r0_.team_id AS team_id_18, r0_.quiz_id AS quiz_id_19, v2_.venue_id AS venue_id_20, p3_.template_id AS template_id_21, p3_.venue_id AS venue_id_22, p3_.moderator_id AS moderator_id_23, p3_.season_id AS season_id_24, p3_.invoice_id AS invoice_id_25 FROM reservation r0_ INNER JOIN team t1_ ON r0_.team_id = t1_.id INNER JOIN venue_table v2_ ON r0_.reserved_table_id = v2_.id INNER JOIN pub_quiz p3_ ON r0_.quiz_id = p3_.id WHERE r0_.quiz_id = ? AND r0_.reserved_table_id = ?
Parameters:
[ 14 2986 ] |
| 7 | 0.27 ms |
SELECT r0_.has_attended AS has_attended_0, r0_.regular_points AS regular_points_1, r0_.seasonal_points AS seasonal_points_2, r0_.has_won_bonus AS has_won_bonus_3, r0_.is_late_registration AS is_late_registration_4, t1_.id AS id_5, t1_.name AS name_6, t1_.is_archived AS is_archived_7, t1_.is_disbanded AS is_disbanded_8, t1_.is_hiring AS is_hiring_9, v2_.id AS id_10, v2_.number_of_chairs AS number_of_chairs_11, v2_.is_available AS is_available_12, v2_.name AS name_13, v2_.number AS number_14, p3_.id AS id_15, p3_.starts_at AS starts_at_16, r0_.reserved_table_id AS reserved_table_id_17, r0_.team_id AS team_id_18, r0_.quiz_id AS quiz_id_19, v2_.venue_id AS venue_id_20, p3_.template_id AS template_id_21, p3_.venue_id AS venue_id_22, p3_.moderator_id AS moderator_id_23, p3_.season_id AS season_id_24, p3_.invoice_id AS invoice_id_25 FROM reservation r0_ INNER JOIN team t1_ ON r0_.team_id = t1_.id INNER JOIN venue_table v2_ ON r0_.reserved_table_id = v2_.id INNER JOIN pub_quiz p3_ ON r0_.quiz_id = p3_.id WHERE r0_.quiz_id = ? AND r0_.reserved_table_id = ?
Parameters:
[ 14 2987 ] |
| 8 | 0.25 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
]
|
| 9 | 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:
[
343
]
|
| 10 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.available_from AS available_from_3, t0.available_to AS available_to_4, t0.language AS language_5, t0.current_state AS current_state_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM quiz_template t0 WHERE t0.id = ?
Parameters:
[
202
]
|
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\VenueTable | No errors. |
| App\Entity\Team | No errors. |
| App\Entity\TeamUser | No errors. |
| App\Entity\TeamApplication | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Round | No errors. |
| App\Entity\OnlineQuiz | No errors. |