Symfony Profiler

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
          AND p1_.is_register = 1
        ORDER BY
          c0_.id ASC
      ) dctrn_result
  ) dctrn_table

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 AND p1_.is_register = 1 ORDER BY c0_.id ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
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,
          p1_.id AS id_19,
          p1_.name AS name_20,
          p1_.slug AS slug_21,
          p1_.status AS status_22,
          p1_.pace AS pace_23,
          p1_.rncp AS rncp_24,
          p1_.metadata AS metadata_25,
          p1_.description AS description_26,
          p1_.entreprise AS entreprise_27,
          p1_.speciality_id AS speciality_id_28,
          p1_.ordering AS ordering_29,
          p1_.is_register AS is_register_30,
          p1_.is_initial AS is_initial_31,
          p1_.is_alternance AS is_alternance_32,
          p1_.year AS year_33,
          p1_.rncp_level AS rncp_level_34,
          p1_.qcm_list AS qcm_list_35,
          p1_.entrance_fee AS entrance_fee_36,
          p1_.total_payment AS total_payment_37,
          p1_.old_slug AS old_slug_38,
          p1_.is_opening AS is_opening_39,
          p1_.is_international AS is_international_40,
          p1_.subtitle AS subtitle_41,
          p1_.link_out_side AS link_out_side_42,
          p1_.admin_program AS admin_program_43,
          p1_.widget AS widget_44,
          p1_.ranking AS ranking_45,
          p1_.information AS information_46,
          p1_.type AS type_47,
          p1_.overview_images AS overview_images_48,
          p1_.currency AS currency_49,
          p1_.created_date AS created_date_50,
          p1_.updated_date AS updated_date_51,
          p1_.seo_title AS seo_title_52,
          p1_.seo_h1 AS seo_h1_53,
          p1_.seo_keyword AS seo_keyword_54,
          p1_.seo_description AS seo_description_55
        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 p1_.is_register = 1
      ) dctrn_result_inner
    ORDER BY
      id_0 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 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, p1_.id AS id_19, p1_.name AS name_20, p1_.slug AS slug_21, p1_.status AS status_22, p1_.pace AS pace_23, p1_.rncp AS rncp_24, p1_.metadata AS metadata_25, p1_.description AS description_26, p1_.entreprise AS entreprise_27, p1_.speciality_id AS speciality_id_28, p1_.ordering AS ordering_29, p1_.is_register AS is_register_30, p1_.is_initial AS is_initial_31, p1_.is_alternance AS is_alternance_32, p1_.year AS year_33, p1_.rncp_level AS rncp_level_34, p1_.qcm_list AS qcm_list_35, p1_.entrance_fee AS entrance_fee_36, p1_.total_payment AS total_payment_37, p1_.old_slug AS old_slug_38, p1_.is_opening AS is_opening_39, p1_.is_international AS is_international_40, p1_.subtitle AS subtitle_41, p1_.link_out_side AS link_out_side_42, p1_.admin_program AS admin_program_43, p1_.widget AS widget_44, p1_.ranking AS ranking_45, p1_.information AS information_46, p1_.type AS type_47, p1_.overview_images AS overview_images_48, p1_.currency AS currency_49, p1_.created_date AS created_date_50, p1_.updated_date AS updated_date_51, p1_.seo_title AS seo_title_52, p1_.seo_h1 AS seo_h1_53, p1_.seo_keyword AS seo_keyword_54, p1_.seo_description AS seo_description_55 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 p1_.is_register = 1) dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 50;

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 p1_.is_register = 1
  AND c0_.id IN (?, ?, ?, ?)
ORDER BY
  c0_.id ASC

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 p1_.is_register = 1 AND c0_.id IN (1, 2, 3, 4) ORDER BY c0_.id ASC;

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 = ?

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 = 1;

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 = ?

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 = 1;

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 = ?

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 = 4;

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 = ?

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 = 5;

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 = ?

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 = 6;

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 = ?

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 = 2;

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 = ?

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 = 7;

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 = ?

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 = 3;

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 = ?

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 = 1;

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 = ?

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 = 1;

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 = ?

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 = 1114;

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 = ?

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 = 49;

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 = ?

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 = 1113;

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 = ?

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 = 50;

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 = ?

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 = 1119;

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 = ?

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 = 51;

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 = ?

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 = 1;

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 = ?

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 = 2;

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 = ?

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 = 2;