Query Metrics

7 Database Queries
7 Different statements
5.86 ms Query time
1 Invalid entities
27 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.65 ms
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.status AS status_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.image_mime_type AS image_mime_type_8, t0.image_size AS image_size_9, t0.image_dimensions AS image_dimensions_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
2 0.69 ms
SELECT b0_.id AS id_0, b0_.place AS place_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.url AS url_4, b0_.target_is_blank AS target_is_blank_5, b0_.status AS status_6, b0_.custom_attributes AS custom_attributes_7, b0_.rule_to_show AS rule_to_show_8, b0_.action AS action_9, b0_.main_image_name AS main_image_name_10, b0_.main_image_original_name AS main_image_original_name_11, b0_.main_image_mime_type AS main_image_mime_type_12, b0_.main_image_size AS main_image_size_13, b0_.main_image_dimensions AS main_image_dimensions_14, b0_.author_id AS author_id_15 FROM banner b0_ WHERE b0_.place = ? AND b0_.status = ? LIMIT 1
Parameters:
[
  7
  "accepted"
]
3 1.70 ms
SELECT COUNT(DISTINCT (m0_.id)) AS sclr_0 FROM material m0_ WHERE m0_.purpose = ? AND m0_.status = ? ORDER BY m0_.id DESC
Parameters:
[
  "company"
  1
]
4 1.48 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.slug AS slug_2, m0_.purpose AS purpose_3, m0_.updated_at AS updated_at_4, m0_.status AS status_5, m0_.views AS views_6, m0_.author AS author_7, m0_.is_main AS is_main_8, m0_.main_image_name AS main_image_name_9, m0_.main_image_original_name AS main_image_original_name_10, m0_.main_image_mime_type AS main_image_mime_type_11, m0_.main_image_size AS main_image_size_12, m0_.main_image_dimensions AS main_image_dimensions_13, m0_.category_id AS category_id_14, m0_.user_id AS user_id_15 FROM material m0_ WHERE m0_.purpose = ? AND m0_.status = ? ORDER BY m0_.id DESC LIMIT 3
Parameters:
[
  "company"
  1
]
5 0.51 ms
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.status AS status_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.image_mime_type AS image_mime_type_8, t0.image_size AS image_size_9, t0.image_dimensions AS image_dimensions_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.purpose = ? AND t0.status = ?
Parameters:
[
  "news"
  1
]
6 0.43 ms
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:
[
  "allNews"
  1
]
7 0.41 ms
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\Category 7

Entities Mapping

Class Mapping errors
App\Entity\SeoPattern No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Category No errors.
App\Entity\Banner\Banner 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\Material No errors.
App\Entity\Measure No errors.
App\Entity\Screaning No errors.
App\Entity\Service No errors.
App\Entity\Expert No errors.
App\Entity\DictionarySearch No errors.
App\Entity\DictionarySearchForPage No errors.
App\Entity\FAQ No errors.
App\Entity\CategoryTranslations No errors.
App\Entity\Tooltip No errors.
App\Entity\TooltipTranslations No errors.