Symfony Profiler

Query Metrics

64 Database Queries

15 Different statements

52.80 ms Query time

7 Invalid entities

55 Managed entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.photo AS photo_4, t0.ordering AS ordering_5, t0.status AS status_6, t0.url AS url_7, t0.youtube_url AS youtube_url_8, t0.logo_id AS logo_id_9 FROM academic_partner t0 WHERE t0.status = ?
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.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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 = ?
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 FROM program_level_group 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 = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_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 = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_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 = ?
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 FROM program_level_group t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_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 = ?
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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 = ?
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 FROM program_level_group t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_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 = ?
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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ?
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
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
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
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 (?, ?, ?)
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 = ?
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
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
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 (?, ?, ?)

#▲	Time	Info
1	6.99 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.photo AS photo_4, t0.ordering AS ordering_5, t0.status AS status_6, t0.url AS url_7, t0.youtube_url AS youtube_url_8, t0.logo_id AS logo_id_9 FROM academic_partner t0 WHERE t0.status = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.photo AS photo_4, t0.ordering AS ordering_5, t0.status AS status_6, t0.url AS url_7, t0.youtube_url AS youtube_url_8, t0.logo_id AS logo_id_9 FROM academic_partner t0 WHERE t0.status = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.photo AS photo_4, t0.ordering AS ordering_5, t0.status AS status_6, t0.url AS url_7, t0.youtube_url AS youtube_url_8, t0.logo_id AS logo_id_9 FROM academic_partner t0 WHERE t0.status = 1;
2	0.50 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: [`1391`] View formatted query View runnable query Explain query 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 = 1391;
3	3.33 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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_id = 1;
4	5.54 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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_id = 1;
5	0.69 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`55`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 55;
6	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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`56`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 56;
7	0.48 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`59`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 59;
8	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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`69`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 69;
9	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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`115`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 115;
10	0.51 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`116`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 116;
11	0.46 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`117`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 117;
12	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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`118`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 118;
13	0.40 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`119`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 119;
14	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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`120`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 120;
15	0.59 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`124`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 124;
16	0.42 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`125`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 125;
17	0.33 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`] View formatted query View runnable query Explain query 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;
18	0.36 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 FROM program_level_group t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 FROM program_level_group 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 FROM program_level_group t0 WHERE t0.id = 1;
19	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: [`1073`] View formatted query View runnable query Explain query 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 = 1073;
20	0.51 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 55;
21	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`56`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 56;
22	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: [`1074`] View formatted query View runnable query Explain query 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 = 1074;
23	0.61 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`59`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 59;
24	0.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`69`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 69;
25	0.56 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`115`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 115;
26	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = 1;
27	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`116`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 116;
28	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`117`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 117;
29	0.38 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`] View formatted query View runnable query Explain query 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;
30	0.36 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 FROM program_level_group t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 FROM program_level_group 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 FROM program_level_group t0 WHERE t0.id = 2;
31	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`124`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 124;
32	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`118`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 118;
33	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`119`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 119;
34	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`120`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 120;
35	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`125`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 125;
36	3.28 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = 1;
37	0.55 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: [`1396`] View formatted query View runnable query Explain query 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 = 1396;
38	0.70 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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_id = 2;
39	0.81 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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_id = 2;
40	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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`100`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 100;
41	0.46 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`148`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 148;
42	0.41 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`149`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 149;
43	0.32 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`] View formatted query View runnable query Explain query 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;
44	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 FROM program_level_group t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 FROM program_level_group 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 FROM program_level_group t0 WHERE t0.id = 3;
45	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`100`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 100;
46	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`148`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 148;
47	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = 2;
48	0.38 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`149`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 149;
49	0.34 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = 2;
50	0.40 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: [`1397`] View formatted query View runnable query Explain query 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 = 1397;
51	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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_id = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_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 academic_partner_campus ON t0.id = academic_partner_campus.campus_id WHERE academic_partner_campus.academic_partner_id = 3;
52	0.61 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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_id = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_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 academic_partner_program ON t0.id = academic_partner_program.program_id WHERE academic_partner_program.academic_partner_id = 3;
53	0.50 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ? Parameters: [`123`] View formatted query View runnable query Explain query 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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_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 program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = 123;
54	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? Parameters: [`123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.times AS times_3, t0.sub_title AS sub_title_4, t0.created_date AS created_date_5, t0.updated_date AS updated_date_6 FROM qcm t0 INNER JOIN program_qcm ON t0.id = program_qcm.qcm_id WHERE program_qcm.program_id = 123;
55	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.academic_partner_id AS academic_partner_id_4 FROM academic_image t0 WHERE t0.academic_partner_id = 3;
56	1.07 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: [] View formatted query View runnable query Explain query 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 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;
57	2.76 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`] View formatted query View runnable query Explain query 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 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 (1, 2, 4)) dctrn_result) dctrn_table;
58	1.07 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`] View formatted query View runnable query Explain query 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 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 (1, 2, 4)) dctrn_result LIMIT 50;
59	1.22 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`] View formatted query View runnable query Explain query 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 (?, ?, ?) 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 (1, 2, 4) AND c0_.id IN (1, 2, 4);
60	0.49 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`] View formatted query View runnable query Explain query 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;
61	0.50 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`] View formatted query View runnable query Explain query 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 = 96;
62	1.10 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`] View formatted query View runnable query Explain query 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 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 (1, 2, 4)) dctrn_result) dctrn_table;
63	0.86 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`] View formatted query View runnable query Explain query 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 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 (1, 2, 4)) dctrn_result LIMIT 50;
64	1.31 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`] View formatted query View runnable query Explain query 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 (?, ?, ?) 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 (1, 2, 4) AND c0_.id IN (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\Program	16
App\Entity\Campus	7
App\Entity\AcademicImage	7
App\Entity\Media	5
App\Entity\Qcm	5
App\Entity\AcademicPartner	3
App\Entity\ProgramLevel	3
App\Entity\ProgramLevelGroup	3
App\Entity\ProgramDomain	2
App\Entity\Country	2
App\Entity\Zone	2

Entities Mapping

Class	Mapping errors
App\Entity\AcademicPartner	No errors.
App\Entity\Media	No errors.
App\Entity\AcademicImage	No errors.
App\Entity\Program	No errors.
App\Entity\Campus	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\News	No errors.
App\Entity\Manager	No errors.
App\Entity\SpoDate	No errors.
App\Entity\CampusImage	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\QcmQuestion	No errors.
App\Entity\ProfileQcm	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\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\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\Role	No errors.
App\Entity\OpenDay	The association App\Entity\OpenDay#campuses refers to the inverse side field App\Entity\Campus#openDay which does not exist.
App\Entity\LandingpageFile	No errors.
App\Entity\SourceBudget	No errors.
App\Entity\Enterprise	No errors.
App\Entity\EnterpriseTutor	No errors.
App\Entity\EnterpriseStaff	No errors.
App\Entity\ProfileStep	No errors.
App\Entity\EnterpriseAddress	No errors.
App\Entity\Bill	No errors.
App\Entity\Opco	The mappings App\Entity\Opco#opcoAddresses and App\Entity\OpcoAddress#opco are inconsistent with each other.
App\Entity\OpcoAddress	The association App\Entity\OpcoAddress#opco refers to the inverse side field App\Entity\Opco#opcoAddesses which does not exist.
App\Entity\OpcoContact	No errors.
App\Entity\CandidateStatus	No errors.
App\Entity\Permission	No errors.

Symfony Profiler

GET https://financia-symfony.silkwires-dev.com/partenaires-academiques.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping