Query Metrics
24
Database Queries
6
Different statements
5.20 ms
Query time
12
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.39 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.18 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.25 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:
[] |
4 | 0.18 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:
[] |
5 | 0.31 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
]
|
6 | 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:
[
19
]
|
7 | 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:
[
9
]
|
8 | 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:
[
30
]
|
9 | 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
]
|
10 | 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:
[
29
]
|
11 | 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:
[
31
]
|
12 | 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:
[
12
]
|
13 | 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:
[
20
]
|
14 | 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
]
|
15 | 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:
[
22
]
|
16 | 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
]
|
17 | 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:
[
25
]
|
18 | 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:
[
26
]
|
19 | 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:
[
8
]
|
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:
[
11
]
|
21 | 0.33 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:
[] |
22 | 0.16 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:
[] |
23 | 0.27 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
]
|
24 | 0.55 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
]
|
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\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\Forum | 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\User |
|
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\Specialite | No errors. |
App\Entity\SousSysteme |
|
App\Entity\Lesson | No errors. |
App\Entity\Reponse | No errors. |
App\Entity\QuizResult | No errors. |
App\Entity\Membre | No errors. |
App\Entity\Sujet | No errors. |
App\Entity\Abonnement | No errors. |
App\Entity\Retrait | No errors. |
App\Entity\Proposition | 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\NetworkConfig | No errors. |
App\Entity\LikeMessageForum | 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\ForumMessage | No errors. |
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. |