Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.id_ffn AS id_ffn_5, t0.last_competition_date_update AS last_competition_date_update_6, t0.country_id AS country_id_7, t0.club_id AS club_id_8, t0.gender_id AS gender_id_9 FROM swimmer t0 WHERE t0.id = ? LIMIT 1

[
  52
]

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.birth_date AS birth_date_4,
  t0.id_ffn AS id_ffn_5,
  t0.last_competition_date_update AS last_competition_date_update_6,
  t0.country_id AS country_id_7,
  t0.club_id AS club_id_8,
  t0.gender_id AS gender_id_9
FROM
  swimmer t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.id_ffn AS id_ffn_5, t0.last_competition_date_update AS last_competition_date_update_6, t0.country_id AS country_id_7, t0.club_id AS club_id_8, t0.gender_id AS gender_id_9 FROM swimmer t0 WHERE t0.id = 52 LIMIT 1;

SELECT r.id, r.heat, r.final_time, r.reaction_time, r.place, r.place_heat, r.lane, r.date_race, ra.id AS id_race, ra.name AS name_race, ra.short_name AS short_name_race, ra.relay AS relay_race, rt.id AS id_result_type, rt.name AS name_result_type, ca.id AS id_category, ca.name AS name_category, c.name AS name_competition, c.short_name, cor.name AS name_country_result, ci.id AS id_city, ci.name AS name_city, co.name AS name_country, ct.id AS id_competition_type, ct.name AS name_competition_type, cd.id AS id_competition_discipline, cd.name AS name_competition_discipline, ps.id AS id_pool_size, CONCAT(ps.size, ps.metric) AS name_pool_size, cl.id AS id_club, cl.name AS name_club, di.name AS name_disqualification, GROUP_CONCAT(CONCAT(rsp.distance,'-',rsp.split_time_modified) ORDER BY rsp.distance SEPARATOR '/') AS splits FROM result r INNER JOIN race_gender rg ON (r.race_gender_id = rg.id) INNER JOIN race ra ON (rg.race_id = ra.id) INNER JOIN stroke st ON (ra.stroke_id = st.id) INNER JOIN result_type rt ON (r.result_type_id = rt.id) INNER JOIN result_swimmer rs ON (rs.result_id = r.id) INNER JOIN competition_swimmer cs ON (rs.competition_swimmer_id = cs.id) INNER JOIN competition c ON (r.competition_id = c.id) INNER JOIN city ci ON (c.city_id = ci.id) INNER JOIN competition_type ct ON (c.competition_type_id = ct.id) INNER JOIN competition_discipline cd ON (c.competition_discipline_id = cd.id) INNER JOIN pool_size ps ON (c.pool_size_id = ps.id) INNER JOIN country cor ON (r.country_id = cor.id) INNER JOIN result_swimmer_split rsp ON (rsp.result_swimmer_id = rs.id) LEFT JOIN country co ON (ci.country_id = co.id) LEFT JOIN category ca ON (r.category_id = ca.id) LEFT JOIN club cl ON (r.club_id = cl.id) LEFT JOIN disqualification di ON (r.disqualification_id = di.id) WHERE cs.swimmer_id = :idSwimmer GROUP BY r.id, r.heat, r.final_time, r.reaction_time, r.place, r.place_heat, r.lane, r.date_race, ra.id, ra.name, ra.short_name, ra.relay, rt.id, rt.name, ca.id, ca.name, c.name, c.short_name, cor.name, ci.id, ci.name, co.name, ct.id, ct.name, cd.id, cd.name, ps.id, ps.size, ps.metric, cl.id, cl.name, di.name ORDER BY ra.relay ASC, st.order_display ASC, ra.distance ASC, rt.order_display ASC, r.date_race DESC;

[
  "idSwimmer" => 52
]

SELECT
  r.id,
  r.heat,
  r.final_time,
  r.reaction_time,
  r.place,
  r.place_heat,
  r.lane,
  r.date_race,
  ra.id AS id_race,
  ra.name AS name_race,
  ra.short_name AS short_name_race,
  ra.relay AS relay_race,
  rt.id AS id_result_type,
  rt.name AS name_result_type,
  ca.id AS id_category,
  ca.name AS name_category,
  c.name AS name_competition,
  c.short_name,
  cor.name AS name_country_result,
  ci.id AS id_city,
  ci.name AS name_city,
  co.name AS name_country,
  ct.id AS id_competition_type,
  ct.name AS name_competition_type,
  cd.id AS id_competition_discipline,
  cd.name AS name_competition_discipline,
  ps.id AS id_pool_size,
  CONCAT(ps.size, ps.metric) AS name_pool_size,
  cl.id AS id_club,
  cl.name AS name_club,
  di.name AS name_disqualification,
  GROUP_CONCAT(
    CONCAT(
      rsp.distance, '-', rsp.split_time_modified
    )
    ORDER BY
      rsp.distance SEPARATOR '/'
  ) AS splits
FROM
  result r
  INNER JOIN race_gender rg ON (r.race_gender_id = rg.id)
  INNER JOIN race ra ON (rg.race_id = ra.id)
  INNER JOIN stroke st ON (ra.stroke_id = st.id)
  INNER JOIN result_type rt ON (r.result_type_id = rt.id)
  INNER JOIN result_swimmer rs ON (rs.result_id = r.id)
  INNER JOIN competition_swimmer cs ON (
    rs.competition_swimmer_id = cs.id
  )
  INNER JOIN competition c ON (r.competition_id = c.id)
  INNER JOIN city ci ON (c.city_id = ci.id)
  INNER JOIN competition_type ct ON (c.competition_type_id = ct.id)
  INNER JOIN competition_discipline cd ON (
    c.competition_discipline_id = cd.id
  )
  INNER JOIN pool_size ps ON (c.pool_size_id = ps.id)
  INNER JOIN country cor ON (r.country_id = cor.id)
  INNER JOIN result_swimmer_split rsp ON (rsp.result_swimmer_id = rs.id)
  LEFT JOIN country co ON (ci.country_id = co.id)
  LEFT JOIN category ca ON (r.category_id = ca.id)
  LEFT JOIN club cl ON (r.club_id = cl.id)
  LEFT JOIN disqualification di ON (r.disqualification_id = di.id)
WHERE
  cs.swimmer_id = :idSwimmer
GROUP BY
  r.id,
  r.heat,
  r.final_time,
  r.reaction_time,
  r.place,
  r.place_heat,
  r.lane,
  r.date_race,
  ra.id,
  ra.name,
  ra.short_name,
  ra.relay,
  rt.id,
  rt.name,
  ca.id,
  ca.name,
  c.name,
  c.short_name,
  cor.name,
  ci.id,
  ci.name,
  co.name,
  ct.id,
  ct.name,
  cd.id,
  cd.name,
  ps.id,
  ps.size,
  ps.metric,
  cl.id,
  cl.name,
  di.name
ORDER BY
  ra.relay ASC,
  st.order_display ASC,
  ra.distance ASC,
  rt.order_display ASC,
  r.date_race DESC;

SELECT r.id, r.heat, r.final_time, r.reaction_time, r.place, r.place_heat, r.lane, r.date_race, ra.id AS id_race, ra.name AS name_race, ra.short_name AS short_name_race, ra.relay AS relay_race, rt.id AS id_result_type, rt.name AS name_result_type, ca.id AS id_category, ca.name AS name_category, c.name AS name_competition, c.short_name, cor.name AS name_country_result, ci.id AS id_city, ci.name AS name_city, co.name AS name_country, ct.id AS id_competition_type, ct.name AS name_competition_type, cd.id AS id_competition_discipline, cd.name AS name_competition_discipline, ps.id AS id_pool_size, CONCAT(ps.size, ps.metric) AS name_pool_size, cl.id AS id_club, cl.name AS name_club, di.name AS name_disqualification, GROUP_CONCAT(CONCAT(rsp.distance,'-',rsp.split_time_modified) ORDER BY rsp.distance SEPARATOR '/') AS splits FROM result r INNER JOIN race_gender rg ON (r.race_gender_id = rg.id) INNER JOIN race ra ON (rg.race_id = ra.id) INNER JOIN stroke st ON (ra.stroke_id = st.id) INNER JOIN result_type rt ON (r.result_type_id = rt.id) INNER JOIN result_swimmer rs ON (rs.result_id = r.id) INNER JOIN competition_swimmer cs ON (rs.competition_swimmer_id = cs.id) INNER JOIN competition c ON (r.competition_id = c.id) INNER JOIN city ci ON (c.city_id = ci.id) INNER JOIN competition_type ct ON (c.competition_type_id = ct.id) INNER JOIN competition_discipline cd ON (c.competition_discipline_id = cd.id) INNER JOIN pool_size ps ON (c.pool_size_id = ps.id) INNER JOIN country cor ON (r.country_id = cor.id) INNER JOIN result_swimmer_split rsp ON (rsp.result_swimmer_id = rs.id) LEFT JOIN country co ON (ci.country_id = co.id) LEFT JOIN category ca ON (r.category_id = ca.id) LEFT JOIN club cl ON (r.club_id = cl.id) LEFT JOIN disqualification di ON (r.disqualification_id = di.id) WHERE cs.swimmer_id = 52 GROUP BY r.id, r.heat, r.final_time, r.reaction_time, r.place, r.place_heat, r.lane, r.date_race, ra.id, ra.name, ra.short_name, ra.relay, rt.id, rt.name, ca.id, ca.name, c.name, c.short_name, cor.name, ci.id, ci.name, co.name, ct.id, ct.name, cd.id, cd.name, ps.id, ps.size, ps.metric, cl.id, cl.name, di.name ORDER BY ra.relay ASC, st.order_display ASC, ra.distance ASC, rt.order_display ASC, r.date_race DESC;;

SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, COUNT(c2_.id) AS sclr_4 FROM competition c2_ INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id GROUP BY c0_.id, c0_.name, c1_.id, c1_.name ORDER BY c1_.id ASC, c0_.id ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c1_.id AS id_2,
  c1_.name AS name_3,
  COUNT(c2_.id) AS sclr_4
FROM
  competition c2_
  INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id
  INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id
GROUP BY
  c0_.id,
  c0_.name,
  c1_.id,
  c1_.name
ORDER BY
  c1_.id ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, COUNT(c2_.id) AS sclr_4 FROM competition c2_ INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id GROUP BY c0_.id, c0_.name, c1_.id, c1_.name ORDER BY c1_.id ASC, c0_.id ASC;