GET https://forum.trainizer.fr/db.env/topic/3

Query Metrics

17 Database Queries
11 Different statements
16.48 ms Query time
0 Invalid entities
16 Managed entities
16 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 0.80 ms
SELECT module FROM organization_module WHERE organization_id = ?
Parameters:
[
  1
]
2 0.81 ms
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "forum.trainizer.fr"
]
3 0.87 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.organization_id AS organization_id_8, t0.category_id AS category_id_9, t0.author_id AS author_id_10 FROM forum_topic t0 WHERE t0.id = ? AND ((t0.organization_id = 1))
Parameters:
[
  "3"
]
4 1.36 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.calendar_feed_secret AS calendar_feed_secret_13, t0.password_changed_at AS password_changed_at_14, t0.tmp_code AS tmp_code_15, t0.tmp_code_date AS tmp_code_date_16, t0.signature AS signature_17, t0.uuid AS uuid_18, t0.phone_number AS phone_number_19, t0.organization_id AS organization_id_20, t0.avatar_id AS avatar_id_21, t0.dtype, t1.password_save AS password_save_22, t1.documents AS documents_23, t1.diploma AS diploma_24, t1.tutorial_completed AS tutorial_completed_25, t1.financial_aid AS financial_aid_26, t1.cohort_id AS cohort_id_27, t2.role AS role_28, t2.entrance_code AS entrance_code_29, t2.entrance_code_date AS entrance_code_date_30, t2.responsible_id AS responsible_id_31, t3.role AS role_32, t3.entrance_code AS entrance_code_33, t3.entrance_code_date AS entrance_code_date_34, t3.sector_id AS sector_id_35, t4.role AS role_36, t4.entrance_code AS entrance_code_37, t4.entrance_code_date AS entrance_code_date_38, t4.coordinator_id AS coordinator_id_39 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 = ? AND ((t0.organization_id = 1))
Parameters:
[
  106
]
5 0.87 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.organization_id AS organization_id_14, t0.user_id AS user_id_15 FROM collaborator t0 WHERE t0.user_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  106
]
6 0.95 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "homework_to_do"
]
7 0.96 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "new_message"
]
8 0.93 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "internship_approval"
  "internship_to_seal"
  "internship_rejected"
]
9 0.89 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "new_document"
]
10 0.97 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "planning_added"
  "planning_updated"
  "planning_removed"
]
11 0.89 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category IN (?, ?, ?, ?) AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "interview_due"
  "interview_overdue"
  "interview_done"
  "interview_ack"
]
12 0.91 ms
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.organization_id AS organization_id_7, t0.user_id AS user_id_8 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL AND ((t0.organization_id = 1)) ORDER BY t0.date DESC
Parameters:
[
  "rncp_expired"
]
13 0.91 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
]
14 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.organization_id AS organization_id_4 FROM forum_category t0 WHERE t0.id = ? AND ((t0.organization_id = 1))
Parameters:
[
  2
]
15 1.01 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.organization_id AS organization_id_5, t0.topic_id AS topic_id_6, t0.author_id AS author_id_7 FROM forum_post t0 WHERE t0.topic_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  3
]
16 1.38 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.calendar_feed_secret AS calendar_feed_secret_13, t0.password_changed_at AS password_changed_at_14, t0.tmp_code AS tmp_code_15, t0.tmp_code_date AS tmp_code_date_16, t0.signature AS signature_17, t0.uuid AS uuid_18, t0.phone_number AS phone_number_19, t0.organization_id AS organization_id_20, t0.avatar_id AS avatar_id_21, t0.dtype, t1.password_save AS password_save_22, t1.documents AS documents_23, t1.diploma AS diploma_24, t1.tutorial_completed AS tutorial_completed_25, t1.financial_aid AS financial_aid_26, t1.cohort_id AS cohort_id_27, t2.role AS role_28, t2.entrance_code AS entrance_code_29, t2.entrance_code_date AS entrance_code_date_30, t2.responsible_id AS responsible_id_31, t3.role AS role_32, t3.entrance_code AS entrance_code_33, t3.entrance_code_date AS entrance_code_date_34, t3.sector_id AS sector_id_35, t4.role AS role_36, t4.entrance_code AS entrance_code_37, t4.entrance_code_date AS entrance_code_date_38, t4.coordinator_id AS coordinator_id_39 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 = ? AND ((t0.organization_id = 1))
Parameters:
[
  1
]
17 1.03 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.organization_id AS organization_id_14, t0.user_id AS user_id_15 FROM collaborator t0 WHERE t0.user_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

16 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
non_strict 12
read_only 4

Managed Entities

default entity manager

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