Query Metrics

68 Database Queries
25 Different statements
137.82 ms Query time
4 Invalid entities
252 Managed entities

Queries

Group similar statements

# 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
]
59 0.58 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:
[
  1169
]
60 0.49 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:
[
  1093
]
61 0.46 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:
[
  1084
]
62 2.01 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0
Parameters:
[]
63 1.90 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 program_campus p2_ ON c0_.id = p2_.campus_id LEFT JOIN program p1_ ON p1_.id = p2_.program_id WHERE p1_.status = 1) dctrn_result) dctrn_table
Parameters:
[]
64 0.79 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 program_campus p2_ ON c0_.id = p2_.campus_id LEFT JOIN program p1_ ON p1_.id = p2_.program_id WHERE p1_.status = 1) dctrn_result LIMIT 50
Parameters:
[]
65 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 program_campus p2_ ON c0_.id = p2_.campus_id LEFT JOIN program p1_ ON p1_.id = p2_.program_id WHERE p1_.status = 1 AND c0_.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  4
  3
  6
  7
  5
]
66 1.06 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
]
67 0.80 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
]
68 0.99 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
]

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\Campus 8
App\Entity\CampusImage 8
App\Entity\Manager 8
App\Entity\ProgramLevel 7
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
  • The mappings App\Entity\Profile#commercial and App\Entity\User#profiles are inconsistent with each other.
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
  • The mappings App\Entity\User#nationality and App\Entity\Country#users are inconsistent with each other.
  • The association App\Entity\User#campuses refers to the inverse side field App\Entity\Campus#users which does not exist.
App\Entity\Partenaire No errors.
App\Entity\Parameter No errors.
App\Entity\Slider No errors.
App\Entity\StudyLevel No errors.
App\Entity\EnglishLevel No errors.
App\Entity\ProfileFile No errors.
App\Entity\Jury No errors.
App\Entity\Oraux No errors.
App\Entity\Status No errors.
App\Entity\Campaign
  • The field 'App\Entity\Campaign#type' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\ProfileNote No errors.
App\Entity\MediaChannel No errors.
App\Entity\Landingpage No errors.
App\Entity\ProfileQcm No errors.
App\Entity\OpenDayPerson
  • The association App\Entity\OpenDayPerson#campus refers to the inverse side field App\Entity\Campus#openDayPeople which does not exist.
App\Entity\Task No errors.
App\Entity\Notification No errors.
App\Entity\ProfileSource No errors.
App\Entity\Site No errors.
App\Entity\Source No errors.
App\Entity\Payment No errors.
App\Entity\Contract No errors.
App\Entity\CvType No errors.
App\Entity\ContractType No errors.
App\Entity\WorkStudy No errors.
App\Entity\AcademicImage No errors.
App\Entity\QcmQuestion No errors.
App\Entity\Role No errors.