https://estiam-france.silkwires-dev.com/fr/collaborer-avec-estiam

Query Metrics

42 Database Queries
7 Different statements
25.02 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.62 ms
(26.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM recruitment_theme t0 ORDER BY t0.name ASC
Parameters:
[]
5.27 ms
(21.07%)
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
]
4.50 ms
(18.00%)
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.44 ms
(17.75%)
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
]
2.60 ms
(10.38%)
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
]
0.90 ms
(3.61%)
1
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 ORDER BY t0.ordering ASC
Parameters:
[]
0.68 ms
(2.73%)
1
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 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
  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\RecruitmentTheme No errors.
App\Entity\Campus No errors.
App\Entity\Media No errors.
App\Entity\User
  • The mappings App\Entity\User#nationality and App\Entity\Country#users are inconsistent with each other.
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\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.
App\Entity\Country No errors.
App\Entity\Zone No errors.
App\Entity\AppointmentPerson No errors.
App\Entity\Qcm No errors.
App\Entity\Cursus No errors.