GET https://www.backend.wiecker.eu/terms

Query Metrics

13 Database Queries
6 Different statements
5.71 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT DATABASE()
Parameters:
[]
2 0.34 ms
SELECT app FROM system_settings WHERE designation = ?
Parameters:
[
  "system"
]
3 0.41 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1
Parameters:
[
  "system"
]
4 0.18 ms
SELECT DATABASE()
Parameters:
[]
5 0.24 ms
SELECT app FROM system_settings WHERE designation = ?
Parameters:
[
  "system"
]
6 0.79 ms
SELECT t0.id AS id_1, t0.site_slug AS site_slug_2, t0.route_name AS route_name_3, t0.site_content AS site_content_4, t0.site_date AS site_date_5, t0.site_excerpt AS site_excerpt_6, t0.site_status AS site_status_7, t0.comment_status AS comment_status_8, t0.site_type AS site_type_9, t0.site_img AS site_img_10, t0.site_user AS site_user_11, t0.site_password AS site_password_12, t0.excerpt_limit AS excerpt_limit_13, t0.extra_css AS extra_css_14, t0.position AS position_15, t0.header AS header_16, t0.footer AS footer_17, t0.builder_active AS builder_active_18, t0.custom AS custom_19, t0.form_builder AS form_builder_20, t0.siteSeo AS siteSeo_21, t0.site_category_id AS site_category_id_22 FROM app_sites t0 WHERE t0.site_slug = ? LIMIT 1
Parameters:
[
  "terms"
]
7 0.81 ms
SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.is_verified AS is_verified_5, u0_.totp_secret AS totp_secret_6 FROM user u0_ WHERE JSON_CONTAINS(u0_.roles, ?) = 1
Parameters:
[
  ""ROLE_SUPER_ADMIN""
]
8 0.70 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.active AS active_6, t0.type AS type_7, t0.menu_settings AS menu_settings_8 FROM menu_category t0 WHERE t0.type = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "main"
  true
]
9 0.38 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1
Parameters:
[
  "system"
]
10 0.56 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1
Parameters:
[
  "system"
]
11 0.35 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1
Parameters:
[
  "system"
]
12 0.29 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1
Parameters:
[
  "system"
]
13 0.27 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1
Parameters:
[
  "system"
]

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\SystemSettings No errors.
App\Entity\AppSites
  • The mappings App\Entity\AppSites#siteCategory and App\Entity\SiteCategory#appSites are inconsistent with each other.
App\Entity\PostSites
  • The mappings App\Entity\PostSites#postCategory and App\Entity\PostCategory#postSites are inconsistent with each other.
App\Entity\SiteSeo No errors.
App\Entity\SiteCategory
  • The association App\Entity\SiteCategory#appSites refers to the owning side field App\Entity\AppSites#appSites which does not exist.
App\Entity\User No errors.
App\Entity\OAuth2UserConsent No errors.
App\Entity\MediaCategory No errors.
App\Entity\Media No errors.
App\Entity\MenuCategory No errors.