http://mcgt-website-rec.azurewebsites.net/_footer

Query Metrics

40 Database Queries
12 Different statements
38.16 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.29 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.slug AS slug_3, t0.link AS link_4, t0.location AS location_5, t0.position AS position_6, t0.publier AS publier_7, t0.encours AS encours_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.date_publier AS date_publier_11, t0.date_final AS date_final_12 FROM event t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "game-theory-days"
]
2 1.33 ms
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_.isopen AS isopen_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.event_id AS event_id_8 FROM media_event m0_ LEFT JOIN event e1_ ON m0_.event_id = e1_.id WHERE e1_.id = ? AND m0_.publier = 1 AND m0_.isopen = 0 ORDER BY m0_.position ASC
Parameters:
[
  1
]
3 0.71 ms
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_.isopen AS isopen_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.event_id AS event_id_8 FROM media_event m0_ LEFT JOIN event e1_ ON m0_.event_id = e1_.id WHERE e1_.id = ? AND m0_.publier = 1 AND m0_.isopen = 1 ORDER BY m0_.position ASC
Parameters:
[
  1
]
4 1.34 ms
SELECT s0_.id AS id_0, s0_.image AS image_1, s0_.link AS link_2, s0_.linkedin AS linkedin_3, s0_.position AS position_4, s0_.publier AS publier_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM speaker s0_ LEFT JOIN event_speaker e2_ ON s0_.id = e2_.speaker_id LEFT JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.id = ? AND s0_.publier = 1 ORDER BY s0_.position ASC
Parameters:
[
  1
]
5 0.99 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.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM event_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
6 1.14 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:
[]
7 1.31 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"
]
8 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:
[
  "events"
]
9 1.15 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"
]
10 0.90 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"
]
11 1.91 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.publier AS publier_3, t0.event_id AS event_id_4 FROM block_event t0 WHERE t0.event_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
12 1.12 ms
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM block_event_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
13 0.70 ms
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM block_event_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
14 0.77 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
15 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
16 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
17 0.53 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
18 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
19 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
20 0.60 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
21 0.79 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
22 1.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
23 0.64 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
24 0.80 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
25 1.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
26 1.53 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
27 1.00 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
28 0.78 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  21
]
29 0.56 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
30 0.79 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  23
]
31 0.62 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  24
]
32 0.60 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  25
]
33 0.71 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  26
]
34 1.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fonction AS fonction_3, t0.specialite AS specialite_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM speaker_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  27
]
35 0.97 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"
]
36 0.97 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"
]
37 1.70 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"
]
38 0.95 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"
]
39 0.65 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"
]
40 0.94 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
]

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\Um6p\Event No errors.
App\Entity\Um6p\BlockEvent No errors.
App\Entity\Um6p\MediaEvent No errors.
App\Entity\Um6p\Speaker No errors.
App\Entity\Um6p\EventTranslation No errors.
App\Entity\Um6p\SpeakerTranslation No 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\Um6p\BlockEventTranslation 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\Formation No errors.
App\Entity\Um6p\FormationTranslation 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.
Vich\UploaderBundle\Entity\File No errors.