GET https://forum.trainizer.fr/robots.txt

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM forum_category t0
Parameters:
[]
2 1.27 ms
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.is_pinned AS is_pinned_4, f0_.is_solved AS is_solved_5, f0_.tags AS tags_6, f1_.id AS id_7, f1_.name AS name_8, f1_.slug AS slug_9, f2_.id AS id_10, f2_.content AS content_11, f2_.created_at AS created_at_12, f2_.is_solution AS is_solution_13, f0_.category_id AS category_id_14, f0_.author_id AS author_id_15, f2_.topic_id AS topic_id_16, f2_.author_id AS author_id_17 FROM forum_topic f0_ LEFT JOIN forum_category f1_ ON f0_.category_id = f1_.id LEFT JOIN forum_post f2_ ON f0_.id = f2_.topic_id ORDER BY f0_.is_pinned DESC, f0_.updated_at DESC
Parameters:
[]
3 1.42 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
]
4 2.55 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:
[
  106
]
5 1.30 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:
[
  23
]
6 1.31 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:
[
  24
]
7 0.89 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
]
8 1.02 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.category_id = ?
Parameters:
[
  1
]
9 0.94 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.category_id = ?
Parameters:
[
  2
]
10 0.98 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.category_id = ?
Parameters:
[
  3
]
11 0.94 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.category_id = ?
Parameters:
[
  4
]
12 0.92 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.category_id = ?
Parameters:
[
  5
]

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\ForumPost 10
App\Entity\ForumTopic 6
App\Entity\ForumCategory 5
App\Entity\User 5
App\Entity\Avatar 3
App\Entity\FeedbackCategory 3
App\Entity\Cohort 2
App\Entity\SiteSettings 1
App\Entity\Theme 1
App\Entity\Notification 1