Query Metrics
33
Database Queries
12
Different statements
10.00 ms
Query time
12
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.53 ms |
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:
[] |
2 | 0.25 ms |
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:
[] |
3 | 0.50 ms |
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.slug = ? LIMIT 1
Parameters:
[
"1690481626-INFORMATIQUE-en-Premiere-A4"
]
|
4 | 0.32 ms |
SELECT t0.id AS id_1, t0.utilisateur_id AS utilisateur_id_2 FROM membre t0 WHERE t0.utilisateur_id IS NULL LIMIT 1
Parameters:
[] |
5 | 0.46 ms |
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:
[] |
6 | 0.25 ms |
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:
[] |
7 | 0.36 ms |
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
]
|
8 | 0.30 ms |
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
]
|
9 | 0.24 ms |
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:
[
9
]
|
10 | 0.25 ms |
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:
[
30
]
|
11 | 0.21 ms |
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:
[
5
]
|
12 | 0.24 ms |
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:
[
29
]
|
13 | 0.22 ms |
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:
[
31
]
|
14 | 0.21 ms |
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:
[
12
]
|
15 | 0.23 ms |
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:
[
20
]
|
16 | 0.24 ms |
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:
[
7
]
|
17 | 0.24 ms |
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:
[
22
]
|
18 | 0.22 ms |
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:
[
24
]
|
19 | 0.25 ms |
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:
[
25
]
|
20 | 0.22 ms |
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:
[
26
]
|
21 | 0.22 ms |
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:
[
8
]
|
22 | 0.23 ms |
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:
[
11
]
|
23 | 0.46 ms |
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:
[] |
24 | 0.22 ms |
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:
[] |
25 | 0.34 ms |
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
]
|
26 | 0.62 ms |
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
]
|
27 | 0.38 ms |
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:
[
10
]
|
28 | 0.25 ms |
SELECT t0.id AS id_1, t0.utilisateur_id AS utilisateur_id_2 FROM membre t0 WHERE t0.id = ?
Parameters:
[
665
]
|
29 | 0.47 ms |
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:
[
1625
]
|
30 | 0.24 ms |
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:
[
20
]
|
31 | 0.17 ms |
SELECT t0.id AS id_1, t0.utilisateur_id AS utilisateur_id_2 FROM membre t0 WHERE t0.id = ?
Parameters:
[
8
]
|
32 | 0.39 ms |
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
]
|
33 | 0.24 ms |
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:
[
10
]
|
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\Cours |
|
App\Entity\Enseignant |
|
App\Entity\Categorie | No errors. |
App\Entity\Media | No errors. |
App\Entity\Forum | No errors. |
App\Entity\SkillLevel | 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\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\Membre | No errors. |
App\Entity\Sujet | No errors. |
App\Entity\User |
|
App\Entity\Exam | No errors. |
App\Entity\Evaluation |
|
App\Entity\MatiereCycle | No errors. |
App\Entity\SubjectChat | No errors. |
App\Entity\Etablissement | No errors. |
App\Entity\MessageChat | 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\EvaluationResultat | No errors. |
App\Entity\Abonnement | No errors. |
App\Entity\Retrait | No errors. |
App\Entity\Proposition | No errors. |
App\Entity\ForumMessage | No errors. |
App\Entity\LikeMessageForum | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Personne |
|
App\Entity\NotificationSetting | No errors. |
App\Entity\Filiere |
|
App\Entity\Device | No errors. |
App\Entity\Contact | No errors. |
App\Entity\WebSocketConnection | No errors. |
App\Entity\EvaluationQuestion | No errors. |
App\Entity\Pays | No errors. |
App\Entity\AbonnementItem | No errors. |
App\Entity\NotificationType | No errors. |
App\Entity\TypeEnseignement | No errors. |
App\Entity\NetworkConfig | No errors. |
App\Entity\QuizzesType | No errors. |
App\Entity\CourseTag | No errors. |
App\Entity\Investisseur |
|
App\Entity\EmailSetting | No errors. |
App\Entity\NotificationTemplate | 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. |