GET https://forum.trainizer.fr/sitemap.xml

Query Metrics

17 Database Queries
9 Different statements
15.31 ms Query time
0 Invalid entities
10 Managed entities
16 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 1.14 ms
SELECT module FROM organization_module WHERE organization_id = ?
Parameters:
[
  1
]
2 0.79 ms
SELECT id FROM organization WHERE domain = ?
Parameters:
[
  "forum.trainizer.fr"
]
3 0.92 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.organization_id = 1))
Parameters:
[]
4 1.30 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, f0_.organization_id AS organization_id_7, f1_.id AS id_8, f1_.name AS name_9, f1_.slug AS slug_10, f1_.organization_id AS organization_id_11, f2_.id AS id_12, f2_.content AS content_13, f2_.created_at AS created_at_14, f2_.is_solution AS is_solution_15, f2_.organization_id AS organization_id_16, f0_.category_id AS category_id_17, f0_.author_id AS author_id_18, f2_.topic_id AS topic_id_19, f2_.author_id AS author_id_20 FROM forum_topic f0_ LEFT JOIN forum_category f1_ ON f0_.category_id = f1_.id AND (f1_.organization_id = 1) LEFT JOIN forum_post f2_ ON f0_.id = f2_.topic_id AND (f2_.organization_id = 1) WHERE (f0_.organization_id = 1) ORDER BY f0_.is_pinned DESC, f0_.updated_at DESC
Parameters:
[]
5 0.72 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"
]
6 0.84 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"
]
7 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:
[
  "internship_approval"
  "internship_to_seal"
  "internship_rejected"
]
8 0.83 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"
]
9 0.71 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"
]
10 0.94 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"
]
11 0.81 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"
]
12 0.83 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
]
13 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.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.category_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  4
]
14 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.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.category_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  5
]
15 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.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.category_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  2
]
16 0.97 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.category_id = ? AND ((t0.organization_id = 1))
Parameters:
[
  3
]
17 0.83 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.category_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\ForumCategory 5
App\Entity\FeedbackCategory 3
App\Entity\SiteSettings 1
App\Entity\Theme 1

Entities Mapping

Class Mapping errors
App\Entity\SiteSettings No errors.
App\Entity\Theme No errors.
App\Entity\ForumCategory No errors.
App\Entity\ForumTopic No errors.
App\Entity\ForumPost No errors.
App\Entity\User No errors.
App\Entity\FeedbackCategory No errors.
App\Entity\Feedback No errors.
App\Entity\Notification No errors.