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, t1_.id AS id_17, t1_.code AS code_18, t1_.enabled AS enabled_19, t1_.name AS name_20, t1_.slug AS slug_21, t1_.visible AS visible_22, t1_.description AS description_23, t1_.value AS value_24, t1_.allow_direct_redemption AS allow_direct_redemption_25, p2_.id AS id_26, p2_.name AS name_27, p2_.slug AS slug_28, p2_.game AS game_29, p2_.background AS background_30, p2_.logo AS logo_31, p2_.enabled AS enabled_32, p2_.public AS public_33, e3_.id AS id_34, e3_.type AS type_35, e3_.name AS name_36, e3_.slug AS slug_37, e3_.description AS description_38, e3_.enabled AS enabled_39, e3_.flags AS flags_40, e3_.starts_at AS starts_at_41, e3_.registration_fee AS registration_fee_42, e3_.max_registration AS max_registration_43, e3_.team_size AS team_size_44, e3_.registration_open_at AS registration_open_at_45, e3_.registration_closed_at AS registration_closed_at_46, e3_.created_at AS created_at_47, e3_.updated_at AS updated_at_48, e3_.format AS format_49, e3_.game AS game_50, e3_.tags AS tags_51, e3_.prizes AS prizes_52, e3_.required_data AS required_data_53, e3_.player_note AS player_note_54, e3_.public AS public_55, e3_.starting_table AS starting_table_56, e3_.additional_metadata AS additional_metadata_57, e3_.event_timer AS event_timer_58, e3_.event_color AS event_color_59, e3_.external_registration_url AS external_registration_url_60, e3_.featured AS featured_61, e3_.image AS image_62, e3_.queue_type AS queue_type_63, c0_.tax_rate_id AS tax_rate_id_64, c0_.tax_regime_id AS tax_regime_id_65, t1_.convention_id AS convention_id_66, t1_.prize_wall_id AS prize_wall_id_67, p2_.convention_id AS convention_id_68, e3_.convention_id AS convention_id_69, e3_.category_id AS category_id_70 FROM convention c0_ LEFT JOIN ticket t1_ ON c0_.id = t1_.convention_id LEFT JOIN prize_wall p2_ ON c0_.id = p2_.convention_id LEFT JOIN event e3_ ON c0_.id = e3_.convention_id WHERE c0_.enabled = 1 ORDER BY c0_.start_date ASC, e3_.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,
  t1_.id AS id_17,
  t1_.code AS code_18,
  t1_.enabled AS enabled_19,
  t1_.name AS name_20,
  t1_.slug AS slug_21,
  t1_.visible AS visible_22,
  t1_.description AS description_23,
  t1_.value AS value_24,
  t1_.allow_direct_redemption AS allow_direct_redemption_25,
  p2_.id AS id_26,
  p2_.name AS name_27,
  p2_.slug AS slug_28,
  p2_.game AS game_29,
  p2_.background AS background_30,
  p2_.logo AS logo_31,
  p2_.enabled AS enabled_32,
  p2_.public AS public_33,
  e3_.id AS id_34,
  e3_.type AS type_35,
  e3_.name AS name_36,
  e3_.slug AS slug_37,
  e3_.description AS description_38,
  e3_.enabled AS enabled_39,
  e3_.flags AS flags_40,
  e3_.starts_at AS starts_at_41,
  e3_.registration_fee AS registration_fee_42,
  e3_.max_registration AS max_registration_43,
  e3_.team_size AS team_size_44,
  e3_.registration_open_at AS registration_open_at_45,
  e3_.registration_closed_at AS registration_closed_at_46,
  e3_.created_at AS created_at_47,
  e3_.updated_at AS updated_at_48,
  e3_.format AS format_49,
  e3_.game AS game_50,
  e3_.tags AS tags_51,
  e3_.prizes AS prizes_52,
  e3_.required_data AS required_data_53,
  e3_.player_note AS player_note_54,
  e3_.public AS public_55,
  e3_.starting_table AS starting_table_56,
  e3_.additional_metadata AS additional_metadata_57,
  e3_.event_timer AS event_timer_58,
  e3_.event_color AS event_color_59,
  e3_.external_registration_url AS external_registration_url_60,
  e3_.featured AS featured_61,
  e3_.image AS image_62,
  e3_.queue_type AS queue_type_63,
  c0_.tax_rate_id AS tax_rate_id_64,
  c0_.tax_regime_id AS tax_regime_id_65,
  t1_.convention_id AS convention_id_66,
  t1_.prize_wall_id AS prize_wall_id_67,
  p2_.convention_id AS convention_id_68,
  e3_.convention_id AS convention_id_69,
  e3_.category_id AS category_id_70
FROM
  convention c0_
  LEFT JOIN ticket t1_ ON c0_.id = t1_.convention_id
  LEFT JOIN prize_wall p2_ ON c0_.id = p2_.convention_id
  LEFT JOIN event e3_ ON c0_.id = e3_.convention_id
WHERE
  c0_.enabled = 1
ORDER BY
  c0_.start_date ASC,
  e3_.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, t1_.id AS id_17, t1_.code AS code_18, t1_.enabled AS enabled_19, t1_.name AS name_20, t1_.slug AS slug_21, t1_.visible AS visible_22, t1_.description AS description_23, t1_.value AS value_24, t1_.allow_direct_redemption AS allow_direct_redemption_25, p2_.id AS id_26, p2_.name AS name_27, p2_.slug AS slug_28, p2_.game AS game_29, p2_.background AS background_30, p2_.logo AS logo_31, p2_.enabled AS enabled_32, p2_.public AS public_33, e3_.id AS id_34, e3_.type AS type_35, e3_.name AS name_36, e3_.slug AS slug_37, e3_.description AS description_38, e3_.enabled AS enabled_39, e3_.flags AS flags_40, e3_.starts_at AS starts_at_41, e3_.registration_fee AS registration_fee_42, e3_.max_registration AS max_registration_43, e3_.team_size AS team_size_44, e3_.registration_open_at AS registration_open_at_45, e3_.registration_closed_at AS registration_closed_at_46, e3_.created_at AS created_at_47, e3_.updated_at AS updated_at_48, e3_.format AS format_49, e3_.game AS game_50, e3_.tags AS tags_51, e3_.prizes AS prizes_52, e3_.required_data AS required_data_53, e3_.player_note AS player_note_54, e3_.public AS public_55, e3_.starting_table AS starting_table_56, e3_.additional_metadata AS additional_metadata_57, e3_.event_timer AS event_timer_58, e3_.event_color AS event_color_59, e3_.external_registration_url AS external_registration_url_60, e3_.featured AS featured_61, e3_.image AS image_62, e3_.queue_type AS queue_type_63, c0_.tax_rate_id AS tax_rate_id_64, c0_.tax_regime_id AS tax_regime_id_65, t1_.convention_id AS convention_id_66, t1_.prize_wall_id AS prize_wall_id_67, p2_.convention_id AS convention_id_68, e3_.convention_id AS convention_id_69, e3_.category_id AS category_id_70 FROM convention c0_ LEFT JOIN ticket t1_ ON c0_.id = t1_.convention_id LEFT JOIN prize_wall p2_ ON c0_.id = p2_.convention_id LEFT JOIN event e3_ ON c0_.id = e3_.convention_id WHERE c0_.enabled = 1 ORDER BY c0_.start_date ASC, e3_.starts_at ASC;