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

Query Metrics

21 Database Queries
12 Different statements
31.20 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.15 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:
[
  "events"
]
2 1.40 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:
[
  "seminars-conferences"
]
3 1.62 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valeur AS valeur_2 FROM config c0_ WHERE c0_.name = ?
Parameters:
[
  "articles_nbr_page"
]
4 8.23 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 = 1 ORDER BY e0_.date_publier DESC) dctrn_result) dctrn_table
Parameters:
[]
5 1.06 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:
[
  8
]
6 1.39 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.59 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.25 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.06 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 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"
]
11 1.26 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"
]
12 0.79 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:
[
  9
]
13 1.30 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_publier_10 FROM (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 = 1) dctrn_result_inner ORDER BY date_publier_10 DESC) dctrn_result LIMIT 10
Parameters:
[]
14 1.13 ms
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 = 1 AND e0_.id IN (?) ORDER BY e0_.date_publier DESC
Parameters:
[
  1
]
15 0.90 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
]
16 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:
[
  "people"
]
17 0.92 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"
]
18 0.80 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"
]
19 0.66 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"
]
20 0.94 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"
]
21 0.65 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\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\Config No errors.
App\Entity\Um6p\Event No errors.
App\Entity\BlockTranslation 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\BlockEventTranslation No errors.
App\Entity\Um6p\SpeakerTranslation No errors.
App\Entity\Actualites No errors.
App\Entity\ActualitesTranslation No errors.
App\Entity\User No errors.
App\Entity\Administrateur 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.