GET https://courseforge.info/api/card/2/search?mode=OR&query=&tags=

Response
200 OK
Browse referrer URL
IP
178.25.83.34
Profiled on
Token
34548d

Query Metrics

64 Database Queries
5 Different statements
36.59 ms Query time
0 Invalid entities
216 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
29.64 ms
(81.02%) 		59 
SELECT t0.id AS id_1, t0.repetitions AS repetitions_2, t0.interval_days AS interval_days_3, t0.ease_factor AS ease_factor_4, t0.due_at AS due_at_5, t0.last_reviewed_at AS last_reviewed_at_6, t0.user_id AS user_id_7, t0.card_id AS card_id_8 FROM card_progress t0 WHERE t0.card_id = ? AND t0.user_id = ? LIMIT 1
Parameters: 
[
  5
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
3.92 ms
(10.72%) 		1 
SELECT c0_.id AS id_0, c0_.question AS question_1, c0_.description AS description_2, c0_.source_text AS source_text_3, c0_.source_meta AS source_meta_4, c0_.position AS position_5, c0_.choice_type AS choice_type_6, c0_.type AS type_7, c0_.expected_answer AS expected_answer_8, c0_.rubric AS rubric_9, c0_.keywords AS keywords_10, c0_.explanation AS explanation_11, c0_.active AS active_12, c0_.public AS public_13, c1_.id AS id_14, c1_.text AS text_15, c1_.position AS position_16, c1_.is_correct AS is_correct_17, t2_.id AS id_18, t2_.name AS name_19, c0_.card_set_id AS card_set_id_20, c1_.card_id AS card_id_21 FROM card c0_ LEFT JOIN card_answer c1_ ON c0_.id = c1_.card_id LEFT JOIN card_tag c3_ ON c0_.id = c3_.card_id LEFT JOIN tag t2_ ON t2_.id = c3_.tag_id WHERE c0_.card_set_id = ? ORDER BY c0_.position ASC, c1_.position ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(3.53%) 		2 
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: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
1.25 ms
(3.42%) 		1 
SELECT c0_.id AS id_0, c0_.repetitions AS repetitions_1, c0_.interval_days AS interval_days_2, c0_.ease_factor AS ease_factor_3, c0_.due_at AS due_at_4, c0_.last_reviewed_at AS last_reviewed_at_5, c1_.id AS id_6, c1_.question AS question_7, c1_.description AS description_8, c1_.source_text AS source_text_9, c1_.source_meta AS source_meta_10, c1_.position AS position_11, c1_.choice_type AS choice_type_12, c1_.type AS type_13, c1_.expected_answer AS expected_answer_14, c1_.rubric AS rubric_15, c1_.keywords AS keywords_16, c1_.explanation AS explanation_17, c1_.active AS active_18, c1_.public AS public_19, c0_.user_id AS user_id_20, c0_.card_id AS card_id_21, c1_.card_set_id AS card_set_id_22 FROM card_progress c0_ INNER JOIN card c1_ ON c0_.card_id = c1_.id WHERE c0_.user_id = ? AND c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  2
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  49
  50
  51
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
  63
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.31%) 		1 
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 WHERE t0.id = ?
Parameters: 
[
  "2"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\CardAnswer 148
App\Entity\Card 59
App\Entity\CardProgress 4
App\Entity\User 2
App\Entity\Company 1
App\Entity\CardSet 1
App\Entity\SourceDocument 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Company No errors.
App\Entity\Course No errors.
App\Entity\CardSet No errors.
App\Entity\CardProgress No errors.
App\Entity\CardAiNote No errors.
App\Entity\Participant No errors.
App\Entity\Message No errors.
App\Entity\Conversation No errors.
App\Entity\CourseAnnouncement No errors.
App\Entity\CourseAnnouncementRead No errors.
App\Entity\Notification No errors.
App\Entity\NotificationUser No errors.
App\Entity\SourceDocument No errors.
App\Entity\Card No errors.
App\Entity\Module No errors.
App\Entity\CardAnswer No errors.
App\Entity\Tag No errors.