Query Metrics

10 Database Queries
5 Different statements
3.12 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.54 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.homepage_baseline AS homepage_baseline_4, t0.homepage_filename AS homepage_filename_5, t0.title AS title_6, t0.meta_description AS meta_description_7, t0.infos_pratiques_adresse AS infos_pratiques_adresse_8, t0.infos_pratiques_mail AS infos_pratiques_mail_9, t0.infos_pratiques_telephone AS infos_pratiques_telephone_10, t0.url_site_internet AS url_site_internet_11, t0.url_billetterie AS url_billetterie_12, t0.url_instagram AS url_instagram_13, t0.url_facebook AS url_facebook_14, t0.url_youtube AS url_youtube_15, t0.calendrier_horaires AS calendrier_horaires_16, t0.infos_pratique_logo_filename AS infos_pratique_logo_filename_17, t0.infos_pratiques_map_filename AS infos_pratiques_map_filename_18, t0.header_image_filename AS header_image_filename_19, t0.texte1 AS texte1_20, t0.slotmachine_filename AS slotmachine_filename_21, t0.autonome_creation_lot AS autonome_creation_lot_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24, t0.enabled AS enabled_25, t0.sortable AS sortable_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28 FROM fiche_partenaire t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "parc-de-la-belle"
]
2 0.42 ms
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 f0_.id <> ? AND f0_.enabled = 1
Parameters:
[
  9
]
3 0.38 ms
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 INNER JOIN fiche_partenaire_categorie ON t0.id = fiche_partenaire_categorie.categorie_id WHERE fiche_partenaire_categorie.fiche_partenaire_id = ?
Parameters:
[
  9
]
4 0.38 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.alt AS alt_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, t0.fiche_partenaire_id AS fiche_partenaire_id_10 FROM fiche_partenaire_carousel t0 WHERE t0.fiche_partenaire_id = ? ORDER BY t0.sortable ASC
Parameters:
[
  9
]
5 0.27 ms
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"
]
6 0.26 ms
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_reglement"
]
7 0.25 ms
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_instagram"
]
8 0.22 ms
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_youtube"
]
9 0.21 ms
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_facebook"
]
10 0.21 ms
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:
[
  "lien_politique_confidentialite"
]

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\FichePartenaire No errors.
App\Entity\Categorie No errors.
App\Entity\FichePartenaireCarousel No errors.
App\Entity\User No errors.
App\Entity\Lot No errors.
App\Entity\Parametre No errors.