Query Metrics
53
Database Queries
15
Different statements
16.99 ms
Query time
12
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.60 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.21 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.32 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 = ? LIMIT 6
Parameters:
[
0
]
|
4 | 0.59 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.categorie_id = ? AND t0.is_validated = ? ORDER BY t0.vues DESC LIMIT 8
Parameters:
[ 1 1 ] |
5 | 0.59 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.categorie_id = ? AND t0.is_validated = ? ORDER BY t0.vues DESC LIMIT 8
Parameters:
[ 2 1 ] |
6 | 0.41 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.categorie_id = ? AND t0.is_validated = ? ORDER BY t0.vues DESC LIMIT 8
Parameters:
[ 3 1 ] |
7 | 0.31 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.categorie_id = ? AND t0.is_validated = ? ORDER BY t0.vues DESC LIMIT 8
Parameters:
[ 4 1 ] |
8 | 0.32 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.categorie_id = ? AND t0.is_validated = ? ORDER BY t0.vues DESC LIMIT 8
Parameters:
[ 5 1 ] |
9 | 0.27 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.categorie_id = ? AND t0.is_validated = ? ORDER BY t0.vues DESC LIMIT 8
Parameters:
[ 6 1 ] |
10 | 0.46 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.is_free ASC, t0.review DESC, t0.created_at DESC LIMIT 6
Parameters:
[
1
]
|
11 | 0.23 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 2
Parameters:
[] |
12 | 1.18 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 ORDER BY t0.join_at DESC LIMIT 4
Parameters:
[] |
13 | 0.55 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:
[] |
14 | 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:
[] |
15 | 0.29 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
]
|
16 | 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:
[
19
]
|
17 | 0.20 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
]
|
18 | 0.16 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
]
|
19 | 0.17 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
]
|
20 | 0.15 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
]
|
21 | 0.17 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
]
|
22 | 0.15 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
]
|
23 | 0.14 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
]
|
24 | 0.16 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
]
|
25 | 0.20 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
]
|
26 | 0.15 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
]
|
27 | 0.13 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
]
|
28 | 0.17 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
]
|
29 | 0.18 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
]
|
30 | 0.19 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
]
|
31 | 0.32 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:
[] |
32 | 0.20 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:
[] |
33 | 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.is_sub_category = ? ORDER BY t0.name ASC LIMIT 12
Parameters:
[
0
]
|
34 | 0.66 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
]
|
35 | 0.36 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = ?
Parameters:
[
15
]
|
36 | 0.45 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 INNER JOIN eleve_cours ON t0.id = eleve_cours.eleve_id WHERE eleve_cours.cours_id = ?
Parameters:
[
15
]
|
37 | 0.27 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.diplome AS diplome_3, t0.recto_cni AS recto_cni_4, t0.verso_cni AS verso_cni_5, t0.selfie_cni AS selfie_cni_6, t0.emploi_du_temps AS emploi_du_temps_7, t0.is_validated AS is_validated_8, t0.details AS details_9, t0.is_rejected AS is_rejected_10, t0.review AS review_11, t0.join_at AS join_at_12, t0.about_me AS about_me_13, t0.is_certified AS is_certified_14, t0.utilisateur_id AS utilisateur_id_15, t0.etablissement_id AS etablissement_id_16, t0.discipline_id AS discipline_id_17 FROM enseignant t0 WHERE t0.id = ?
Parameters:
[
43
]
|
38 | 0.95 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:
[
46
]
|
39 | 0.24 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = ?
Parameters:
[
72
]
|
40 | 0.23 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 INNER JOIN eleve_cours ON t0.id = eleve_cours.eleve_id WHERE eleve_cours.cours_id = ?
Parameters:
[
72
]
|
41 | 0.20 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.diplome AS diplome_3, t0.recto_cni AS recto_cni_4, t0.verso_cni AS verso_cni_5, t0.selfie_cni AS selfie_cni_6, t0.emploi_du_temps AS emploi_du_temps_7, t0.is_validated AS is_validated_8, t0.details AS details_9, t0.is_rejected AS is_rejected_10, t0.review AS review_11, t0.join_at AS join_at_12, t0.about_me AS about_me_13, t0.is_certified AS is_certified_14, t0.utilisateur_id AS utilisateur_id_15, t0.etablissement_id AS etablissement_id_16, t0.discipline_id AS discipline_id_17 FROM enseignant t0 WHERE t0.id = ?
Parameters:
[
154
]
|
42 | 0.34 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:
[
1176
]
|
43 | 0.23 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = ?
Parameters:
[
71
]
|
44 | 0.20 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 INNER JOIN eleve_cours ON t0.id = eleve_cours.eleve_id WHERE eleve_cours.cours_id = ?
Parameters:
[
71
]
|
45 | 0.23 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = ?
Parameters:
[
64
]
|
46 | 0.26 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 INNER JOIN eleve_cours ON t0.id = eleve_cours.eleve_id WHERE eleve_cours.cours_id = ?
Parameters:
[
64
]
|
47 | 0.53 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.diplome AS diplome_3, t0.recto_cni AS recto_cni_4, t0.verso_cni AS verso_cni_5, t0.selfie_cni AS selfie_cni_6, t0.emploi_du_temps AS emploi_du_temps_7, t0.is_validated AS is_validated_8, t0.details AS details_9, t0.is_rejected AS is_rejected_10, t0.review AS review_11, t0.join_at AS join_at_12, t0.about_me AS about_me_13, t0.is_certified AS is_certified_14, t0.utilisateur_id AS utilisateur_id_15, t0.etablissement_id AS etablissement_id_16, t0.discipline_id AS discipline_id_17 FROM enseignant t0 WHERE t0.id = ?
Parameters:
[
25
]
|
48 | 0.49 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:
[
28
]
|
49 | 0.22 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = ?
Parameters:
[
63
]
|
50 | 0.27 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 INNER JOIN eleve_cours ON t0.id = eleve_cours.eleve_id WHERE eleve_cours.cours_id = ?
Parameters:
[
63
]
|
51 | 0.24 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.message AS message_4, t0.cours_id AS cours_id_5, t0.eleve_id AS eleve_id_6 FROM review t0 WHERE t0.cours_id = ?
Parameters:
[
62
]
|
52 | 0.27 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 INNER JOIN eleve_cours ON t0.id = eleve_cours.eleve_id WHERE eleve_cours.cours_id = ?
Parameters:
[
62
]
|
53 | 0.40 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:
[
1433
]
|
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\Cours |
|
App\Entity\Enseignant |
|
App\Entity\Exam | No errors. |
App\Entity\Evaluation |
|
App\Entity\MatiereCycle | No errors. |
App\Entity\SubjectChat | 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\Etablissement | No errors. |
App\Entity\Reponse | No errors. |
App\Entity\QuizResult | No errors. |
App\Entity\EvaluationResultat | No errors. |
App\Entity\MessageChat | No errors. |
App\Entity\EvaluationQuestion | No errors. |
App\Entity\WebSocketConnection | No errors. |
App\Entity\Specialite | No errors. |
App\Entity\SousSysteme |
|
App\Entity\Lesson | 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\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. |