Query Metrics

10 Database Queries
6 Different statements
5.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.79 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.image AS image_5, t0.presentation AS presentation_6, t0.metro AS metro_7, t0.bus AS bus_8, t0.parking AS parking_9, t0.acces_pmr AS acces_pmr_10, t0.map AS map_11, t0.image_bleu AS image_bleu_12, t0.slug AS slug_13 FROM office t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.58 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.image AS image_5, t0.presentation AS presentation_6, t0.metro AS metro_7, t0.bus AS bus_8, t0.parking AS parking_9, t0.acces_pmr AS acces_pmr_10, t0.map AS map_11, t0.image_bleu AS image_bleu_12, t0.slug AS slug_13 FROM office t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.38 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.image AS image_5, t0.presentation AS presentation_6, t0.metro AS metro_7, t0.bus AS bus_8, t0.parking AS parking_9, t0.acces_pmr AS acces_pmr_10, t0.map AS map_11, t0.image_bleu AS image_bleu_12, t0.slug AS slug_13 FROM office t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.63 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_url AS site_url_3, t0.site_url_full AS site_url_full_4, t0.site_logo AS site_logo_5, t0.site_keywords AS site_keywords_6, t0.site_description AS site_description_7, t0.site_facebook AS site_facebook_8, t0.site_instagram AS site_instagram_9, t0.site_linkedin AS site_linkedin_10, t0.site_espaceclient AS site_espaceclient_11, t0.site_rgpd AS site_rgpd_12, t0.expert_titre1 AS expert_titre1_13, t0.expert_titre2 AS expert_titre2_14, t0.expert_content AS expert_content_15, t0.tarif_titre1 AS tarif_titre1_16, t0.tarif_titre2 AS tarif_titre2_17, t0.tarif_text AS tarif_text_18, t0.tarif_honnoraires AS tarif_honnoraires_19, t0.tarif_image AS tarif_image_20, t0.tarif_footertitre1 AS tarif_footertitre1_21, t0.tarif_footertitre2 AS tarif_footertitre2_22, t0.tarif_footertextbutton AS tarif_footertextbutton_23, t0.site_email AS site_email_24, t0.site_telephone AS site_telephone_25, t0.office_titre AS office_titre_26, t0.tarif_brochure AS tarif_brochure_27, t0.site_mentions AS site_mentions_28, t0.footer_notairesfrance AS footer_notairesfrance_29, t0.offre_titre AS offre_titre_30 FROM setting t0
Parameters:
[]
5 0.47 ms
SELECT t0.id AS id_1, t0.hero_text1 AS hero_text1_2, t0.hero_text2 AS hero_text2_3, t0.hero_image AS hero_image_4, t0.diff_image1 AS diff_image1_5, t0.diff_image2 AS diff_image2_6, t0.diff_image3 AS diff_image3_7, t0.diff_titre1 AS diff_titre1_8, t0.diff_titre2 AS diff_titre2_9, t0.diff_text AS diff_text_10, t0.diff_buttontext AS diff_buttontext_11, t0.offices_titre1 AS offices_titre1_12, t0.offices_titre2 AS offices_titre2_13, t0.offices_image1 AS offices_image1_14, t0.offices_imagetext1 AS offices_imagetext1_15, t0.offices_buttontext1 AS offices_buttontext1_16, t0.offices_image2 AS offices_image2_17, t0.offices_imagetext2 AS offices_imagetext2_18, t0.offices_image3 AS offices_image3_19, t0.offices_imagetext3 AS offices_imagetext3_20, t0.actu_titre1 AS actu_titre1_21, t0.actu_titre2 AS actu_titre2_22, t0.actu_linkedin AS actu_linkedin_23, t0.actu_facebook AS actu_facebook_24, t0.avis_titre1 AS avis_titre1_25, t0.avis_titre2 AS avis_titre2_26, t0.offices_image1bleu AS offices_image1bleu_27, t0.offices_image2bleu AS offices_image2bleu_28, t0.offices_image3bleu AS offices_image3bleu_29 FROM homepage t0
Parameters:
[]
6 0.29 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.url AS url_4 FROM label t0
Parameters:
[]
7 0.93 ms
SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.image AS image_3, a0_.created_at AS created_at_4, a0_.content AS content_5, a0_.eval AS eval_6, a0_.is_enabled AS is_enabled_7, o1_.id AS id_8, o1_.titre AS titre_9, o1_.adresse AS adresse_10, o1_.telephone AS telephone_11, o1_.image AS image_12, o1_.presentation AS presentation_13, o1_.metro AS metro_14, o1_.bus AS bus_15, o1_.parking AS parking_16, o1_.acces_pmr AS acces_pmr_17, o1_.map AS map_18, o1_.image_bleu AS image_bleu_19, o1_.slug AS slug_20, a0_.office_id AS office_id_21 FROM avis a0_ LEFT JOIN office o1_ ON a0_.office_id = o1_.id WHERE a0_.office_id = ? AND a0_.is_enabled = 1 ORDER BY a0_.id DESC LIMIT 1
Parameters:
[
  2
]
8 0.80 ms
SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.image AS image_3, a0_.created_at AS created_at_4, a0_.content AS content_5, a0_.eval AS eval_6, a0_.is_enabled AS is_enabled_7, o1_.id AS id_8, o1_.titre AS titre_9, o1_.adresse AS adresse_10, o1_.telephone AS telephone_11, o1_.image AS image_12, o1_.presentation AS presentation_13, o1_.metro AS metro_14, o1_.bus AS bus_15, o1_.parking AS parking_16, o1_.acces_pmr AS acces_pmr_17, o1_.map AS map_18, o1_.image_bleu AS image_bleu_19, o1_.slug AS slug_20, a0_.office_id AS office_id_21 FROM avis a0_ LEFT JOIN office o1_ ON a0_.office_id = o1_.id WHERE a0_.office_id = ? AND a0_.is_enabled = 1 ORDER BY a0_.id DESC LIMIT 1
Parameters:
[
  1
]
9 0.63 ms
SELECT a0_.id AS id_0, a0_.firstname AS firstname_1, a0_.lastname AS lastname_2, a0_.image AS image_3, a0_.created_at AS created_at_4, a0_.content AS content_5, a0_.eval AS eval_6, a0_.is_enabled AS is_enabled_7, o1_.id AS id_8, o1_.titre AS titre_9, o1_.adresse AS adresse_10, o1_.telephone AS telephone_11, o1_.image AS image_12, o1_.presentation AS presentation_13, o1_.metro AS metro_14, o1_.bus AS bus_15, o1_.parking AS parking_16, o1_.acces_pmr AS acces_pmr_17, o1_.map AS map_18, o1_.image_bleu AS image_bleu_19, o1_.slug AS slug_20, a0_.office_id AS office_id_21 FROM avis a0_ LEFT JOIN office o1_ ON a0_.office_id = o1_.id WHERE a0_.office_id = ? AND a0_.is_enabled = 1 ORDER BY a0_.id DESC LIMIT 1
Parameters:
[
  3
]
10 0.47 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.content AS content_6, t0.eval AS eval_7, t0.is_enabled AS is_enabled_8, t0.office_id AS office_id_9 FROM avis t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]

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\Setting No errors.
App\Entity\Homepage No errors.
App\Entity\Label No errors.
App\Entity\Avis No errors.
App\Entity\Office No errors.
App\Entity\Offre No errors.