Query Metrics
7
Database Queries
7
Different statements
4.19 ms
Query time
0
Invalid entities
15
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.87 ms (20.79%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.email AS email_3, t0.password AS password_4, t0.username AS username_5, t0.locale AS locale_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.person_id AS person_id_11, t12.id AS id_13, t12.gender AS gender_14, t12.first_name AS first_name_15, t12.last_name AS last_name_16, t12.email AS email_17, t12.phone AS phone_18, t12.address AS address_19, t12.npa AS npa_20, t12.city AS city_21, t12.birth_date AS birth_date_22, t12.decease_date AS decease_date_23, t12.retire_date AS retire_date_24, t12.printedAt AS printedAt_25, t12.lastPrintedAt AS lastPrintedAt_26, t12.numberPrinted AS numberPrinted_27, t12.note AS note_28, t12.language AS language_29, t12.membership_date AS membership_date_30, t12.membership_type AS membership_type_31, t12.deletedAt AS deletedAt_32, t12.locked AS locked_33, t12.licenseNumber AS licenseNumber_34, t12.hash AS hash_35, t12.birth_city_country AS birth_city_country_36, t12.height AS height_37, t12.spouse_children AS spouse_children_38, t12.former_name AS former_name_39, t12.residence_city_country AS residence_city_country_40, t12.education_city_country AS education_city_country_41, t12.occupation AS occupation_42, t12.website AS website_43, t12.twitter AS twitter_44, t12.facebook AS facebook_45, t12.instagram AS instagram_46, t12.snapchat AS snapchat_47, t12.discr AS discr_48, t12.created_by AS created_by_49, t12.updated_by AS updated_by_50, t12.created_at AS created_at_51, t12.updated_at AS updated_at_52, t12.federation_id AS federation_id_53, t12.previous_federation_id AS previous_federation_id_54, t0.federation_id AS federation_id_55 FROM user t0 LEFT JOIN person t12 ON t0.person_id = t12.id INNER JOIN team_user ON t0.id = team_user.user_id WHERE team_user.team_id = ?
Parameters:
[
13
]
|
|
0.80 ms (19.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.token AS token_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.division_id AS division_id_10, t0.tournament_session_id AS tournament_session_id_11 FROM team t0 WHERE t0.id = ?
Parameters:
[
"13"
]
|
|
0.65 ms (15.51%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.state AS state_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.rule_book_id AS rule_book_id_9 FROM division t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.65 ms (15.41%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.register_start_at AS register_start_at_3, t0.register_end_at AS register_end_at_4, t0.inspection_start_at AS inspection_start_at_5, t0.training_start_at AS training_start_at_6, t0.shooting_start_at AS shooting_start_at_7, t0.max_competitors AS max_competitors_8, t0.is_final AS is_final_9, t0.session_category AS session_category_10, t0.is_inter_club AS is_inter_club_11, t0.is_inter_gender AS is_inter_gender_12, t0.team_members_number AS team_members_number_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.tournament_id AS tournament_id_18 FROM tournament_session t0 WHERE t0.id = ?
Parameters:
[
14
]
|
|
0.44 ms (10.57%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.registration_start_at AS registration_start_at_5, t0.registration_end_at AS registration_end_at_6, t0.ianseo_link AS ianseo_link_7, t0.description AS description_8, t0.url AS url_9, t0.state AS state_10, t0.token AS token_11, t0.slug AS slug_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.tournament_category_id AS tournament_category_id_17, t0.tournament_format_id AS tournament_format_id_18, t0.place_id AS place_id_19, t0.user_organizer_id AS user_organizer_id_20, t0.club_organizer_id AS club_organizer_id_21, t0.rule_book_id AS rule_book_id_22, t0.banner_file_id AS banner_file_id_23 FROM tournament t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
0.43 ms (10.33%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortName AS shortName_3, t0.code AS code_4, t0.correspondenceLanguage AS correspondenceLanguage_5, t0.country AS country_6, t0.visible AS visible_7, t0.address AS address_8, t0.npa AS npa_9, t0.city AS city_10, t0.cantonCode AS cantonCode_11, t0.phone AS phone_12, t0.phone2 AS phone2_13, t0.mobile AS mobile_14, t0.fax AS fax_15, t0.fax2 AS fax2_16, t0.correspondanceCountry AS correspondanceCountry_17, t0.affiliated_year AS affiliated_year_18, t0.contactName AS contactName_19, t0.emailAddress AS emailAddress_20, t0.url AS url_21, t0.isMember AS isMember_22, t0.sendTo AS sendTo_23, t0.member_until_date AS member_until_date_24, t0.comment AS comment_25 FROM federation t0 WHERE t0.id IN (?)
Parameters:
[
26
]
|
|
0.35 ms (8.33%) |
1 |
SELECT t0.id AS id_1, t0.state AS state_2, t0.result AS result_3, t0.is_guest AS is_guest_4, t0.correspondence_language AS correspondence_language_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.phone AS phone_9, t0.address AS address_10, t0.zip AS zip_11, t0.city AS city_12, t0.birth_date AS birth_date_13, t0.license_number AS license_number_14, t0.country AS country_15, t0.token AS token_16, t0.club_name AS club_name_17, t0.is_wheelchair_user AS is_wheelchair_user_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.user_id AS user_id_23, t0.tournament_session_id AS tournament_session_id_24, t0.division_id AS division_id_25, t0.tournament_age_class_id AS tournament_age_class_id_26, t0.team_id AS team_id_27 FROM session_registration t0 WHERE t0.team_id = ?
Parameters:
[
13
]
|
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\User | 2 |
| App\Entity\Team | 1 |
| App\Entity\Division | 1 |
| App\Entity\TournamentSession | 1 |
| App\Entity\Tournament | 1 |
| App\Entity\TournamentCategory | 1 |
| App\Entity\TournamentFormat | 1 |
| App\Entity\Place | 1 |
| App\Entity\Federation | 1 |
| App\Entity\RuleBook | 1 |
| App\Entity\TournamentFile | 1 |
| App\Entity\Person | 1 |
| App\Entity\SessionRegistration | 1 |
| App\Entity\TournamentAgeClass | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Team | No errors. |
| App\Entity\Division | No errors. |
| App\Entity\TournamentSession | No errors. |
| App\Entity\SessionRegistration | No errors. |
| App\Entity\User | No errors. |
| App\Entity\TeamInvitation | No errors. |
| App\Entity\TeamJoinRequest | No errors. |
| App\Entity\Tournament | No errors. |
| App\Entity\TournamentCategory | No errors. |
| App\Entity\TournamentFormat | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\Federation | No errors. |
| App\Entity\RuleBook | No errors. |
| App\Entity\TournamentFile | No errors. |
| App\Entity\TournamentReferee | No errors. |
| App\Entity\TournamentAgeClass | No errors. |
| App\Entity\TournamentQuestion | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\AbstractLicense | No errors. |
| App\Entity\License | No errors. |
| App\Entity\PersonFormations | No errors. |
| App\Entity\CommitteeFunction | No errors. |
| App\Entity\TournamentQuestionAnswer | No errors. |