Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.icon AS icon_5,
  t0.code AS code_6,
  t0.league AS league_7,
  t0.season AS season_8,
  t0.sport_id AS sport_id_9
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.id = ?

[
  23
]

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.external_id AS external_id_5,
  t0.competition_id AS competition_id_6
FROM
  round t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.id = 23;

SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.bet_opened AS bet_opened_3, g0_.status AS status_4, g0_.date AS date_5, g0_.weight AS weight_6, g0_.home_scores AS home_scores_7, g0_.away_scores AS away_scores_8, g0_.api_id AS api_id_9, g0_.home_odds AS home_odds_10, g0_.away_odds AS away_odds_11, g0_.draw_odds AS draw_odds_12, g0_.status_detail AS status_detail_13, g0_.clock AS clock_14, g0_.allow_draw AS allow_draw_15, g0_.winner AS winner_16, g0_.updated_at AS updated_at_17, g0_.details AS details_18, c1_.id AS id_19, c1_.name AS name_20, c1_.description AS description_21, c1_.code AS code_22, c1_.icon AS icon_23, c1_.api_id AS api_id_24, c1_.current_form AS current_form_25, c2_.id AS id_26, c2_.name AS name_27, c2_.description AS description_28, c2_.code AS code_29, c2_.icon AS icon_30, c2_.api_id AS api_id_31, c2_.current_form AS current_form_32, b3_.id AS id_33, b3_.prediction AS prediction_34, b3_.score AS score_35, b3_.evaluated AS evaluated_36, b3_.boosted AS boosted_37, b3_.created_at AS created_at_38, b3_.updated_at AS updated_at_39, g0_.competition_id AS competition_id_40, g0_.round_id AS round_id_41, g0_.home_competitor_id AS home_competitor_id_42, g0_.away_competitor_id AS away_competitor_id_43, c1_.participant_id AS participant_id_44, c1_.competition_id AS competition_id_45, c2_.participant_id AS participant_id_46, c2_.competition_id AS competition_id_47, b3_.user_id AS user_id_48, b3_.game_id AS game_id_49 FROM game g0_ INNER JOIN competitor c1_ ON g0_.away_competitor_id = c1_.id INNER JOIN competitor c2_ ON g0_.home_competitor_id = c2_.id LEFT JOIN bet b3_ ON g0_.id = b3_.game_id AND (b3_.user_id = ?) WHERE g0_.round_id = ? ORDER BY g0_.date ASC

[
  0
  23
]

SELECT
  g0_.id AS id_0,
  g0_.home_score AS home_score_1,
  g0_.away_score AS away_score_2,
  g0_.bet_opened AS bet_opened_3,
  g0_.status AS status_4,
  g0_.date AS date_5,
  g0_.weight AS weight_6,
  g0_.home_scores AS home_scores_7,
  g0_.away_scores AS away_scores_8,
  g0_.api_id AS api_id_9,
  g0_.home_odds AS home_odds_10,
  g0_.away_odds AS away_odds_11,
  g0_.draw_odds AS draw_odds_12,
  g0_.status_detail AS status_detail_13,
  g0_.clock AS clock_14,
  g0_.allow_draw AS allow_draw_15,
  g0_.winner AS winner_16,
  g0_.updated_at AS updated_at_17,
  g0_.details AS details_18,
  c1_.id AS id_19,
  c1_.name AS name_20,
  c1_.description AS description_21,
  c1_.code AS code_22,
  c1_.icon AS icon_23,
  c1_.api_id AS api_id_24,
  c1_.current_form AS current_form_25,
  c2_.id AS id_26,
  c2_.name AS name_27,
  c2_.description AS description_28,
  c2_.code AS code_29,
  c2_.icon AS icon_30,
  c2_.api_id AS api_id_31,
  c2_.current_form AS current_form_32,
  b3_.id AS id_33,
  b3_.prediction AS prediction_34,
  b3_.score AS score_35,
  b3_.evaluated AS evaluated_36,
  b3_.boosted AS boosted_37,
  b3_.created_at AS created_at_38,
  b3_.updated_at AS updated_at_39,
  g0_.competition_id AS competition_id_40,
  g0_.round_id AS round_id_41,
  g0_.home_competitor_id AS home_competitor_id_42,
  g0_.away_competitor_id AS away_competitor_id_43,
  c1_.participant_id AS participant_id_44,
  c1_.competition_id AS competition_id_45,
  c2_.participant_id AS participant_id_46,
  c2_.competition_id AS competition_id_47,
  b3_.user_id AS user_id_48,
  b3_.game_id AS game_id_49
FROM
  game g0_
  INNER JOIN competitor c1_ ON g0_.away_competitor_id = c1_.id
  INNER JOIN competitor c2_ ON g0_.home_competitor_id = c2_.id
  LEFT JOIN bet b3_ ON g0_.id = b3_.game_id
  AND (b3_.user_id = ?)
WHERE
  g0_.round_id = ?
ORDER BY
  g0_.date ASC

SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.bet_opened AS bet_opened_3, g0_.status AS status_4, g0_.date AS date_5, g0_.weight AS weight_6, g0_.home_scores AS home_scores_7, g0_.away_scores AS away_scores_8, g0_.api_id AS api_id_9, g0_.home_odds AS home_odds_10, g0_.away_odds AS away_odds_11, g0_.draw_odds AS draw_odds_12, g0_.status_detail AS status_detail_13, g0_.clock AS clock_14, g0_.allow_draw AS allow_draw_15, g0_.winner AS winner_16, g0_.updated_at AS updated_at_17, g0_.details AS details_18, c1_.id AS id_19, c1_.name AS name_20, c1_.description AS description_21, c1_.code AS code_22, c1_.icon AS icon_23, c1_.api_id AS api_id_24, c1_.current_form AS current_form_25, c2_.id AS id_26, c2_.name AS name_27, c2_.description AS description_28, c2_.code AS code_29, c2_.icon AS icon_30, c2_.api_id AS api_id_31, c2_.current_form AS current_form_32, b3_.id AS id_33, b3_.prediction AS prediction_34, b3_.score AS score_35, b3_.evaluated AS evaluated_36, b3_.boosted AS boosted_37, b3_.created_at AS created_at_38, b3_.updated_at AS updated_at_39, g0_.competition_id AS competition_id_40, g0_.round_id AS round_id_41, g0_.home_competitor_id AS home_competitor_id_42, g0_.away_competitor_id AS away_competitor_id_43, c1_.participant_id AS participant_id_44, c1_.competition_id AS competition_id_45, c2_.participant_id AS participant_id_46, c2_.competition_id AS competition_id_47, b3_.user_id AS user_id_48, b3_.game_id AS game_id_49 FROM game g0_ INNER JOIN competitor c1_ ON g0_.away_competitor_id = c1_.id INNER JOIN competitor c2_ ON g0_.home_competitor_id = c2_.id LEFT JOIN bet b3_ ON g0_.id = b3_.game_id AND (b3_.user_id = 0) WHERE g0_.round_id = 23 ORDER BY g0_.date ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.icon AS icon_4
FROM
  sport t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.competition_id = ? ORDER BY t0.sequence ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.external_id AS external_id_5,
  t0.competition_id AS competition_id_6
FROM
  round t0
WHERE
  t0.competition_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.competition_id = 1 ORDER BY t0.sequence ASC;