Query Metrics
58
Database Queries
21
Different statements
127.69 ms
Query time
2
Invalid entities
250
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 27.29 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type IN (?, ?) ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table
Parameters:
[ 1 1 2 ] |
| 2 | 1.95 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type IN (?, ?)) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 3
Parameters:
[ 1 1 2 ] |
| 3 | 0.76 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ WHERE n0_.status = ? AND n0_.type IN (?, ?) AND n0_.id IN (?, ?, ?) ORDER BY n0_.published_time DESC
Parameters:
[ 1 1 2 779 777 776 ] |
| 4 | 4.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters:
[
779
]
|
| 5 | 2.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1426
]
|
| 6 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters:
[
777
]
|
| 7 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters:
[
776
]
|
| 8 | 2.24 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ INNER JOIN campus_image c1_ ON c0_.id = c1_.campus_id) dctrn_result) dctrn_table
Parameters:
[] |
| 9 | 0.60 ms |
SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ INNER JOIN campus_image c1_ ON c0_.id = c1_.campus_id) dctrn_result LIMIT 50
Parameters:
[] |
| 10 | 0.63 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ INNER JOIN campus_image c1_ ON c0_.id = c1_.campus_id WHERE c0_.id IN (?, ?, ?, ?, ?)
Parameters:
[ 1 2 5 7 8 ] |
| 11 | 1.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
1
]
|
| 12 | 24.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
1
]
|
| 13 | 1.94 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 14 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 15 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 16 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 17 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 18 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 19 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 20 | 3.89 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
1
]
|
| 21 | 1.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1114
]
|
| 22 | 2.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
49
]
|
| 23 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1113
]
|
| 24 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
50
]
|
| 25 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1119
]
|
| 26 | 0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
51
]
|
| 27 | 1.84 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 28 | 0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
2
]
|
| 29 | 1.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
2
]
|
| 30 | 0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
2
]
|
| 31 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1106
]
|
| 32 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
48
]
|
| 33 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
65
]
|
| 34 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
5
]
|
| 35 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
5
]
|
| 36 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
5
]
|
| 37 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
7
]
|
| 38 | 0.73 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
7
]
|
| 39 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
7
]
|
| 40 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1112
]
|
| 41 | 0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
54
]
|
| 42 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
66
]
|
| 43 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.campus_id AS campus_id_4 FROM campus_image t0 WHERE t0.campus_id = ?
Parameters:
[
8
]
|
| 44 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.pace AS pace_5, t0.rncp AS rncp_6, t0.metadata AS metadata_7, t0.description AS description_8, t0.entreprise AS entreprise_9, t0.speciality_id AS speciality_id_10, t0.ordering AS ordering_11, t0.is_register AS is_register_12, t0.is_initial AS is_initial_13, t0.is_alternance AS is_alternance_14, t0.year AS year_15, t0.rncp_level AS rncp_level_16, t0.qcm_list AS qcm_list_17, t0.entrance_fee AS entrance_fee_18, t0.total_payment AS total_payment_19, t0.old_slug AS old_slug_20, t0.is_opening AS is_opening_21, t0.is_international AS is_international_22, t0.subtitle AS subtitle_23, t0.link_out_side AS link_out_side_24, t0.admin_program AS admin_program_25, t0.widget AS widget_26, t0.ranking AS ranking_27, t0.information AS information_28, t0.type AS type_29, t0.overview_images AS overview_images_30, t0.currency AS currency_31, t0.created_date AS created_date_32, t0.updated_date AS updated_date_33, t0.seo_title AS seo_title_34, t0.seo_h1 AS seo_h1_35, t0.seo_keyword AS seo_keyword_36, t0.seo_description AS seo_description_37, t0.brochure_id AS brochure_id_38, t0.media_id AS media_id_39, t0.director_image_id AS director_image_id_40, t0.review_image_id AS review_image_id_41, t0.intervenant_image_id AS intervenant_image_id_42, t0.prerequisites_image_id AS prerequisites_image_id_43, t0.cost_training_image_id AS cost_training_image_id_44, t0.outcomes_image_id AS outcomes_image_id_45, t0.level_id AS level_id_46, t0.domain_id AS domain_id_47, t0.alumni_interview_poster_id AS alumni_interview_poster_id_48, t0.plus_formation_file_id AS plus_formation_file_id_49 FROM program t0 INNER JOIN program_campus ON t0.id = program_campus.program_id WHERE program_campus.campus_id = ?
Parameters:
[
8
]
|
| 45 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.service AS service_3, t0.position AS position_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.title AS title_7, t0.image_id AS image_id_8 FROM manager t0 INNER JOIN campus_manager ON t0.id = campus_manager.manager_id WHERE campus_manager.campus_id = ?
Parameters:
[
8
]
|
| 46 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
1115
]
|
| 47 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN manager_campus ON t0.id = manager_campus.campus_id WHERE manager_campus.manager_id = ?
Parameters:
[
46
]
|
| 48 | 5.88 ms |
SELECT p0_.id AS id_0, p0_.metadata AS metadata_1, p0_.home_page AS home_page_2 FROM parameter p0_ WHERE p0_.id = ? LIMIT 1
Parameters:
[
1
]
|
| 49 | 0.44 ms |
SELECT p0_.id AS id_0, p0_.metadata AS metadata_1, p0_.home_page AS home_page_2 FROM parameter p0_ WHERE p0_.id = ? LIMIT 1
Parameters:
[
2
]
|
| 50 | 11.50 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.event_date AS event_date_2, s0_.status AS status_3, s0_.event_time AS event_time_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.campus_id AS campus_id_7 FROM spo_date s0_ LEFT JOIN campus c1_ ON s0_.campus_id = c1_.id WHERE c1_.id = ? AND s0_.status = 1 AND s0_.event_date >= ? ORDER BY s0_.event_date ASC LIMIT 1
Parameters:
[ 1 "2026-03-09" ] |
| 51 | 0.65 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.event_date AS event_date_2, s0_.status AS status_3, s0_.event_time AS event_time_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.campus_id AS campus_id_7 FROM spo_date s0_ LEFT JOIN campus c1_ ON s0_.campus_id = c1_.id WHERE c1_.id = ? AND s0_.status = 1 AND s0_.event_date >= ? ORDER BY s0_.event_date ASC LIMIT 1
Parameters:
[ 2 "2026-03-09" ] |
| 52 | 3.76 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p1_ ON p0_.id = p1_.group_id INNER JOIN program p2_ ON p1_.id = p2_.level_id WHERE p2_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC
Parameters:
[] |
| 53 | 6.16 ms |
SELECT t0.id AS id_1, t0.site AS site_2, t0.subtitle AS subtitle_3, t0.position AS position_4, t0.status AS status_5, t0.youtube_url AS youtube_url_6, t0.created_date AS created_date_7, t0.updated_date AS updated_date_8, t0.image_id AS image_id_9 FROM slider t0 WHERE t0.status = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
| 54 | 0.94 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p1_ ON p0_.id = p1_.group_id INNER JOIN program p2_ ON p1_.id = p2_.level_id WHERE p2_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC
Parameters:
[] |
| 55 | 3.02 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters:
[ 1 2 4 ] |
| 56 | 0.87 ms |
SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters:
[ 1 2 4 ] |
| 57 | 1.05 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?) AND c0_.id IN (?, ?, ?)
Parameters:
[ 1 2 4 1 2 4 ] |
| 58 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?
Parameters:
[
96
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Media | 143 |
| App\Entity\Program | 56 |
| App\Entity\CampusImage | 8 |
| App\Entity\Manager | 8 |
| App\Entity\ProgramLevel | 7 |
| App\Entity\Campus | 6 |
| App\Entity\ProgramDomain | 5 |
| App\Entity\ProgramLevelGroup | 4 |
| App\Entity\Slider | 4 |
| App\Entity\News | 3 |
| App\Entity\Country | 2 |
| App\Entity\Zone | 2 |
| App\Entity\Parameter | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\News | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Campus | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Profile |
|
| App\Entity\Manager | No errors. |
| App\Entity\SpoDate | No errors. |
| App\Entity\CampusImage | No errors. |
| App\Entity\AcademicPartner | No errors. |
| App\Entity\ProgramLevel | No errors. |
| App\Entity\ProgramDomain | No errors. |
| App\Entity\Qcm | No errors. |
| App\Entity\Cursus | No errors. |
| App\Entity\Spo | No errors. |
| App\Entity\ProgramLevelGroup | No errors. |
| App\Entity\Zone | No errors. |
| App\Entity\User |
|
| App\Entity\Partenaire | No errors. |
| App\Entity\Parameter | No errors. |
| App\Entity\Slider | No errors. |