GET https://ito.qr-pib.kz/post/?page=5

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.48 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 = 'ito.qr-pib.kz')
Parameters:
[
  "ito.qr-pib.kz"
]
2 0.58 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:
[
  "18"
  "kk"
  "App\Entity\Nav"
]
3 8.32 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN ext_translations t1_ ON t1_.locale = 'kk' 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 = 'kk' 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 = 'ito.qr-pib.kz') AND (p0_.deleted_at IS NULL)
Parameters:
[
  "post"
]
4 2.19 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 = 'kk' 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 = 'kk' 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 = 'ito.qr-pib.kz') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC LIMIT 10 OFFSET 40
Parameters:
[
  "post"
]
5 1.70 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 = 'kk' 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 = 'kk' 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 = 'ito.qr-pib.kz') AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC
Parameters:
[
  "post"
  46462
  46092
  45907
  45492
  45477
  45597
  45987
  43682
  43462
  42892
]
6 1.75 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 = 'ito.qr-pib.kz'))
Parameters:
[
  46462
]
7 0.58 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 = 'ito.qr-pib.kz'))
Parameters:
[
  46092
]
8 1.13 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 = 'ito.qr-pib.kz'))
Parameters:
[
  45907
]
9 1.11 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 = 'ito.qr-pib.kz'))
Parameters:
[
  45492
]
10 0.37 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 = 'ito.qr-pib.kz'))
Parameters:
[
  45477
]
11 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 = 'ito.qr-pib.kz'))
Parameters:
[
  45597
]
12 0.33 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 = 'ito.qr-pib.kz'))
Parameters:
[
  45987
]
13 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 = 'ito.qr-pib.kz'))
Parameters:
[
  43682
]
14 0.45 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 = 'ito.qr-pib.kz'))
Parameters:
[
  43462
]
15 0.58 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 = 'ito.qr-pib.kz'))
Parameters:
[
  42892
]

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.