http://mcgt-rec.um6p.ma/

Query Metrics

80 Database Queries
18 Different statements
84.43 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
17.51 ms
(20.74%)
18
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mission AS mission_3, t0.specialite AS specialite_4, t0.contenu AS contenu_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM prof_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
11.08 ms
(13.12%)
11
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.publier AS publier_4, t0.link AS link_5, t0.linkedin AS linkedin_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM prof t0 INNER JOIN module_prof ON t0.id = module_prof.prof_id WHERE module_prof.module_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
10.06 ms
(11.91%)
11
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.preview AS preview_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM module_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
7.94 ms
(9.41%)
8
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.slug AS slug_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.publier AS publier_5, p0_.position AS position_6, p0_.imagemobile AS imagemobile_7, p0_.menu AS menu_8, p0_.categorie_id AS categorie_id_9 FROM PAGE p0_ LEFT JOIN categorypage c1_ ON p0_.categorie_id = c1_.id WHERE p0_.categorie_id = c1_.id AND c1_.slug = ? AND p0_.publier = 1 ORDER BY p0_.position ASC
Parameters:
[
  "people"
]
4.80 ms
(5.69%)
4
SELECT e0_.id AS id_0, e0_.image AS image_1, e0_.slug AS slug_2, e0_.link AS link_3, e0_.location AS location_4, e0_.position AS position_5, e0_.publier AS publier_6, e0_.encours AS encours_7, e0_.created_at AS created_at_8, e0_.updated_at AS updated_at_9, e0_.date_publier AS date_publier_10, e0_.date_final AS date_final_11 FROM event e0_ WHERE e0_.publier = ? ORDER BY e0_.date_publier DESC LIMIT 2
Parameters:
[
  1
]
4.54 ms
(5.38%)
2
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.duree AS duree_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM formation_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
4.48 ms
(5.31%)
4
SELECT m0_.id AS id_0, m0_.image AS image_1, m0_.link AS link_2, m0_.position AS position_3, m0_.publier AS publier_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6 FROM media_phd m0_ WHERE m0_.publier = 1 ORDER BY m0_.position ASC
Parameters:
[]
4.24 ms
(5.02%)
5
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.titre AS titre_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  26
]
3.56 ms
(4.22%)
4
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.direction AS direction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.publier AS publier_8, t0.background AS background_9, t0.style_block AS style_block_10, t0.page_id AS page_id_11 FROM block t0 WHERE t0.id = ? AND t0.publier = ? LIMIT 1
Parameters:
[
  26
  1
]
3.16 ms
(3.74%)
4
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.publier AS publier_2 FROM formation f0_ WHERE f0_.publier = ? ORDER BY f0_.position ASC
Parameters:
[
  1
]
3.03 ms
(3.59%)
2
SELECT t0.id AS id_1, t0.position AS position_2, t0.publier AS publier_3, t0.formation_id AS formation_id_4 FROM module t0 WHERE t0.formation_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
2.05 ms
(2.42%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.publier AS publier_6, t0.position AS position_7, t0.imagemobile AS imagemobile_8, t0.menu AS menu_9, t0.categorie_id AS categorie_id_10 FROM PAGE t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "home"
]
1.97 ms
(2.34%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.preview AS preview_3, t0.contenu AS contenu_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.menutitre AS menutitre_8, t0.menuclass AS menuclass_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
1.64 ms
(1.94%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.direction AS direction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.publier AS publier_8, t0.background AS background_9, t0.style_block AS style_block_10, t0.page_id AS page_id_11 FROM block t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
1.41 ms
(1.66%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.publier AS publier_6, t0.position AS position_7, t0.imagemobile AS imagemobile_8, t0.menu AS menu_9, t0.categorie_id AS categorie_id_10 FROM PAGE t0 WHERE t0.slug = ? AND t0.publier = ? LIMIT 1
Parameters:
[
  "home"
  1
]
1.11 ms
(1.31%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.direction AS direction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.publier AS publier_8, t0.background AS background_9, t0.style_block AS style_block_10, t0.page_id AS page_id_11 FROM block t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "popup_cookies"
]
0.98 ms
(1.16%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.preview AS preview_3, t0.contenu AS contenu_4, t0.seo_titre AS seo_titre_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM event_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.86 ms
(1.02%)
1
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.position AS position_2, c0_.slug AS slug_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.imagemobile AS imagemobile_6, c0_.menu AS menu_7 FROM categorypage c0_ ORDER BY c0_.position ASC
Parameters:
[]

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\Page No errors.
App\Entity\Categorypage No errors.
App\Entity\Block No errors.
App\Entity\PageTranslation No errors.
App\Entity\CategorypageTranslation No errors.
App\Entity\BlockTranslation No errors.
App\Entity\Actualites No errors.
App\Entity\ActualitesTranslation No errors.
App\Entity\User No errors.
App\Entity\Administrateur No errors.
App\Entity\Config No errors.
App\Entity\Contact No errors.
App\Entity\Faq No errors.
App\Entity\FaqTranslation No errors.
App\Entity\Language No errors.
App\Entity\Media No errors.
App\Entity\MediaBlock
  • The association App\Entity\MediaBlock#block refers to the inverse side field App\Entity\Block#medias which does not exist.
App\Entity\MediaTranslation No errors.
App\Entity\Partenaires No errors.
App\Entity\Presse No errors.
App\Entity\PresseTranslation No errors.
App\Entity\Switcher No errors.
App\Entity\SwitcherTranslation No errors.
App\Entity\Um6p\BlockEvent No errors.
App\Entity\Um6p\BlockEventTranslation No errors.
App\Entity\Um6p\Event No errors.
App\Entity\Um6p\EventTranslation No errors.
App\Entity\Um6p\Formation No errors.
App\Entity\Um6p\FormationTranslation No errors.
App\Entity\Um6p\MediaEvent No errors.
App\Entity\Um6p\MediaPhd No errors.
App\Entity\Um6p\Module No errors.
App\Entity\Um6p\ModuleTranslation No errors.
App\Entity\Um6p\Prof
  • The association App\Entity\Um6p\Prof#pages refers to the inverse side field App\Entity\Page#profs which does not exist.
App\Entity\Um6p\ProfTranslation No errors.
App\Entity\Um6p\Speaker No errors.
App\Entity\Um6p\SpeakerTranslation No errors.
Vich\UploaderBundle\Entity\File No errors.