Query Metrics
107
Database Queries
15
Different statements
33.95 ms
Query time
12
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.21 ms (15.34%) |
28 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_solved AS is_solved_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.membre_id AS membre_id_6, t0.forum_id AS forum_id_7 FROM sujet t0 WHERE t0.forum_id = ?
Parameters:
[
3
]
|
4.24 ms (12.49%) |
3 |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_copyrights AS site_copyrights_3, t0.site_email AS site_email_4, t0.site_description AS site_description_5, t0.contact_phone AS contact_phone_6, t0.support_email AS support_email_7, t0.contact_address AS contact_address_8, t0.main_site_url AS main_site_url_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.maintenance_text AS maintenance_text_11 FROM site_setting t0 LIMIT 1
Parameters:
[] |
3.94 ms (11.60%) |
8 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.phone_number AS phone_number_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.is_blocked AS is_blocked_8, t0.is_admin AS is_admin_9, t0.points AS points_10, t0.especes AS especes_11, t12.id AS id_13, t12.reference AS reference_14, t12.join_at AS join_at_15, t12.is_premium AS is_premium_16, t12.classe_id AS classe_id_17, t12.utilisateur_id AS utilisateur_id_18, t12.etablissement_id AS etablissement_id_19, t20.id AS id_21, t20.reference AS reference_22, t20.diplome AS diplome_23, t20.recto_cni AS recto_cni_24, t20.verso_cni AS verso_cni_25, t20.selfie_cni AS selfie_cni_26, t20.emploi_du_temps AS emploi_du_temps_27, t20.is_validated AS is_validated_28, t20.details AS details_29, t20.is_rejected AS is_rejected_30, t20.review AS review_31, t20.join_at AS join_at_32, t20.about_me AS about_me_33, t20.is_certified AS is_certified_34, t20.utilisateur_id AS utilisateur_id_35, t20.etablissement_id AS etablissement_id_36, t20.discipline_id AS discipline_id_37, t38.id AS id_39, t38.last_name AS last_name_40, t38.first_name AS first_name_41, t38.pseudo AS pseudo_42, t38.born_at AS born_at_43, t38.lieu_naissance AS lieu_naissance_44, t38.sexe AS sexe_45, t38.avatar AS avatar_46, t38.adresse AS adresse_47, t38.telephone AS telephone_48, t38.invitation_code AS invitation_code_49, t38.invitation_link AS invitation_link_50, t38.join_at AS join_at_51, t38.update_at AS update_at_52, t38.utilisateur_id AS utilisateur_id_53, t38.parent_id AS parent_id_54, t38.pays_id AS pays_id_55 FROM kulmapeck_user t0 LEFT JOIN eleve t12 ON t12.utilisateur_id = t0.id LEFT JOIN enseignant t20 ON t20.utilisateur_id = t0.id LEFT JOIN personne t38 ON t38.utilisateur_id = t0.id WHERE t0.id = ?
Parameters:
[
73
]
|
3.62 ms (10.68%) |
15 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.content AS content_3, t0.likes AS likes_4, t0.is_answer AS is_answer_5, t0.is_response AS is_response_6, t0.membre_id AS membre_id_7, t0.sujet_id AS sujet_id_8, t0.forum_message_id AS forum_message_id_9 FROM forum_message t0 WHERE t0.sujet_id = ?
Parameters:
[
3
]
|
2.79 ms (8.21%) |
15 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
19
]
|
2.55 ms (7.53%) |
8 |
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.slug AS slug_3, t0.content AS content_4, t0.description AS description_5, t0.is_published AS is_published_6, t0.is_free AS is_free_7, t0.niveau_difficulte AS niveau_difficulte_8, t0.duree_apprentissage AS duree_apprentissage_9, t0.created_at AS created_at_10, t0.vues AS vues_11, t0.is_validated AS is_validated_12, t0.montant_abonnement AS montant_abonnement_13, t0.language AS language_14, t0.number_of_lessons AS number_of_lessons_15, t0.tags AS tags_16, t0.is_rejected AS is_rejected_17, t0.review AS review_18, t0.updated_at AS updated_at_19, t0.published_at AS published_at_20, t0.enseignant_id AS enseignant_id_21, t0.categorie_id AS categorie_id_22, t23.id AS id_24, t23.video_url AS video_url_25, t23.mp4_file AS mp4_file_26, t23.web_mfile AS web_mfile_27, t23.ogg_file AS ogg_file_28, t23.image_file AS image_file_29, t23.cours_id AS cours_id_30, t31.id AS id_32, t31.cours_id AS cours_id_33, t0.skill_level_id AS skill_level_id_34 FROM cours t0 LEFT JOIN media t23 ON t23.cours_id = t0.id LEFT JOIN forum t31 ON t31.cours_id = t0.id WHERE t0.id = ?
Parameters:
[
19
]
|
2.37 ms (6.99%) |
1 |
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.slug AS slug_3, t0.content AS content_4, t0.description AS description_5, t0.is_published AS is_published_6, t0.is_free AS is_free_7, t0.niveau_difficulte AS niveau_difficulte_8, t0.duree_apprentissage AS duree_apprentissage_9, t0.created_at AS created_at_10, t0.vues AS vues_11, t0.is_validated AS is_validated_12, t0.montant_abonnement AS montant_abonnement_13, t0.language AS language_14, t0.number_of_lessons AS number_of_lessons_15, t0.tags AS tags_16, t0.is_rejected AS is_rejected_17, t0.review AS review_18, t0.updated_at AS updated_at_19, t0.published_at AS published_at_20, t0.enseignant_id AS enseignant_id_21, t0.categorie_id AS categorie_id_22, t23.id AS id_24, t23.video_url AS video_url_25, t23.mp4_file AS mp4_file_26, t23.web_mfile AS web_mfile_27, t23.ogg_file AS ogg_file_28, t23.image_file AS image_file_29, t23.cours_id AS cours_id_30, t31.id AS id_32, t31.cours_id AS cours_id_33, t0.skill_level_id AS skill_level_id_34 FROM cours t0 LEFT JOIN media t23 ON t23.cours_id = t0.id LEFT JOIN forum t31 ON t31.cours_id = t0.id WHERE t0.is_validated = ? ORDER BY t0.created_at DESC, t0.vues DESC LIMIT 8
Parameters:
[
1
]
|
2.22 ms (6.55%) |
6 |
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.slug AS slug_3, t0.content AS content_4, t0.description AS description_5, t0.is_published AS is_published_6, t0.is_free AS is_free_7, t0.niveau_difficulte AS niveau_difficulte_8, t0.duree_apprentissage AS duree_apprentissage_9, t0.created_at AS created_at_10, t0.vues AS vues_11, t0.is_validated AS is_validated_12, t0.montant_abonnement AS montant_abonnement_13, t0.language AS language_14, t0.number_of_lessons AS number_of_lessons_15, t0.tags AS tags_16, t0.is_rejected AS is_rejected_17, t0.review AS review_18, t0.updated_at AS updated_at_19, t0.published_at AS published_at_20, t0.enseignant_id AS enseignant_id_21, t0.categorie_id AS categorie_id_22, t23.id AS id_24, t23.video_url AS video_url_25, t23.mp4_file AS mp4_file_26, t23.web_mfile AS web_mfile_27, t23.ogg_file AS ogg_file_28, t23.image_file AS image_file_29, t23.cours_id AS cours_id_30, t31.id AS id_32, t31.cours_id AS cours_id_33, t0.skill_level_id AS skill_level_id_34 FROM cours t0 LEFT JOIN media t23 ON t23.cours_id = t0.id LEFT JOIN forum t31 ON t31.cours_id = t0.id WHERE t0.categorie_id = ?
Parameters:
[
5
]
|
1.93 ms (5.68%) |
8 |
SELECT t0.id AS id_1, t0.cours_id AS cours_id_2 FROM forum t0 WHERE t0.id = ?
Parameters:
[
8
]
|
1.51 ms (4.44%) |
8 |
SELECT t0.id AS id_1, t0.utilisateur_id AS utilisateur_id_2 FROM membre t0 WHERE t0.id = ?
Parameters:
[
8
]
|
1.09 ms (3.20%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image_file AS image_file_3, c0_.is_sub_category AS is_sub_category_4, c0_.category_id AS category_id_5 FROM categorie c0_ INNER JOIN cours c1_ ON c0_.id = c1_.categorie_id INNER JOIN forum f2_ ON c1_.id = f2_.cours_id INNER JOIN sujet s3_ ON f2_.id = s3_.forum_id WHERE c1_.is_validated = ? ORDER BY c0_.name ASC LIMIT 15
Parameters:
[
1
]
|
0.93 ms (2.75%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.icon AS icon_4 FROM social_setting t0
Parameters:
[] |
0.69 ms (2.03%) |
1 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_solved AS is_solved_3, t0.created_at AS created_at_4, t0.reference AS reference_5, t0.membre_id AS membre_id_6, t0.forum_id AS forum_id_7 FROM sujet t0 ORDER BY t0.is_solved DESC
Parameters:
[] |
0.53 ms (1.55%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.is_sub_category = ? ORDER BY t0.name ASC LIMIT 12
Parameters:
[
0
]
|
0.33 ms (0.98%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.is_sub_category = ? ORDER BY t0.name ASC LIMIT 11
Parameters:
[
0
]
|
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\SiteSetting | No errors. |
App\Entity\SocialSetting | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Sujet | No errors. |
App\Entity\Membre | No errors. |
App\Entity\Forum | No errors. |
App\Entity\ForumMessage | No errors. |
App\Entity\Cours |
|
App\Entity\Enseignant |
|
App\Entity\Exam | No errors. |
App\Entity\Evaluation |
|
App\Entity\MatiereCycle | No errors. |
App\Entity\SubjectChat | No errors. |
App\Entity\User |
|
App\Entity\LikeMessageForum | No errors. |
App\Entity\Classe | No errors. |
App\Entity\Chapitre | No errors. |
App\Entity\Eleve |
|
App\Entity\Formation |
|
App\Entity\Like | No errors. |
App\Entity\Media | No errors. |
App\Entity\FAQ | No errors. |
App\Entity\Review | No errors. |
App\Entity\Payment | No errors. |
App\Entity\PaymentMethod | No errors. |
App\Entity\Lecture | No errors. |
App\Entity\Quiz | No errors. |
App\Entity\QuizLost | No errors. |
App\Entity\SkillLevel | No errors. |
App\Entity\Etablissement | No errors. |
App\Entity\MessageChat | No errors. |
App\Entity\EvaluationQuestion | No errors. |
App\Entity\EvaluationResultat | No errors. |
App\Entity\WebSocketConnection | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Personne |
|
App\Entity\NotificationSetting | No errors. |
App\Entity\Filiere |
|
App\Entity\Retrait | No errors. |
App\Entity\Device | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Specialite | No errors. |
App\Entity\SousSysteme |
|
App\Entity\Lesson | No errors. |
App\Entity\Reponse | No errors. |
App\Entity\QuizResult | No errors. |
App\Entity\Abonnement | No errors. |
App\Entity\Proposition | No errors. |
App\Entity\Pays | No errors. |
App\Entity\NetworkConfig | No errors. |
App\Entity\QuizzesType | No errors. |
App\Entity\TypeEnseignement | No errors. |
App\Entity\CourseTag | No errors. |
App\Entity\Investisseur |
|
App\Entity\AbonnementItem | No errors. |
App\Entity\EmailSetting | No errors. |
App\Entity\NotificationTemplate | No errors. |
App\Entity\NotificationType | No errors. |
App\Entity\PartAction |
|
App\Entity\ResetPasswordRequest | No errors. |
App\Entity\PushNotification | No errors. |
App\Entity\Term | No errors. |
App\Entity\ChatMessage |
|
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |