GET https://dev.air-v.net/fr/reservation/gunslinger?player=5

Query Metrics

7 Database Queries
7 Different statements
1.93 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description_en AS description_en_3, t0.description_fr AS description_fr_4, t0.short_description_en AS short_description_en_5, t0.short_description_fr AS short_description_fr_6, t0.category AS category_7, t0.type AS type_8, t0.age AS age_9, t0.price AS price_10, t0.min_player AS min_player_11, t0.range_player AS range_player_12, t0.max_player AS max_player_13, t0.team_size AS team_size_14, t0.time AS time_15, t0.team_choose AS team_choose_16, t0.days AS days_17, t0.wednesday_schedules AS wednesday_schedules_18, t0.thursday_schedules AS thursday_schedules_19, t0.friday_schedules AS friday_schedules_20, t0.saturday_schedules AS saturday_schedules_21, t0.sunday_schedules AS sunday_schedules_22, t0.nb_days AS nb_days_23, t0.available AS available_24, t0.slug AS slug_25, t0.level AS level_26, t0.youtube_videos AS youtube_videos_27, t0.accessibility AS accessibility_28, t0.genre AS genre_29 FROM game t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "gunslinger"
]
2 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.size AS size_3, t0.updated_at AS updated_at_4, t0.game_id AS game_id_5 FROM game_image t0 WHERE t0.game_id = ? LIMIT 1
Parameters:
[
  67
]
3 0.16 ms
SELECT t0.id AS id_1, t0.players AS players_2, t0.date AS date_3, t0.hours AS hours_4, t0.game_id AS game_id_5 FROM reservation t0 WHERE t0.game_id = ?
Parameters:
[
  67
]
4 0.13 ms
SELECT t0.id AS id_1, t0.players AS players_2, t0.price AS price_3, t0.reference_id AS reference_id_4, t0.created_at AS created_at_5, t0.session_id AS session_id_6, t0.payment_intent_id AS payment_intent_id_7, t0.status AS status_8, t0.reservation_id AS reservation_id_9, t0.user_id AS user_id_10 FROM operation t0
Parameters:
[]
5 0.63 ms
SELECT t0.id AS id_1, t0.players AS players_2, t0.date AS date_3, t0.hours AS hours_4, t0.game_id AS game_id_5 FROM reservation t0 ORDER BY t0.id DESC
Parameters:
[]
6 0.28 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.monday_schedules AS monday_schedules_3, t0.tuesday_schedules AS tuesday_schedules_4, t0.wednesday_schedules AS wednesday_schedules_5, t0.thursday_schedules AS thursday_schedules_6, t0.friday_schedules AS friday_schedules_7, t0.saturday_schedules AS saturday_schedules_8, t0.sunday_schedules AS sunday_schedules_9 FROM standard_schedule t0 WHERE t0.category = ? LIMIT 1
Parameters:
[
  "gaming"
]
7 0.19 ms
SELECT t0.id AS id_1, t0.specific_date AS specific_date_2, t0.is_open AS is_open_3, t0.schedule AS schedule_4 FROM specific_day 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\Game No errors.
App\Entity\GameImage No errors.
App\Entity\Reservation
  • The field App\Entity\Reservation#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#reservation does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Tag No errors.
App\Entity\User
  • The association App\Entity\User#coupon refers to the inverse side field App\Entity\Coupon#users which does not exist.
App\Entity\Order No errors.
App\Entity\Operation
  • The association App\Entity\Operation#user refers to the inverse side field App\Entity\User#operations which does not exist.
App\Entity\StandardSchedule No errors.
App\Entity\SpecificDay No errors.
App\Entity\TagLang No errors.
App\Entity\Coupon No errors.
App\Entity\Newsletter No errors.
App\Entity\ClosedDay No errors.
App\Entity\Configuration No errors.
App\Entity\Code No errors.
App\Entity\ResetPasswordRequest No errors.
Vich\UploaderBundle\Entity\File No errors.