GET https://financia-symfony.silkwires-dev.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CFrontend%255CPartialController%2…

Response
200 OK
Browse referrer URL
IP
216.73.216.106
Profiled on
Token
55a8f8

Query Metrics

285 Database Queries
48 Different statements
118.62 ms Query time
2 Invalid entities
238 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.61 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
2 0.96 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
3 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
4 0.89 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ? ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table
Parameters: 
[
  1
  2
  1
]
View formatted query    View runnable query    Explain query
5 0.81 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, c1_.id AS id_17, c1_.name AS name_18, c1_.slug AS slug_19, c1_.status AS status_20, c1_.ordering AS ordering_21, c1_.city AS city_22, c1_.youtube_url AS youtube_url_23, c1_.link360 AS link360_24, c1_.address AS address_25, c1_.cp AS cp_26, c1_.description AS description_27, c1_.is_main AS is_main_28, c1_.google_map AS google_map_29, c1_.created_date AS created_date_30, c1_.updated_date AS updated_date_31, c1_.seo_title AS seo_title_32, c1_.seo_h1 AS seo_h1_33, c1_.seo_keyword AS seo_keyword_34, c1_.seo_description AS seo_description_35 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ?) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 3
Parameters: 
[
  1
  2
  1
]
View formatted query    View runnable query    Explain query
6 0.65 ms 
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ? AND n0_.id IN (?, ?, ?) ORDER BY n0_.published_time DESC
Parameters: 
[
  1
  2
  1
  779
  777
  733
]
View formatted query    View runnable query    Explain query
7 1.16 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters: 
[
  779
]
View formatted query    View runnable query    Explain query
8 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: 
[
  1426
]
View formatted query    View runnable query    Explain query
9 0.72 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters: 
[
  777
]
View formatted query    View runnable query    Explain query
10 0.41 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: 
[
  1034
]
View formatted query    View runnable query    Explain query
11 0.58 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters: 
[
  733
]
View formatted query    View runnable query    Explain query
12 0.54 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["5"]"
]
View formatted query    View runnable query    Explain query
13 0.37 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
14 0.54 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result) dctrn_table
Parameters: 
[
  55
  56
  57
  59
  60
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
15 0.45 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result LIMIT 50
Parameters: 
[
  55
  56
  57
  59
  60
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
16 0.45 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?)
Parameters: 
[
  55
  56
  57
  59
  60
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
17 0.46 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["3"]"
]
View formatted query    View runnable query    Explain query
18 0.37 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
19 0.49 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result) dctrn_table
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
20 0.49 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result LIMIT 50
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
21 0.38 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?)
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
  49
  50
  51
]
View formatted query    View runnable query    Explain query
22 0.44 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["4"]"
]
View formatted query    View runnable query    Explain query
23 0.30 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
24 0.46 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result) dctrn_table
Parameters: 
[
  48
  52
  53
  54
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
25 0.43 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result LIMIT 50
Parameters: 
[
  48
  52
  53
  54
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
]
View formatted query    View runnable query    Explain query
26 0.41 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?)
Parameters: 
[
  48
  52
  53
  54
  49
  50
  51
  52
  53
  54
  55
  57
  59
  60
  52
  53
  54
]
View formatted query    View runnable query    Explain query
27 1.16 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36 FROM program p0_ INNER JOIN program_campus p2_ ON p0_.id = p2_.program_id INNER JOIN campus c1_ ON c1_.id = p2_.campus_id INNER JOIN program_level p3_ ON p0_.level_id = p3_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?) ORDER BY p3_.id ASC, p0_.name ASC) dctrn_result) dctrn_table
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
28 1.24 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, id_56, name_1 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36, c1_.id AS id_37, c1_.name AS name_38, c1_.slug AS slug_39, c1_.status AS status_40, c1_.ordering AS ordering_41, c1_.city AS city_42, c1_.youtube_url AS youtube_url_43, c1_.link360 AS link360_44, c1_.address AS address_45, c1_.cp AS cp_46, c1_.description AS description_47, c1_.is_main AS is_main_48, c1_.google_map AS google_map_49, c1_.created_date AS created_date_50, c1_.updated_date AS updated_date_51, c1_.seo_title AS seo_title_52, c1_.seo_h1 AS seo_h1_53, c1_.seo_keyword AS seo_keyword_54, c1_.seo_description AS seo_description_55, p2_.id AS id_56, p2_.name AS name_57, p2_.slug AS slug_58, p2_.created_date AS created_date_59, p2_.updated_date AS updated_date_60 FROM program p0_ INNER JOIN program_campus p3_ ON p0_.id = p3_.program_id INNER JOIN campus c1_ ON c1_.id = p3_.campus_id INNER JOIN program_level p2_ ON p0_.level_id = p2_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?)) dctrn_result_inner ORDER BY id_56 ASC, name_1 ASC) dctrn_result LIMIT 50
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
29 2.72 ms 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36, p0_.brochure_id AS brochure_id_37, p0_.media_id AS media_id_38, p0_.director_image_id AS director_image_id_39, p0_.review_image_id AS review_image_id_40, p0_.intervenant_image_id AS intervenant_image_id_41, p0_.prerequisites_image_id AS prerequisites_image_id_42, p0_.cost_training_image_id AS cost_training_image_id_43, p0_.outcomes_image_id AS outcomes_image_id_44, p0_.level_id AS level_id_45, p0_.domain_id AS domain_id_46, p0_.alumni_interview_poster_id AS alumni_interview_poster_id_47, p0_.plus_formation_file_id AS plus_formation_file_id_48 FROM program p0_ INNER JOIN program_campus p2_ ON p0_.id = p2_.program_id INNER JOIN campus c1_ ON c1_.id = p2_.campus_id INNER JOIN program_level p3_ ON p0_.level_id = p3_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p3_.id ASC, p0_.name ASC
Parameters: 
[
  1
  59
  69
  27
  80
  48
  23
  2
  1
  92
  102
  81
  93
  3
  77
  21
  4
  20
  10
  34
  95
  83
  153
  150
  151
  17
  152
  37
  79
]
View formatted query    View runnable query    Explain query
30 0.53 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
31 0.42 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
32 0.58 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1074
]
View formatted query    View runnable query    Explain query
33 0.80 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
34 2.90 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
35 0.58 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
36 0.46 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
37 0.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
38 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 FROM program_level_group t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
39 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1063
]
View formatted query    View runnable query    Explain query
40 0.55 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
41 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  904
]
View formatted query    View runnable query    Explain query
42 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  905
]
View formatted query    View runnable query    Explain query
43 0.36 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: 
[
  903
]
View formatted query    View runnable query    Explain query
44 0.42 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: 
[
  902
]
View formatted query    View runnable query    Explain query
45 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: 
[
  1332
]
View formatted query    View runnable query    Explain query
46 1.87 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: 
[
  27
]
View formatted query    View runnable query    Explain query
47 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
48 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: 
[
  80
]
View formatted query    View runnable query    Explain query
49 0.35 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: 
[
  936
]
View formatted query    View runnable query    Explain query
50 0.29 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: 
[
  937
]
View formatted query    View runnable query    Explain query
51 0.29 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: 
[
  935
]
View formatted query    View runnable query    Explain query
52 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  934
]
View formatted query    View runnable query    Explain query
53 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: 
[
  80
]
View formatted query    View runnable query    Explain query
54 0.29 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
55 0.28 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: 
[
  1167
]
View formatted query    View runnable query    Explain query
56 0.49 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: 
[
  48
]
View formatted query    View runnable query    Explain query
57 0.30 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: 
[
  947
]
View formatted query    View runnable query    Explain query
58 0.30 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: 
[
  948
]
View formatted query    View runnable query    Explain query
59 0.30 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: 
[
  946
]
View formatted query    View runnable query    Explain query
60 0.27 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: 
[
  945
]
View formatted query    View runnable query    Explain query
61 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: 
[
  48
]
View formatted query    View runnable query    Explain query
62 0.28 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
63 0.25 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: 
[
  1061
]
View formatted query    View runnable query    Explain query
64 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: 
[
  23
]
View formatted query    View runnable query    Explain query
65 0.28 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: 
[
  991
]
View formatted query    View runnable query    Explain query
66 0.35 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: 
[
  992
]
View formatted query    View runnable query    Explain query
67 0.29 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: 
[
  989
]
View formatted query    View runnable query    Explain query
68 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  988
]
View formatted query    View runnable query    Explain query
69 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  990
]
View formatted query    View runnable query    Explain query
70 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: 
[
  23
]
View formatted query    View runnable query    Explain query
71 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1042
]
View formatted query    View runnable query    Explain query
72 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: 
[
  2
]
View formatted query    View runnable query    Explain query
73 0.30 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: 
[
  966
]
View formatted query    View runnable query    Explain query
74 0.28 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: 
[
  967
]
View formatted query    View runnable query    Explain query
75 0.28 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: 
[
  964
]
View formatted query    View runnable query    Explain query
76 0.29 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: 
[
  963
]
View formatted query    View runnable query    Explain query
77 0.33 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: 
[
  965
]
View formatted query    View runnable query    Explain query
78 0.33 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: 
[
  1281
]
View formatted query    View runnable query    Explain query
79 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1283
]
View formatted query    View runnable query    Explain query
80 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: 
[
  2
]
View formatted query    View runnable query    Explain query
81 0.29 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: 
[
  1165
]
View formatted query    View runnable query    Explain query
82 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: 
[
  1
]
View formatted query    View runnable query    Explain query
83 0.28 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: 
[
  961
]
View formatted query    View runnable query    Explain query
84 0.42 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: 
[
  962
]
View formatted query    View runnable query    Explain query
85 0.27 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: 
[
  959
]
View formatted query    View runnable query    Explain query
86 0.29 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: 
[
  958
]
View formatted query    View runnable query    Explain query
87 0.28 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: 
[
  960
]
View formatted query    View runnable query    Explain query
88 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: 
[
  1
]
View formatted query    View runnable query    Explain query
89 0.33 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
90 0.43 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: 
[
  92
]
View formatted query    View runnable query    Explain query
91 0.28 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: 
[
  1003
]
View formatted query    View runnable query    Explain query
92 0.27 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: 
[
  1004
]
View formatted query    View runnable query    Explain query
93 0.29 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: 
[
  1002
]
View formatted query    View runnable query    Explain query
94 0.30 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: 
[
  1001
]
View formatted query    View runnable query    Explain query
95 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: 
[
  92
]
View formatted query    View runnable query    Explain query
96 0.30 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
97 0.27 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5 FROM program_level_group t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
98 0.28 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: 
[
  1418
]
View formatted query    View runnable query    Explain query
99 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: 
[
  102
]
View formatted query    View runnable query    Explain query
100 0.33 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: 
[
  825
]
View formatted query    View runnable query    Explain query
101 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  834
]
View formatted query    View runnable query    Explain query
102 0.33 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: 
[
  832
]
View formatted query    View runnable query    Explain query
103 0.30 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: 
[
  831
]
View formatted query    View runnable query    Explain query
104 0.33 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: 
[
  824
]
View formatted query    View runnable query    Explain query
105 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: 
[
  102
]
View formatted query    View runnable query    Explain query
106 0.43 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: 
[
  81
]
View formatted query    View runnable query    Explain query
107 0.30 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: 
[
  1025
]
View formatted query    View runnable query    Explain query
108 0.28 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: 
[
  1026
]
View formatted query    View runnable query    Explain query
109 0.29 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: 
[
  1024
]
View formatted query    View runnable query    Explain query
110 0.28 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: 
[
  1023
]
View formatted query    View runnable query    Explain query
111 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: 
[
  81
]
View formatted query    View runnable query    Explain query
112 0.27 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: 
[
  1060
]
View formatted query    View runnable query    Explain query
113 0.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ?
Parameters: 
[
  93
]
View formatted query    View runnable query    Explain query
114 0.29 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: 
[
  842
]
View formatted query    View runnable query    Explain query
115 0.28 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: 
[
  1009
]
View formatted query    View runnable query    Explain query
116 0.27 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: 
[
  1008
]
View formatted query    View runnable query    Explain query
117 0.26 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: 
[
  840
]
View formatted query    View runnable query    Explain query
118 0.27 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: 
[
  841
]
View formatted query    View runnable query    Explain query
119 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: 
[
  93
]
View formatted query    View runnable query    Explain query
120 0.25 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
121 0.26 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: 
[
  1043
]
View formatted query    View runnable query    Explain query
122 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: 
[
  3
]
View formatted query    View runnable query    Explain query
123 0.27 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: 
[
  845
]
View formatted query    View runnable query    Explain query
124 0.30 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: 
[
  846
]
View formatted query    View runnable query    Explain query
125 0.30 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: 
[
  1005
]
View formatted query    View runnable query    Explain query
126 0.27 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: 
[
  843
]
View formatted query    View runnable query    Explain query
127 0.27 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: 
[
  844
]
View formatted query    View runnable query    Explain query
128 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: 
[
  3
]
View formatted query    View runnable query    Explain query
129 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: 
[
  77
]
View formatted query    View runnable query    Explain query
130 0.28 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: 
[
  1132
]
View formatted query    View runnable query    Explain query
131 0.28 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: 
[
  1135
]
View formatted query    View runnable query    Explain query
132 0.27 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: 
[
  1131
]
View formatted query    View runnable query    Explain query
133 0.28 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: 
[
  1130
]
View formatted query    View runnable query    Explain query
134 0.28 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: 
[
  1134
]
View formatted query    View runnable query    Explain query
135 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: 
[
  77
]
View formatted query    View runnable query    Explain query
136 0.29 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: 
[
  1059
]
View formatted query    View runnable query    Explain query
137 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: 
[
  21
]
View formatted query    View runnable query    Explain query
138 0.27 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: 
[
  850
]
View formatted query    View runnable query    Explain query
139 0.27 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: 
[
  851
]
View formatted query    View runnable query    Explain query
140 0.28 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: 
[
  848
]
View formatted query    View runnable query    Explain query
141 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  847
]
View formatted query    View runnable query    Explain query
142 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  849
]
View formatted query    View runnable query    Explain query
143 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: 
[
  21
]
View formatted query    View runnable query    Explain query
144 0.27 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: 
[
  1044
]
View formatted query    View runnable query    Explain query
145 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: 
[
  4
]
View formatted query    View runnable query    Explain query
146 0.27 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: 
[
  860
]
View formatted query    View runnable query    Explain query
147 0.30 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: 
[
  861
]
View formatted query    View runnable query    Explain query
148 0.28 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: 
[
  858
]
View formatted query    View runnable query    Explain query
149 0.28 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: 
[
  857
]
View formatted query    View runnable query    Explain query
150 0.29 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: 
[
  859
]
View formatted query    View runnable query    Explain query
151 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: 
[
  4
]
View formatted query    View runnable query    Explain query
152 0.27 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: 
[
  1055
]
View formatted query    View runnable query    Explain query
153 0.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
154 0.28 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: 
[
  870
]
View formatted query    View runnable query    Explain query
155 0.26 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: 
[
  871
]
View formatted query    View runnable query    Explain query
156 0.28 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: 
[
  868
]
View formatted query    View runnable query    Explain query
157 0.28 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: 
[
  867
]
View formatted query    View runnable query    Explain query
158 0.28 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: 
[
  869
]
View formatted query    View runnable query    Explain query
159 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: 
[
  20
]
View formatted query    View runnable query    Explain query
160 0.27 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: 
[
  1050
]
View formatted query    View runnable query    Explain query
161 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: 
[
  10
]
View formatted query    View runnable query    Explain query
162 0.27 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: 
[
  880
]
View formatted query    View runnable query    Explain query
163 0.27 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: 
[
  881
]
View formatted query    View runnable query    Explain query
164 0.29 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: 
[
  878
]
View formatted query    View runnable query    Explain query
165 0.27 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: 
[
  877
]
View formatted query    View runnable query    Explain query
166 0.27 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: 
[
  879
]
View formatted query    View runnable query    Explain query
167 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: 
[
  10
]
View formatted query    View runnable query    Explain query
168 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: 
[
  34
]
View formatted query    View runnable query    Explain query
169 0.29 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: 
[
  890
]
View formatted query    View runnable query    Explain query
170 0.29 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: 
[
  891
]
View formatted query    View runnable query    Explain query
171 0.27 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: 
[
  888
]
View formatted query    View runnable query    Explain query
172 0.26 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: 
[
  887
]
View formatted query    View runnable query    Explain query
173 0.27 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: 
[
  889
]
View formatted query    View runnable query    Explain query
174 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: 
[
  34
]
View formatted query    View runnable query    Explain query
175 0.28 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: 
[
  1162
]
View formatted query    View runnable query    Explain query
176 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: 
[
  95
]
View formatted query    View runnable query    Explain query
177 0.28 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: 
[
  1160
]
View formatted query    View runnable query    Explain query
178 0.26 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: 
[
  1161
]
View formatted query    View runnable query    Explain query
179 0.27 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: 
[
  1158
]
View formatted query    View runnable query    Explain query
180 0.29 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: 
[
  1157
]
View formatted query    View runnable query    Explain query
181 0.29 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: 
[
  1159
]
View formatted query    View runnable query    Explain query
182 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: 
[
  95
]
View formatted query    View runnable query    Explain query
183 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: 
[
  83
]
View formatted query    View runnable query    Explain query
184 0.28 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: 
[
  1014
]
View formatted query    View runnable query    Explain query
185 0.28 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: 
[
  1015
]
View formatted query    View runnable query    Explain query
186 0.33 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: 
[
  893
]
View formatted query    View runnable query    Explain query
187 0.27 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: 
[
  892
]
View formatted query    View runnable query    Explain query
188 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: 
[
  83
]
View formatted query    View runnable query    Explain query
189 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: 
[
  153
]
View formatted query    View runnable query    Explain query
190 0.28 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: 
[
  1484
]
View formatted query    View runnable query    Explain query
191 0.30 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: 
[
  1482
]
View formatted query    View runnable query    Explain query
192 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1481
]
View formatted query    View runnable query    Explain query
193 0.28 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: 
[
  1483
]
View formatted query    View runnable query    Explain query
194 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: 
[
  153
]
View formatted query    View runnable query    Explain query
195 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: 
[
  150
]
View formatted query    View runnable query    Explain query
196 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: 
[
  150
]
View formatted query    View runnable query    Explain query
197 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
198 0.27 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
199 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: 
[
  151
]
View formatted query    View runnable query    Explain query
200 0.32 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: 
[
  151
]
View formatted query    View runnable query    Explain query
201 0.25 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM program_domain t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
202 0.26 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: 
[
  1053
]
View formatted query    View runnable query    Explain query
203 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: 
[
  17
]
View formatted query    View runnable query    Explain query
204 0.27 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: 
[
  1409
]
View formatted query    View runnable query    Explain query
205 0.29 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: 
[
  1410
]
View formatted query    View runnable query    Explain query
206 0.33 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: 
[
  17
]
View formatted query    View runnable query    Explain query
207 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: 
[
  152
]
View formatted query    View runnable query    Explain query
208 0.28 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: 
[
  1352
]
View formatted query    View runnable query    Explain query
209 0.27 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: 
[
  1343
]
View formatted query    View runnable query    Explain query
210 0.28 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: 
[
  1356
]
View formatted query    View runnable query    Explain query
211 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: 
[
  152
]
View formatted query    View runnable query    Explain query
212 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.group_id AS group_id_6 FROM program_level t0 WHERE t0.id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
213 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: 
[
  4
]
View formatted query    View runnable query    Explain query
214 0.27 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: 
[
  1282
]
View formatted query    View runnable query    Explain query
215 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: 
[
  37
]
View formatted query    View runnable query    Explain query
216 0.34 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: 
[
  37
]
View formatted query    View runnable query    Explain query
217 0.39 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: 
[
  79
]
View formatted query    View runnable query    Explain query
218 0.33 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: 
[
  79
]
View formatted query    View runnable query    Explain query
219 0.53 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ? ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table
Parameters: 
[
  2
  2
  1
]
View formatted query    View runnable query    Explain query
220 0.60 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, c1_.id AS id_17, c1_.name AS name_18, c1_.slug AS slug_19, c1_.status AS status_20, c1_.ordering AS ordering_21, c1_.city AS city_22, c1_.youtube_url AS youtube_url_23, c1_.link360 AS link360_24, c1_.address AS address_25, c1_.cp AS cp_26, c1_.description AS description_27, c1_.is_main AS is_main_28, c1_.google_map AS google_map_29, c1_.created_date AS created_date_30, c1_.updated_date AS updated_date_31, c1_.seo_title AS seo_title_32, c1_.seo_h1 AS seo_h1_33, c1_.seo_keyword AS seo_keyword_34, c1_.seo_description AS seo_description_35 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ?) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 3
Parameters: 
[
  2
  2
  1
]
View formatted query    View runnable query    Explain query
221 0.49 ms 
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ? AND n0_.id IN (?, ?) ORDER BY n0_.published_time DESC
Parameters: 
[
  2
  2
  1
  777
  733
]
View formatted query    View runnable query    Explain query
222 0.47 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["5"]"
]
View formatted query    View runnable query    Explain query
223 0.31 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
224 0.39 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters: 
[
  55
  56
  57
  59
  60
  48
  56
  65
]
View formatted query    View runnable query    Explain query
225 0.34 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters: 
[
  55
  56
  57
  59
  60
  48
  56
  65
]
View formatted query    View runnable query    Explain query
226 0.29 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?) AND m0_.id IN (?)
Parameters: 
[
  55
  56
  57
  59
  60
  48
  56
  65
  56
]
View formatted query    View runnable query    Explain query
227 0.36 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["3"]"
]
View formatted query    View runnable query    Explain query
228 0.30 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
229 0.40 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  48
  56
  65
]
View formatted query    View runnable query    Explain query
230 0.37 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  48
  56
  65
]
View formatted query    View runnable query    Explain query
231 0.32 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?, ?, ?) AND m0_.id IN (?, ?)
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  48
  56
  65
  48
  65
]
View formatted query    View runnable query    Explain query
232 0.36 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["4"]"
]
View formatted query    View runnable query    Explain query
233 0.31 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
234 0.38 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters: 
[
  48
  52
  53
  54
  48
  56
  65
]
View formatted query    View runnable query    Explain query
235 0.35 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters: 
[
  48
  52
  53
  54
  48
  56
  65
]
View formatted query    View runnable query    Explain query
236 0.29 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?, ?, ?) AND m0_.id IN (?)
Parameters: 
[
  48
  52
  53
  54
  48
  56
  65
  48
]
View formatted query    View runnable query    Explain query
237 0.75 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36 FROM program p0_ INNER JOIN program_campus p2_ ON p0_.id = p2_.program_id INNER JOIN campus c1_ ON c1_.id = p2_.campus_id INNER JOIN program_level p3_ ON p0_.level_id = p3_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?) ORDER BY p3_.id ASC, p0_.name ASC) dctrn_result) dctrn_table
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
238 0.81 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, id_56, name_1 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36, c1_.id AS id_37, c1_.name AS name_38, c1_.slug AS slug_39, c1_.status AS status_40, c1_.ordering AS ordering_41, c1_.city AS city_42, c1_.youtube_url AS youtube_url_43, c1_.link360 AS link360_44, c1_.address AS address_45, c1_.cp AS cp_46, c1_.description AS description_47, c1_.is_main AS is_main_48, c1_.google_map AS google_map_49, c1_.created_date AS created_date_50, c1_.updated_date AS updated_date_51, c1_.seo_title AS seo_title_52, c1_.seo_h1 AS seo_h1_53, c1_.seo_keyword AS seo_keyword_54, c1_.seo_description AS seo_description_55, p2_.id AS id_56, p2_.name AS name_57, p2_.slug AS slug_58, p2_.created_date AS created_date_59, p2_.updated_date AS updated_date_60 FROM program p0_ INNER JOIN program_campus p3_ ON p0_.id = p3_.program_id INNER JOIN campus c1_ ON c1_.id = p3_.campus_id INNER JOIN program_level p2_ ON p0_.level_id = p2_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?)) dctrn_result_inner ORDER BY id_56 ASC, name_1 ASC) dctrn_result LIMIT 50
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
239 1.27 ms 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36, p0_.brochure_id AS brochure_id_37, p0_.media_id AS media_id_38, p0_.director_image_id AS director_image_id_39, p0_.review_image_id AS review_image_id_40, p0_.intervenant_image_id AS intervenant_image_id_41, p0_.prerequisites_image_id AS prerequisites_image_id_42, p0_.cost_training_image_id AS cost_training_image_id_43, p0_.outcomes_image_id AS outcomes_image_id_44, p0_.level_id AS level_id_45, p0_.domain_id AS domain_id_46, p0_.alumni_interview_poster_id AS alumni_interview_poster_id_47, p0_.plus_formation_file_id AS plus_formation_file_id_48 FROM program p0_ INNER JOIN program_campus p2_ ON p0_.id = p2_.program_id INNER JOIN campus c1_ ON c1_.id = p2_.campus_id INNER JOIN program_level p3_ ON p0_.level_id = p3_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p3_.id ASC, p0_.name ASC
Parameters: 
[
  2
  27
  23
  2
  102
  93
  4
  10
  154
  152
]
View formatted query    View runnable query    Explain query
240 0.75 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: 
[
  154
]
View formatted query    View runnable query    Explain query
241 0.36 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: 
[
  1379
]
View formatted query    View runnable query    Explain query
242 0.33 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: 
[
  1378
]
View formatted query    View runnable query    Explain query
243 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1380
]
View formatted query    View runnable query    Explain query
244 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: 
[
  154
]
View formatted query    View runnable query    Explain query
245 0.74 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ? ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table
Parameters: 
[
  4
  2
  1
]
View formatted query    View runnable query    Explain query
246 0.60 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, c1_.id AS id_17, c1_.name AS name_18, c1_.slug AS slug_19, c1_.status AS status_20, c1_.ordering AS ordering_21, c1_.city AS city_22, c1_.youtube_url AS youtube_url_23, c1_.link360 AS link360_24, c1_.address AS address_25, c1_.cp AS cp_26, c1_.description AS description_27, c1_.is_main AS is_main_28, c1_.google_map AS google_map_29, c1_.created_date AS created_date_30, c1_.updated_date AS updated_date_31, c1_.seo_title AS seo_title_32, c1_.seo_h1 AS seo_h1_33, c1_.seo_keyword AS seo_keyword_34, c1_.seo_description AS seo_description_35 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ?) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 3
Parameters: 
[
  4
  2
  1
]
View formatted query    View runnable query    Explain query
247 0.50 ms 
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ INNER JOIN news_campus n2_ ON n0_.id = n2_.news_id INNER JOIN campus c1_ ON c1_.id = n2_.campus_id WHERE c1_.id = ? AND n0_.type = ? AND n0_.status = ? AND n0_.id IN (?, ?) ORDER BY n0_.published_time DESC
Parameters: 
[
  4
  2
  1
  776
  734
]
View formatted query    View runnable query    Explain query
248 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 news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters: 
[
  776
]
View formatted query    View runnable query    Explain query
249 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1035
]
View formatted query    View runnable query    Explain query
250 0.43 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
Parameters: 
[
  734
]
View formatted query    View runnable query    Explain query
251 0.42 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["5"]"
]
View formatted query    View runnable query    Explain query
252 0.32 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
253 0.36 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?)) dctrn_result) dctrn_table
Parameters: 
[
  55
  56
  57
  59
  60
  68
]
View formatted query    View runnable query    Explain query
254 0.29 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?) AND m0_.id IN (?)) dctrn_result LIMIT 50
Parameters: 
[
  55
  56
  57
  59
  60
  68
]
View formatted query    View runnable query    Explain query
255 0.41 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["3"]"
]
View formatted query    View runnable query    Explain query
256 0.33 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
257 0.37 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?)) dctrn_result) dctrn_table
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  68
]
View formatted query    View runnable query    Explain query
258 0.30 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?)) dctrn_result LIMIT 50
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  68
]
View formatted query    View runnable query    Explain query
259 0.29 ms 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6, m0_.image_id AS image_id_7 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?) AND m0_.id IN (?)
Parameters: 
[
  48
  49
  50
  51
  65
  66
  67
  68
  69
  68
  68
]
View formatted query    View runnable query    Explain query
260 0.46 ms 
SELECT m.id FROM `manager` m WHERE m.service <> '' AND JSON_CONTAINS(m.service, ?) = 1
Parameters: 
[
  "["4"]"
]
View formatted query    View runnable query    Explain query
261 0.31 ms 
SELECT manager_id
                    FROM manager_campus
                    WHERE campus_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
262 0.34 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?)) dctrn_result) dctrn_table
Parameters: 
[
  48
  52
  53
  54
  68
]
View formatted query    View runnable query    Explain query
263 0.28 ms 
SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.service AS service_2, m0_.position AS position_3, m0_.email AS email_4, m0_.telephone AS telephone_5, m0_.title AS title_6 FROM manager m0_ WHERE m0_.id IN (?, ?, ?, ?) AND m0_.id IN (?)) dctrn_result LIMIT 50
Parameters: 
[
  48
  52
  53
  54
  68
]
View formatted query    View runnable query    Explain query
264 0.72 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36 FROM program p0_ INNER JOIN program_campus p2_ ON p0_.id = p2_.program_id INNER JOIN campus c1_ ON c1_.id = p2_.campus_id INNER JOIN program_level p3_ ON p0_.level_id = p3_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?) ORDER BY p3_.id ASC, p0_.name ASC) dctrn_result) dctrn_table
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
265 0.73 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, id_56, name_1 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36, c1_.id AS id_37, c1_.name AS name_38, c1_.slug AS slug_39, c1_.status AS status_40, c1_.ordering AS ordering_41, c1_.city AS city_42, c1_.youtube_url AS youtube_url_43, c1_.link360 AS link360_44, c1_.address AS address_45, c1_.cp AS cp_46, c1_.description AS description_47, c1_.is_main AS is_main_48, c1_.google_map AS google_map_49, c1_.created_date AS created_date_50, c1_.updated_date AS updated_date_51, c1_.seo_title AS seo_title_52, c1_.seo_h1 AS seo_h1_53, c1_.seo_keyword AS seo_keyword_54, c1_.seo_description AS seo_description_55, p2_.id AS id_56, p2_.name AS name_57, p2_.slug AS slug_58, p2_.created_date AS created_date_59, p2_.updated_date AS updated_date_60 FROM program p0_ INNER JOIN program_campus p3_ ON p0_.id = p3_.program_id INNER JOIN campus c1_ ON c1_.id = p3_.campus_id INNER JOIN program_level p2_ ON p0_.level_id = p2_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?)) dctrn_result_inner ORDER BY id_56 ASC, name_1 ASC) dctrn_result LIMIT 50
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
266 0.86 ms 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.pace AS pace_4, p0_.rncp AS rncp_5, p0_.metadata AS metadata_6, p0_.description AS description_7, p0_.entreprise AS entreprise_8, p0_.speciality_id AS speciality_id_9, p0_.ordering AS ordering_10, p0_.is_register AS is_register_11, p0_.is_initial AS is_initial_12, p0_.is_alternance AS is_alternance_13, p0_.year AS year_14, p0_.rncp_level AS rncp_level_15, p0_.qcm_list AS qcm_list_16, p0_.entrance_fee AS entrance_fee_17, p0_.total_payment AS total_payment_18, p0_.old_slug AS old_slug_19, p0_.is_opening AS is_opening_20, p0_.is_international AS is_international_21, p0_.subtitle AS subtitle_22, p0_.link_out_side AS link_out_side_23, p0_.admin_program AS admin_program_24, p0_.widget AS widget_25, p0_.ranking AS ranking_26, p0_.information AS information_27, p0_.type AS type_28, p0_.overview_images AS overview_images_29, p0_.currency AS currency_30, p0_.created_date AS created_date_31, p0_.updated_date AS updated_date_32, p0_.seo_title AS seo_title_33, p0_.seo_h1 AS seo_h1_34, p0_.seo_keyword AS seo_keyword_35, p0_.seo_description AS seo_description_36, p0_.brochure_id AS brochure_id_37, p0_.media_id AS media_id_38, p0_.director_image_id AS director_image_id_39, p0_.review_image_id AS review_image_id_40, p0_.intervenant_image_id AS intervenant_image_id_41, p0_.prerequisites_image_id AS prerequisites_image_id_42, p0_.cost_training_image_id AS cost_training_image_id_43, p0_.outcomes_image_id AS outcomes_image_id_44, p0_.level_id AS level_id_45, p0_.domain_id AS domain_id_46, p0_.alumni_interview_poster_id AS alumni_interview_poster_id_47, p0_.plus_formation_file_id AS plus_formation_file_id_48 FROM program p0_ INNER JOIN program_campus p2_ ON p0_.id = p2_.program_id INNER JOIN campus c1_ ON c1_.id = p2_.campus_id INNER JOIN program_level p3_ ON p0_.level_id = p3_.id WHERE (p0_.status = 1 OR p0_.is_opening = 1 OR p0_.is_international = 1) AND c1_.id IN (?) AND p0_.id IN (?, ?) ORDER BY p3_.id ASC, p0_.name ASC
Parameters: 
[
  4
  88
  101
]
View formatted query    View runnable query    Explain query
267 0.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ?
Parameters: 
[
  88
]
View formatted query    View runnable query    Explain query
268 0.33 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: 
[
  1279
]
View formatted query    View runnable query    Explain query
269 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1280
]
View formatted query    View runnable query    Explain query
270 0.29 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: 
[
  1278
]
View formatted query    View runnable query    Explain query
271 0.29 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: 
[
  1277
]
View formatted query    View runnable query    Explain query
272 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: 
[
  88
]
View formatted query    View runnable query    Explain query
273 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: 
[
  101
]
View formatted query    View runnable query    Explain query
274 0.29 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: 
[
  1212
]
View formatted query    View runnable query    Explain query
275 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1213
]
View formatted query    View runnable query    Explain query
276 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1210
]
View formatted query    View runnable query    Explain query
277 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1209
]
View formatted query    View runnable query    Explain query
278 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
Parameters: 
[
  1211
]
View formatted query    View runnable query    Explain query
279 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: 
[
  101
]
View formatted query    View runnable query    Explain query
280 0.89 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
281 0.96 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
282 0.76 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
283 0.92 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
284 0.34 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
285 0.37 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?
Parameters: 
[
  96
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Media 144
App\Entity\Program 31
App\Entity\Qcm 20
App\Entity\Manager 14
App\Entity\ProgramLevel 7
App\Entity\News 5
App\Entity\ProgramDomain 5
App\Entity\Campus 4
App\Entity\ProgramLevelGroup 4
App\Entity\Country 2
App\Entity\Zone 2

Entities Mapping

Class Mapping errors
App\Entity\Campus No errors.
App\Entity\Manager No errors.
App\Entity\News No errors.
App\Entity\Media 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\Program No errors.
App\Entity\SpoDate No errors.
App\Entity\CampusImage No errors.
App\Entity\AcademicPartner No errors.
App\Entity\ProgramLevel No errors.
App\Entity\ProgramDomain No errors.
App\Entity\Qcm No errors.
App\Entity\Cursus No errors.
App\Entity\Spo No errors.
App\Entity\ProgramLevelGroup No errors.
App\Entity\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.