GET https://courseforge.info/api/courses

Query Metrics

6 Database Queries
6 Different statements
2.92 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surename AS surename_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.last_activity_at AS last_activity_at_9, t0.trainer_id AS trainer_id_10, t0.company_id AS company_id_11 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.course_type AS course_type_6, t0.max_participants AS max_participants_7, t0.course_code AS course_code_8, t0.is_active AS is_active_9, t0.public AS public_10, t0.user_id AS user_id_11, t0.source_document_id AS source_document_id_12 FROM course t0 WHERE t0.user_id = ?
Parameters:
[
  1
]
3 0.52 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.ai_document AS ai_document_4, t0.ai_text AS ai_text_5, t0.is_active AS is_active_6, t0.public AS public_7, t0.source_document_id AS source_document_id_8, t0.user_id AS user_id_9 FROM card_set t0 INNER JOIN course_card_set ON t0.id = course_card_set.card_set_id WHERE course_card_set.course_id = ?
Parameters:
[
  1
]
4 0.46 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surename AS surename_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.last_activity_at AS last_activity_at_9, t0.trainer_id AS trainer_id_10, t0.company_id AS company_id_11 FROM `user` t0 INNER JOIN user_curses ON t0.id = user_curses.user_id WHERE user_curses.course_id = ?
Parameters:
[
  1
]
5 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.learning_goals AS learning_goals_4, t0.start_date AS start_date_5, t0.exam_date AS exam_date_6, t0.position AS position_7, t0.is_active AS is_active_8, t0.public AS public_9, t0.auto_generate_exam AS auto_generate_exam_10, t0.exam_duration_minutes AS exam_duration_minutes_11, t0.exam_question_count AS exam_question_count_12, t0.section_indexes AS section_indexes_13, t0.chunk_indexes AS chunk_indexes_14, t0.course_id AS course_id_15 FROM module t0 WHERE t0.course_id = ?
Parameters:
[
  1
]
6 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.content_html AS content_html_5, t0.content_json AS content_json_6, t0.is_published AS is_published_7, t0.is_pinned AS is_pinned_8, t0.created_at AS created_at_9, t0.notify AS notify_10, t0.expires_at AS expires_at_11, t0.updated_at AS updated_at_12, t0.course_id AS course_id_13, t0.author_id AS author_id_14 FROM course_announcement t0 WHERE t0.course_id = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 2
App\Entity\Company 1
App\Entity\Course 1
App\Entity\SourceDocument 1
App\Entity\Module 1