Query Metrics
10
Database Queries
7
Different statements
3.42 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.66 ms (48.64%) |
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
]
|
0.53 ms (15.47%) |
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.slug = ? AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1
Parameters:
[
"bpjeps-apt"
]
|
0.36 ms (10.44%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.training_id AS training_id_4 FROM job_opening t0 WHERE t0.training_id = ?
Parameters:
[
5
]
|
0.26 ms (7.74%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.quote AS quote_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.training_id AS training_id_9 FROM alumni t0 WHERE t0.training_id = ?
Parameters:
[
5
]
|
0.23 ms (6.64%) |
1 |
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:
[
3
]
|
0.19 ms (5.55%) |
1 |
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:
[
5
]
|
0.19 ms (5.52%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.job AS job_4, t0.testimonial AS testimonial_5, t0.image_name AS image_name_6, t0.image_size AS image_size_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.training_id AS training_id_10 FROM educational_team t0 WHERE t0.training_id = ?
Parameters:
[
5
]
|
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\LeadCatalog | No errors. |
App\Entity\LeadCatalogSession | No errors. |
App\Entity\AlumniHighlight | No errors. |
App\Entity\LeadCatalogTrainingCategory | No errors. |