Query Metrics
4
Database Queries
4
Different statements
34.76 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
32.60 ms (93.80%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.website AS website_4, t0.started_at AS started_at_5, t0.ended_at AS ended_at_6, t0.main AS main_7, t0.open_to_foreigners AS open_to_foreigners_8, t0.open_to_accreditations AS open_to_accreditations_9, t0.is_active AS is_active_10, t0.is_published AS is_published_11, t0.is_cancelled AS is_cancelled_12, t0.is_important AS is_important_13, t0.presentation_text AS presentation_text_14, t0.is_edit_old_live AS is_edit_old_live_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.portal_id AS portal_id_19, t0.address_id AS address_id_20, t0.level_id AS level_id_21, t0.organization_id AS organization_id_22, t0.track_id AS track_id_23, t0.chronometer_id AS chronometer_id_24, t0.banner_image_id AS banner_image_id_25, t0.presentation_image_id AS presentation_image_id_26, t0.discipline_id AS discipline_id_27, t0.sector_id AS sector_id_28 FROM trial t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"autocross-de-marcollin-29172"
]
|
|
0.83 ms (2.39%) |
1 |
SELECT t0.id AS id_7, t0.gender AS gender_8, t0.last_name AS last_name_9, t0.first_name AS first_name_10, t0.email AS email_11, t0.phone AS phone_12, t0.roles AS roles_13, t0.password AS password_14, t0.email_validated_at AS email_validated_at_15, t0.last_logged_at AS last_logged_at_16, t0.active AS active_17, t0.website AS website_18, t0.seniority AS seniority_19, t0.birth_date AS birth_date_20, t0.token AS token_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24, t0.address_id AS address_id_25, t0.avatar_id AS avatar_id_26, t0.background_id AS background_id_27, t0.race_id AS race_id_28, t0.favorite_discipline_group_id AS favorite_discipline_group_id_29, t0.type, t2.moderation AS moderation_30, t3.status AS status_31, t3.journalist_type AS journalist_type_32, t3.have_press_card AS have_press_card_33, t3.company AS company_34, t3.press_card_id AS press_card_id_35, t5.civility AS civility_36, t5.member_status AS member_status_37, t5.username AS username_38, t5.home_phone AS home_phone_39, t5.website_url AS website_url_40, t5.birth_place AS birth_place_41, t5.delivery AS delivery_42, t5.nationality AS nationality_43, t5.is_deceased AS is_deceased_44, t5.license_number AS license_number_45, t5.licensed_unique_number AS licensed_unique_number_46, t5.license_number_pre1995 AS license_number_pre1995_47, t5.license_date AS license_date_48, t5.license_date_or AS license_date_or_49, t5.license_place AS license_place_50, t5.first_license_date AS first_license_date_51, t5.dh_cr_mod AS dh_cr_mod_52, t5.championship AS championship_53, t5.championship_position AS championship_position_54, t5.team AS team_55, t5.description AS description_56, t5.teams AS teams_57, t5.disciplines AS disciplines_58, t5.is_corporation AS is_corporation_59, t5.portal_id AS portal_id_60, t5.pilot_sheet_image_id AS pilot_sheet_image_id_61, t5.main_discipline_group_id AS main_discipline_group_id_62 FROM user t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN contributor t2 ON t0.id = t2.id LEFT JOIN journalist t3 ON t0.id = t3.id LEFT JOIN chronometer t4 ON t0.id = t4.id LEFT JOIN licensed t5 ON t0.id = t5.id LEFT JOIN keen t6 ON t0.id = t6.id WHERE t0.id = ?
Parameters:
[
1077281
]
|
|
0.76 ms (2.19%) |
1 |
SELECT t0.id AS id_5, t0.slug AS slug_6, t0.typology AS typology_7, t0.name AS name_8, t0.website AS website_9, t0.description AS description_10, t0.phone AS phone_11, t0.mobile_phone AS mobile_phone_12, t0.email AS email_13, t0.press_email AS press_email_14, t0.portal_id AS portal_id_15, t0.is_active AS is_active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.address_id AS address_id_20, t0.logo_id AS logo_id_21, t0.banner_id AS banner_id_22, t0.presentation_image_id AS presentation_image_id_23, t0.key_figure1_id AS key_figure1_id_24, t0.key_figure2_id AS key_figure2_id_25, t0.key_figure3_id AS key_figure3_id_26, t0.key_figure4_id AS key_figure4_id_27, t0.type, t1.affiliation_number AS affiliation_number_28, t1.departments AS departments_29, t1.code AS code_30, t1.president_id AS president_id_31, t1.sister_league_id AS sister_league_id_32, t1.sector_id AS sector_id_33, t2.code AS code_34, t2.state AS state_35, t2.suspension_start AS suspension_start_36, t2.suspension_end AS suspension_end_37, t2.suspension_reason AS suspension_reason_38, t2.president_id AS president_id_39, t2.league_id AS league_id_40, t2.sector_id AS sector_id_41, t3.is_karting AS is_karting_42, t4.types AS types_43, t4.hom_end_date AS hom_end_date_44 FROM organization t0 LEFT JOIN league t1 ON t0.id = t1.id LEFT JOIN club t2 ON t0.id = t2.id LEFT JOIN school t3 ON t0.id = t3.id LEFT JOIN track t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
378
]
|
|
0.56 ms (1.62%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.captain AS captain_3, t0.title AS title_4, t0.description AS description_5, t0.type AS type_6, t0.french_team_id AS french_team_id_7, t0.captain_image_id AS captain_image_id_8, t0.licensed_id AS licensed_id_9, t0.slider_image_team_id AS slider_image_team_id_10, t0.copilot_id AS copilot_id_11, t0.copilot_background_image_id AS copilot_background_image_id_12 FROM french_team_pilots t0 WHERE t0.copilot_id = ?
Parameters:
[
1077281
]
|
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.