GET https://devz8.com/bafa/detail/2260/LILLE%20(59)

Query Metrics

2 Database Queries
2 Different statements
15.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
15.28 ms
(96.33%)
1
SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, f0_.zone_id AS zone_id_30, f0_.type_id AS type_id_31, f0_.theme_id AS theme_id_32, f0_.themebafa_id AS themebafa_id_33, f0_.saison_id AS saison_id_34, f0_.region_id AS region_id_35, f0_.hebergement_id AS hebergement_id_36, f0_.externat_id AS externat_id_37, f0_.actif_id AS actif_id_38, f0_.disponibilite_id AS disponibilite_id_39, t3_.type_id AS type_id_40 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id WHERE f0_.id = ?
Parameters:
[
  "2260"
]
0.58 ms
(3.67%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Formation No errors.
App\Entity\Type No errors.
App\Entity\Region No errors.
App\Entity\Theme No errors.
App\Entity\Saison No errors.
App\Entity\Externat No errors.
App\Entity\Webzone No errors.
App\Entity\ThemeBafa No errors.
App\Entity\Hebergement No errors.
App\Entity\Actif No errors.
App\Entity\Disponibilite No errors.
App\Entity\Pooldocformation No errors.
App\Entity\EspaceDocument No errors.
App\Entity\ThemeBafaPrincipal No errors.