Query Metrics
4
Database Queries
4
Different statements
14.15 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 11.87 ms |
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:
[
"2478"
]
|
2 | 0.40 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = ?
Parameters:
[
2
]
|
3 | 1.29 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.descriptif AS descriptif_3, t0.zone_id AS zone_id_4 FROM theme_bafa t0 WHERE t0.id = ?
Parameters:
[
682
]
|
4 | 0.60 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.theme_id AS theme_id_3 FROM theme_bafa_principal t0 INNER JOIN theme_bafa_principal_theme_bafa ON t0.id = theme_bafa_principal_theme_bafa.theme_bafa_principal_id WHERE theme_bafa_principal_theme_bafa.theme_bafa_id = ?
Parameters:
[
682
]
|
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. |