Query Metrics
8
Database Queries
8
Different statements
20.96 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.22 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_disabled AS is_disabled_6, t0.is_root AS is_root_7, t0.is_admin AS is_admin_8, t0.is_archived AS is_archived_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.updated_at AS updated_at_12, t13.id AS id_14, t13.nom_ar AS nom_ar_15, t13.prenom_ar AS prenom_ar_16, t13.nom_fr AS nom_fr_17, t13.prenom_fr AS prenom_fr_18, t13.date_naissance AS date_naissance_19, t13.residence AS residence_20, t13.situation_matrimoniale AS situation_matrimoniale_21, t13.profession AS profession_22, t13.langues_parlees AS langues_parlees_23, t13.ecole_frequentee AS ecole_frequentee_24, t13.lieu_naissance AS lieu_naissance_25, t13.commentaire AS commentaire_26, t13.is_archived AS is_archived_27, t13.contact AS contact_28, t13.numero_piece AS numero_piece_29, t13.date_expiration_piece AS date_expiration_piece_30, t13.specialite AS specialite_31, t13.annee_obtention_diplome AS annee_obtention_diplome_32, t13.date_debut_contrat AS date_debut_contrat_33, t13.lien_facebook AS lien_facebook_34, t13.lien_twitter AS lien_twitter_35, t13.nationalite AS nationalite_36, t13.image_name AS image_name_37, t13.is_predicateur_suivi AS is_predicateur_suivi_38, t13.created_at AS created_at_39, t13.deleted_at AS deleted_at_40, t13.updated_at AS updated_at_41, t13.user_id AS user_id_42, t13.diplome_id AS diplome_id_43, t13.pays_id AS pays_id_44, t13.created_by AS created_by_45, t13.deleted_by AS deleted_by_46, t13.updated_by AS updated_by_47, t0.pays_id AS pays_id_48, t0.created_by AS created_by_49, t0.deleted_by AS deleted_by_50, t0.updated_by AS updated_by_51 FROM `user` t0 LEFT JOIN predicateur t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||||||||
| 2 | 2.33 ms |
SELECT p0_.id AS id_0, p0_.nom_ar AS nom_ar_1, p0_.prenom_ar AS prenom_ar_2, p0_.nom_fr AS nom_fr_3, p0_.prenom_fr AS prenom_fr_4, p0_.date_naissance AS date_naissance_5, p0_.residence AS residence_6, p0_.situation_matrimoniale AS situation_matrimoniale_7, p0_.profession AS profession_8, p0_.langues_parlees AS langues_parlees_9, p0_.ecole_frequentee AS ecole_frequentee_10, p0_.lieu_naissance AS lieu_naissance_11, p0_.commentaire AS commentaire_12, p0_.is_archived AS is_archived_13, p0_.contact AS contact_14, p0_.numero_piece AS numero_piece_15, p0_.date_expiration_piece AS date_expiration_piece_16, p0_.specialite AS specialite_17, p0_.annee_obtention_diplome AS annee_obtention_diplome_18, p0_.date_debut_contrat AS date_debut_contrat_19, p0_.lien_facebook AS lien_facebook_20, p0_.lien_twitter AS lien_twitter_21, p0_.nationalite AS nationalite_22, p0_.image_name AS image_name_23, p0_.is_predicateur_suivi AS is_predicateur_suivi_24, p0_.created_at AS created_at_25, p0_.deleted_at AS deleted_at_26, p0_.updated_at AS updated_at_27, p0_.user_id AS user_id_28, p0_.diplome_id AS diplome_id_29, p0_.pays_id AS pays_id_30, p0_.created_by AS created_by_31, p0_.deleted_by AS deleted_by_32, p0_.updated_by AS updated_by_33 FROM predicateur p0_ WHERE p0_.pays_id = ? AND p0_.id = ? AND p0_.is_predicateur_suivi = ?
Parameters:
[ 1 17 1 ]
|
||||||||||||||||||||||||||||||
| 3 | 6.52 ms |
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.debut AS debut_2, t0_.fin AS fin_3, t0_.created_at AS created_at_4, t0_.deleted_at AS deleted_at_5, t0_.updated_at AS updated_at_6, t0_.pays_id AS pays_id_7, t0_.created_by AS created_by_8, t0_.deleted_by AS deleted_by_9, t0_.updated_by AS updated_by_10 FROM trimestre t0_ WHERE t0_.pays_id = ? AND t0_.debut <= ? AND t0_.fin >= ?
Parameters:
[ 1 "2026-01-08" "2026-01-08" ]
|
||||||||||||||||||||||||||||||
| 4 | 0.74 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.deleted_by AS deleted_by_7, t0.updated_by AS updated_by_8 FROM discipline t0 WHERE t0.id = ?
Parameters:
[
"29"
]
|
||||||||||||||||||||||||||||||
| 5 | 0.31 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM canal t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
||||||||||||||||||||||||||||||
| 6 | 1.66 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 7 | 1.79 ms |
INSERT INTO cours (libelle, date, localite, lieu, nombre_participant, commentaire, nom_canal, created_at, deleted_at, updated_at, predicateur_id, discipline_id, canal_id, pays_id, trimestre_id, created_by, deleted_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "نصيحة لمهملي الصلاة على حساب مشاهدة المباريات " "2026-01-08 06:08:00" "أبيدجان " "مسجد الهدى " null "" null "2026-01-08 06:08:30" null null 17 29 1 1 19 17 null null ]
|
||||||||||||||||||||||||||||||
| 8 | 6.39 ms |
"COMMIT"
Parameters:
[]
|
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\Predicateur |
|
| App\Entity\Diplome | No errors. |
| App\Entity\Pays |
|
| App\Entity\AccesPays | No errors. |
| App\Entity\Cours | No errors. |
| App\Entity\Seminaire | No errors. |
| App\Entity\Dawa | No errors. |
| App\Entity\Conference | No errors. |
| App\Entity\Fatwa | No errors. |
| App\Entity\Sermon | No errors. |
| App\Entity\Reunion | No errors. |
| App\Entity\Rappel | No errors. |
| App\Entity\Recherche | No errors. |
| App\Entity\VisiteAutre | No errors. |
| App\Entity\VisitePrison | No errors. |
| App\Entity\Suggestion | No errors. |
| App\Entity\Converti | No errors. |
| App\Entity\Livre | No errors. |
| App\Entity\DistributionCoranArabe |
|
| App\Entity\Formation | No errors. |
| App\Entity\Rencontre | No errors. |
| App\Entity\Panel | No errors. |
| App\Entity\Journal | No errors. |
| App\Entity\Magazine | No errors. |
| App\Entity\Radio | No errors. |
| App\Entity\Television | No errors. |
| App\Entity\Rapport | No errors. |
| App\Entity\PredicateurEgare | No errors. |
| App\Entity\Conduite | No errors. |
| App\Entity\Traduction | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\Autre | No errors. |
| App\Entity\ProgrammePreche | No errors. |
| App\Entity\Twitter | No errors. |
| App\Entity\Facebook | No errors. |
| App\Entity\Youtube | No errors. |
| App\Entity\Zoom | No errors. |
| App\Entity\Trimestre |
|
| App\Entity\Discipline |
|
| App\Entity\Canal | No errors. |