GET https://forum.trainizer.fr/fr/topic/6

Query Metrics

5 Database Queries
5 Different statements
6.39 ms Query time
0 Invalid entities
12 Managed entities
11 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 1.07 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_pinned AS is_pinned_5, t0.is_solved AS is_solved_6, t0.tags AS tags_7, t0.category_id AS category_id_8, t0.author_id AS author_id_9 FROM forum_topic t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
2 1.33 ms
SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
  1
]
3 2.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM forum_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.98 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_solution AS is_solution_4, t0.topic_id AS topic_id_5, t0.author_id AS author_id_6 FROM forum_post t0 WHERE t0.topic_id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

11 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
non_strict 7
read_only 4

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FeedbackCategory 3
App\Entity\User 2
App\Entity\SiteSettings 1
App\Entity\Theme 1
App\Entity\ForumTopic 1
App\Entity\ForumCategory 1
App\Entity\Avatar 1
App\Entity\Notification 1
App\Entity\ForumPost 1

Entities Mapping

Class Mapping errors
App\Entity\SiteSettings No errors.
App\Entity\Theme No errors.
App\Entity\ForumTopic No errors.
App\Entity\ForumCategory No errors.
App\Entity\User No errors.
App\Entity\Trainee No errors.
App\Entity\Coordinator No errors.
App\Entity\Responsible No errors.
App\Entity\Trainer No errors.
App\Entity\Avatar No errors.
App\Entity\Cohort No errors.
App\Entity\Sector No errors.
App\Entity\Notification No errors.
App\Entity\Feedback No errors.
App\Entity\Message No errors.
App\Entity\UserQuiz No errors.
App\Entity\Calendar No errors.
App\Entity\RssFeed No errors.
App\Entity\Course No errors.
App\Entity\Quiz No errors.
App\Entity\ForumPost No errors.
App\Entity\FeedbackCategory No errors.