Query Metrics

40 Database Queries
5 Different statements
22.63 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.94 ms
(26.25%)
12
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.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.seo_title AS seo_title_10, t0.seo_h1 AS seo_h1_11, t0.seo_keyword AS seo_keyword_12, t0.seo_description AS seo_description_13, t0.logo_id AS logo_id_14, t0.image_depiction_id AS image_depiction_id_15 FROM campus t0 INNER JOIN program_campus ON t0.id = program_campus.campus_id WHERE program_campus.program_id = ?
Parameters:
[
  1
]
5.84 ms
(25.80%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.level AS level_5, t0.pace AS pace_6, t0.rncp AS rncp_7, t0.metadata AS metadata_8, t0.description AS description_9, t0.entreprise AS entreprise_10, t0.speciality_id AS speciality_id_11, t0.ordering AS ordering_12, t0.is_register AS is_register_13, t0.is_initial AS is_initial_14, t0.is_alternance AS is_alternance_15, t0.year AS year_16, t0.created_date AS created_date_17, t0.updated_date AS updated_date_18, t0.seo_title AS seo_title_19, t0.seo_h1 AS seo_h1_20, t0.seo_keyword AS seo_keyword_21, t0.seo_description AS seo_description_22, t0.brochure_id AS brochure_id_23, t0.media_id AS media_id_24 FROM program t0 WHERE t0.level = ? AND t0.status = ? ORDER BY t0.ordering ASC
Parameters:
[
  1
  1
]
5.17 ms
(22.83%)
12
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.cours AS cours_4, t0.media_id AS media_id_5 FROM cursus t0 INNER JOIN program_cursus ON t0.id = program_cursus.cursus_id WHERE program_cursus.program_id = ?
Parameters:
[
  1
]
4.65 ms
(20.55%)
12
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:
[
  31
]
1.03 ms
(4.57%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.content AS content_3, a0_.photo AS photo_4, a0_.video AS video_5, a0_.status AS status_6, a0_.created_date AS created_date_7, a0_.updated_date AS updated_date_8, a0_.slug AS slug_9, a0_.seo_title AS seo_title_10, a0_.seo_h1 AS seo_h1_11, a0_.seo_keyword AS seo_keyword_12, a0_.seo_description AS seo_description_13 FROM alumni a0_ WHERE a0_.slug = ? AND a0_.status = ? LIMIT 1
Parameters:
[
  "mohamed-ali-alumnus-estiam-2018-et-responsable-d-application-et-chef-de-projet-chez-bnp-paribas"
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Alumni No errors.
App\Entity\Program No errors.
App\Entity\Media No errors.
App\Entity\Profile
  • The mappings App\Entity\Profile#commercial and App\Entity\User#profiles are inconsistent with each other.
App\Entity\AppointmentPerson No errors.
App\Entity\Qcm No errors.
App\Entity\Campus No errors.
App\Entity\Cursus No errors.
App\Entity\User
  • The mappings App\Entity\User#nationality and App\Entity\Country#users are inconsistent with each other.
App\Entity\CampusCenter No errors.
App\Entity\CampusPresentationBlock No errors.
App\Entity\CampusArticle No errors.
App\Entity\CampusKeyFigure No errors.
App\Entity\Offer No errors.
App\Entity\Candidate No errors.
App\Entity\Participate No errors.
App\Entity\OpenDayPerson No errors.
App\Entity\Forum No errors.