GET https://api-theatre.rassamahin.ru/api/news?itemsPerPage=6&page=1

Query Metrics

14 Database Queries
4 Different statements
77.93 ms Query time
0 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 66.74 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.data AS data_2, n0_.created_at AS created_at_3, n0_.pinned AS pinned_4, n0_.image_id AS image_id_5 FROM news n0_ ORDER BY n0_.created_at DESC LIMIT 6
Parameters:
[]
2 1.46 ms
SELECT COUNT(n0_.id) AS sclr_0 FROM news n0_
Parameters:
[]
3 1.14 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "73cdf429-8a43-4661-be68-bc98733ff4e2"
]
4 2.60 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
Parameters:
[
  "news"
  Symfony\Component\Uid\UuidV4 {#1165
    __toString(): "7371cf40-c847-4f9a-bea6-1f334229e3ba"
  }
]
5 0.71 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "d70f5773-5429-4ba9-8089-cafb42f4ec58"
]
6 0.63 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
Parameters:
[
  "news"
  Symfony\Component\Uid\UuidV4 {#1258
    __toString(): "3082bfac-6d2f-465a-b34f-dea887bd50d1"
  }
]
7 0.44 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "4ec502bc-abb2-4588-af6f-05ef7967f8c6"
]
8 0.90 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
Parameters:
[
  "news"
  Symfony\Component\Uid\UuidV4 {#1265
    __toString(): "2eb598d4-91e3-4487-883b-2ea630f0f2fc"
  }
]
9 0.63 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "4e8595e9-3ce3-493d-99a1-fd989d970927"
]
10 0.72 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
Parameters:
[
  "news"
  Symfony\Component\Uid\UuidV4 {#1272
    __toString(): "5c91e607-e920-4198-9a6a-8874119d986a"
  }
]
11 0.38 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "693e5ffc-e90b-4860-828a-0d35ff554f72"
]
12 0.55 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
Parameters:
[
  "news"
  Symfony\Component\Uid\UuidV4 {#1279
    __toString(): "88b0043f-ea2e-4096-bc6e-273a1449b960"
  }
]
13 0.45 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "564a6b7d-164a-4712-9d38-dc92abc970ba"
]
14 0.57 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.created_at AS created_at_3 FROM tag t0_ INNER JOIN tag_assignment t1_ ON (t1_.tag_id = t0_.id) WHERE t1_.target_type = ? AND t1_.target_id = ? ORDER BY t0_.title ASC
Parameters:
[
  "news"
  Symfony\Component\Uid\UuidV4 {#1286
    __toString(): "333d5a4a-4493-4935-8188-c37b41c563f8"
  }
]

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\News\Domain\Model\News 6
App\File\Domain\Model\File 6

Entities Mapping