Query Metrics
9
Database Queries
5
Different statements
5.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.60 ms (26.93%) |
4 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.domain AS domain_7, t0.post_id AS post_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM attachment t0 WHERE t0.post_id = ? AND ((t0.domain = 'qarlygash.qr-pib.kz'))
Parameters:
[
57915
]
|
|
1.54 ms (25.89%) |
1 |
SELECT p0_.id AS id_0, p0_.published_at AS published_at_1, t1_.content AS title_2, p0_.slug AS slug_3, p0_.summary AS summary_4, t2_.content AS content_5, p0_.is_active AS is_active_6, p0_.type AS type_7, p0_.template AS template_8, p0_.counter AS counter_9, p0_.modified_at AS modified_at_10, p0_.id_old AS id_old_11, p0_.template_old AS template_old_12, p0_.is_slider_active AS is_slider_active_13, p0_.domain AS domain_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.deleted_at AS deleted_at_17, p0_.author_id AS author_id_18, p0_.parent_id AS parent_id_19, p0_.created_by AS created_by_20, p0_.updated_by AS updated_by_21 FROM post p0_ INNER JOIN ext_translations t1_ ON t1_.locale = 'ru' AND t1_.field = 'title' AND t1_.object_class = 'App\\Entity\\Post' AND t1_.foreign_key = p0_.id INNER JOIN ext_translations t2_ ON t2_.locale = 'ru' AND t2_.field = 'content' AND t2_.object_class = 'App\\Entity\\Post' AND t2_.foreign_key = p0_.id WHERE (p0_.type = 'post' AND t1_.content <> '' AND p0_.is_active = 1 AND p0_.published_at < CURRENT_TIMESTAMP) AND (p0_.domain = 'qarlygash.qr-pib.kz') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC LIMIT 4
Parameters:
[] |
|
1.38 ms (23.27%) |
1 |
SELECT t0.id AS id_1, t0.published_at AS published_at_2, t0.title AS title_3, t0.slug AS slug_4, t0.summary AS summary_5, t0.content AS content_6, t0.is_active AS is_active_7, t0.type AS type_8, t0.template AS template_9, t0.counter AS counter_10, t0.modified_at AS modified_at_11, t0.id_old AS id_old_12, t0.template_old AS template_old_13, t0.is_slider_active AS is_slider_active_14, t0.domain AS domain_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.author_id AS author_id_19, t0.parent_id AS parent_id_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22 FROM post t0 WHERE t0.template = ? AND t0.is_active = ? AND ((t0.domain = 'qarlygash.qr-pib.kz') AND (t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[ "about" 1 ] |
|
0.99 ms (16.57%) |
2 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "14" "ru" "App\Entity\Nav" ] |
|
0.44 ms (7.34%) |
1 |
SELECT n0_.id AS id_0, n0_.body AS body_1, n0_.domain AS domain_2, n0_.created_by AS created_by_3, n0_.updated_by AS updated_by_4 FROM nav n0_ WHERE (n0_.domain = ?) AND (n0_.domain = 'qarlygash.qr-pib.kz')
Parameters:
[
"qarlygash.qr-pib.kz"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Post | No errors. |
| App\Entity\Nav | No errors. |
| App\Entity\User | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\Entity\Attachment | No errors. |
| App\Entity\Category | No errors. |