Query Metrics

7 Database Queries
6 Different statements
11.35 ms Query time
2 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 2.44 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_.slug = ? AND n0_.status = ? AND n0_.type = ? LIMIT 1
Parameters:
[
  "master-success-day-accompagnement-reussite-etudiante-janvier-2026-financia-business-school"
  1
  2
]
2 0.98 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:
[]
3 1.06 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result) dctrn_table
Parameters:
[
  1
  2
  4
]
4 0.86 ms
SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.ordering AS ordering_4, c0_.city AS city_5, c0_.youtube_url AS youtube_url_6, c0_.link360 AS link360_7, c0_.address AS address_8, c0_.cp AS cp_9, c0_.description AS description_10, c0_.is_main AS is_main_11, c0_.google_map AS google_map_12, c0_.created_date AS created_date_13, c0_.updated_date AS updated_date_14, c0_.seo_title AS seo_title_15, c0_.seo_h1 AS seo_h1_16, c0_.seo_keyword AS seo_keyword_17, c0_.seo_description AS seo_description_18 FROM campus c0_ LEFT JOIN manager_campus m2_ ON c0_.id = m2_.campus_id LEFT JOIN manager m1_ ON m1_.id = m2_.manager_id LEFT JOIN news_campus n4_ ON c0_.id = n4_.campus_id LEFT JOIN news n3_ ON n3_.id = n4_.news_id WHERE (c0_.description <> '' OR c0_.address <> '' OR c0_.link360 <> '' OR c0_.youtube_url <> '') AND c0_.id IN (?, ?, ?)) dctrn_result LIMIT 50
Parameters:
[
  1
  2
  4
]
5 1.27 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
]
6 0.89 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
]
7 3.85 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
]

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

Entities Mapping

Class Mapping errors
App\Entity\News No errors.
App\Entity\Media No errors.
App\Entity\Campus No errors.
App\Entity\Program No errors.
App\Entity\ProgramLevelGroup No errors.
App\Entity\ProgramLevel No errors.
App\Entity\Manager 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\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.