Query Metrics

19 Database Queries
13 Different statements
14.00 ms Query time
1 Invalid entities
35 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.28 ms
UPDATE material SET views = views + 1 WHERE id = ?
Parameters:
[
  684
]
2 0.66 ms
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.id = ?
Parameters:
[
  684
]
3 0.83 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.active AS active_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.ip AS ip_5, c0_.user_id AS user_id_6, c0_.material_id AS material_id_7 FROM comment c0_ WHERE c0_.active = ? AND c0_.material_id IN (?)
Parameters:
[
  1
  684
]
4 0.49 ms
SELECT m0_.id AS id_0, m0_.locale AS locale_1, m0_.title AS title_2, m0_.sub_title AS sub_title_3, m0_.description AS description_4, m0_.content AS content_5, m0_.seo_title AS seo_title_6, m0_.seo_description AS seo_description_7, m0_.seo_keywords AS seo_keywords_8, m0_.translatable_id AS translatable_id_9 FROM material_translations m0_ WHERE m0_.translatable_id IN (?)
Parameters:
[
  684
]
5 0.69 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, m1_.id AS id_2, c2_.title AS title_3, c2_.locale AS locale_4 FROM category c0_ LEFT JOIN material m1_ ON (m1_.category_id = c0_.id) INNER JOIN category_translations c2_ ON (c2_.translatable_id = c0_.id) WHERE c0_.purpose = ? AND m1_.id IN (?)
Parameters:
[
  "news"
  684
]
6 0.79 ms
SELECT m0_.id AS id_0, c1_.id AS id_1, c1_.slug AS slug_2, c2_.title AS title_3, c2_.locale AS locale_4 FROM material m0_ INNER JOIN material_category m3_ ON m0_.id = m3_.material_id INNER JOIN category c1_ ON c1_.id = m3_.category_id INNER JOIN category_translations c2_ ON (c2_.translatable_id = c1_.id)
Parameters:
[]
7 0.58 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.short_description AS short_description_2, p0_.url AS url_3, p0_.image AS image_4, p0_.created_at AS created_at_5, p0_.parent_id AS parent_id_6 FROM parsed_material p0_ ORDER BY p0_.id DESC LIMIT 5
Parameters:
[]
8 0.52 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 = ?
Parameters:
[
  1
  "accepted"
]
9 0.45 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 = ?
Parameters:
[
  2
  "accepted"
]
10 0.50 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 = ?
Parameters:
[
  6
  "accepted"
]
11 0.58 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 = ?
Parameters:
[
  5
  "accepted"
]
12 0.46 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.active AS active_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.ip AS ip_5, c0_.user_id AS user_id_6, c0_.material_id AS material_id_7 FROM comment c0_ WHERE c0_.material_id = ? AND c0_.active = ?
Parameters:
[
  684
  1
]
13 0.37 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.active AS active_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.ip AS ip_5, c0_.user_id AS user_id_6, c0_.material_id AS material_id_7 FROM comment c0_ WHERE c0_.material_id = ? AND c0_.active = ? ORDER BY c0_.id DESC LIMIT 3
Parameters:
[
  684
  1
]
14 0.50 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
]
15 0.55 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:
[
  "news"
  1
]
16 0.31 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:
[
  "news"
  1
]
17 0.29 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:
[
  "news"
  1
]
18 0.57 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:
[
  "news"
  1
]
19 0.55 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
App\Entity\Banner\Banner 5
App\Entity\Material 1
App\Entity\User 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\CategoryTranslations No errors.
App\Entity\ParsedMaterial No errors.
App\Entity\ParseNews No errors.
App\Entity\Banner\Banner 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\Tooltip No errors.
App\Entity\TooltipTranslations No errors.