Query Metrics
9
Database Queries
7
Different statements
103.25 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 31.81 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 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 LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.type_id = ? AND f0_.datedebut > ? AND f0_.actif_id = ? ORDER BY f0_.datedebut ASC) dctrn_result) dctrn_table
Parameters:
[ 1 "2024-12-19" 1 ] |
2 | 0.25 ms |
SELECT s0_.id AS id_0, s0_.nom AS nom_1 FROM saison s0_
Parameters:
[] |
3 | 0.20 ms |
SELECT r0_.id AS id_0, r0_.nom AS nom_1 FROM region r0_
Parameters:
[] |
4 | 0.23 ms |
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.type_id AS type_id_2 FROM theme t0_ WHERE t0_.type_id = ?
Parameters:
[
1
]
|
5 | 31.47 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (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, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 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 LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.type_id = ? AND f0_.datedebut > ? AND f0_.actif_id = ?) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 10
Parameters:
[ 1 "2024-12-19" 1 ] |
6 | 16.67 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, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 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 LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.type_id = ? AND f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC
Parameters:
[ 1 "2024-12-19" 1 2260 2279 2541 2323 2324 2325 2407 2408 2409 2280 ] |
7 | 0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = ?
Parameters:
[
2
]
|
8 | 12.45 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (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, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 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 LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.type_id = ? AND f0_.datedebut > ? AND f0_.actif_id = ?) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 10
Parameters:
[ 1 "2024-12-19" 1 ] |
9 | 9.91 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, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 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 LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.type_id = ? AND f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC
Parameters:
[ 1 "2024-12-19" 1 2260 2279 2541 2323 2324 2325 2407 2408 2409 2280 ] |
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\Theme | No errors. |
App\Entity\Type | No errors. |
App\Entity\Saison | No errors. |
App\Entity\Region | No errors. |
App\Entity\Formation | No errors. |
App\Entity\Externat | No errors. |
App\Entity\ThemeBafa | No errors. |
App\Entity\EspaceDocument | No errors. |
App\Entity\ThemeBafaPrincipal | No errors. |
App\Entity\Webzone | No errors. |
App\Entity\Hebergement | No errors. |
App\Entity\Actif | No errors. |
App\Entity\Disponibilite | No errors. |
App\Entity\Pooldocformation | No errors. |