Query Metrics

9 Database Queries
4 Different statements
5.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.62 ms
(47.51%)
6
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "footer_lien_participer_tirage"
]
1.81 ms
(32.84%)
1
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.slug AS slug_2, f0_.homepage_baseline AS homepage_baseline_3, f0_.homepage_filename AS homepage_filename_4, f0_.title AS title_5, f0_.meta_description AS meta_description_6, f0_.infos_pratiques_adresse AS infos_pratiques_adresse_7, f0_.infos_pratiques_mail AS infos_pratiques_mail_8, f0_.infos_pratiques_telephone AS infos_pratiques_telephone_9, f0_.url_site_internet AS url_site_internet_10, f0_.url_billetterie AS url_billetterie_11, f0_.url_instagram AS url_instagram_12, f0_.url_facebook AS url_facebook_13, f0_.url_youtube AS url_youtube_14, f0_.calendrier_horaires AS calendrier_horaires_15, f0_.infos_pratique_logo_filename AS infos_pratique_logo_filename_16, f0_.infos_pratiques_map_filename AS infos_pratiques_map_filename_17, f0_.header_image_filename AS header_image_filename_18, f0_.texte1 AS texte1_19, f0_.slotmachine_filename AS slotmachine_filename_20, f0_.autonome_creation_lot AS autonome_creation_lot_21, f0_.created_by AS created_by_22, f0_.updated_by AS updated_by_23, f0_.enabled AS enabled_24, f0_.sortable AS sortable_25, f0_.created_at AS created_at_26, f0_.updated_at AS updated_at_27 FROM fiche_partenaire f0_ WHERE EXISTS (SELECT 1 FROM fiche_partenaire_categorie f1_ WHERE f1_.fiche_partenaire_id = f0_.id AND f1_.categorie_id IN (?)) AND f0_.enabled = 1 ORDER BY f0_.libelle ASC
Parameters:
[
  4
]
0.61 ms
(11.05%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.enabled AS enabled_6, t0.sortable AS sortable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM categorie t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "culture"
]
0.47 ms
(8.60%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.enabled AS enabled_6, t0.sortable AS sortable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM categorie t0 ORDER BY t0.libelle 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\Categorie No errors.
App\Entity\FichePartenaire No errors.
App\Entity\FichePartenaireCarousel No errors.
App\Entity\User No errors.
App\Entity\Lot No errors.
App\Entity\Parametre No errors.