Query Metrics
156
Database Queries
18
Different statements
130.74 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
31.29 ms (23.93%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.reserved_for_members AS reserved_for_members_3, b0_.short_description AS short_description_4, b0_.content AS content_5, b0_.publication_date AS publication_date_6, b0_.unpublication_date AS unpublication_date_7, b0_.status AS status_8, b0_.is_spotlight AS is_spotlight_9, b0_.is_alert AS is_alert_10, b0_.is_top_category AS is_top_category_11, b0_.project_data AS project_data_12, b0_.content_type AS content_type_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b0_.deleted_at AS deleted_at_16, b0_.author_id AS author_id_17, b0_.main_category_id AS main_category_id_18, b0_.championship_id AS championship_id_19, b0_.trial_id AS trial_id_20, b0_.track_id AS track_id_21, b0_.media_id AS media_id_22, b0_.media_responsive_id AS media_responsive_id_23 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.main_category_id = b1_.id LEFT JOIN blog_category_discipline_group b3_ ON b1_.id = b3_.blog_category_id LEFT JOIN discipline_group d2_ ON d2_.id = b3_.discipline_group_id WHERE ((b0_.unpublication_date >= NOW() OR b0_.unpublication_date IS NULL) OR b0_.unpublication_date IS NULL) AND (b0_.deleted_at IS NULL AND b0_.status = ? AND b0_.publication_date <= NOW()) AND (d2_.id = ? AND d2_.is_active = 1 AND d2_.deleted_at IS NULL) ORDER BY b0_.publication_date DESC LIMIT 10
Parameters:
[ "publie" 2 ] |
|
20.45 ms (15.64%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.reserved_for_members AS reserved_for_members_4, t0.short_description AS short_description_5, t0.content AS content_6, t0.publication_date AS publication_date_7, t0.unpublication_date AS unpublication_date_8, t0.status AS status_9, t0.is_spotlight AS is_spotlight_10, t0.is_alert AS is_alert_11, t0.is_top_category AS is_top_category_12, t0.project_data AS project_data_13, t0.content_type AS content_type_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.author_id AS author_id_18, t0.main_category_id AS main_category_id_19, t20.id AS id_21, t20.name AS name_22, t20.slug AS slug_23, t20.short_description AS short_description_24, t20.long_description AS long_description_25, t20.color AS color_26, t20.created_at AS created_at_27, t20.updated_at AS updated_at_28, t20.deleted_at AS deleted_at_29, t20.parent_category_id AS parent_category_id_30, t0.championship_id AS championship_id_31, t0.trial_id AS trial_id_32, t0.track_id AS track_id_33, t0.media_id AS media_id_34, t35.id AS id_36, t35.alt AS alt_37, t35.status AS status_38, t35.legend AS legend_39, t35.copyright AS copyright_40, t35.is_published AS is_published_41, t35.created_at AS created_at_42, t35.updated_at AS updated_at_43, t35.deleted_at AS deleted_at_44, t35.image_id AS image_id_45, t35.author_id AS author_id_46, t35.media_category_id AS media_category_id_47, t0.media_responsive_id AS media_responsive_id_48, t49.id AS id_50, t49.alt AS alt_51, t49.status AS status_52, t49.legend AS legend_53, t49.copyright AS copyright_54, t49.is_published AS is_published_55, t49.created_at AS created_at_56, t49.updated_at AS updated_at_57, t49.deleted_at AS deleted_at_58, t49.image_id AS image_id_59, t49.author_id AS author_id_60, t49.media_category_id AS media_category_id_61 FROM blog_post t0 INNER JOIN blog_category t20 ON t0.main_category_id = t20.id INNER JOIN media t35 ON t0.media_id = t35.id LEFT JOIN media t49 ON t0.media_responsive_id = t49.id WHERE t0.main_category_id IN (?)
Parameters:
[
27
]
|
|
13.45 ms (10.29%) |
10 |
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:
[
1099966
]
|
|
12.06 ms (9.22%) |
33 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.color AS color_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_category_id AS parent_category_id_10 FROM blog_category t0 INNER JOIN blog_post_blog_category ON t0.id = blog_post_blog_category.blog_category_id WHERE blog_post_blog_category.blog_post_id = ?
Parameters:
[
209
]
|
|
10.85 ms (8.30%) |
33 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.tag_id WHERE blog_post_tag.blog_post_id = ?
Parameters:
[
209
]
|
|
10.53 ms (8.06%) |
28 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.size AS size_4, t0.mime_type AS mime_type_5, t0.src AS src_6, t0.alt AS alt_7, t0.width AS width_8, t0.height AS height_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM image t0 WHERE t0.id IN (?)
Parameters:
[
2268
]
|
|
8.83 ms (6.75%) |
10 |
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 INNER JOIN blog_post_user ON t0.id = blog_post_user.user_id WHERE blog_post_user.blog_post_id = ?
Parameters:
[
209
]
|
|
6.78 ms (5.19%) |
5 |
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:
[
487
]
|
|
4.88 ms (3.73%) |
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM tag t0 INNER JOIN media_tag ON t0.id = media_tag.tag_id WHERE media_tag.media_id = ?
Parameters:
[
565
]
|
|
4.62 ms (3.53%) |
5 |
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.id = ?
Parameters:
[
28189
]
|
|
2.39 ms (1.83%) |
1 |
SELECT t1.id AS id_2, t1.gender AS gender_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.email AS email_6, t1.phone AS phone_7, t1.roles AS roles_8, t1.password AS password_9, t1.email_validated_at AS email_validated_at_10, t1.last_logged_at AS last_logged_at_11, t1.active AS active_12, t1.website AS website_13, t1.seniority AS seniority_14, t1.birth_date AS birth_date_15, t1.token AS token_16, t1.created_at AS created_at_17, t1.updated_at AS updated_at_18, t1.deleted_at AS deleted_at_19, t1.address_id AS address_id_20, t1.avatar_id AS avatar_id_21, t1.background_id AS background_id_22, t1.race_id AS race_id_23, t1.favorite_discipline_group_id AS favorite_discipline_group_id_24, t1.type FROM admin t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.email = ? LIMIT 1
Parameters:
[
"alex@keole.net"
]
|
|
2.02 ms (1.55%) |
7 |
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:
[
89311
]
|
|
0.89 ms (0.68%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.color AS color_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_category_id AS parent_category_id_10 FROM blog_category t0 WHERE t0.parent_category_id IS NULL AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[] |
|
0.53 ms (0.40%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.meta_title AS meta_title_3, d0_.meta_description AS meta_description_4, d0_.primary_color AS primary_color_5, d0_.secondary_color AS secondary_color_6, d0_.dark_color AS dark_color_7, d0_.medium_color AS medium_color_8, d0_.light_color AS light_color_9, d0_.first_zone_title AS first_zone_title_10, d0_.first_zone_text AS first_zone_text_11, d0_.second_zone_title AS second_zone_title_12, d0_.second_zone_text AS second_zone_text_13, d0_.third_zone_title AS third_zone_title_14, d0_.third_zone_text AS third_zone_text_15, d0_.is_active AS is_active_16, d0_.h1 AS h1_17, d0_.portal_id AS portal_id_18, d0_.deleted_at AS deleted_at_19, d0_.created_at AS created_at_20, d0_.updated_at AS updated_at_21, d0_.banner_image_id AS banner_image_id_22, d0_.list_image_id AS list_image_id_23, d0_.document_id AS document_id_24, d0_.category_id AS category_id_25, d0_.first_zone_image_id AS first_zone_image_id_26, d0_.second_zone_image_id AS second_zone_image_id_27, d0_.third_zone_image_id AS third_zone_image_id_28, d0_.cups_and_championships_carousel_id AS cups_and_championships_carousel_id_29 FROM discipline_group d0_ WHERE d0_.id IN (?)
Parameters:
[
"2"
]
|
|
0.34 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.size AS size_4, t0.mime_type AS mime_type_5, t0.src AS src_6, t0.alt AS alt_7, t0.width AS width_8, t0.height AS height_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM image t0 WHERE t0.id IN (?, ?, ?)
Parameters:
[ 2722 2730 2736 ] |
|
0.32 ms (0.25%) |
1 |
SELECT t0.id AS id_1, t0.alt AS alt_2, t0.status AS status_3, t0.legend AS legend_4, t0.copyright AS copyright_5, t0.is_published AS is_published_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.image_id AS image_id_10, t11.id AS id_12, t11.name AS name_13, t11.original_name AS original_name_14, t11.size AS size_15, t11.mime_type AS mime_type_16, t11.src AS src_17, t11.alt AS alt_18, t11.width AS width_19, t11.height AS height_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.deleted_at AS deleted_at_23, t0.author_id AS author_id_24, t0.media_category_id AS media_category_id_25 FROM media t0 INNER JOIN image t11 ON t0.image_id = t11.id WHERE t0.id IN (?)
Parameters:
[
565
]
|
|
0.28 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.color AS color_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_category_id AS parent_category_id_10 FROM blog_category t0 WHERE t0.id IN (?)
Parameters:
[
16
]
|
|
0.23 ms (0.18%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.color AS color_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_category_id AS parent_category_id_10 FROM blog_category t0 WHERE t0.id = ?
Parameters:
[
24
]
|
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.