Query Metrics

8 Database Queries
6 Different statements
10.16 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 4.88 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Érëê2xÀ┐²-5\x1Dß8┼"
]
2 2.13 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.54 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.70 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.45 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.33 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.68 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.44 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\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.