GET https://www.asfivillejuif.com/

Query Metrics

101 Database Queries
17 Different statements
49.64 ms Query time
1 Invalid entities
125 Managed entities

Grouped Statements

Show all queries

Time Count Info
12.69 ms
(25.56%)
26
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
7.26 ms
(14.63%)
21
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_quill t0 WHERE t0.id = ?
Parameters:
[
  1
]
5.12 ms
(10.31%)
17
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_varchar t0 WHERE t0.id = ?
Parameters:
[
  1
]
3.72 ms
(7.49%)
8
SELECT t0.id AS id_1, t0.url_original AS url_original_2, t0.url AS url_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM data_image t0 WHERE t0.id = ?
Parameters:
[
  1
]
3.44 ms
(6.92%)
6
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.titre AS titre_4, t0.description AS description_5, t0.date_upload AS date_upload_6, t0.storage_url AS storage_url_7, t0.flickr AS flickr_8, t0.storage_url_bdef AS storage_url_bdef_9, t0.port AS port_10, t0.ipad AS ipad_11, t0.ordi AS ordi_12, t0.user_proprio_id AS user_proprio_id_13 FROM album_docs t0 WHERE t0.id = ?
Parameters:
[
  1
]
3.15 ms
(6.35%)
8
SELECT t0.id AS id_1, t0.jour_semaine AS jour_semaine_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.canceled_dates AS canceled_dates_7, t0.ordre AS ordre_8, t0.creneau_id AS creneau_id_9 FROM creneau_event t0 WHERE t0.creneau_id = ?
Parameters:
[
  1
]
2.15 ms
(4.33%)
1
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.actif AS actif_3, t0.visuel_id AS visuel_id_4 FROM datas_carousel t0 INNER JOIN conf_hero_datas_carousel ON t0.id = conf_hero_datas_carousel.datas_carousel_id WHERE conf_hero_datas_carousel.conf_hero_id = ?
Parameters:
[
  1
]
1.92 ms
(3.87%)
1
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.actif AS actif_3, t0.url_id AS url_id_4, t0.texte_id AS texte_id_5 FROM datas_link t0 INNER JOIN conf_hero_datas_link ON t0.id = conf_hero_datas_link.datas_link_id WHERE conf_hero_datas_link.conf_hero_id = ?
Parameters:
[
  1
]
1.80 ms
(3.62%)
4
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.url AS url_4, t0.js AS js_5, t0.css AS css_6, t0.actif AS actif_7 FROM contenu t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.49 ms
(2.99%)
2
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.home_page = 1
Parameters:
[]
1.38 ms
(2.77%)
1
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.zoom AS zoom_4, t0.titre_id AS titre_id_5, t0.texte_id AS texte_id_6, t0.texte_form_id AS texte_form_id_7, t0.texte_bouton_id AS texte_bouton_id_8, t0.adresse_id AS adresse_id_9, t0.telephone_id AS telephone_id_10, t0.email_id AS email_id_11 FROM conf_contact t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.37 ms
(2.76%)
1
SELECT t0.id AS id_1, t0.texte1_id AS texte1_id_2, t0.texte2_id AS texte2_id_3, t0.texte3_id AS texte3_id_4, t0.temps_id AS temps_id_5, t0.texte_bandeau_id AS texte_bandeau_id_6 FROM conf_hero t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.30 ms
(2.62%)
1
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.titre_id AS titre_id_3, t0.texte_id AS texte_id_4 FROM conf_sommaire t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.96 ms
(1.93%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_nombre t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.67 ms
(1.36%)
1
SELECT c0_.id AS id_0, c0_.nom_template AS nom_template_1, c0_.ordre AS ordre_2, c0_.id_conf AS id_conf_3, c0_.actif AS actif_4, c0_.page_id AS page_id_5, c0_.contenu_id AS contenu_id_6 FROM cases_pages c0_ WHERE c0_.page_id = ? AND c0_.actif = 1 ORDER BY c0_.ordre ASC
Parameters:
[
  1
]
0.66 ms
(1.32%)
1
SELECT c0_.id AS id_0, c0_.ordre AS ordre_1, c0_.actif AS actif_2, c0_.lien AS lien_3, c0_.date_crea AS date_crea_4, c0_.date_modif AS date_modif_5, c0_.titre_id AS titre_id_6, c0_.texte_id AS texte_id_7, c0_.visuel_id AS visuel_id_8, c0_.texte2_id AS texte2_id_9 FROM creneaux c0_ WHERE c0_.actif = 1 ORDER BY c0_.ordre ASC
Parameters:
[]
0.58 ms
(1.16%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.home_page = 1
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Pages\Pages 29
App\Entity\Datas\DataQuill 22
App\Entity\Datas\DataVarchar 17
App\Entity\Creneaux\CreneauEvent 15
App\Entity\Creneaux\Creneaux 8
App\Entity\Datas\DataImage 8
App\Entity\Datas\DatasCarousel 6
App\Entity\Album\AlbumDocs 6
App\Entity\Pages\CasesPages 4
App\Entity\Pages\Contenu 4
App\Entity\Securite\SecurUser 1
App\Entity\Conf\ConfHero 1
App\Entity\Datas\DataNombre 1
App\Entity\Conf\ConfSommaire 1
App\Entity\Conf\ConfContact 1
App\Entity\Datas\DatasLink 1

Entities Mapping

Class Mapping errors
App\Entity\Pages\Pages No errors.
App\Entity\Securite\SecurUser No errors.
App\Entity\Pages\CasesPages No errors.
App\Entity\Pages\Contenu No errors.
App\Entity\Conf\ConfHero No errors.
App\Entity\Datas\DataQuill No errors.
App\Entity\Datas\DataVarchar No errors.
App\Entity\Datas\DataNombre No errors.
App\Entity\Datas\DatasLink No errors.
App\Entity\Datas\DatasCarousel No errors.
App\Entity\Conf\ConfSommaire No errors.
App\Entity\Creneaux\Creneaux
  • The association App\Entity\Creneaux\Creneaux#securUsers refers to the owning side field App\Entity\Securite\SecurUser#groupe which does not exist.
App\Entity\Datas\DataImage No errors.
App\Entity\Creneaux\CreneauEvent No errors.
App\Entity\Conf\ConfContact No errors.
App\Entity\Album\AlbumDocs No errors.
App\Entity\Album\AlbumCategorie No errors.