GET https://dev.gloster.hu/befektetoknek/kozlemenyek/01929fba-84be-77b5-9a79-18d0368c90dc

Query Metrics

14 Database Queries
10 Different statements
7.25 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT t0.highlighted_category AS highlighted_category_1, t0.year AS year_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vendor_id AS vendor_id_9, t0.date AS date_10, t0.is_chart AS is_chart_11, t0.category_id AS category_id_12, t0.post_id AS post_id_13 FROM investor_announcement t0 WHERE t0.id = ?
Parameters:
[
  b"\x01ƃ║ä¥wÁÜy\x18ð6îÉ▄"
]
2 0.41 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.meta_id AS meta_id_8 FROM system_application t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "default"
]
3 0.60 ms
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM common_meta t0 WHERE t0.id = ?
Parameters:
[
  b"\x01’lÓ!ƒtF’Íïc“á­G"
]
4 0.34 ms
SELECT t0.site_name AS site_name_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.image AS image_4, t0.id AS id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.locale AS locale_11, t0.title AS title_12, t0.slug AS slug_13, t0.translatable_id AS translatable_id_14 FROM common_meta_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01’lÓ!ƒtF’Íïc“á­G"
]
5 0.60 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.meta_id AS meta_id_8 FROM system_application t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "default"
]
6 0.45 ms
SELECT t0.config_key AS config_key_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.application_id AS application_id_8 FROM system_application_config t0 WHERE t0.application_id = ?
Parameters:
[
  b"\x01Œô”ŒäqY³fgçÍÙoÎ"
]
7 0.58 ms
SELECT t0.value AS value_1, t0.file AS file_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM system_application_config_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ìB\x1F°e}\x17º:\x1Fð§oZ╬"
]
8 0.35 ms
SELECT t0.value AS value_1, t0.file AS file_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM system_application_config_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"""
    \x01ìB\x1F©\n
    \x7Fª▒ôıHådkq
    """
]
9 0.93 ms
SELECT t0.is_slider AS is_slider_1, t0.is_rss_feed AS is_rss_feed_2, t0.file_content AS file_content_3, t0.id AS id_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_at AS deleted_at_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.slug AS slug_12, t0.is_active AS is_active_13, t0.is_highlighted AS is_highlighted_14, t0.file AS file_15, t0.content AS content_16, t0.translatable_id AS translatable_id_17 FROM investor_announcement_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ƃ║ä¥wÁÜy\x18ð6îÉ▄"
]
10 0.42 ms
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.vendor_id AS vendor_id_7, t0.file AS file_8, t0.position AS position_9, t0.announcement_id AS announcement_id_10 FROM investor_document t0 WHERE t0.announcement_id = ?
Parameters:
[
  b"\x01ƃ║ä¥wÁÜy\x18ð6îÉ▄"
]
11 0.33 ms
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.color AS color_7, t0.leader_id AS leader_id_8, t0.meta_id AS meta_id_9 FROM industry t0
Parameters:
[]
12 0.49 ms
SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.title AS title_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.content AS content_12, t0.image AS image_13, t0.translatable_id AS translatable_id_14 FROM industry_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01Œÿ‹\x1DfsF•\x12ÇÓ1p-!"
]
13 0.39 ms
SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.title AS title_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.content AS content_12, t0.image AS image_13, t0.translatable_id AS translatable_id_14 FROM industry_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01Œÿ’9Utr Üü¶\x12lkO"
]
14 0.37 ms
SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.title AS title_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.content AS content_12, t0.image AS image_13, t0.translatable_id AS translatable_id_14 FROM industry_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01î ô5ÎqZü¼┴O\x06jC\x03"
]

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\Shared\AbstractEntity No errors.
App\Entity\Shared\AbstractTranslatableEntity No errors.
App\Entity\Investor\Announcement\Announcement No errors.
App\Entity\Investor\Announcement\AnnouncementCategory No errors.
App\Entity\Common\Social\Post No errors.
App\Entity\Investor\Document\Document No errors.
App\Entity\Common\Layout\Slider\Slide No errors.
App\Entity\Magazine\Article\Article
  • The field App\Entity\Magazine\Article\Article#promptArticles is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Magazine\Article\Article#promptArticles does not contain the required 'mappedBy="promptArticles"' attribute.
App\Entity\Shared\AbstractTranslationEntity No errors.
App\Entity\Investor\Announcement\AnnouncementTranslation No errors.
App\Entity\System\Application\Application No errors.
App\Entity\Common\Meta\Meta No errors.
App\Entity\System\Application\Config No errors.
App\Entity\System\Application\ApplicationTranslation No errors.
App\Entity\Common\Meta\MetaTranslation No errors.
App\Entity\System\Application\ConfigTranslation No errors.
App\Entity\Investor\Announcement\AnnouncementCategoryTranslation No errors.
App\Entity\Common\Social\PostItem No errors.
App\Entity\Common\Prompt\Prompt No errors.
App\Entity\Investor\Document\DocumentTranslation No errors.
App\Entity\Common\Layout\Slider\Slider No errors.
App\Entity\Common\Layout\Slider\SlideTranslation No errors.
App\Entity\Common\Author\Author No errors.
App\Entity\Common\Layout\Block No errors.
App\Entity\Common\Tag\Tag No errors.
App\Entity\Magazine\Article\ArticleTranslation No errors.
App\Entity\Industry\Industry No errors.
App\Entity\Company\Team\Team No errors.
App\Entity\Industry\IndustryTranslation No errors.
App\Entity\Common\Prompt\PromptTranslation No errors.
App\Entity\Common\Layout\Slider\SliderTranslation No errors.
App\Entity\Common\Author\AuthorTranslation No errors.
App\Entity\Common\Layout\BlockTranslation No errors.
App\Entity\Common\Tag\TagTranslation No errors.
App\Entity\Company\Team\TeamTranslation No errors.