Query Metrics

12 Database Queries
8 Different statements
7.36 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.36 ms
SELECT m0_.image AS image_0, m0_.prompt AS prompt_1, m0_.id AS id_2, m0_.created_by AS created_by_3, m0_.updated_by AS updated_by_4, m0_.deleted_at AS deleted_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.media_collection AS media_collection_8, m0_.start_date AS start_date_9, m0_.end_date AS end_date_10, m1_.intro AS intro_11, m1_.id AS id_12, m1_.created_by AS created_by_13, m1_.updated_by AS updated_by_14, m1_.deleted_at AS deleted_at_15, m1_.created_at AS created_at_16, m1_.updated_at AS updated_at_17, m1_.locale AS locale_18, m1_.title AS title_19, m1_.slug AS slug_20, m1_.is_active AS is_active_21, m1_.published_at AS published_at_22, m1_.content AS content_23, m0_.author_id AS author_id_24, m0_.post_id AS post_id_25, m0_.meta_id AS meta_id_26, m1_.translatable_id AS translatable_id_27 FROM magazine_article m0_ LEFT JOIN magazine_article_translation m1_ ON m0_.id = m1_.translatable_id WHERE m1_.locale = ? AND m1_.is_active = 1 AND m1_.deleted_at IS NULL AND (m0_.start_date IS NULL OR m0_.start_date <= ?) AND (m0_.end_date IS NULL OR m0_.end_date >= ?) ORDER BY m1_.created_at DESC
Parameters:
[
  "hu"
  "2026-02-10 09:22:41"
  "2026-02-10 09:22:41"
]
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.47 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.85 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.52 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.43 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.33 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.31 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.39 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:
[]
10 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-!"
]
11 0.42 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"
]
12 0.38 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\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\Magazine\Article\ArticleTranslation No errors.
App\Entity\Common\Author\Author No errors.
App\Entity\Common\Social\Post No errors.
App\Entity\Common\Meta\Meta No errors.
App\Entity\Common\Prompt\Prompt No errors.
App\Entity\Investor\Announcement\Announcement No errors.
App\Entity\Common\Layout\Block No errors.
App\Entity\Common\Tag\Tag No errors.
App\Entity\System\Application\Application 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\Common\Author\AuthorTranslation No errors.
App\Entity\Common\Social\PostItem No errors.
App\Entity\Common\Prompt\PromptTranslation No errors.
App\Entity\Investor\Document\Document No errors.
App\Entity\Investor\Announcement\AnnouncementCategory No errors.
App\Entity\Common\Layout\Slider\Slide No errors.
App\Entity\Investor\Announcement\AnnouncementTranslation No errors.
App\Entity\Common\Layout\Slider\Slider No errors.
App\Entity\Company\Team\Team No errors.
App\Entity\Common\Layout\BlockTranslation No errors.
App\Entity\Common\Tag\TagTranslation No errors.
App\Entity\Industry\Industry No errors.
App\Entity\Industry\IndustryTranslation No errors.