Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 12
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.enabled AS enabled_3, c0_.location AS location_4, c0_.currency AS currency_5, c0_.start_date AS start_date_6, c0_.end_date AS end_date_7, c0_.logo AS logo_8, c0_.background AS background_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.country AS country_12, c0_.timezone AS timezone_13, c0_.public AS public_14, c0_.game AS game_15, c0_.flags AS flags_16, e1_.id AS id_17, e1_.type AS type_18, e1_.name AS name_19, e1_.slug AS slug_20, e1_.description AS description_21, e1_.enabled AS enabled_22, e1_.flags AS flags_23, e1_.starts_at AS starts_at_24, e1_.registration_fee AS registration_fee_25, e1_.max_registration AS max_registration_26, e1_.team_size AS team_size_27, e1_.registration_open_at AS registration_open_at_28, e1_.registration_closed_at AS registration_closed_at_29, e1_.created_at AS created_at_30, e1_.updated_at AS updated_at_31, e1_.format AS format_32, e1_.game AS game_33, e1_.tags AS tags_34, e1_.prizes AS prizes_35, e1_.required_data AS required_data_36, e1_.player_note AS player_note_37, e1_.public AS public_38, e1_.starting_table AS starting_table_39, e1_.additional_metadata AS additional_metadata_40, e1_.event_timer AS event_timer_41, e1_.event_color AS event_color_42, e1_.external_registration_url AS external_registration_url_43, e1_.featured AS featured_44, e1_.image AS image_45, e1_.queue_type AS queue_type_46, e2_.id AS id_47, e2_.quantity AS quantity_48, t3_.id AS id_49, t3_.exhausts_ticket AS exhausts_ticket_50, t3_.discount_type AS discount_type_51, t3_.discount_value AS discount_value_52, t3_.required_to_view AS required_to_view_53, t3_.required_to_register AS required_to_register_54, e4_.id AS id_55, e4_.label AS label_56, c0_.tax_rate_id AS tax_rate_id_57, c0_.tax_regime_id AS tax_regime_id_58, e1_.convention_id AS convention_id_59, e1_.category_id AS category_id_60, e2_.event_id AS event_id_61, e2_.ticket_id AS ticket_id_62, t3_.ticket_id AS ticket_id_63, t3_.event_id AS event_id_64, e4_.convention_id AS convention_id_65 FROM convention c0_ LEFT JOIN event e1_ ON c0_.id = e1_.convention_id LEFT JOIN event_ticket e2_ ON e1_.id = e2_.event_id LEFT JOIN ticket_consumer t3_ ON e1_.id = t3_.event_id LEFT JOIN event_category e4_ ON e1_.category_id = e4_.id WHERE c0_.id = ? ORDER BY e1_.starts_at ASC

[
  12
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.enabled AS enabled_3,
  c0_.location AS location_4,
  c0_.currency AS currency_5,
  c0_.start_date AS start_date_6,
  c0_.end_date AS end_date_7,
  c0_.logo AS logo_8,
  c0_.background AS background_9,
  c0_.created_at AS created_at_10,
  c0_.updated_at AS updated_at_11,
  c0_.country AS country_12,
  c0_.timezone AS timezone_13,
  c0_.public AS public_14,
  c0_.game AS game_15,
  c0_.flags AS flags_16,
  e1_.id AS id_17,
  e1_.type AS type_18,
  e1_.name AS name_19,
  e1_.slug AS slug_20,
  e1_.description AS description_21,
  e1_.enabled AS enabled_22,
  e1_.flags AS flags_23,
  e1_.starts_at AS starts_at_24,
  e1_.registration_fee AS registration_fee_25,
  e1_.max_registration AS max_registration_26,
  e1_.team_size AS team_size_27,
  e1_.registration_open_at AS registration_open_at_28,
  e1_.registration_closed_at AS registration_closed_at_29,
  e1_.created_at AS created_at_30,
  e1_.updated_at AS updated_at_31,
  e1_.format AS format_32,
  e1_.game AS game_33,
  e1_.tags AS tags_34,
  e1_.prizes AS prizes_35,
  e1_.required_data AS required_data_36,
  e1_.player_note AS player_note_37,
  e1_.public AS public_38,
  e1_.starting_table AS starting_table_39,
  e1_.additional_metadata AS additional_metadata_40,
  e1_.event_timer AS event_timer_41,
  e1_.event_color AS event_color_42,
  e1_.external_registration_url AS external_registration_url_43,
  e1_.featured AS featured_44,
  e1_.image AS image_45,
  e1_.queue_type AS queue_type_46,
  e2_.id AS id_47,
  e2_.quantity AS quantity_48,
  t3_.id AS id_49,
  t3_.exhausts_ticket AS exhausts_ticket_50,
  t3_.discount_type AS discount_type_51,
  t3_.discount_value AS discount_value_52,
  t3_.required_to_view AS required_to_view_53,
  t3_.required_to_register AS required_to_register_54,
  e4_.id AS id_55,
  e4_.label AS label_56,
  c0_.tax_rate_id AS tax_rate_id_57,
  c0_.tax_regime_id AS tax_regime_id_58,
  e1_.convention_id AS convention_id_59,
  e1_.category_id AS category_id_60,
  e2_.event_id AS event_id_61,
  e2_.ticket_id AS ticket_id_62,
  t3_.ticket_id AS ticket_id_63,
  t3_.event_id AS event_id_64,
  e4_.convention_id AS convention_id_65
FROM
  convention c0_
  LEFT JOIN event e1_ ON c0_.id = e1_.convention_id
  LEFT JOIN event_ticket e2_ ON e1_.id = e2_.event_id
  LEFT JOIN ticket_consumer t3_ ON e1_.id = t3_.event_id
  LEFT JOIN event_category e4_ ON e1_.category_id = e4_.id
WHERE
  c0_.id = ?
ORDER BY
  e1_.starts_at ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.enabled AS enabled_3, c0_.location AS location_4, c0_.currency AS currency_5, c0_.start_date AS start_date_6, c0_.end_date AS end_date_7, c0_.logo AS logo_8, c0_.background AS background_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.country AS country_12, c0_.timezone AS timezone_13, c0_.public AS public_14, c0_.game AS game_15, c0_.flags AS flags_16, e1_.id AS id_17, e1_.type AS type_18, e1_.name AS name_19, e1_.slug AS slug_20, e1_.description AS description_21, e1_.enabled AS enabled_22, e1_.flags AS flags_23, e1_.starts_at AS starts_at_24, e1_.registration_fee AS registration_fee_25, e1_.max_registration AS max_registration_26, e1_.team_size AS team_size_27, e1_.registration_open_at AS registration_open_at_28, e1_.registration_closed_at AS registration_closed_at_29, e1_.created_at AS created_at_30, e1_.updated_at AS updated_at_31, e1_.format AS format_32, e1_.game AS game_33, e1_.tags AS tags_34, e1_.prizes AS prizes_35, e1_.required_data AS required_data_36, e1_.player_note AS player_note_37, e1_.public AS public_38, e1_.starting_table AS starting_table_39, e1_.additional_metadata AS additional_metadata_40, e1_.event_timer AS event_timer_41, e1_.event_color AS event_color_42, e1_.external_registration_url AS external_registration_url_43, e1_.featured AS featured_44, e1_.image AS image_45, e1_.queue_type AS queue_type_46, e2_.id AS id_47, e2_.quantity AS quantity_48, t3_.id AS id_49, t3_.exhausts_ticket AS exhausts_ticket_50, t3_.discount_type AS discount_type_51, t3_.discount_value AS discount_value_52, t3_.required_to_view AS required_to_view_53, t3_.required_to_register AS required_to_register_54, e4_.id AS id_55, e4_.label AS label_56, c0_.tax_rate_id AS tax_rate_id_57, c0_.tax_regime_id AS tax_regime_id_58, e1_.convention_id AS convention_id_59, e1_.category_id AS category_id_60, e2_.event_id AS event_id_61, e2_.ticket_id AS ticket_id_62, t3_.ticket_id AS ticket_id_63, t3_.event_id AS event_id_64, e4_.convention_id AS convention_id_65 FROM convention c0_ LEFT JOIN event e1_ ON c0_.id = e1_.convention_id LEFT JOIN event_ticket e2_ ON e1_.id = e2_.event_id LEFT JOIN ticket_consumer t3_ ON e1_.id = t3_.event_id LEFT JOIN event_category e4_ ON e1_.category_id = e4_.id WHERE c0_.id = 12 ORDER BY e1_.starts_at ASC;