Symfony Profiler

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.date AS date_1
FROM
  matchs_match m0_
  LEFT JOIN matchs_match_equipe m1_ ON m0_.id = m1_.the_match_id
  INNER JOIN ligues_ligue_saison l2_ ON m0_.the_ligue_saison_id = l2_.id
WHERE
  m0_.the_statut_id = ?
ORDER BY
  m0_.date DESC
LIMIT
  30 OFFSET 4170

SELECT DISTINCT m0_.id AS id_0, m0_.date AS date_1 FROM matchs_match m0_ LEFT JOIN matchs_match_equipe m1_ ON m0_.id = m1_.the_match_id INNER JOIN ligues_ligue_saison l2_ ON m0_.the_ligue_saison_id = l2_.id WHERE m0_.the_statut_id = 2 ORDER BY m0_.date DESC LIMIT 30 OFFSET 4170;

SELECT
  t0.id AS id_1,
  t0.temps AS temps_2,
  t0.remplacement_numero AS remplacement_numero_3,
  t0.the_type_id AS the_type_id_4,
  t0.commentaire AS commentaire_5,
  t0.the_match_id AS the_match_id_6,
  t0.the_joueur_id AS the_joueur_id_7,
  t0.the_joueur_assist_id AS the_joueur_assist_id_8,
  t0.the_match_equipe_id AS the_match_equipe_id_9,
  t0.the_match_joueur_id AS the_match_joueur_id_10
FROM
  matchs_event t0
WHERE
  t0.the_match_equipe_id = ?
ORDER BY
  t0.temps DESC

SELECT t0.id AS id_1, t0.temps AS temps_2, t0.remplacement_numero AS remplacement_numero_3, t0.the_type_id AS the_type_id_4, t0.commentaire AS commentaire_5, t0.the_match_id AS the_match_id_6, t0.the_joueur_id AS the_joueur_id_7, t0.the_joueur_assist_id AS the_joueur_assist_id_8, t0.the_match_equipe_id AS the_match_equipe_id_9, t0.the_match_joueur_id AS the_match_joueur_id_10 FROM matchs_event t0 WHERE t0.the_match_equipe_id = 5953 ORDER BY t0.temps DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.founded AS founded_4,
  t0.image AS image_5,
  t0.is_national AS is_national_6,
  t0.the_statut_stats_id AS the_statut_stats_id_7,
  t0.logo AS logo_8,
  t0.stade_id AS stade_id_9,
  t0.pays_id AS pays_id_10,
  t0.the_stats_id AS the_stats_id_11,
  t0.the_coach_id AS the_coach_id_12
FROM
  clubs_club t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.founded AS founded_4, t0.image AS image_5, t0.is_national AS is_national_6, t0.the_statut_stats_id AS the_statut_stats_id_7, t0.logo AS logo_8, t0.stade_id AS stade_id_9, t0.pays_id AS pays_id_10, t0.the_stats_id AS the_stats_id_11, t0.the_coach_id AS the_coach_id_12 FROM clubs_club t0 WHERE t0.id = 92;

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  matchs_match m0_
  LEFT JOIN matchs_match_equipe m1_ ON m0_.id = m1_.the_match_id
  INNER JOIN ligues_ligue_saison l2_ ON m0_.the_ligue_saison_id = l2_.id
WHERE
  m0_.the_statut_id = ?

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM matchs_match m0_ LEFT JOIN matchs_match_equipe m1_ ON m0_.id = m1_.the_match_id INNER JOIN ligues_ligue_saison l2_ ON m0_.the_ligue_saison_id = l2_.id WHERE m0_.the_statut_id = 2;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.date AS date_2,
  m0_.the_statut_id AS the_statut_id_3,
  m0_.the_statut_stats_id AS the_statut_stats_id_4,
  m0_.the_resultat_id AS the_resultat_id_5,
  m0_.the_datetime_api_update AS the_datetime_api_update_6,
  m0_.arbitre_nom AS arbitre_nom_7,
  m0_.the_date AS the_date_8,
  m0_.the_statut_line_up_id AS the_statut_line_up_id_9,
  m0_.the_statut_event_id AS the_statut_event_id_10,
  m1_.id AS id_11,
  m1_.goals AS goals_12,
  m1_.formation AS formation_13,
  m1_.resultat AS resultat_14,
  m1_.color_player_primary AS color_player_primary_15,
  m1_.color_player_number AS color_player_number_16,
  m1_.color_player_border AS color_player_border_17,
  m1_.color_goalkeeper_primary AS color_goalkeeper_primary_18,
  m1_.color_goalkeeper_number AS color_goalkeeper_number_19,
  m1_.color_goalkeeper_border AS color_goalkeeper_border_20,
  m1_.the_statut_id AS the_statut_id_21,
  m1_.the_statut_stats_id AS the_statut_stats_id_22,
  m1_.the_type_id AS the_type_id_23,
  m0_.stade_id AS stade_id_24,
  m0_.the_ligue_saison_id AS the_ligue_saison_id_25,
  m0_.the_statut_api_id AS the_statut_api_id_26,
  m0_.the_club_domicile_id AS the_club_domicile_id_27,
  m0_.the_club_exterieur_id AS the_club_exterieur_id_28,
  m0_.the_round_id AS the_round_id_29,
  m0_.the_cote_id AS the_cote_id_30,
  m1_.the_stats_id AS the_stats_id_31,
  m1_.the_coach_id AS the_coach_id_32,
  m1_.the_match_id AS the_match_id_33,
  m1_.the_club_id AS the_club_id_34,
  m1_.the_equipe_id AS the_equipe_id_35
FROM
  matchs_match m0_
  LEFT JOIN matchs_match_equipe m1_ ON m0_.id = m1_.the_match_id
  INNER JOIN ligues_ligue_saison l2_ ON m0_.the_ligue_saison_id = l2_.id
WHERE
  m0_.the_statut_id = ?
  AND m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  m0_.date DESC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.date AS date_2, m0_.the_statut_id AS the_statut_id_3, m0_.the_statut_stats_id AS the_statut_stats_id_4, m0_.the_resultat_id AS the_resultat_id_5, m0_.the_datetime_api_update AS the_datetime_api_update_6, m0_.arbitre_nom AS arbitre_nom_7, m0_.the_date AS the_date_8, m0_.the_statut_line_up_id AS the_statut_line_up_id_9, m0_.the_statut_event_id AS the_statut_event_id_10, m1_.id AS id_11, m1_.goals AS goals_12, m1_.formation AS formation_13, m1_.resultat AS resultat_14, m1_.color_player_primary AS color_player_primary_15, m1_.color_player_number AS color_player_number_16, m1_.color_player_border AS color_player_border_17, m1_.color_goalkeeper_primary AS color_goalkeeper_primary_18, m1_.color_goalkeeper_number AS color_goalkeeper_number_19, m1_.color_goalkeeper_border AS color_goalkeeper_border_20, m1_.the_statut_id AS the_statut_id_21, m1_.the_statut_stats_id AS the_statut_stats_id_22, m1_.the_type_id AS the_type_id_23, m0_.stade_id AS stade_id_24, m0_.the_ligue_saison_id AS the_ligue_saison_id_25, m0_.the_statut_api_id AS the_statut_api_id_26, m0_.the_club_domicile_id AS the_club_domicile_id_27, m0_.the_club_exterieur_id AS the_club_exterieur_id_28, m0_.the_round_id AS the_round_id_29, m0_.the_cote_id AS the_cote_id_30, m1_.the_stats_id AS the_stats_id_31, m1_.the_coach_id AS the_coach_id_32, m1_.the_match_id AS the_match_id_33, m1_.the_club_id AS the_club_id_34, m1_.the_equipe_id AS the_equipe_id_35 FROM matchs_match m0_ LEFT JOIN matchs_match_equipe m1_ ON m0_.id = m1_.the_match_id INNER JOIN ligues_ligue_saison l2_ ON m0_.the_ligue_saison_id = l2_.id WHERE m0_.the_statut_id = 2 AND m0_.id IN (20, 1461, 1464, 2211, 2212, 2213, 2214, 2972, 2974, 2977, 13, 17, 706, 707, 708, 709, 710, 711, 712, 713, 1031, 1457, 1458, 1459, 1460, 1463, 1465, 1466, 2207, 2208) ORDER BY m0_.date DESC;

SELECT
  t0.id AS id_1,
  t0.start_at AS start_at_2,
  t0.end_at AS end_at_3,
  t0.is_current AS is_current_4,
  t0.the_datetime_api_update_equipe AS the_datetime_api_update_equipe_5,
  t0.the_datetime_api_update_joueur AS the_datetime_api_update_joueur_6,
  t0.the_datetime_api_update_match AS the_datetime_api_update_match_7,
  t0.the_datetime_calculate_stats AS the_datetime_calculate_stats_8,
  t0.the_datetime_api_update_pronostics AS the_datetime_api_update_pronostics_9,
  t0.the_datetime_api_update_cote AS the_datetime_api_update_cote_10,
  t0.the_datetime_api_load_match_line_up AS the_datetime_api_load_match_line_up_11,
  t0.the_datetime_api_load_match_event AS the_datetime_api_load_match_event_12,
  t0.the_datetime_api_load_classement AS the_datetime_api_load_classement_13,
  t0.the_statut_id AS the_statut_id_14,
  t0.is_defaut AS is_defaut_15,
  t0.saison_id AS saison_id_16,
  t0.ligue_id AS ligue_id_17
FROM
  ligues_ligue_saison t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.is_current AS is_current_4, t0.the_datetime_api_update_equipe AS the_datetime_api_update_equipe_5, t0.the_datetime_api_update_joueur AS the_datetime_api_update_joueur_6, t0.the_datetime_api_update_match AS the_datetime_api_update_match_7, t0.the_datetime_calculate_stats AS the_datetime_calculate_stats_8, t0.the_datetime_api_update_pronostics AS the_datetime_api_update_pronostics_9, t0.the_datetime_api_update_cote AS the_datetime_api_update_cote_10, t0.the_datetime_api_load_match_line_up AS the_datetime_api_load_match_line_up_11, t0.the_datetime_api_load_match_event AS the_datetime_api_load_match_event_12, t0.the_datetime_api_load_classement AS the_datetime_api_load_classement_13, t0.the_statut_id AS the_statut_id_14, t0.is_defaut AS is_defaut_15, t0.saison_id AS saison_id_16, t0.ligue_id AS ligue_id_17 FROM ligues_ligue_saison t0 WHERE t0.id = 9;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.flag AS flag_3,
  p0_.is_actif AS is_actif_4,
  p0_.nationality AS nationality_5
FROM
  pays_pays p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.flag AS flag_3, p0_.is_actif AS is_actif_4, p0_.nationality AS nationality_5 FROM pays_pays p0_ ORDER BY p0_.name ASC;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.code AS code_2,
  l0_.image AS image_3,
  l0_.is_actif AS is_actif_4,
  l0_.the_type_id AS the_type_id_5,
  l0_.the_statut_id AS the_statut_id_6,
  l0_.coefficient AS coefficient_7,
  l0_.logo AS logo_8,
  l0_.is_defaut AS is_defaut_9,
  l0_.pays_id AS pays_id_10
FROM
  ligues_ligue l0_
WHERE
  l0_.the_statut_id = ?
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.image AS image_3, l0_.is_actif AS is_actif_4, l0_.the_type_id AS the_type_id_5, l0_.the_statut_id AS the_statut_id_6, l0_.coefficient AS coefficient_7, l0_.logo AS logo_8, l0_.is_defaut AS is_defaut_9, l0_.pays_id AS pays_id_10 FROM ligues_ligue l0_ WHERE l0_.the_statut_id = 1 ORDER BY l0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.flag AS flag_3,
  p0_.is_actif AS is_actif_4,
  p0_.nationality AS nationality_5
FROM
  pays_pays p0_
WHERE
  p0_.code = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.flag AS flag_3, p0_.is_actif AS is_actif_4, p0_.nationality AS nationality_5 FROM pays_pays p0_ WHERE p0_.code = 'FR';

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;