GET https://troyes.abeille-verte.fr/franchise/francis-moreau-1

Query Metrics

4 Database Queries
4 Different statements
3.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.94 ms
(29.36%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.profile_filename AS profile_filename_4, t0.departement AS departement_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.secteur AS secteur_8, t0.mail AS mail_9, t0.phone AS phone_10, t0.fiche_google AS fiche_google_11, t0.services AS services_12, t0.siret AS siret_13, t0.seo_title AS seo_title_14, t0.seo_content AS seo_content_15, t0.is_ads_word AS is_ads_word_16, t0.title_home_site AS title_home_site_17, t0.subdomain AS subdomain_18, t0.presentation AS presentation_19, t0.title_service AS title_service_20, t0.description_service AS description_service_21, t0.title_service_2 AS title_service_2_22, t0.description_service_2 AS description_service_2_23, t0.home_filename AS home_filename_24 FROM franchise t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.80 ms
(24.90%)
1
SELECT a0_.id AS id_0, a0_.actuality_filename AS actuality_filename_1, a0_.title AS title_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.text AS text_5, a0_.owned_by_id AS owned_by_id_6 FROM actuality a0_ LEFT JOIN actuality_franchise a2_ ON a0_.id = a2_.actuality_id LEFT JOIN franchise f1_ ON f1_.id = a2_.franchise_id WHERE f1_.id IN (?) ORDER BY a0_.id DESC
Parameters:
[
  1
]
0.74 ms
(23.16%)
1
SELECT r0_.id AS id_0, r0_.ville AS ville_1, r0_.realisation_filename AS realisation_filename_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r0_.list AS list_5, r0_.description AS description_6, r0_.title AS title_7, r0_.franchise_id AS franchise_id_8 FROM realisation r0_ WHERE r0_.franchise_id = ? ORDER BY r0_.id DESC
Parameters:
[
  1
]
0.72 ms
(22.59%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.text AS text_2, a0_.rate AS rate_3, a0_.online AS online_4, a0_.is_legal AS is_legal_5, a0_.franchise_id AS franchise_id_6 FROM avis a0_ WHERE a0_.franchise_id = ? AND a0_.online = 1 ORDER BY a0_.id DESC LIMIT 10
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\Franchise No errors.
App\Entity\Avis No errors.
App\Entity\Realisation No errors.
App\Entity\Cities No errors.
App\Entity\ContactWebsitePro No errors.
App\Entity\Actuality No errors.
App\Entity\DevisWebsite No errors.
App\Entity\User No errors.
App\Entity\PicturesRealisation No errors.