Query Metrics
5
Database Queries
5
Different statements
4.98 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.41 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 | 0.88 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 | 1.33 ms |
SELECT c0_.id AS id_0, c0_.libelle AS libelle_1, c0_.date AS date_2, c0_.localite AS localite_3, c0_.lieu AS lieu_4, c0_.nombre_participant AS nombre_participant_5, c0_.commentaire AS commentaire_6, c0_.nom_canal AS nom_canal_7, c0_.created_at AS created_at_8, c0_.deleted_at AS deleted_at_9, c0_.updated_at AS updated_at_10, c0_.predicateur_id AS predicateur_id_11, c0_.discipline_id AS discipline_id_12, c0_.canal_id AS canal_id_13, c0_.pays_id AS pays_id_14, c0_.trimestre_id AS trimestre_id_15, c0_.created_by AS created_by_16, c0_.deleted_by AS deleted_by_17, c0_.updated_by AS updated_by_18 FROM cours c0_ WHERE c0_.predicateur_id = ? AND c0_.trimestre_id = ? ORDER BY c0_.date DESC
Parameters:
[ 17 19 ]
|
||||||||||||||||||||||||||||
| 4 | 0.82 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM canal t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 0.54 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
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\Discipline |
|
| App\Entity\Canal | No errors. |
| App\Entity\Trimestre |
|