Query Metrics
9
Database Queries
6
Different statements
24.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.92 ms |
SELECT count(DISTINCT i0_.id) AS sclr_0 FROM instrument i0_
Parameters:
[] |
| 2 | 2.11 ms |
SELECT DISTINCT i0_.id AS id_0 FROM instrument i0_ LIMIT 8 OFFSET 8
Parameters:
[] |
| 3 | 4.08 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.picture AS picture_2, i0_.release_at AS release_at_3, i0_.description AS description_4, i0_.summary AS summary_5, i0_.slug AS slug_6, i0_.updated_at AS updated_at_7, i0_.category_id AS category_id_8, i0_.company_id AS company_id_9 FROM instrument i0_ WHERE i0_.id IN (?, ?, ?)
Parameters:
[ 4 8 11 ] |
| 4 | 1.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.updated_at AS updated_at_4, t0.description AS description_5, t0.slug AS slug_6 FROM company t0
Parameters:
[] |
| 5 | 3.33 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.file AS file_4, t0.updated_at AS updated_at_5, t0.seek_to AS seek_to_6, t0.instrument_id AS instrument_id_7, t0.artist_id AS artist_id_8, t0.player_id AS player_id_9 FROM sound t0 WHERE t0.instrument_id = ?
Parameters:
[
4
]
|
| 6 | 0.57 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.file AS file_4, t0.updated_at AS updated_at_5, t0.seek_to AS seek_to_6, t0.instrument_id AS instrument_id_7, t0.artist_id AS artist_id_8, t0.player_id AS player_id_9 FROM sound t0 WHERE t0.instrument_id = ?
Parameters:
[
8
]
|
| 7 | 2.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM artist t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 8 | 3.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.file AS file_4, t0.updated_at AS updated_at_5, t0.seek_to AS seek_to_6, t0.instrument_id AS instrument_id_7, t0.artist_id AS artist_id_8, t0.player_id AS player_id_9 FROM sound t0 WHERE t0.instrument_id = ?
Parameters:
[
11
]
|
| 9 | 3.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM artist t0 WHERE t0.id = ?
Parameters:
[
18
]
|
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\Instrument | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Sound | No errors. |
| App\Entity\Artist | No errors. |
| App\Entity\Player | No errors. |
| App\Entity\User | No errors. |