GET https://backend.wiecker.eu/general/article-12025-11-18T10:47:35+01:00monthly

Query Metrics

13 Database Queries
7 Different statements
5.66 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT DATABASE()
Parameters:
[]
2 0.37 ms
SELECT app FROM system_settings WHERE designation = ?
Parameters:
[
  "system"
]
3 0.52 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.22 ms
SELECT DATABASE()
Parameters:
[]
5 0.22 ms
SELECT app FROM system_settings WHERE designation = ?
Parameters:
[
  "system"
]
6 0.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.category_design AS category_design_8, t0.post_design AS post_design_9, t0.post_loop AS post_loop_10, t0.category_header AS category_header_11, t0.category_footer AS category_footer_12, t0.post_header AS post_header_13, t0.post_footer AS post_footer_14, t0.created_at AS created_at_15 FROM post_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "general"
]
7 0.47 ms
SELECT t0.id AS id_1, t0.post_content AS post_content_2, t0.post_date AS post_date_3, t0.post_excerpt AS post_excerpt_4, t0.comment_status AS comment_status_5, t0.site_type AS site_type_6, t0.site_img AS site_img_7, t0.excerpt_limit AS excerpt_limit_8, t0.extra_css AS extra_css_9, t0.position AS position_10, t0.post_status AS post_status_11, t0.builder AS builder_12, t0.post_slug AS post_slug_13, t0.header AS header_14, t0.footer AS footer_15, t0.post_gallery AS post_gallery_16, t0.siteSeo AS siteSeo_17, t0.post_category_id AS post_category_id_18 FROM post_sites t0 WHERE t0.post_slug = ? AND t0.post_status = ? LIMIT 1
Parameters:
[
  "article-12025-11-18T10:47:35+01:00monthly"
  "publish"
]
8 0.65 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""
]
9 0.61 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
]
10 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"
]
11 0.60 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.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"
]
13 0.28 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\PostCategory
  • The association App\Entity\PostCategory#postSites refers to the owning side field App\Entity\PostSites#postSites which does not exist.
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\User No errors.
App\Entity\OAuth2UserConsent No errors.
App\Entity\MediaCategory No errors.
App\Entity\Media No errors.
App\Entity\MenuCategory No errors.