Query Metrics

28 Database Queries
26 Different statements
130.65 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
109.42 ms
(83.76%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.recherche AS recherche_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5 FROM localisations t0 ORDER BY t0.libelle ASC
Parameters:
[]
1.99 ms
(1.52%)
2
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.description AS description_2, t0_.image AS image_3, t0_.courant AS courant_4, t0_.dirname AS dirname_5, t0_.color_prime AS color_prime_6, t0_.color_second AS color_second_7, t0_.color_third AS color_third_8, t0_.date_maj AS date_maj_9, t0_.text_color_prime AS text_color_prime_10, t0_.text_color_second AS text_color_second_11, t0_.color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_.courant = ? LIMIT 1
Parameters:
[
  1
]
1.91 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.date_creation AS date_creation_4, t0.date_maj AS date_maj_5, t0.image AS image_6, t0.titre_seo AS titre_seo_7, t0.date_publication AS date_publication_8, t0.nature_offre AS nature_offre_9, t0.type_offre AS type_offre_10, t0.smin_offre AS smin_offre_11, t0.smax_offre AS smax_offre_12, t0.afficher_carrousel_offre AS afficher_carrousel_offre_13, t0.afficher_carrousel_crit AS afficher_carrousel_crit_14, t0.titre_offre AS titre_offre_15, t0.afficher_bouton_offre AS afficher_bouton_offre_16, t0.libelle_bouton_offre AS libelle_bouton_offre_17, t0.title_bouton_offre AS title_bouton_offre_18, t0.url_offre AS url_offre_19, t0.og_title AS og_title_20, t0.og_desc AS og_desc_21, t0.og_image AS og_image_22, t0.seo_titre AS seo_titre_23, t0.seo_desc AS seo_desc_24, t0.user_id AS user_id_25, t0.statut_id AS statut_id_26, t0.categorie_id AS categorie_id_27, t0.agence_id AS agence_id_28 FROM actus t0 WHERE t0.titre_seo = ? LIMIT 1
Parameters:
[
  "courtaboeuf-moteur-economique-de-lessonne-evolution-marches-et-articulation-avec-paris-saclay"
]
1.63 ms
(1.25%)
1
SELECT t0.id AS id_1, t0.affichage AS affichage_2, t0.choix_affichage_carte AS choix_affichage_carte_3, t0.choix_affichage_mixte AS choix_affichage_mixte_4, t0.choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.61 ms
(1.23%)
2
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.seo_url AS seo_url_3, t0.seo_titre AS seo_titre_4, t0.seo_desc AS seo_desc_5, t0.titre AS titre_6, t0.contenu_un AS contenu_un_7, t0.contenu_deux AS contenu_deux_8, t0.date_maj AS date_maj_9, t0.image AS image_10, t0.citation AS citation_11, t0.image_citation AS image_citation_12, t0.afficher_bloc_contact AS afficher_bloc_contact_13, t0.nature_offre AS nature_offre_14, t0.type_offre AS type_offre_15, t0.smin_offre AS smin_offre_16, t0.smax_offre AS smax_offre_17, t0.afficher_carrousel_offre AS afficher_carrousel_offre_18, t0.afficher_carrousel_crit AS afficher_carrousel_crit_19, t0.titre_offre AS titre_offre_20, t0.afficher_bouton_offre AS afficher_bouton_offre_21, t0.libelle_bouton_offre AS libelle_bouton_offre_22, t0.title_bouton_offre AS title_bouton_offre_23, t0.url_offre AS url_offre_24, t0.afficher_bloc_actus AS afficher_bloc_actus_25, t0.og_title AS og_title_26, t0.og_desc AS og_desc_27, t0.og_image AS og_image_28, t0.page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.41 ms
(1.08%)
1
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.contenu AS contenu_2, a0_.date_creation AS date_creation_3, a0_.date_maj AS date_maj_4, a0_.image AS image_5, a0_.titre_seo AS titre_seo_6, a0_.date_publication AS date_publication_7, a0_.nature_offre AS nature_offre_8, a0_.type_offre AS type_offre_9, a0_.smin_offre AS smin_offre_10, a0_.smax_offre AS smax_offre_11, a0_.afficher_carrousel_offre AS afficher_carrousel_offre_12, a0_.afficher_carrousel_crit AS afficher_carrousel_crit_13, a0_.titre_offre AS titre_offre_14, a0_.afficher_bouton_offre AS afficher_bouton_offre_15, a0_.libelle_bouton_offre AS libelle_bouton_offre_16, a0_.title_bouton_offre AS title_bouton_offre_17, a0_.url_offre AS url_offre_18, a0_.og_title AS og_title_19, a0_.og_desc AS og_desc_20, a0_.og_image AS og_image_21, a0_.seo_titre AS seo_titre_22, a0_.seo_desc AS seo_desc_23, a0_.user_id AS user_id_24, a0_.statut_id AS statut_id_25, a0_.categorie_id AS categorie_id_26, a0_.agence_id AS agence_id_27 FROM actus a0_ WHERE a0_.statut_id = ? AND a0_.date_publication < ? AND a0_.categorie_id = ? AND a0_.id <> ? ORDER BY a0_.date_publication DESC LIMIT 3
Parameters:
[
  2
  "2025-11-08 07:57:19"
  6
  84
]
1.20 ms
(0.92%)
1
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.secteur AS secteur_6, t0.picto AS picto_7, t0.date_maj AS date_maj_8, t0.email AS email_9, t0.tel AS tel_10, t0.ordre AS ordre_11, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 ORDER BY t0.ordre ASC
Parameters:
[]
0.99 ms
(0.76%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_seo AS libelle_seo_3, t0.color AS color_4 FROM actus_categorie t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.88 ms
(0.68%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.svg AS svg_6, t0.svg_header AS svg_header_7, t0.template_id AS template_id_8 FROM favoris_config t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
  1
]
0.87 ms
(0.67%)
1
SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.71 ms
(0.54%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.date_maj AS date_maj_4, t0.actif AS actif_5, t0.cle_api AS cle_api_6, t0.puce_map AS puce_map_7, t0.styles AS styles_8 FROM maps t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.70 ms
(0.53%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_trois_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.66 ms
(0.51%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.64 ms
(0.49%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.64 ms
(0.49%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_deux_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.60 ms
(0.46%)
1
SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.afficher_actus_similaires AS afficher_actus_similaires_5, t0.url_liste AS url_liste_6, t0.url_detail AS url_detail_7, t0.h1_liste AS h1_liste_8, t0.afficher_bloc_contact AS afficher_bloc_contact_9, t0.titre_actu_similaire AS titre_actu_similaire_10, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11, t0.seo_title AS seo_title_12, t0.seo_desc AS seo_desc_13, t0.image_bg AS image_bg_14, t0.date_maj AS date_maj_15 FROM actus_config t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.58 ms
(0.45%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3 FROM partage_config t0
Parameters:
[]
0.56 ms
(0.43%)
1
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.email AS email_6, t0.tel AS tel_7, t0.fax AS fax_8, t0.description AS description_9, t0.image AS image_10, t0.date_maj AS date_maj_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.facebook AS facebook_14, t0.contact_titre AS contact_titre_15, t0.contact_span AS contact_span_16, t0.contact_texte AS contact_texte_17, t0.favico AS favico_18, t0.cle_google_map AS cle_google_map_19, t0.puce_google_map AS puce_google_map_20, t0.contact_fond AS contact_fond_21, t0.google_analytics AS google_analytics_22, t0.insta AS insta_23 FROM infos t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.52 ms
(0.40%)
1
SELECT t0.id AS id_1, t0.nb_lignes AS nb_lignes_2, t0.libelle AS libelle_3, t0.afficher_pagination AS afficher_pagination_4, t0.url_liste AS url_liste_5, t0.url_detail AS url_detail_6, t0.h1_liste AS h1_liste_7, t0.afficher_bloc_contact AS afficher_bloc_contact_8, t0.afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9, t0.seo_title AS seo_title_10, t0.seo_desc AS seo_desc_11, t0.image_bg AS image_bg_12, t0.date_maj AS date_maj_13, t0.afficher_unite_loyer AS afficher_unite_loyer_14, t0.afficher_loyer AS afficher_loyer_15, t0.afficher_prix AS afficher_prix_16, t0.afficher_unite_prix AS afficher_unite_prix_17, t0.slider_surface_max AS slider_surface_max_18, t0.afficher_tri AS afficher_tri_19, t0.afficher_favoris AS afficher_favoris_20, t0.button_contact AS button_contact_21 FROM offres_config t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.51 ms
(0.39%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_menu_deux_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
0.50 ms
(0.38%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.actif AS actif_5, t0.date_maj AS date_maj_6, t0.nb AS nb_7 FROM secteur_config t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
  1
]
0.48 ms
(0.37%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.45 ms
(0.34%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.libelle_third AS libelle_third_4, t0.slug AS slug_5, t0.slug_second AS slug_second_6, t0.slug_third AS slug_third_7 FROM offres_nature t0
Parameters:
[]
0.42 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu t0
Parameters:
[]
0.39 ms
(0.30%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_second AS libelle_second_3, t0.slug AS slug_4, t0.slug_second AS slug_second_5 FROM offres_type t0
Parameters:
[]
0.37 ms
(0.28%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.photo AS photo_3, t0.update_at AS update_at_4, t0.type_offre_id AS type_offre_id_5 FROM offres_photos t0
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\Infos No errors.
App\Entity\Agence No errors.
App\Entity\ActusConfig No errors.
App\Entity\OffresConfig No errors.
App\Entity\OffresPhotos No errors.
App\Entity\OffresNature No errors.
App\Entity\OffresType No errors.
App\Entity\Localisations No errors.
App\Entity\Pages
  • The association App\Entity\Pages#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\Template No errors.
App\Entity\Menu No errors.
App\Entity\MenuMega No errors.
App\Entity\Footer No errors.
App\Entity\SecteurConfig No errors.
App\Entity\FavorisConfig No errors.
App\Entity\PartageConfig No errors.
App\Entity\Maps No errors.
App\Entity\TypeAffichage No errors.
App\Entity\Actus
  • The association App\Entity\Actus#localisationOffre refers to the inverse side field App\Entity\Localisations#actuses which does not exist.
App\Entity\ActusCategorie No errors.
App\Entity\Offres No errors.
App\Entity\User No errors.
App\Entity\ActusStatut No errors.
App\Entity\Carriere No errors.
App\Entity\Secteur No errors.
App\Entity\Equipe No errors.
App\Entity\AlerteMail No errors.
App\Entity\MenuLink No errors.
App\Entity\FooterLink No errors.
App\Entity\MenuMegaDeux No errors.
App\Entity\FooterBig No errors.