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

Query Metrics

18 Database Queries
9 Different statements
7.89 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.13 ms
(27.07%)
5
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"
]
1.02 ms
(12.94%)
3
SELECT DATABASE()
Parameters:
[]
1.02 ms
(12.92%)
2
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.route_name = ? LIMIT 1
Parameters:
[
  "app_public_index"
]
0.94 ms
(11.88%)
3
SELECT app FROM system_settings WHERE designation = ?
Parameters:
[
  "system"
]
0.74 ms
(9.44%)
1
SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.seo_content AS seo_content_3, t0.no_index AS no_index_4, t0.no_follow AS no_follow_5, t0.fb_active AS fb_active_6, t0.og_type AS og_type_7, t0.og_title AS og_title_8, t0.og_content AS og_content_9, t0.og_image AS og_image_10, t0.x_active AS x_active_11, t0.x_type AS x_type_12, t0.x_site AS x_site_13, t0.x_creator AS x_creator_14, t0.fb_app_id AS fb_app_id_15, t0.fb_admins AS fb_admins_16, t0.title_prefix AS title_prefix_17, t0.title_suffix AS title_suffix_18, t0.title_separator AS title_separator_19, t0.reading_time AS reading_time_20, t0.created_at AS created_at_21, t0.last_update AS last_update_22, t23.id AS id_24, t23.site_slug AS site_slug_25, t23.route_name AS route_name_26, t23.site_content AS site_content_27, t23.site_date AS site_date_28, t23.site_excerpt AS site_excerpt_29, t23.site_status AS site_status_30, t23.comment_status AS comment_status_31, t23.site_type AS site_type_32, t23.site_img AS site_img_33, t23.site_user AS site_user_34, t23.site_password AS site_password_35, t23.excerpt_limit AS excerpt_limit_36, t23.extra_css AS extra_css_37, t23.position AS position_38, t23.header AS header_39, t23.footer AS footer_40, t23.builder_active AS builder_active_41, t23.custom AS custom_42, t23.form_builder AS form_builder_43, t23.siteSeo AS siteSeo_44, t23.site_category_id AS site_category_id_45, t46.id AS id_47, t46.post_content AS post_content_48, t46.post_date AS post_date_49, t46.post_excerpt AS post_excerpt_50, t46.comment_status AS comment_status_51, t46.site_type AS site_type_52, t46.site_img AS site_img_53, t46.excerpt_limit AS excerpt_limit_54, t46.extra_css AS extra_css_55, t46.position AS position_56, t46.post_status AS post_status_57, t46.builder AS builder_58, t46.post_slug AS post_slug_59, t46.header AS header_60, t46.footer AS footer_61, t46.post_gallery AS post_gallery_62, t46.siteSeo AS siteSeo_63, t46.post_category_id AS post_category_id_64 FROM site_seo t0 LEFT JOIN app_sites t23 ON t23.siteSeo = t0.id LEFT JOIN post_sites t46 ON t46.siteSeo = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.70 ms
(8.84%)
1
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""
]
0.55 ms
(6.99%)
1
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
]
0.41 ms
(5.14%)
1
SELECT t0.id AS id_1, t0.slider AS slider_2, t0.designation AS designation_3, t0.created_at AS created_at_4, t0.type AS type_5 FROM media_slider t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
0.38 ms
(4.79%)
1
SELECT t0.id AS id_1, t0.form_id AS form_id_2, t0.type AS type_3, t0.form AS form_4, t0.created_at AS created_at_5 FROM form_builder t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\PostCategory
  • The association App\Entity\PostCategory#postSites refers to the owning side field App\Entity\PostSites#postSites which does not exist.
App\Entity\FormBuilder 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.
App\Entity\MediaSlider No errors.