Query Metrics
12
Database Queries
10
Different statements
15.03 ms
Query time
0
Invalid entities
79
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.80 ms (45.28%) |
2 |
SELECT t0.id AS id_1, t0.engaged AS engaged_2, t0.created_at AS created_at_3, t0.name AS name_4, t0.category_id AS category_id_5, t0.club_id AS club_id_6 FROM team t0 WHERE t0.id = ?
Parameters:
[
34
]
|
|
3.42 ms (22.77%) |
2 |
SELECT p0_.id AS id_0, p0_.enable AS enable_1, p1_.id AS id_2, p1_.license AS license_3, p1_.name_player AS name_player_4, p1_.name AS name_5, p1_.nick_name AS nick_name_6, p1_.num_player AS num_player_7, p1_.photo AS photo_8, p1_.poste AS poste_9, p1_.slug_player AS slug_player_10, p1_.height AS height_11, p1_.email AS email_12, p1_.phone AS phone_13, p1_.sex AS sex_14, p1_.birthday AS birthday_15, p1_.activity AS activity_16, p1_.created_at AS created_at_17, p1_.user_creat AS user_creat_18, p1_.instagram AS instagram_19, p1_.tiktok AS tiktok_20, p0_.team_id AS team_id_21, p0_.player_id AS player_id_22, p0_.saison_id AS saison_id_23, p1_.category_id AS category_id_24 FROM player_team p0_ INNER JOIN player p1_ ON p0_.player_id = p1_.id WHERE p0_.team_id = ? AND p0_.saison_id = ? ORDER BY p1_.name ASC
Parameters:
[ 34 6 ] |
|
0.99 ms (6.59%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.phone AS phone_5, t0.last_name AS last_name_6, t0.nick_name AS nick_name_7, t0.first_name AS first_name_8, t0.birthday AS birthday_9, t0.avatar AS avatar_10, t0.ligue_id AS ligue_id_11, t0.club_id AS club_id_12, t0.officiel_id AS officiel_id_13, t0.coach_id AS coach_id_14, t0.player_id AS player_id_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.66 ms (4.43%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.hours AS hours_3, t0.num_game AS num_game_4, t0.result_home AS result_home_5, t0.result_out AS result_out_6, t0.pts_home AS pts_home_7, t0.pts_out AS pts_out_8, t0.name_game AS name_game_9, t0.slug_game AS slug_game_10, t0.convocation AS convocation_11, t0.ticket AS ticket_12, t0.img AS img_13, t0.featured AS featured_14, t0.score_updated_at AS score_updated_at_15, t0.day_id AS day_id_16, t0.team_home_id AS team_home_id_17, t0.team_out_id AS team_out_id_18, t0.locate_id AS locate_id_19, t0.otm_chrono_id AS otm_chrono_id_20, t0.otm_marque_id AS otm_marque_id_21, t0.otm24s_id AS otm24s_id_22, t0.arbitre_id AS arbitre_id_23, t0.arbitre2_id AS arbitre2_id_24, t0.score_updated_by_id AS score_updated_by_id_25, t0.quarter_id AS quarter_id_26 FROM game t0 WHERE t0.id = ?
Parameters:
[
3274
]
|
|
0.65 ms (4.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.nick_name AS nick_name_3, t0.address AS address_4, t0.website AS website_5, t0.phone AS phone_6, t0.link_facebook AS link_facebook_7, t0.link_instagram AS link_instagram_8, t0.link_twitter AS link_twitter_9, t0.link_tiktok AS link_tiktok_10, t0.departement AS departement_11, t0.logo AS logo_12, t0.banner AS banner_13, t0.city AS city_14, t0.zip AS zip_15, t0.mail AS mail_16, t0.opt_partenaire AS opt_partenaire_17, t0.opt_otm AS opt_otm_18, t0.opt_slid AS opt_slid_19, t0.distributor AS distributor_20, t0.distributor_2 AS distributor_2_21, t0.slug_ligue AS slug_ligue_22, t0.slug_dept AS slug_dept_23, t0.opt_document AS opt_document_24 FROM ligue t0
Parameters:
[] |
|
0.63 ms (4.17%) |
1 |
SELECT t0.id AS id_1, t0.phase AS phase_2, t0.number_day AS number_day_3, t0.statuts AS statuts_4, t0.name AS name_5, t0.slug_day AS slug_day_6, t0.championnat_id AS championnat_id_7 FROM day t0 WHERE t0.id = ?
Parameters:
[
800
]
|
|
0.60 ms (3.98%) |
1 |
SELECT t0.id AS id_1, t0.points AS points_2, t0.minutes AS minutes_3, t0.lf_try AS lf_try_4, t0.lf_succes AS lf_succes_5, t0.t3pts AS t3pts_6, t0.s3pts AS s3pts_7, t0.faults AS faults_8, t0.player_id AS player_id_9, t0.game_id AS game_id_10, t0.saison_id AS saison_id_11 FROM stat t0 WHERE t0.game_id = ?
Parameters:
[
3274
]
|
|
0.59 ms (3.91%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.types AS types_3, t0.format AS format_4, t0.wins_to_qualify AS wins_to_qualify_5, t0.wins_to_win AS wins_to_win_6, t0.prono_enabled AS prono_enabled_7, t0.img AS img_8, t0.ligue_id AS ligue_id_9, t0.saison_id AS saison_id_10, t0.category_id AS category_id_11, t0.championnat_source_id AS championnat_source_id_12, t0.champs_master_id AS champs_master_id_13 FROM championnat t0 WHERE t0.id = ?
Parameters:
[
71
]
|
|
0.43 ms (2.86%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.nick_name AS nick_name_3, t0.logo AS logo_4, t0.banner AS banner_5, t0.website AS website_6, t0.link_facebook AS link_facebook_7, t0.link_instagram AS link_instagram_8, t0.link_twitter AS link_twitter_9, t0.link_tiktok AS link_tiktok_10, t0.address AS address_11, t0.zip AS zip_12, t0.departement AS departement_13, t0.city AS city_14, t0.opt_partenaire AS opt_partenaire_15, t0.name_president AS name_president_16, t0.nick_name_president AS nick_name_president_17, t0.phone_president AS phone_president_18, t0.mail_president AS mail_president_19, t0.name_referent AS name_referent_20, t0.nick_name_referent AS nick_name_referent_21, t0.phone_referent AS phone_referent_22, t0.mail_referent AS mail_referent_23, t0.visibility AS visibility_24, t0.color_home AS color_home_25, t0.color_out AS color_out_26, t0.slug_club AS slug_club_27, t0.ligue_id AS ligue_id_28 FROM club t0
Parameters:
[] |
|
0.26 ms (1.70%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived AS archived_3 FROM saison t0 WHERE t0.id = ?
Parameters:
[
6
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Club | 63 |
| App\Entity\Ligue | 3 |
| App\Entity\Team | 2 |
| App\Entity\Championnat | 2 |
| App\Entity\User | 1 |
| App\Entity\Game | 1 |
| App\Entity\Day | 1 |
| App\Entity\Quarter | 1 |
| App\Entity\Saison | 1 |
| App\Entity\Category | 1 |
| App\Entity\PlayerTeam | 1 |
| App\Entity\Player | 1 |
| App\Entity\Stat | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Ligue | No errors. |
| App\Entity\Club | No errors. |
| App\Entity\Officiel | No errors. |
| App\Entity\Coach | No errors. |
| App\Entity\Player | No errors. |
| App\Entity\Game | No errors. |
| App\Entity\Day | No errors. |
| App\Entity\Team | No errors. |
| App\Entity\Terrain | No errors. |
| App\Entity\Quarter | No errors. |
| App\Entity\Stat | No errors. |
| App\Entity\Championnat | No errors. |
| App\Entity\Saison | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\PlayerTeam | No errors. |