Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

1 Different statements

1.68 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.68 ms (100.00%)	4	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`] View formatted query View runnable query Explain query 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 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 = 1 AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1;

Time▼

Count

Info

1.68 ms
(100.00%)

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
]

View formatted query View runnable query Explain query

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

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 = 1 AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1;

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\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.

Symfony Profiler

https://qa.qwantic.co/dispositifs

Configuration Settings

Theme