Query Metrics
11
Database Queries
5
Different statements
3.69 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.60 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.slug = ? AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1
Parameters:
[
"le-pouvoir-des-mots"
]
|
| 2 | 0.28 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.place AS place_6, t0.duration_in_month AS duration_in_month_7, t0.training_file AS training_file_8, t0.remote AS remote_9, t0.training_id AS training_id_10 FROM session t0 WHERE t0.training_id = ?
Parameters:
[
12
]
|
| 3 | 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
]
|
| 4 | 0.44 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.36 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.35 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
]
|
| 7 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.color AS color_4, t0.slug AS slug_5, t0.catalog AS catalog_6 FROM training_category t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 8 | 0.37 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.ranking AS ranking_2, t0_.slug AS slug_3, t0_.is_visible AS is_visible_4, t0_.front_page AS front_page_5, t0_.catch_phrase AS catch_phrase_6, t0_.prerequisite AS prerequisite_7, t0_.header_desktop_name AS header_desktop_name_8, t0_.header_desktop_size AS header_desktop_size_9, t0_.header_mobile_name AS header_mobile_name_10, t0_.header_mobile_size AS header_mobile_size_11, t0_.card_image_name AS card_image_name_12, t0_.card_image_size AS card_image_size_13, t0_.band_image_name AS band_image_name_14, t0_.band_image_size AS band_image_size_15, t0_.created_at AS created_at_16, t0_.updated_at AS updated_at_17, t0_.eligible_cpf AS eligible_cpf_18, t0_.job_opening_content_intro AS job_opening_content_intro_19, t0_.meta_title AS meta_title_20, t0_.meta_description AS meta_description_21, t0_.acronym AS acronym_22, t0_.participant_number AS participant_number_23, t0_.place AS place_24, t0_.market_label AS market_label_25, t0_.open_to_all AS open_to_all_26, t0_.public_in_difficulty AS public_in_difficulty_27, t0_.duration_in_day_min AS duration_in_day_min_28, t0_.duration_in_day_max AS duration_in_day_max_29, t0_.goal_short_training AS goal_short_training_30, t0_.tools AS tools_31, t0_.teaching_method AS teaching_method_32, t0_.access_modalities AS access_modalities_33, t0_.program_short_training AS program_short_training_34, t0_.accessibility_info AS accessibility_info_35, t0_.summary AS summary_36, t0_.evaluation_methods AS evaluation_methods_37, t0_.benefits_list AS benefits_list_38, t0_.price_inter AS price_inter_39, t0_.price_intra AS price_intra_40, t0_.price_inter_remote AS price_inter_remote_41, t0_.price_intra_remote AS price_intra_remote_42, t0_.discr AS discr_43, t0_.category_id AS category_id_44 FROM training t0_ WHERE (t0_.id <> ?) AND t0_.discr IN ('shortTraining') LIMIT 3
Parameters:
[
12
]
|
| 9 | 0.22 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.place AS place_6, t0.duration_in_month AS duration_in_month_7, t0.training_file AS training_file_8, t0.remote AS remote_9, t0.training_id AS training_id_10 FROM session t0 WHERE t0.training_id = ?
Parameters:
[
11
]
|
| 10 | 0.21 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.place AS place_6, t0.duration_in_month AS duration_in_month_7, t0.training_file AS training_file_8, t0.remote AS remote_9, t0.training_id AS training_id_10 FROM session t0 WHERE t0.training_id = ?
Parameters:
[
13
]
|
| 11 | 0.18 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.place AS place_6, t0.duration_in_month AS duration_in_month_7, t0.training_file AS training_file_8, t0.remote AS remote_9, t0.training_id AS training_id_10 FROM session t0 WHERE t0.training_id = ?
Parameters:
[
14
]
|
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 |
|
| App\Entity\EducationalTeam |
|
| App\Entity\AlumniHighlight | No errors. |
| App\Entity\LeadCatalog | No errors. |
| App\Entity\LeadCatalogTrainingCategory | No errors. |