GET https://api-theatre.rassamahin.ru/api/inhouse-stage?itemsPerPage=1000&page=1

Query Metrics

10 Database Queries
4 Different statements
12.17 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 2.39 ms
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.widget AS widget_2, i0_.position AS position_3, i0_.created_at AS created_at_4 FROM inhouse_stage i0_ ORDER BY i0_.position ASC, i0_.created_at DESC LIMIT 1000
Parameters:
[]
2 1.10 ms
SELECT COUNT(DISTINCT i0_.id) AS sclr_0 FROM inhouse_stage i0_
Parameters:
[]
3 2.01 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters:
[
  "a5ea1e9e-f580-4f85-8726-55e5a49c58d9"
]
4 2.39 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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:
[
  "inhouse_stage"
  Symfony\Component\Uid\UuidV4 {#1164
    __toString(): "a5ea1e9e-f580-4f85-8726-55e5a49c58d9"
  }
]
5 0.92 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters:
[
  "0ca1d0cb-67e2-4c2e-aed3-f6a5f3f06d65"
]
6 0.80 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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:
[
  "inhouse_stage"
  Symfony\Component\Uid\UuidV4 {#1206
    __toString(): "0ca1d0cb-67e2-4c2e-aed3-f6a5f3f06d65"
  }
]
7 0.65 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters:
[
  "634773e7-fe71-4c2b-83fe-db72e16b8fa8"
]
8 0.65 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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:
[
  "inhouse_stage"
  Symfony\Component\Uid\UuidV4 {#1213
    __toString(): "634773e7-fe71-4c2b-83fe-db72e16b8fa8"
  }
]
9 0.68 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 INNER JOIN inhouse_stage_photos ON t0.id = inhouse_stage_photos.file_id WHERE inhouse_stage_photos.stage_id = ?
Parameters:
[
  "d03ca077-9603-4a5b-8d87-e73e4289a42b"
]
10 0.59 ms
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.color AS color_2, t0_.url AS url_3, t0_.created_at AS created_at_4 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:
[
  "inhouse_stage"
  Symfony\Component\Uid\UuidV4 {#1218
    __toString(): "d03ca077-9603-4a5b-8d87-e73e4289a42b"
  }
]

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\File\Domain\Model\File 16
App\InhouseStage\Domain\Model\InhouseStage 4

Entities Mapping