Query Metrics

10 Database Queries
6 Different statements
7.74 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.10 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, m0_.author_id AS author_id_11, m0_.post_id AS post_id_12, m0_.meta_id AS meta_id_13 FROM magazine_article m0_ LEFT JOIN magazine_article_translation m1_ ON m0_.id = m1_.translatable_id WHERE m1_.slug = ? AND m1_.locale = ? LIMIT 1
Parameters:
[
  "a-gloster-portfoliotisztitasa-uj-lehetosegek-es-hosszu-tavu-novekedes-kihivasai"
  "hu"
]
2 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’š?ëZs¬º‰¯\x14ahöþ"
]
3 0.75 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’š?ëZs¬º‰¯\x14ahöþ"
]
4 2.42 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"
]
5 0.38 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"
]
6 0.37 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"
]
7 0.89 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"
]
8 0.39 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Î"
]
9 0.36 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╬"
]
10 0.47 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
    """
]

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\Common\Meta\MetaTranslation 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\System\Application\ConfigTranslation No errors.