Query Metrics
10
Database Queries
6
Different statements
5.86 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.07 ms (35.33%) |
3 |
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
]
|
1.83 ms (31.23%) |
3 |
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
]
|
0.71 ms (12.08%) |
1 |
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:
[] |
0.50 ms (8.58%) |
1 |
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:
[] |
0.39 ms (6.69%) |
1 |
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
]
|
0.36 ms (6.09%) |
1 |
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:
[] |
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. |