https://qa.qwantic.co/blog/garantir-la-reussite-des-equipes

Query Metrics

7 Database Queries
4 Different statements
2.44 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.catch_phrase AS catch_phrase_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.body AS body_6, t0.cta_text AS cta_text_7, t0.cta_link AS cta_link_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.video_link AS video_link_11, t0.published AS published_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.slug AS slug_15, t0.body_second AS body_second_16, t0.category_id AS category_id_17 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "garantir-la-reussite-des-equipes"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.category_id AS category_id_24, t0.discr, t0.target_profile AS target_profile_25, t0.price AS price_26, t0.dead_line AS dead_line_27, t0.certificate AS certificate_28, t0.goal AS goal_29, t0.presentation AS presentation_30, t0.program AS program_31, t0.success_rate AS success_rate_32, t0.head_section_title AS head_section_title_33, t0.head_section_content AS head_section_content_34, t0.validation_goal AS validation_goal_35, t0.professional_outlet_intro AS professional_outlet_intro_36, t0.professional_outlet_places AS professional_outlet_places_37, t0.professional_outlet_outro AS professional_outlet_outro_38, t0.participant_number AS participant_number_39, t0.place AS place_40, t0.market_label AS market_label_41, t0.open_to_all AS open_to_all_42, t0.public_in_difficulty AS public_in_difficulty_43, t0.duration_in_day_min AS duration_in_day_min_44, t0.duration_in_day_max AS duration_in_day_max_45, t0.goal_short_training AS goal_short_training_46, t0.tools AS tools_47, t0.teaching_method AS teaching_method_48, t0.access_modalities AS access_modalities_49, t0.program_short_training AS program_short_training_50, t0.accessibility_info AS accessibility_info_51, t0.summary AS summary_52, t0.evaluation_methods AS evaluation_methods_53, t0.benefits_list AS benefits_list_54, t0.price_inter AS price_inter_55, t0.price_intra AS price_intra_56, t0.price_inter_remote AS price_inter_remote_57, t0.price_intra_remote AS price_intra_remote_58 FROM training t0 WHERE t0.front_page = ? AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1
Parameters:
[
  1
]
3 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.category_id AS category_id_24, t0.discr, t0.target_profile AS target_profile_25, t0.price AS price_26, t0.dead_line AS dead_line_27, t0.certificate AS certificate_28, t0.goal AS goal_29, t0.presentation AS presentation_30, t0.program AS program_31, t0.success_rate AS success_rate_32, t0.head_section_title AS head_section_title_33, t0.head_section_content AS head_section_content_34, t0.validation_goal AS validation_goal_35, t0.professional_outlet_intro AS professional_outlet_intro_36, t0.professional_outlet_places AS professional_outlet_places_37, t0.professional_outlet_outro AS professional_outlet_outro_38, t0.participant_number AS participant_number_39, t0.place AS place_40, t0.market_label AS market_label_41, t0.open_to_all AS open_to_all_42, t0.public_in_difficulty AS public_in_difficulty_43, t0.duration_in_day_min AS duration_in_day_min_44, t0.duration_in_day_max AS duration_in_day_max_45, t0.goal_short_training AS goal_short_training_46, t0.tools AS tools_47, t0.teaching_method AS teaching_method_48, t0.access_modalities AS access_modalities_49, t0.program_short_training AS program_short_training_50, t0.accessibility_info AS accessibility_info_51, t0.summary AS summary_52, t0.evaluation_methods AS evaluation_methods_53, t0.benefits_list AS benefits_list_54, t0.price_inter AS price_inter_55, t0.price_intra AS price_intra_56, t0.price_inter_remote AS price_inter_remote_57, t0.price_intra_remote AS price_intra_remote_58 FROM training t0 WHERE t0.front_page = ? AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1
Parameters:
[
  1
]
4 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.category_id AS category_id_24, t0.discr, t0.target_profile AS target_profile_25, t0.price AS price_26, t0.dead_line AS dead_line_27, t0.certificate AS certificate_28, t0.goal AS goal_29, t0.presentation AS presentation_30, t0.program AS program_31, t0.success_rate AS success_rate_32, t0.head_section_title AS head_section_title_33, t0.head_section_content AS head_section_content_34, t0.validation_goal AS validation_goal_35, t0.professional_outlet_intro AS professional_outlet_intro_36, t0.professional_outlet_places AS professional_outlet_places_37, t0.professional_outlet_outro AS professional_outlet_outro_38, t0.participant_number AS participant_number_39, t0.place AS place_40, t0.market_label AS market_label_41, t0.open_to_all AS open_to_all_42, t0.public_in_difficulty AS public_in_difficulty_43, t0.duration_in_day_min AS duration_in_day_min_44, t0.duration_in_day_max AS duration_in_day_max_45, t0.goal_short_training AS goal_short_training_46, t0.tools AS tools_47, t0.teaching_method AS teaching_method_48, t0.access_modalities AS access_modalities_49, t0.program_short_training AS program_short_training_50, t0.accessibility_info AS accessibility_info_51, t0.summary AS summary_52, t0.evaluation_methods AS evaluation_methods_53, t0.benefits_list AS benefits_list_54, t0.price_inter AS price_inter_55, t0.price_intra AS price_intra_56, t0.price_inter_remote AS price_inter_remote_57, t0.price_intra_remote AS price_intra_remote_58 FROM training t0 WHERE t0.front_page = ? AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1
Parameters:
[
  1
]
5 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.category_id AS category_id_24, t0.discr, t0.target_profile AS target_profile_25, t0.price AS price_26, t0.dead_line AS dead_line_27, t0.certificate AS certificate_28, t0.goal AS goal_29, t0.presentation AS presentation_30, t0.program AS program_31, t0.success_rate AS success_rate_32, t0.head_section_title AS head_section_title_33, t0.head_section_content AS head_section_content_34, t0.validation_goal AS validation_goal_35, t0.professional_outlet_intro AS professional_outlet_intro_36, t0.professional_outlet_places AS professional_outlet_places_37, t0.professional_outlet_outro AS professional_outlet_outro_38, t0.participant_number AS participant_number_39, t0.place AS place_40, t0.market_label AS market_label_41, t0.open_to_all AS open_to_all_42, t0.public_in_difficulty AS public_in_difficulty_43, t0.duration_in_day_min AS duration_in_day_min_44, t0.duration_in_day_max AS duration_in_day_max_45, t0.goal_short_training AS goal_short_training_46, t0.tools AS tools_47, t0.teaching_method AS teaching_method_48, t0.access_modalities AS access_modalities_49, t0.program_short_training AS program_short_training_50, t0.accessibility_info AS accessibility_info_51, t0.summary AS summary_52, t0.evaluation_methods AS evaluation_methods_53, t0.benefits_list AS benefits_list_54, t0.price_inter AS price_inter_55, t0.price_intra AS price_intra_56, t0.price_inter_remote AS price_inter_remote_57, t0.price_intra_remote AS price_intra_remote_58 FROM training t0 WHERE t0.front_page = ? AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1
Parameters:
[
  1
]
6 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
  5
]
7 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.catch_phrase AS catch_phrase_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.body AS body_6, t0.cta_text AS cta_text_7, t0.cta_link AS cta_link_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.video_link AS video_link_11, t0.published AS published_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.slug AS slug_15, t0.body_second AS body_second_16, t0.category_id AS category_id_17 FROM article t0 ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[]

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\Article No errors.
App\Entity\ArticleCategory No errors.
App\Entity\ArticleTag No errors.
App\Entity\Training No errors.
App\Entity\TrainingCategory No errors.
App\Entity\DiplomaTraining No errors.
App\Entity\ShortTraining No errors.
App\Entity\JobOpening No errors.
App\Entity\Session No errors.
App\Entity\Registration No errors.
App\Entity\Alumni
  • The association App\Entity\Alumni#training refers to the inverse side field App\Entity\Training#alumnis which does not exist.
App\Entity\EducationalTeam
  • The association App\Entity\EducationalTeam#training refers to the inverse side field App\Entity\Training#educationalTeams which does not exist.