GET https://vstupenky.lednacci.cz/order/seats/5

Query Metrics

11 Database Queries
10 Different statements
21.95 ms Query time
4 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 1.83 ms
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.theme AS theme_3, t0.title AS title_4, t0.logo_path AS logo_path_5, t0.company_id AS company_id_6 FROM portal_configurations t0 WHERE t0.domain = ? LIMIT 1
Parameters:
[
  "vstupenky.lednacci.cz"
]
2 1.07 ms
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.name AS name_3, t0.starts_at AS starts_at_4, t0.is_enabled_for_sale AS is_enabled_for_sale_5, t0.event_group_id AS event_group_id_6, t0.venue_layout_id AS venue_layout_id_7, t0.home_team_id AS home_team_id_8, t0.away_team_id AS away_team_id_9 FROM "events" t0 WHERE t0.id = ?
Parameters:
[
  5
]
3 9.76 ms
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.name AS name_3, t0.editor_json AS editor_json_4 FROM "venue_layouts" t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
4 1.48 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.label AS label_5, t0.type AS type_6, t0.capacity AS capacity_7, t0.business_id AS business_id_8, t0.venue_layout_id AS venue_layout_id_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM "venue_elements" t0 WHERE t0.venue_layout_id = ?
Parameters:
[
  2
]
5 1.58 ms
SELECT v0_.id AS id_0, v0_.business_id AS business_id_1, v0_.status AS status_2, v0_.event_id AS event_id_3, v0_.reserved_until AS reserved_until_4, v0_.order_id AS order_id_5, v0_.reservation_token AS reservation_token_6, v0_.created_at AS created_at_7, v0_.ticket_id AS ticket_id_8 FROM venue_element_reservations v0_ WHERE v0_.event_id = ? AND v0_.reserved_until > ?
Parameters:
[
  Simpleticket\Ticket\Domain\ValueObject\EventId {#869
    __toString(): "5"
  }
  "2026-03-31 19:46:58"
]
6 2.06 ms
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.title AS title_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5 FROM tags t0 INNER JOIN event_tags ON t0.id = event_tags.tag_id WHERE event_tags.event_id = ?
Parameters:
[
  5
]
7 1.41 ms
SELECT DISTINCT spsr.business_id
                 FROM season_pass_seat_reservations spsr
                 INNER JOIN season_pass_tags spt ON spt.season_pass_id = spsr.season_pass_id
                 WHERE spt.tag_id IN (?)
                   AND (spsr.status = 2 OR (spsr.status < 2 AND spsr.reserved_until > ?))
Parameters:
[
  3
  "2026-03-31 19:46:58+00:00"
]
8 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.json AS json_3, t0.venue_layout_id AS venue_layout_id_4 FROM "venue_layout_variants" t0 INNER JOIN event_venue_layout_variants ON t0.id = event_venue_layout_variants.venue_layout_variant_id WHERE event_venue_layout_variants.event_id = ?
Parameters:
[
  5
]
9 1.10 ms
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.title AS title_3, t0.type AS type_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.tree_root AS tree_root_8, t0.parent_id AS parent_id_9 FROM event_groups t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 0.51 ms
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.name AS name_3, t0.is_home AS is_home_4, t0.image_path AS image_path_5 FROM "teams" t0 WHERE t0.id = ?
Parameters:
[
  9
]
11 0.34 ms
SELECT t0.id AS id_1, t0.company_id AS company_id_2, t0.name AS name_3, t0.is_home AS is_home_4, t0.image_path AS image_path_5 FROM "teams" t0 WHERE t0.id = ?
Parameters:
[
  7
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Simpleticket\Ticket\Domain\Entity\EventGroup 2
Simpleticket\Ticket\Domain\Entity\Team 2
Simpleticket\Ticket\Domain\Entity\VenueElementReservation 2
Simpleticket\Identity\Company\Domain\Entity\PortalConfiguration 1
Simpleticket\Identity\Company\Domain\Entity\Company 1
Simpleticket\Ticket\Domain\Entity\Event 1
Simpleticket\Ticket\Domain\Entity\VenueLayout 1
Simpleticket\Ticket\Domain\Entity\Tag 1

Entities Mapping

Class Mapping errors
Simpleticket\Identity\Company\Domain\Entity\PortalConfiguration No errors.
Simpleticket\Identity\Company\Domain\Entity\Company
  • The association Simpleticket\Identity\Company\Domain\Entity\Company#userCompanies refers to the owning side field Simpleticket\Identity\Company\Domain\Entity\UserCompany#company which does not exist.
Simpleticket\Ticket\Domain\Entity\Event No errors.
Simpleticket\Ticket\Domain\Entity\EventGroup No errors.
Simpleticket\Ticket\Domain\Entity\VenueLayout
  • The mappings Simpleticket\Ticket\Domain\Entity\VenueLayout#venueElements and Simpleticket\Ticket\Domain\Entity\VenueElement#venueLayout are inconsistent with each other.
Simpleticket\Ticket\Domain\Entity\Team No errors.
Simpleticket\Ticket\Domain\Entity\VenueLayoutVariant No errors.
Simpleticket\Ticket\Domain\Entity\TicketType
  • The field Simpleticket\Ticket\Domain\Entity\TicketType#imports is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Simpleticket\Ticket\Domain\Import\Import#ticketType does not contain the required 'inversedBy: "imports"' attribute.
Simpleticket\Ticket\Domain\Entity\TicketVariant No errors.
Simpleticket\Ticket\Domain\Entity\PriceWave No errors.
Simpleticket\Ticket\Domain\Entity\Tag No errors.
Simpleticket\Ticket\Domain\Entity\VenueElement
  • The association Simpleticket\Ticket\Domain\Entity\VenueElement#venueLayout refers to the inverse side field Simpleticket\Ticket\Domain\Entity\VenueLayout#elements which does not exist.
Simpleticket\Ticket\Domain\Entity\VenueLayoutTicketType No errors.
Simpleticket\Ticket\Domain\Entity\VenueElementReservation No errors.
Simpleticket\Ticket\Domain\Entity\Ticket No errors.