Query Metrics
41
Database Queries
8
Different statements
14.23 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.56 ms |
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
Parameters:
[] |
2 | 0.29 ms |
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
Parameters:
[] |
3 | 1.72 ms |
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
Parameters:
[] |
4 | 1.07 ms |
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 170
Parameters:
[] |
5 | 0.66 ms |
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
Parameters:
[ 126 129 155 65 115 122 128 146 176 86 ] |
6 | 0.49 ms |
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 = ?
Parameters:
[
8
]
|
7 | 0.40 ms |
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 = ?
Parameters:
[
126
]
|
8 | 0.32 ms |
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 = ?
Parameters:
[
126
]
|
9 | 0.34 ms |
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 = ?
Parameters:
[
126
]
|
10 | 0.37 ms |
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 = ?
Parameters:
[
129
]
|
11 | 0.23 ms |
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 = ?
Parameters:
[
129
]
|
12 | 0.26 ms |
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 = ?
Parameters:
[
129
]
|
13 | 0.22 ms |
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 = ?
Parameters:
[
10
]
|
14 | 0.29 ms |
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 = ?
Parameters:
[
155
]
|
15 | 0.27 ms |
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 = ?
Parameters:
[
155
]
|
16 | 0.29 ms |
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 = ?
Parameters:
[
155
]
|
17 | 0.23 ms |
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 = ?
Parameters:
[
4
]
|
18 | 0.27 ms |
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 = ?
Parameters:
[
65
]
|
19 | 0.21 ms |
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 = ?
Parameters:
[
65
]
|
20 | 0.23 ms |
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 = ?
Parameters:
[
65
]
|
21 | 0.32 ms |
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 = ?
Parameters:
[
115
]
|
22 | 0.22 ms |
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 = ?
Parameters:
[
115
]
|
23 | 0.28 ms |
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 = ?
Parameters:
[
115
]
|
24 | 0.31 ms |
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 = ?
Parameters:
[
122
]
|
25 | 0.25 ms |
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 = ?
Parameters:
[
122
]
|
26 | 0.28 ms |
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 = ?
Parameters:
[
122
]
|
27 | 0.27 ms |
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 = ?
Parameters:
[
128
]
|
28 | 0.29 ms |
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 = ?
Parameters:
[
128
]
|
29 | 0.27 ms |
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 = ?
Parameters:
[
128
]
|
30 | 0.22 ms |
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 = ?
Parameters:
[
3
]
|
31 | 0.32 ms |
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 = ?
Parameters:
[
146
]
|
32 | 0.22 ms |
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 = ?
Parameters:
[
146
]
|
33 | 0.27 ms |
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 = ?
Parameters:
[
146
]
|
34 | 0.22 ms |
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 = ?
Parameters:
[
6
]
|
35 | 0.27 ms |
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 = ?
Parameters:
[
176
]
|
36 | 0.26 ms |
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 = ?
Parameters:
[
176
]
|
37 | 0.25 ms |
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 = ?
Parameters:
[
176
]
|
38 | 0.21 ms |
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 = ?
Parameters:
[
7
]
|
39 | 0.30 ms |
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 = ?
Parameters:
[
86
]
|
40 | 0.24 ms |
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 = ?
Parameters:
[
86
]
|
41 | 0.24 ms |
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 = ?
Parameters:
[
86
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\FootballApi\FootballApiStatut | No errors. |
App\Entity\Coachs\Coachs | No errors. |
App\Entity\Coachs\CoachCarrer | No errors. |
App\Entity\Pronostics\Pronostiqueur | No errors. |
App\Entity\Pays\Pays | No errors. |
App\Entity\Clubs\Clubs | No errors. |
App\Entity\Equipes\EquipeJoueur | No errors. |
App\Entity\Matchs\MatchJoueur | No errors. |
App\Entity\Ligues\Ligues | No errors. |
App\Entity\Clubs\ClubStats | No errors. |
App\Entity\Stades\Stades | No errors. |
App\Entity\Equipes\Equipes | No errors. |
App\Entity\Ligues\Classement | No errors. |
App\Entity\Joueurs\Joueurs | No errors. |
App\Entity\Clubs\ClubStatsForme | No errors. |
App\Entity\Clubs\ClubStatsNoteOffensive | No errors. |
App\Entity\Clubs\ClubStatsNoteDefensive | No errors. |
App\Entity\Clubs\ClubStatsHistorique | No errors. |
App\Entity\Matchs\MatchEquipeStatsNoteOffensive | No errors. |
App\Entity\Matchs\MatchEquipeStatsNoteDefensive | No errors. |