Query Metrics
19
Database Queries
13
Different statements
11.55 ms
Query time
1
Invalid entities
36
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.85 ms (24.66%) |
1 |
UPDATE material SET views = views + 1 WHERE id = ?
Parameters:
[
570
]
|
|
1.66 ms (14.33%) |
4 |
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 ] |
|
1.64 ms (14.15%) |
4 |
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" ] |
|
0.64 ms (5.51%) |
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:
[] |
|
0.62 ms (5.40%) |
1 |
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:
[] |
|
0.62 ms (5.40%) |
1 |
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 570 ] |
|
0.58 ms (4.99%) |
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.id = ?
Parameters:
[
570
]
|
|
0.57 ms (4.89%) |
1 |
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:
[] |
|
0.56 ms (4.89%) |
1 |
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 ] |
|
0.53 ms (4.63%) |
1 |
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" 570 ] |
|
0.48 ms (4.12%) |
1 |
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:
[
570
]
|
|
0.45 ms (3.88%) |
1 |
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:
[ 570 1 ] |
|
0.36 ms (3.14%) |
1 |
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:
[ 570 1 ] |
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\MaterialTranslations | 2 |
| App\Entity\Material | 1 |
| App\Entity\User | 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 |
|
| 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. |