Query Metrics
12
Database Queries
12
Different statements
3.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.43 ms (10.75%) |
1 |
SELECT t0.heures AS heures_1, t0.jours AS jours_2, t0.rncp_code AS rncp_code_3, t0.diploma_code AS diploma_code_4, t0.diploma_label AS diploma_label_5, t0.id AS id_6, t0.ctime AS ctime_7, t0.utime AS utime_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.ref AS ref_11, t0.label AS label_12, t0.digi_id AS digi_id_13, t0.digi_ref AS digi_ref_14, t0.cerfa_data AS cerfa_data_15, t0.parent_id AS parent_id_16, t17.heures AS heures_18, t17.jours AS jours_19, t17.rncp_code AS rncp_code_20, t17.diploma_code AS diploma_code_21, t17.diploma_label AS diploma_label_22, t17.id AS id_23, t17.ctime AS ctime_24, t17.utime AS utime_25, t17.active AS active_26, t17.deleted AS deleted_27, t17.ref AS ref_28, t17.label AS label_29, t17.digi_id AS digi_id_30, t17.digi_ref AS digi_ref_31, t17.cerfa_data AS cerfa_data_32, t17.parent_id AS parent_id_33, t17.creneau_id AS creneau_id_34, t17.formation_id AS formation_id_35, t17.digi_account_id AS digi_account_id_36, t0.creneau_id AS creneau_id_37, t0.formation_id AS formation_id_38, t39.id AS id_40, t39.ctime AS ctime_41, t39.utime AS utime_42, t39.active AS active_43, t39.deleted AS deleted_44, t39.ref AS ref_45, t39.label AS label_46, t0.digi_account_id AS digi_account_id_47 FROM formation_programme t0 LEFT JOIN formation_programme t17 ON t0.parent_id = t17.id LEFT JOIN formation t39 ON t0.formation_id = t39.id WHERE t0.id IN (?)
Parameters:
[
594
]
|
|
0.42 ms (10.53%) |
1 |
SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.digi_id AS digi_id_6, t0.digi_ref AS digi_ref_7, t0.cerfa_data AS cerfa_data_8, t0.session_id AS session_id_9, t10.customers_nb AS customers_nb_11, t10.afest_jours AS afest_jours_12, t10.debut AS debut_13, t10.fin AS fin_14, t10.diplome AS diplome_15, t10.state AS state_16, t10.remarques AS remarques_17, t10.id AS id_18, t10.ctime AS ctime_19, t10.utime AS utime_20, t10.active AS active_21, t10.deleted AS deleted_22, t10.ref AS ref_23, t10.label AS label_24, t10.digi_id AS digi_id_25, t10.digi_ref AS digi_ref_26, t10.cerfa_data AS cerfa_data_27, t10.formation_id AS formation_id_28, t10.programme_id AS programme_id_29, t10.lieu_id AS lieu_id_30, t10.salle_id AS salle_id_31, t10.creneau_type_id AS creneau_type_id_32, t10.digi_account_id AS digi_account_id_33, t0.entreprise_id AS entreprise_id_34, t35.id AS id_36, t35.ctime AS ctime_37, t35.utime AS utime_38, t35.active AS active_39, t35.deleted AS deleted_40, t35.ref AS ref_41, t35.label AS label_42, t35.tel AS tel_43, t35.fax AS fax_44, t35.email AS email_45, t35.adresse AS adresse_46, t35.adresse_cp AS adresse_cp_47, t35.adresse_ville AS adresse_ville_48, t35.digi_id AS digi_id_49, t35.digi_ref AS digi_ref_50, t35.cerfa_data AS cerfa_data_51, t35.digi_account_id AS digi_account_id_52, t0.apprenant_id AS apprenant_id_53, t54.contrat_debut AS contrat_debut_55, t54.contrat_signature AS contrat_signature_56, t54.id AS id_57, t54.ctime AS ctime_58, t54.utime AS utime_59, t54.active AS active_60, t54.deleted AS deleted_61, t54.civilite AS civilite_62, t54.nom AS nom_63, t54.prenom AS prenom_64, t54.tel AS tel_65, t54.fax AS fax_66, t54.email AS email_67, t54.adresse AS adresse_68, t54.adresse_cp AS adresse_cp_69, t54.adresse_ville AS adresse_ville_70, t54.digi_id AS digi_id_71, t54.digi_ref AS digi_ref_72, t54.cerfa_data AS cerfa_data_73, t54.digi_account_id AS digi_account_id_74, t0.digi_account_id AS digi_account_id_75 FROM session_customer t0 LEFT JOIN session t10 ON t0.session_id = t10.id LEFT JOIN entreprise t35 ON t0.entreprise_id = t35.id LEFT JOIN apprenant t54 ON t0.apprenant_id = t54.id WHERE t0.id = ?
Parameters:
[
"4262"
]
|
|
0.41 ms (10.32%) |
1 |
SELECT t0.label AS label_1, t0.email AS email_2, t0.api_token AS api_token_3, t0.id AS id_4, t0.ctime AS ctime_5, t0.utime AS utime_6, t0.active AS active_7, t0.deleted AS deleted_8, t0.civilite AS civilite_9, t0.nom AS nom_10, t0.prenom AS prenom_11 FROM digi_account t0
Parameters:
[] |
|
0.39 ms (9.73%) |
1 |
SELECT t0.password AS password_1, t0.id AS id_2, t0.ctime AS ctime_3, t0.utime AS utime_4, t0.active AS active_5, t0.deleted AS deleted_6, t0.civilite AS civilite_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.tel AS tel_10, t0.fax AS fax_11, t0.email AS email_12, t0.adresse AS adresse_13, t0.adresse_cp AS adresse_cp_14, t0.adresse_ville AS adresse_ville_15, t0.digi_id AS digi_id_16, t0.digi_ref AS digi_ref_17, t0.type_id AS type_id_18, t19.id AS id_20, t19.ctime AS ctime_21, t19.utime AS utime_22, t19.active AS active_23, t19.deleted AS deleted_24, t19.ref AS ref_25, t19.label AS label_26, t0.digi_account_id AS digi_account_id_27 FROM user t0 LEFT JOIN user_type t19 ON t0.type_id = t19.id WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.36 ms (9.07%) |
1 |
SELECT t0.code AS code_1, t0.alpha2 AS alpha2_2, t0.alpha3 AS alpha3_3, t0.nom_fr_fr AS nom_fr_fr_4, t0.nom_en_gb AS nom_en_gb_5, t0.id AS id_6, t0.ctime AS ctime_7, t0.utime AS utime_8, t0.active AS active_9, t0.deleted AS deleted_10 FROM loc_pays t0
Parameters:
[] |
|
0.31 ms (7.84%) |
1 |
SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.ref AS ref_6, t0.label AS label_7 FROM user_role t0 INNER JOIN user_role_user_type ON t0.id = user_role_user_type.user_role_id WHERE user_role_user_type.user_type_id = ?
Parameters:
[
6
]
|
|
0.30 ms (7.64%) |
1 |
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.ctime AS ctime_4, t0.utime AS utime_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.ref AS ref_8, t0.label AS label_9 FROM param t0 WHERE t0.ref = ? LIMIT 1
Parameters:
[
"digi_account_id"
]
|
|
0.30 ms (7.48%) |
1 |
SELECT t0.etage AS etage_1, t0.capacite AS capacite_2, t0.color AS color_3, t0.id AS id_4, t0.ctime AS ctime_5, t0.utime AS utime_6, t0.active AS active_7, t0.deleted AS deleted_8, t0.ref AS ref_9, t0.label AS label_10, t0.digi_id AS digi_id_11, t0.digi_ref AS digi_ref_12, t0.lieu_id AS lieu_id_13, t14.external AS external_15, t14.id AS id_16, t14.ctime AS ctime_17, t14.utime AS utime_18, t14.active AS active_19, t14.deleted AS deleted_20, t14.ref AS ref_21, t14.label AS label_22, t14.tel AS tel_23, t14.fax AS fax_24, t14.email AS email_25, t14.adresse AS adresse_26, t14.adresse_cp AS adresse_cp_27, t14.adresse_ville AS adresse_ville_28, t0.parent_id AS parent_id_29, t30.etage AS etage_31, t30.capacite AS capacite_32, t30.color AS color_33, t30.id AS id_34, t30.ctime AS ctime_35, t30.utime AS utime_36, t30.active AS active_37, t30.deleted AS deleted_38, t30.ref AS ref_39, t30.label AS label_40, t30.digi_id AS digi_id_41, t30.digi_ref AS digi_ref_42, t30.lieu_id AS lieu_id_43, t30.parent_id AS parent_id_44, t30.digi_account_id AS digi_account_id_45, t0.digi_account_id AS digi_account_id_46 FROM salle t0 LEFT JOIN lieu t14 ON t0.lieu_id = t14.id LEFT JOIN salle t30 ON t0.parent_id = t30.id WHERE t0.id IN (?)
Parameters:
[
7
]
|
|
0.29 ms (7.29%) |
1 |
SELECT t0.contrat_debut AS contrat_debut_1, t0.contrat_signature AS contrat_signature_2, t0.id AS id_3, t0.ctime AS ctime_4, t0.utime AS utime_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.civilite AS civilite_8, t0.nom AS nom_9, t0.prenom AS prenom_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.email AS email_13, t0.adresse AS adresse_14, t0.adresse_cp AS adresse_cp_15, t0.adresse_ville AS adresse_ville_16, t0.digi_id AS digi_id_17, t0.digi_ref AS digi_ref_18, t0.cerfa_data AS cerfa_data_19, t0.digi_account_id AS digi_account_id_20 FROM apprenant t0 WHERE t0.id = ?
Parameters:
[
"4205"
]
|
|
0.28 ms (7.01%) |
1 |
SELECT t0.code AS code_1, t0.nom AS nom_2, t0.region_code AS region_code_3, t0.region_nom AS region_nom_4, t0.id AS id_5, t0.ctime AS ctime_6, t0.utime AS utime_7, t0.active AS active_8, t0.deleted AS deleted_9 FROM loc_dept t0
Parameters:
[] |
|
0.27 ms (6.86%) |
1 |
SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.ref AS ref_6, t0.label AS label_7 FROM user_role t0 INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = ?
Parameters:
[
7
]
|
|
0.22 ms (5.48%) |
1 |
SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.ref AS ref_6, t0.label AS label_7 FROM formation t0 WHERE t0.id IN (?)
Parameters:
[
7
]
|
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\User | No errors. |
| App\Entity\DigiAccount | No errors. |
| App\Entity\Param | No errors. |
| App\Entity\UserType | No errors. |
| App\Entity\UserRole | No errors. |
| App\Entity\Session | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\Synchro | No errors. |
| App\Entity\Apprenant | No errors. |
| App\Entity\SessionCustomer | No errors. |
| App\Entity\CERFA | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\FormationProgramme | No errors. |
| App\Entity\Lieu | No errors. |
| App\Entity\Salle | No errors. |
| App\Entity\Creneau | No errors. |
| App\Entity\Entreprise | No errors. |
| App\Entity\Financeur | No errors. |
| App\Entity\Facture | No errors. |
| App\Entity\Intervenant | No errors. |
| App\Entity\SessionSub | No errors. |
| App\Entity\SessionCreneau | No errors. |
| App\Entity\EntrepriseContact | No errors. |
| App\Entity\FormationModule | No errors. |
| App\Entity\LocDept | No errors. |
| App\Entity\LocPays | No errors. |