GET https://qarlygash.qr-pib.kz/ru/post/?page=54

Query Metrics

15 Database Queries
6 Different statements
200.68 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
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"
]
2 0.55 ms
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"
]
3 138.61 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 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 = ? 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)
Parameters:
[
  "post"
]
4 55.07 ms
SELECT DISTINCT p0_.id AS id_0, p0_.published_at AS published_at_1 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 = ? 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 10 OFFSET 530
Parameters:
[
  "post"
]
5 1.64 ms
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 = ? AND t1_.content <> '' AND p0_.is_active = 1 AND p0_.published_at < CURRENT_TIMESTAMP AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.domain = 'qarlygash.qr-pib.kz') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC
Parameters:
[
  "post"
  14810
  14809
  14803
  14799
  14801
  14807
  14804
  14797
  14794
  14792
]
6 0.96 ms
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:
[
  14810
]
7 0.39 ms
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:
[
  14809
]
8 0.42 ms
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:
[
  14803
]
9 0.41 ms
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:
[
  14799
]
10 0.30 ms
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:
[
  14801
]
11 0.43 ms
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:
[
  14807
]
12 0.41 ms
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:
[
  14804
]
13 0.30 ms
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:
[
  14797
]
14 0.40 ms
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:
[
  14794
]
15 0.38 ms
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:
[
  14792
]

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.