GET http://demo.burdanowka.ovh/de/kontakt

Query Metrics

9 Database Queries
5 Different statements
6.04 ms Query time
0 Invalid entities
56 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
5.03 ms
(83.25%)
5
SELECT m0_.id AS id_0, m0_.menu AS menu_1, m0_.locale AS locale_2, m0_.title AS title_3, m0_.type AS type_4, m0_.url AS url_5, m0_.hint AS hint_6, m0_.button AS button_7, m0_.position AS position_8, m0_.published AS published_9, m0_.open_in_new_tab AS open_in_new_tab_10, m0_.source_id AS source_id_11, m1_.id AS id_12, m1_.menu AS menu_13, m1_.locale AS locale_14, m1_.title AS title_15, m1_.type AS type_16, m1_.url AS url_17, m1_.hint AS hint_18, m1_.button AS button_19, m1_.position AS position_20, m1_.published AS published_21, m1_.open_in_new_tab AS open_in_new_tab_22, m1_.source_id AS source_id_23, m2_.id AS id_24, m2_.menu AS menu_25, m2_.locale AS locale_26, m2_.title AS title_27, m2_.type AS type_28, m2_.url AS url_29, m2_.hint AS hint_30, m2_.button AS button_31, m2_.position AS position_32, m2_.published AS published_33, m2_.open_in_new_tab AS open_in_new_tab_34, m2_.source_id AS source_id_35, a3_.id AS id_36, a3_.title AS title_37, a3_.slug AS slug_38, a3_.locale AS locale_39, a3_.translation_group AS translation_group_40, a3_.excerpt AS excerpt_41, a3_.content AS content_42, a3_.status AS status_43, a3_.meta_title AS meta_title_44, a3_.meta_description AS meta_description_45, a3_.position AS position_46, a3_.show_contact_form AS show_contact_form_47, a3_.source_id AS source_id_48, a3_.source_type AS source_type_49, a3_.published_at AS published_at_50, a3_.created_at AS created_at_51, a3_.updated_at AS updated_at_52, a4_.id AS id_53, a4_.title AS title_54, a4_.slug AS slug_55, a4_.locale AS locale_56, a4_.translation_group AS translation_group_57, a4_.excerpt AS excerpt_58, a4_.content AS content_59, a4_.status AS status_60, a4_.meta_title AS meta_title_61, a4_.meta_description AS meta_description_62, a4_.position AS position_63, a4_.show_contact_form AS show_contact_form_64, a4_.source_id AS source_id_65, a4_.source_type AS source_type_66, a4_.published_at AS published_at_67, a4_.created_at AS created_at_68, a4_.updated_at AS updated_at_69, a5_.id AS id_70, a5_.title AS title_71, a5_.slug AS slug_72, a5_.locale AS locale_73, a5_.translation_group AS translation_group_74, a5_.excerpt AS excerpt_75, a5_.content AS content_76, a5_.status AS status_77, a5_.meta_title AS meta_title_78, a5_.meta_description AS meta_description_79, a5_.position AS position_80, a5_.show_contact_form AS show_contact_form_81, a5_.source_id AS source_id_82, a5_.source_type AS source_type_83, a5_.published_at AS published_at_84, a5_.created_at AS created_at_85, a5_.updated_at AS updated_at_86, m0_.article_id AS article_id_87, m0_.parent_id AS parent_id_88, m1_.article_id AS article_id_89, m1_.parent_id AS parent_id_90, m2_.article_id AS article_id_91, m2_.parent_id AS parent_id_92, a3_.category_id AS category_id_93, a3_.featured_image_id AS featured_image_id_94, a4_.category_id AS category_id_95, a4_.featured_image_id AS featured_image_id_96, a5_.category_id AS category_id_97, a5_.featured_image_id AS featured_image_id_98 FROM menu_item m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN article a3_ ON m0_.article_id = a3_.id LEFT JOIN article a4_ ON m1_.article_id = a4_.id LEFT JOIN article a5_ ON m2_.article_id = a5_.id WHERE m0_.menu = ? AND m0_.locale = ? AND m0_.parent_id IS NULL AND m0_.published = 1 ORDER BY m0_.position ASC, m1_.position ASC, m2_.position ASC
Parameters:
[
  "main"
  "de"
]
0.29 ms
(4.87%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.locale AS locale_3, a0_.translation_group AS translation_group_4, a0_.excerpt AS excerpt_5, a0_.content AS content_6, a0_.status AS status_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.position AS position_10, a0_.show_contact_form AS show_contact_form_11, a0_.source_id AS source_id_12, a0_.source_type AS source_type_13, a0_.published_at AS published_at_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.category_id AS category_id_17, a0_.featured_image_id AS featured_image_id_18 FROM article a0_ WHERE a0_.translation_group = ? AND a0_.id <> ? AND a0_.status = ?
Parameters:
[
  "2a283d6f4b6d04d58d7ca648deb139b4"
  446
  "published"
]
0.25 ms
(4.19%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.locale AS locale_3, a0_.translation_group AS translation_group_4, a0_.excerpt AS excerpt_5, a0_.content AS content_6, a0_.status AS status_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.position AS position_10, a0_.show_contact_form AS show_contact_form_11, a0_.source_id AS source_id_12, a0_.source_type AS source_type_13, a0_.published_at AS published_at_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.category_id AS category_id_17, a0_.featured_image_id AS featured_image_id_18 FROM article a0_ WHERE a0_.slug = ? AND a0_.locale = ? AND a0_.status = ?
Parameters:
[
  "kontakt"
  "de"
  "published"
]
0.25 ms
(4.09%)
1
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_tagline AS brand_tagline_3, t0.reception_hours AS reception_hours_4, t0.phone AS phone_5, t0.address AS address_6, t0.email AS email_7, t0.coordinates AS coordinates_8, t0.booking_url AS booking_url_9, t0.booking_label AS booking_label_10, t0.footer_hours AS footer_hours_11, t0.copyright AS copyright_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14 FROM site_settings t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
0.22 ms
(3.61%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.filename AS filename_3, t0.title AS title_4, t0.alt AS alt_5, t0.caption AS caption_6, t0.width AS width_7, t0.height AS height_8, t0.filesize AS filesize_9, t0.mime_type AS mime_type_10, t0.file_exists AS file_exists_11, t0.source AS source_12, t0.created_at AS created_at_13 FROM media t0 INNER JOIN article_media ON t0.id = article_media.media_id WHERE article_media.article_id = ? ORDER BY t0.id ASC
Parameters:
[
  446
]

Database Connections

Name Service
default doctrine.dbal.default_connection
joomla doctrine.dbal.joomla_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MenuItem 23
App\Entity\Article 17
App\Entity\Media 13
App\Entity\Category 2
App\Entity\SiteSettings 1

Entities Mapping

Class Mapping errors
App\Entity\Article No errors.
App\Entity\Category No errors.
App\Entity\Media No errors.
App\Entity\SiteSettings No errors.
App\Entity\MenuItem No errors.