Query Metrics
48
Database Queries
9
Different statements
17.59 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.76 ms (44.11%) |
20 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.date AS date_3, t0.the_statut_id AS the_statut_id_4, t0.the_statut_stats_id AS the_statut_stats_id_5, t0.the_resultat_id AS the_resultat_id_6, t0.the_datetime_api_update AS the_datetime_api_update_7, t0.arbitre_nom AS arbitre_nom_8, t0.the_date AS the_date_9, t0.the_statut_line_up_id AS the_statut_line_up_id_10, t0.the_statut_event_id AS the_statut_event_id_11, t0.stade_id AS stade_id_12, t0.the_ligue_saison_id AS the_ligue_saison_id_13, t0.the_statut_api_id AS the_statut_api_id_14, t0.the_club_domicile_id AS the_club_domicile_id_15, t0.the_club_exterieur_id AS the_club_exterieur_id_16, t0.the_round_id AS the_round_id_17, t0.the_cote_id AS the_cote_id_18 FROM matchs_match t0 WHERE t0.the_round_id = ? ORDER BY t0.date ASC
Parameters:
[
510
]
|
3.26 ms (18.54%) |
12 |
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 = ?
Parameters:
[
188
]
|
2.26 ms (12.85%) |
9 |
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
]
|
1.11 ms (6.28%) |
1 |
SELECT DISTINCT l0_.id AS id_0, l0_.the_ligue_saison_id AS sclr_1, l0_.numero AS numero_2, l0_.nom AS nom_3 FROM ligues_round l0_ ORDER BY l0_.the_ligue_saison_id DESC, l0_.numero ASC, l0_.nom ASC LIMIT 20
Parameters:
[] |
0.98 ms (5.58%) |
1 |
SELECT count(DISTINCT l0_.id) AS sclr_0 FROM ligues_round l0_
Parameters:
[] |
0.85 ms (4.83%) |
2 |
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:
[] |
0.55 ms (3.12%) |
1 |
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
Parameters:
[
1
]
|
0.49 ms (2.77%) |
1 |
SELECT l0_.id AS id_0, l0_.numero AS numero_1, l0_.nom AS nom_2, l0_.the_date_debut AS the_date_debut_3, l0_.the_date_fin AS the_date_fin_4, l0_.the_statut_id AS the_statut_id_5, l0_.is_next AS is_next_6, l0_.the_ligue_saison_id AS the_ligue_saison_id_7 FROM ligues_round l0_ WHERE l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.the_ligue_saison_id DESC, l0_.numero ASC, l0_.nom ASC
Parameters:
[ 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 ] |
0.34 ms (1.92%) |
1 |
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 = ?
Parameters:
[
15
]
|
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\Ligues\Round | No errors. |
App\Entity\Ligues\LigueSaison | No errors. |
App\Entity\Matchs\Matchs | No errors. |
App\Entity\Joueurs\Joueurs | No errors. |
App\Entity\Saison\Saison | No errors. |
App\Entity\Equipes\Equipes | No errors. |
App\Entity\Ligues\Classement | No errors. |
App\Entity\Pronostics\Pronostic | No errors. |
App\Entity\Paris\Cote | No errors. |
App\Entity\Stades\Stades | No errors. |
App\Entity\Matchs\MatchStatutApi | No errors. |
App\Entity\Matchs\MatchCote | No errors. |
App\Entity\Matchs\MatchEquipe | No errors. |
App\Entity\Matchs\Event | No errors. |
App\Entity\Clubs\ClubStats | No errors. |