https://d4y.stage.smartlabs.at/ueber-uns/wahlarzt

Query Metrics

19 Database Queries
7 Different statements
4.52 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN (?) AND t0.enabled = ? ORDER BY t0.is_default DESC
Parameters:
[
  [
    "d4y.stage.smartlabs.at"
    "localhost"
  ]
  1
]
2 0.40 ms
SELECT t0.route_name AS route_name_1, t0.page_alias AS page_alias_2, t0.type AS type_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.decorate AS decorate_6, t0.edited AS edited_7, t0.name AS name_8, t0.slug AS slug_9, t0.url AS url_10, t0.custom_url AS custom_url_11, t0.request_method AS request_method_12, t0.title AS title_13, t0.meta_keyword AS meta_keyword_14, t0.meta_description AS meta_description_15, t0.javascript AS javascript_16, t0.stylesheet AS stylesheet_17, t0.raw_headers AS raw_headers_18, t0.template AS template_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.id AS id_22, t0.site_id AS site_id_23, t0.parent_id AS parent_id_24, t0.target_id AS target_id_25 FROM page__page t0 WHERE t0.url = ? AND t0.site_id = ? LIMIT 1
Parameters:
[
  "/ueber-uns/wahlarzt"
  1
]
3 0.37 ms
SELECT p0_.name AS name_0, p0_.type AS type_1, p0_.settings AS settings_2, p0_.enabled AS enabled_3, p0_.position AS position_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.id AS id_7, p0_.blocks AS blocks_8, p0_.layout AS layout_9, p0_.headline AS headline_10, p0_.headline_align AS headline_align_11, p0_.headline_width AS headline_width_12, p0_.headline2 AS headline2_13, p0_.headline_color AS headline_color_14, p0_.intro_text AS intro_text_15, p0_.text AS text_16, p0_.text2 AS text2_17, p0_.text_color AS text_color_18, p0_.media_crop AS media_crop_19, p0_.media_effect AS media_effect_20, p0_.media_crop_variant AS media_crop_variant_21, p0_.media2_crop AS media2_crop_22, p0_.media2_effect AS media2_effect_23, p0_.media2_crop_variant AS media2_crop_variant_24, p0_.background_color AS background_color_25, p0_.style AS style_26, p0_.slug AS slug_27, p0_.margin_bottom AS margin_bottom_28, p0_.parent_id AS parent_id_29, p0_.page_id AS page_id_30, p0_.media AS media_31, p0_.media2 AS media2_32 FROM page__block p0_ WHERE p0_.page_id = ? ORDER BY p0_.position ASC
Parameters:
[
  185
]
4 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM sonata_menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "main_navigation_de"
]
5 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.menu = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
6 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  46
]
7 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  45
]
8 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  43
]
9 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
10 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
11 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  44
]
12 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
13 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
14 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  49
]
15 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  7
]
16 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  8
]
17 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.class_attribute AS class_attribute_4, t0.position AS position_5, t0.target AS target_6, t0.enabled AS enabled_7, t0.parent AS parent_8, t0.menu AS menu_9 FROM sonata_menu_item t0 WHERE t0.parent = ? ORDER BY t0.position ASC
Parameters:
[
  9
]
18 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM sonata_menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "main_navigation_de"
]
19 0.24 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22, t0.crop AS crop_23, t0.category_id AS category_id_24 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
  364
]

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
Sonata\PageBundle\Entity\BaseSite No errors.
App\Entity\SonataPageSite No errors.
Sonata\PageBundle\Entity\BasePage No errors.
App\Entity\SonataPagePage No errors.
Sonata\PageBundle\Entity\BaseBlock No errors.
App\Entity\SonataPageBlock No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\SonataMediaMedia No errors.
Smartlabs\MenuBundle\Entity\Menu No errors.
Smartlabs\MenuBundle\Entity\MenuItem No errors.
Sonata\ClassificationBundle\Entity\BaseCategory No errors.
App\Entity\SonataClassificationCategory No errors.
Sonata\MediaBundle\Entity\BaseGalleryHasMedia No errors.
App\Entity\SonataMediaGalleryHasMedia No errors.