Symfony Profiler

Query Metrics

39 Database Queries

11 Different statements

148.34 ms Query time

2 Invalid entities

25 Managed entities

Queries


SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ?) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 9
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.published_time DESC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ?
SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p2_ ON p0_.id = p2_.group_id INNER JOIN program p4_ ON p2_.id = p4_.level_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\ProgramLevelGroup' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'name' AND t3_.object_class = 'App\\Entity\\ProgramLevel' AND t3_.foreign_key = p2_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'name' AND t5_.object_class = 'App\\Entity\\Program' AND t5_.foreign_key = p4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'metadata' AND t6_.object_class = 'App\\Entity\\Program' AND t6_.foreign_key = p4_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'description' AND t7_.object_class = 'App\\Entity\\Program' AND t7_.foreign_key = p4_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'entreprise' AND t8_.object_class = 'App\\Entity\\Program' AND t8_.foreign_key = p4_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'en' AND t9_.field = 'subtitle' AND t9_.object_class = 'App\\Entity\\Program' AND t9_.foreign_key = p4_.id WHERE p4_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?) AND c0_.id IN (?, ?, ?)
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ?

#▲	Time	Info
1	3.23 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? ORDER BY n0_.published_time DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = 1 AND n0_.type = 1 ORDER BY n0_.published_time DESC) dctrn_result) dctrn_table;
2	5.26 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ?) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 9 Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, published_time_9 FROM ( SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? ) dctrn_result_inner ORDER BY published_time_9 DESC ) dctrn_result LIMIT 9 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_time_9 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16 FROM news n0_ WHERE n0_.status = 1 AND n0_.type = 1) dctrn_result_inner ORDER BY published_time_9 DESC) dctrn_result LIMIT 9;
3	3.38 ms	SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.published_time DESC Parameters: [`1 1 732 721 711 704 708 703 710 709 712`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ WHERE n0_.status = ? AND n0_.type = ? AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.published_time DESC SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.content AS content_3, n0_.seo_title AS seo_title_4, n0_.seo_description AS seo_description_5, n0_.status AS status_6, n0_.priority AS priority_7, n0_.type AS type_8, n0_.published_time AS published_time_9, n0_.event_categories AS event_categories_10, n0_.event_date AS event_date_11, n0_.created_date AS created_date_12, n0_.updated_date AS updated_date_13, n0_.slug AS slug_14, n0_.seo_h1 AS seo_h1_15, n0_.seo_keyword AS seo_keyword_16, n0_.media_id AS media_id_17 FROM news n0_ WHERE n0_.status = 1 AND n0_.type = 1 AND n0_.id IN (732, 721, 711, 704, 708, 703, 710, 709, 712) ORDER BY n0_.published_time DESC;
4	4.07 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"732" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '732' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
5	3.27 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"721" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '721' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
6	0.59 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"711" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '711' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
7	0.43 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"704" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '704' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
8	0.36 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"708" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '708' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
9	4.03 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"703" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '703' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
10	1.80 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"710" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '710' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
11	4.37 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"709" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '709' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
12	0.53 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"712" "en" "App\Entity\News"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '712' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\News';
13	3.24 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: [`1033`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 1033;
14	5.92 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: [`732`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 732;
15	4.22 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: [`1077`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 1077;
16	4.57 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: [`721`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 721;
17	4.62 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? Parameters: [`1076`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 1076;
18	0.64 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: [`711`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 711;
19	3.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? Parameters: [`657`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 657;
20	3.56 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: [`704`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 704;
21	3.87 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: [`661`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 661;
22	5.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 news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? Parameters: [`708`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 708;
23	0.54 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: [`656`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 656;
24	4.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: [`703`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 703;
25	5.12 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: [`663`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 663;
26	3.84 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: [`710`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 710;
27	3.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: [`662`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 662;
28	6.57 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: [`709`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 709;
29	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? Parameters: [`665`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.path AS path_4, t0.size AS size_5, t0.has_webp AS has_webp_6, t0.has_webm AS has_webm_7, t0.has_thumb AS has_thumb_8 FROM media t0 WHERE t0.id = 665;
30	5.68 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: [`712`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.ordering AS ordering_5, t0.city AS city_6, t0.youtube_url AS youtube_url_7, t0.link360 AS link360_8, t0.address AS address_9, t0.cp AS cp_10, t0.description AS description_11, t0.is_main AS is_main_12, t0.google_map AS google_map_13, t0.created_date AS created_date_14, t0.updated_date AS updated_date_15, t0.seo_title AS seo_title_16, t0.seo_h1 AS seo_h1_17, t0.seo_keyword AS seo_keyword_18, t0.seo_description AS seo_description_19, t0.logo_id AS logo_id_20, t0.country_id AS country_id_21 FROM campus t0 INNER JOIN news_campus ON t0.id = news_campus.campus_id WHERE news_campus.news_id = 712;
31	16.28 ms	SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p2_ ON p0_.id = p2_.group_id INNER JOIN program p4_ ON p2_.id = p4_.level_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\ProgramLevelGroup' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'name' AND t3_.object_class = 'App\\Entity\\ProgramLevel' AND t3_.foreign_key = p2_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'name' AND t5_.object_class = 'App\\Entity\\Program' AND t5_.foreign_key = p4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'metadata' AND t6_.object_class = 'App\\Entity\\Program' AND t6_.foreign_key = p4_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'description' AND t7_.object_class = 'App\\Entity\\Program' AND t7_.foreign_key = p4_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'entreprise' AND t8_.object_class = 'App\\Entity\\Program' AND t8_.foreign_key = p4_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'en' AND t9_.field = 'subtitle' AND t9_.object_class = 'App\\Entity\\Program' AND t9_.foreign_key = p4_.id WHERE p4_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p2_ ON p0_.id = p2_.group_id INNER JOIN program p4_ ON p2_.id = p4_.level_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\ProgramLevelGroup' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'name' AND t3_.object_class = 'App\\Entity\\ProgramLevel' AND t3_.foreign_key = p2_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'name' AND t5_.object_class = 'App\\Entity\\Program' AND t5_.foreign_key = p4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'metadata' AND t6_.object_class = 'App\\Entity\\Program' AND t6_.foreign_key = p4_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'description' AND t7_.object_class = 'App\\Entity\\Program' AND t7_.foreign_key = p4_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'entreprise' AND t8_.object_class = 'App\\Entity\\Program' AND t8_.foreign_key = p4_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'en' AND t9_.field = 'subtitle' AND t9_.object_class = 'App\\Entity\\Program' AND t9_.foreign_key = p4_.id WHERE p4_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, p0_.slug AS slug_2 FROM program_level_group p0_ INNER JOIN program_level p2_ ON p0_.id = p2_.group_id INNER JOIN program p4_ ON p2_.id = p4_.level_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\ProgramLevelGroup' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'name' AND t3_.object_class = 'App\\Entity\\ProgramLevel' AND t3_.foreign_key = p2_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'name' AND t5_.object_class = 'App\\Entity\\Program' AND t5_.foreign_key = p4_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'metadata' AND t6_.object_class = 'App\\Entity\\Program' AND t6_.foreign_key = p4_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'description' AND t7_.object_class = 'App\\Entity\\Program' AND t7_.foreign_key = p4_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'entreprise' AND t8_.object_class = 'App\\Entity\\Program' AND t8_.foreign_key = p4_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'en' AND t9_.field = 'subtitle' AND t9_.object_class = 'App\\Entity\\Program' AND t9_.foreign_key = p4_.id WHERE p4_.status = 1 GROUP BY p0_.id ORDER BY p0_.id ASC;
32	3.46 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result) dctrn_table Parameters: [`1 2 4`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE ( c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '' ) AND c0_.id IN (?, ?, ?) ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (1, 2, 4)) dctrn_result) dctrn_table;
33	4.21 ms	SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result LIMIT 50 Parameters: [`1 2 4`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE ( c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '' ) AND c0_.id IN (?, ?, ?) ) dctrn_result LIMIT 50 SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (1, 2, 4)) dctrn_result LIMIT 50;
34	1.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 SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE ( c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '' ) AND c0_.id IN (?, ?, ?) AND c0_.id IN (?, ?, ?) SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18, c0_.logo_id AS logo_id_19, c0_.country_id AS country_id_20 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (1, 2, 4) AND c0_.id IN (1, 2, 4);
35	8.09 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"1" "en" "App\Entity\Campus"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Campus';
36	3.73 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"2" "en" "App\Entity\Campus"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Campus';
37	2.58 ms	SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? Parameters: [`"4" "en" "App\Entity\Campus"`] View formatted query View runnable query Explain query SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ? SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Campus';
38	2.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = 1;
39	4.32 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ? Parameters: [`96`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ordering AS ordering_4, t0.nationality AS nationality_5, t0.language AS language_6, t0.zone_id AS zone_id_7 FROM country t0 WHERE t0.id = 96;

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\News	9
App\Entity\Media	9
App\Entity\Campus	3
App\Entity\Country	2
App\Entity\Zone	2

Entities Mapping

Class	Mapping errors
App\Entity\News	No errors.
App\Entity\Media	No errors.
App\Entity\Campus	No errors.
App\Entity\Program	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\Country	No errors.
App\Entity\ProgramLevelGroup	No errors.
App\Entity\ProgramLevel	No errors.
App\Entity\Manager	No errors.
App\Entity\Profile	The mappings App\Entity\Profile#commercial and App\Entity\User#profiles are inconsistent with each other.
App\Entity\SpoDate	No errors.
App\Entity\CampusImage	No errors.
App\Entity\AcademicPartner	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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping