Query Metrics
2
Database Queries
2
Different statements
4.91 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.84 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.registration_open AS registration_open_3, t0.username_change_enabled AS username_change_enabled_4, t0.default_sort_mode AS default_sort_mode_5, t0.wiki_enabled AS wiki_enabled_6, t0.wiki_log_public AS wiki_log_public_7, t0.forum_create_role AS forum_create_role_8, t0.message_compose_role AS message_compose_role_9, t0.moderators_can_set_forum_log_visibility AS moderators_can_set_forum_log_visibility_10, t0.image_upload_role AS image_upload_role_11, t0.wiki_edit_role AS wiki_edit_role_12, t0.trash_enabled AS trash_enabled_13, t0.registration_captcha_enabled AS registration_captcha_enabled_14, t0.url_images_enabled AS url_images_enabled_15, t0.submission_link_destination AS submission_link_destination_16, t0.default_theme_id AS default_theme_id_17 FROM sites t0 WHERE t0.id = ?
Parameters:
[
"00000000-0000-0000-0000-000000000000"
]
|
| 2 | 4.08 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.was_admin AS was_admin_1, f0_.timestamp AS timestamp_2, f0_.title AS title_3, f0_.reason AS reason_4, f0_.title AS title_5, f0_.title AS title_6, f0_.reason AS reason_7, f0_.title AS title_8, f0_.locked AS locked_9, f0_.title AS title_10, f0_.action_type AS action_type_11 FROM forum_log_entries f0_ WHERE (f0_.forum_id IN (SELECT f1_.id FROM forums f1_ WHERE f1_.moderation_log_public = TRUE)) AND f0_.action_type IN ('comment_deletion', 'comment_restored', 'submission_deletion', 'ban', 'submission_lock', 'submission_restored') ORDER BY f0_.timestamp DESC) dctrn_result) dctrn_table
Parameters:
[] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ForumLogEntry | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\Forum | No errors. |
| App\Entity\ForumLogCommentDeletion | No errors. |
| App\Entity\ForumLogCommentRestored | No errors. |
| App\Entity\ForumLogSubmissionDeletion | No errors. |
| App\Entity\ForumLogBan | No errors. |
| App\Entity\ForumLogSubmissionLock | No errors. |
| App\Entity\ForumLogSubmissionRestored | No errors. |