GET https://fanfinity.playerlink.online/event/394

Query Metrics

6 Database Queries
6 Different statements
9.76 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 1.39 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.flags AS flags_7, t0.starts_at AS starts_at_8, t0.registration_fee AS registration_fee_9, t0.max_registration AS max_registration_10, t0.team_size AS team_size_11, t0.registration_open_at AS registration_open_at_12, t0.registration_closed_at AS registration_closed_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.format AS format_16, t0.game AS game_17, t0.tags AS tags_18, t0.prizes AS prizes_19, t0.required_data AS required_data_20, t0.player_note AS player_note_21, t0.public AS public_22, t0.starting_table AS starting_table_23, t0.additional_metadata AS additional_metadata_24, t0.event_timer AS event_timer_25, t0.event_color AS event_color_26, t0.external_registration_url AS external_registration_url_27, t0.featured AS featured_28, t0.image AS image_29, t0.queue_type AS queue_type_30, t0.convention_id AS convention_id_31, t0.category_id AS category_id_32 FROM event t0 WHERE t0.id = ?
Parameters:
[
  "394"
]
2 1.35 ms
SELECT t0.id AS id_1, t0.is_child_relationship AS is_child_relationship_2, t0.flags AS flags_3, t0.parent_user_id AS parent_user_id_4, t0.child_user_id AS child_user_id_5 FROM user_relation t0 WHERE t0.parent_user_id IS NULL
Parameters:
[]
3 1.40 ms
SELECT t0.id AS id_1, t0.prompt AS prompt_2, t0.type AS type_3, t0.required AS required_4, t0.event_id AS event_id_5 FROM event_option t0 WHERE t0.event_id = ?
Parameters:
[
  394
]
4 2.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.location AS location_5, t0.currency AS currency_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.logo AS logo_9, t0.background AS background_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.country AS country_13, t0.timezone AS timezone_14, t0.public AS public_15, t0.game AS game_16, t0.flags AS flags_17, t0.tax_rate_id AS tax_rate_id_18, t0.tax_regime_id AS tax_regime_id_19 FROM convention t0 WHERE t0.id = ?
Parameters:
[
  12
]
5 1.24 ms
SELECT t0.id AS id_1, t0.exhausts_ticket AS exhausts_ticket_2, t0.discount_type AS discount_type_3, t0.discount_value AS discount_value_4, t0.required_to_view AS required_to_view_5, t0.required_to_register AS required_to_register_6, t0.ticket_id AS ticket_id_7, t0.event_id AS event_id_8 FROM ticket_consumer t0 WHERE t0.event_id = ?
Parameters:
[
  394
]
6 1.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.csv AS csv_4, t0.event_id AS event_id_5 FROM cms_element t0 WHERE t0.event_id = ?
Parameters:
[
  394
]

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
App\Entity\Event 1
App\Entity\Convention 1
App\Entity\EventCategory 1
App\Entity\TaxRate 1