Query Metrics
7
Database Queries
7
Different statements
5.86 ms
Query time
1
Invalid entities
27
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.70 ms (28.96%) |
1 |
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 ] |
|
1.48 ms (25.19%) |
1 |
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 ] |
|
0.69 ms (11.84%) |
1 |
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" ] |
|
0.65 ms (11.16%) |
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.slug IS NULL LIMIT 1
Parameters:
[] |
|
0.51 ms (8.63%) |
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.43 ms (7.32%) |
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:
[ "allNews" 1 ] |
|
0.41 ms (6.91%) |
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\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 |
|
| 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. |