http://mcgt-website-rec.azurewebsites.net/en/people/advisory-board

Method
GET
HTTP Status
200
IP
169.254.130.1
Profiled on
Token
20ef47

Query Metrics

36 Database Queries
12 Different statements
41.04 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.00 ms 
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.imagemobile AS imagemobile_7, t0.menu AS menu_8 FROM categorypage t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "people"
]
View formatted query    View runnable query    Explain query
2 1.15 ms 
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: 
[
  "advisory-board"
]
View formatted query    View runnable query    Explain query
3 1.14 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query
4 1.26 ms 
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: 
[]
View formatted query    View runnable query    Explain query
5 1.21 ms 
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"
]
View formatted query    View runnable query    Explain query
6 0.79 ms 
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: 
[
  "events"
]
View formatted query    View runnable query    Explain query
7 0.89 ms 
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: 
[
  "join-us"
]
View formatted query    View runnable query    Explain query
8 2.38 ms 
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: 
[
  "join-us"
]
View formatted query    View runnable query    Explain query
9 1.58 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM categorypage_translation t0 WHERE t0.translatable_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
10 2.28 ms 
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"
]
View formatted query    View runnable query    Explain query
11 0.73 ms 
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: 
[
  5
]
View formatted query    View runnable query    Explain query
12 1.26 ms 
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: 
[
  7
]
View formatted query    View runnable query    Explain query
13 1.74 ms 
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.position AS position_2, p0_.publier AS publier_3, p0_.link AS link_4, p0_.linkedin AS linkedin_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7 FROM prof p0_ LEFT JOIN prof_page p2_ ON p0_.id = p2_.prof_id LEFT JOIN PAGE p1_ ON p1_.id = p2_.page_id LEFT JOIN prof_translation p3_ ON p0_.id = p3_.translatable_id WHERE p0_.publier = 1 AND p1_.slug = ? ORDER BY p3_.nom ASC
Parameters: 
[
  "advisory-board"
]
View formatted query    View runnable query    Explain query
14 1.41 ms 
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: 
[
  11
]
View formatted query    View runnable query    Explain query
15 0.89 ms 
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: 
[
  21
]
View formatted query    View runnable query    Explain query
16 0.73 ms 
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: 
[
  15
]
View formatted query    View runnable query    Explain query
17 0.70 ms 
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: 
[
  16
]
View formatted query    View runnable query    Explain query
18 0.77 ms 
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: 
[
  17
]
View formatted query    View runnable query    Explain query
19 0.73 ms 
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: 
[
  13
]
View formatted query    View runnable query    Explain query
20 0.76 ms 
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: 
[
  9
]
View formatted query    View runnable query    Explain query
21 0.66 ms 
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: 
[
  18
]
View formatted query    View runnable query    Explain query
22 0.77 ms 
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: 
[
  12
]
View formatted query    View runnable query    Explain query
23 0.74 ms 
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: 
[
  19
]
View formatted query    View runnable query    Explain query
24 0.98 ms 
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: 
[
  20
]
View formatted query    View runnable query    Explain query
25 0.92 ms 
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: 
[
  10
]
View formatted query    View runnable query    Explain query
26 0.86 ms 
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: 
[
  5
]
View formatted query    View runnable query    Explain query
27 0.75 ms 
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: 
[
  14
]
View formatted query    View runnable query    Explain query
28 2.18 ms 
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: 
[
  8
]
View formatted query    View runnable query    Explain query
29 0.78 ms 
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: 
[
  "advisory-board"
  1
]
View formatted query    View runnable query    Explain query
30 0.68 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query
31 1.37 ms 
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"
]
View formatted query    View runnable query    Explain query
32 1.27 ms 
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: 
[
  "events"
]
View formatted query    View runnable query    Explain query
33 1.79 ms 
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: 
[
  "join-us"
]
View formatted query    View runnable query    Explain query
34 1.07 ms 
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: 
[
  "join-us"
]
View formatted query    View runnable query    Explain query
35 1.74 ms 
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"
]
View formatted query    View runnable query    Explain query
36 1.06 ms 
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: 
[
  30
]
View formatted query    View runnable query    Explain query

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\Categorypage No errors.
App\Entity\Page No errors.
App\Entity\CategorypageTranslation No errors.
App\Entity\Block No errors.
App\Entity\PageTranslation 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.