Query Metrics

4 Database Queries
4 Different statements
2.90 ms Query time
1 Invalid entities
22 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.63 ms
(56.07%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.slug AS slug_3, t0.purpose AS purpose_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.views AS views_7, t0.author AS author_8, t0.is_main AS is_main_9, t0.main_image_name AS main_image_name_10, t0.main_image_original_name AS main_image_original_name_11, t0.main_image_mime_type AS main_image_mime_type_12, t0.main_image_size AS main_image_size_13, t0.main_image_dimensions AS main_image_dimensions_14, t0.category_id AS category_id_15, t0.user_id AS user_id_16 FROM material t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "services-rates"
]
0.58 ms
(19.92%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.translatable_id AS translatable_id_10 FROM material_translations t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  827
  "uk"
]
0.35 ms
(12.24%)
1
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.status AS status_3 FROM seo_pattern t0 WHERE t0.purpose = ? AND t0.status = ?
Parameters:
[
  "staticPage"
  1
]
0.34 ms
(11.77%)
1
SELECT t0.id AS id_1, t0.place AS place_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5 FROM tooltip t0
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Tooltip 20
App\Entity\Material 1
App\Entity\MaterialTranslations 1

Entities Mapping

Class Mapping errors
App\Entity\SeoPattern No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Material No errors.
App\Entity\Category No errors.
App\Entity\User
  • The mappings App\Entity\User#expertRequestTo and App\Entity\CompanyUser#user are inconsistent with each other.
  • The mappings App\Entity\User#companyUsers and App\Entity\CompanyUser#user are inconsistent with each other.
  • The mappings App\Entity\User#experts and App\Entity\Clients#expert are inconsistent with each other.
  • The mappings App\Entity\User#clients and App\Entity\Clients#client are inconsistent with each other.
App\Entity\Comment No errors.
App\Entity\MaterialFiles No errors.
App\Entity\MaterialTranslations No errors.
App\Entity\Tooltip No errors.
App\Entity\TooltipTranslations No errors.