Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.fixtures_played_home AS fixtures_played_home_2,
  t0.fixtures_played_away AS fixtures_played_away_3,
  t0.fixtures_played_total AS fixtures_played_total_4,
  t0.fixtures_wins_home AS fixtures_wins_home_5,
  t0.fixtures_wins_away AS fixtures_wins_away_6,
  t0.fixtures_wins_total AS fixtures_wins_total_7,
  t0.fixtures_draws_home AS fixtures_draws_home_8,
  t0.fixtures_draws_away AS fixtures_draws_away_9,
  t0.fixtures_draws_total AS fixtures_draws_total_10,
  t0.fixtures_loses_home AS fixtures_loses_home_11,
  t0.fixtures_loses_away AS fixtures_loses_away_12,
  t0.fixtures_loses_total AS fixtures_loses_total_13,
  t0.goals_for_total_home AS goals_for_total_home_14,
  t0.goals_for_total_away AS goals_for_total_away_15,
  t0.goals_for_total_total AS goals_for_total_total_16,
  t0.goals_for_average_home AS goals_for_average_home_17,
  t0.goals_for_average_away AS goals_for_average_away_18,
  t0.goals_for_average_total AS goals_for_average_total_19,
  t0.goals_against_total_home AS goals_against_total_home_20,
  t0.goals_against_total_away AS goals_against_total_away_21,
  t0.goals_against_total_total AS goals_against_total_total_22,
  t0.goals_against_average_home AS goals_against_average_home_23,
  t0.goals_against_average_away AS goals_against_average_away_24,
  t0.goals_against_average_total AS goals_against_average_total_25,
  t0.note_globale AS note_globale_26,
  t0.position AS position_27,
  t0.points AS points_28,
  t0.possession_moyenne AS possession_moyenne_29,
  t0.goals_moyenne_match AS goals_moyenne_match_30,
  t0.the_forme_id AS the_forme_id_31,
  t0.the_note_offensive_id AS the_note_offensive_id_32,
  t0.the_note_defensive_id AS the_note_defensive_id_33
FROM
  clubs_club_stats t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fixtures_played_home AS fixtures_played_home_2, t0.fixtures_played_away AS fixtures_played_away_3, t0.fixtures_played_total AS fixtures_played_total_4, t0.fixtures_wins_home AS fixtures_wins_home_5, t0.fixtures_wins_away AS fixtures_wins_away_6, t0.fixtures_wins_total AS fixtures_wins_total_7, t0.fixtures_draws_home AS fixtures_draws_home_8, t0.fixtures_draws_away AS fixtures_draws_away_9, t0.fixtures_draws_total AS fixtures_draws_total_10, t0.fixtures_loses_home AS fixtures_loses_home_11, t0.fixtures_loses_away AS fixtures_loses_away_12, t0.fixtures_loses_total AS fixtures_loses_total_13, t0.goals_for_total_home AS goals_for_total_home_14, t0.goals_for_total_away AS goals_for_total_away_15, t0.goals_for_total_total AS goals_for_total_total_16, t0.goals_for_average_home AS goals_for_average_home_17, t0.goals_for_average_away AS goals_for_average_away_18, t0.goals_for_average_total AS goals_for_average_total_19, t0.goals_against_total_home AS goals_against_total_home_20, t0.goals_against_total_away AS goals_against_total_away_21, t0.goals_against_total_total AS goals_against_total_total_22, t0.goals_against_average_home AS goals_against_average_home_23, t0.goals_against_average_away AS goals_against_average_away_24, t0.goals_against_average_total AS goals_against_average_total_25, t0.note_globale AS note_globale_26, t0.position AS position_27, t0.points AS points_28, t0.possession_moyenne AS possession_moyenne_29, t0.goals_moyenne_match AS goals_moyenne_match_30, t0.the_forme_id AS the_forme_id_31, t0.the_note_offensive_id AS the_note_offensive_id_32, t0.the_note_defensive_id AS the_note_defensive_id_33 FROM clubs_club_stats t0 WHERE t0.id = 62;

SELECT
  t0.id AS id_1,
  t0.res AS res_2,
  t0.be AS be_3,
  t0.tca AS tca_4,
  t0.tnca AS tnca_5,
  t0.tta AS tta_6,
  t0.tdsa AS tdsa_7,
  t0.thsa AS thsa_8,
  t0.tb AS tb_9,
  t0.ag AS ag_10,
  t0.fc AS fc_11,
  t0.cjr AS cjr_12,
  t0.ca AS ca_13,
  t0.pra AS pra_14,
  t0.tpa AS tpa_15,
  t0.poa AS poa_16,
  t0.note_defensive AS note_defensive_17
FROM
  clubs_club_stats_note_defensive t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.res AS res_2, t0.be AS be_3, t0.tca AS tca_4, t0.tnca AS tnca_5, t0.tta AS tta_6, t0.tdsa AS tdsa_7, t0.thsa AS thsa_8, t0.tb AS tb_9, t0.ag AS ag_10, t0.fc AS fc_11, t0.cjr AS cjr_12, t0.ca AS ca_13, t0.pra AS pra_14, t0.tpa AS tpa_15, t0.poa AS poa_16, t0.note_defensive AS note_defensive_17 FROM clubs_club_stats_note_defensive t0 WHERE t0.id = 62;

SELECT
  t0.id AS id_1,
  t0.res AS res_2,
  t0.bm AS bm_3,
  t0.tc AS tc_4,
  t0.conv AS conv_5,
  t0.ppr AS ppr_6,
  t0.ts AS ts_7,
  t0.po AS po_8,
  t0.note_offensive AS note_offensive_9
FROM
  clubs_club_stats_note_offensive t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.res AS res_2, t0.bm AS bm_3, t0.tc AS tc_4, t0.conv AS conv_5, t0.ppr AS ppr_6, t0.ts AS ts_7, t0.po AS po_8, t0.note_offensive AS note_offensive_9 FROM clubs_club_stats_note_offensive t0 WHERE t0.id = 62;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.flag AS flag_4,
  t0.is_actif AS is_actif_5,
  t0.nationality AS nationality_6
FROM
  pays_pays t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.flag AS flag_4, t0.is_actif AS is_actif_5, t0.nationality AS nationality_6 FROM pays_pays t0 WHERE t0.id = 4;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  clubs_club c0_
  INNER JOIN clubs_club_stats c1_ ON c0_.the_stats_id = c1_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM clubs_club c0_ INNER JOIN clubs_club_stats c1_ ON c0_.the_stats_id = c1_.id;

SELECT
  DISTINCT c0_.id AS id_0,
  c1_.position AS position_1
FROM
  clubs_club c0_
  INNER JOIN clubs_club_stats c1_ ON c0_.the_stats_id = c1_.id
ORDER BY
  c1_.position ASC
LIMIT
  10 OFFSET 20

SELECT DISTINCT c0_.id AS id_0, c1_.position AS position_1 FROM clubs_club c0_ INNER JOIN clubs_club_stats c1_ ON c0_.the_stats_id = c1_.id ORDER BY c1_.position ASC LIMIT 10 OFFSET 20;

SELECT
  f0_.id AS id_0,
  f0_.nb_request_current AS nb_request_current_1,
  f0_.nb_request_remaining AS nb_request_remaining_2,
  f0_.nb_request_limit AS nb_request_limit_3,
  f0_.nb_rate_current AS nb_rate_current_4,
  f0_.nb_rate_remaining AS nb_rate_remaining_5,
  f0_.nb_rate_limit AS nb_rate_limit_6,
  f0_.the_datetime_last_update AS the_datetime_last_update_7
FROM
  football_api_statut f0_
LIMIT
  1

SELECT f0_.id AS id_0, f0_.nb_request_current AS nb_request_current_1, f0_.nb_request_remaining AS nb_request_remaining_2, f0_.nb_request_limit AS nb_request_limit_3, f0_.nb_rate_current AS nb_rate_current_4, f0_.nb_rate_remaining AS nb_rate_remaining_5, f0_.nb_rate_limit AS nb_rate_limit_6, f0_.the_datetime_last_update AS the_datetime_last_update_7 FROM football_api_statut f0_ LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.founded AS founded_3,
  c0_.image AS image_4,
  c0_.is_national AS is_national_5,
  c0_.the_statut_stats_id AS the_statut_stats_id_6,
  c0_.logo AS logo_7,
  c0_.stade_id AS stade_id_8,
  c0_.pays_id AS pays_id_9,
  c0_.the_stats_id AS the_stats_id_10,
  c0_.the_coach_id AS the_coach_id_11
FROM
  clubs_club c0_
  INNER JOIN clubs_club_stats c1_ ON c0_.the_stats_id = c1_.id
WHERE
  c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c1_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.founded AS founded_3, c0_.image AS image_4, c0_.is_national AS is_national_5, c0_.the_statut_stats_id AS the_statut_stats_id_6, c0_.logo AS logo_7, c0_.stade_id AS stade_id_8, c0_.pays_id AS pays_id_9, c0_.the_stats_id AS the_stats_id_10, c0_.the_coach_id AS the_coach_id_11 FROM clubs_club c0_ INNER JOIN clubs_club_stats c1_ ON c0_.the_stats_id = c1_.id WHERE c0_.id IN (62, 100, 21, 74, 11, 23, 8, 72, 98, 57) ORDER BY c1_.position ASC;