https://estiam-france.silkwires-dev.com/fr/formation-web-mobile-development

Query Metrics

41 Database Queries
6 Different statements
19.44 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.10 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.status AS status_3, p0_.level AS level_4, p0_.pace AS pace_5, p0_.rncp AS rncp_6, p0_.metadata AS metadata_7, p0_.description AS description_8, p0_.entreprise AS entreprise_9, p0_.speciality_id AS speciality_id_10, p0_.ordering AS ordering_11, p0_.is_register AS is_register_12, p0_.is_initial AS is_initial_13, p0_.is_alternance AS is_alternance_14, p0_.year AS year_15, p0_.created_date AS created_date_16, p0_.updated_date AS updated_date_17, p0_.seo_title AS seo_title_18, p0_.seo_h1 AS seo_h1_19, p0_.seo_keyword AS seo_keyword_20, p0_.seo_description AS seo_description_21, p0_.brochure_id AS brochure_id_22, p0_.media_id AS media_id_23 FROM program p0_ WHERE p0_.slug = ? AND p0_.status = ? LIMIT 1
Parameters:
[
  "web-mobile-development"
  1
]
2 0.64 ms
SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.content AS content_2, o0_.image AS image_3, o0_.video AS video_4, o0_.status AS status_5, o0_.type AS type_6, o0_.created_date AS created_date_7, o0_.updated_date AS updated_date_8 FROM our_student o0_ WHERE o0_.status = ? AND o0_.type = ? ORDER BY o0_.created_date DESC LIMIT 3
Parameters:
[
  1
  2
]
3 0.46 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:
[
  29
]
4 0.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.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:
[
  10
]
5 0.67 ms
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:
[
  10
]
6 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:
[
  15
]
7 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:
[
  16
]
8 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:
[
  17
]
9 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:
[
  18
]
10 1.00 ms
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
]
11 0.44 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:
[
  31
]
12 0.50 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.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
]
13 0.44 ms
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
]
14 0.55 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:
[
  49
]
15 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.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:
[
  2
]
16 0.39 ms
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:
[
  2
]
17 0.85 ms
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:
[
  2
  1
]
18 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:
[
  50
]
19 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.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:
[
  3
]
20 0.46 ms
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:
[
  3
]
21 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:
[
  51
]
22 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.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:
[
  4
]
23 0.38 ms
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:
[
  4
]
24 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.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:
[
  23
]
25 0.35 ms
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:
[
  23
]
26 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.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:
[
  24
]
27 0.32 ms
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:
[
  24
]
28 0.52 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.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:
[
  25
]
29 0.33 ms
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:
[
  25
]
30 0.83 ms
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:
[
  3
  1
]
31 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:
[
  28
]
32 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.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:
[
  11
]
33 0.39 ms
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:
[
  11
]
34 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:
[
  27
]
35 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.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:
[
  12
]
36 0.46 ms
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:
[
  12
]
37 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:
[
  26
]
38 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.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:
[
  13
]
39 0.38 ms
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:
[
  13
]
40 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.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:
[
  27
]
41 0.42 ms
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:
[
  27
]

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\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\OurStudent 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.