Query Metrics
17
Database Queries
6
Different statements
8.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.33 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.created_at AS created_at_2, f0_.deleted AS deleted_3, f0_.type AS type_4, f0_.status AS status_5, f0_.extension AS extension_6, f0_.mime_type AS mime_type_7, f0_.real_name AS real_name_8, f0_.description AS description_9, f0_.url AS url_10, f0_.folder_id AS folder_id_11, f0_.project_id AS project_id_12, f0_.playable_id AS playable_id_13, f0_.picture_id AS picture_id_14 FROM file f0_ INNER JOIN action a1_ ON f0_.id = a1_.file_id AND a1_.discr IN ('file_action') LEFT JOIN playable p2_ ON f0_.playable_id = p2_.id LEFT JOIN playable_music_style p4_ ON p2_.id = p4_.playable_id LEFT JOIN music_style m3_ ON m3_.id = p4_.music_style_id WHERE f0_.status = ? AND f0_.deleted = 0 AND a1_.action = ? AND f0_.type = ? GROUP BY a1_.id ORDER BY a1_.created_at DESC LIMIT 6
Parameters:
[ "public" "publish" "music" ] |
| 2 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.city AS city_4, t0.creator_id AS creator_id_5, t0.common_information_id AS common_information_id_6 FROM band t0
Parameters:
[] |
| 3 | 0.53 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.sub_path AS sub_path_3, t0.alt AS alt_4 FROM picture t0 WHERE t0.id = ?
Parameters:
[
466
]
|
| 4 | 0.28 ms |
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
486
]
|
| 5 | 0.43 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip AS ip_3, t0.user_id AS user_id_4, t0.playable_id AS playable_id_5 FROM playback t0 WHERE t0.playable_id = ?
Parameters:
[
486
]
|
| 6 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.deleted AS deleted_4, t0.parent_id AS parent_id_5, t0.owner_id AS owner_id_6, t0.creator_id AS creator_id_7 FROM folder t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 7 | 0.30 ms |
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
466
]
|
| 8 | 0.32 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip AS ip_3, t0.user_id AS user_id_4, t0.playable_id AS playable_id_5 FROM playback t0 WHERE t0.playable_id = ?
Parameters:
[
466
]
|
| 9 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.deleted AS deleted_4, t0.parent_id AS parent_id_5, t0.owner_id AS owner_id_6, t0.creator_id AS creator_id_7 FROM folder t0 WHERE t0.id = ?
Parameters:
[
162
]
|
| 10 | 0.29 ms |
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
467
]
|
| 11 | 0.36 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip AS ip_3, t0.user_id AS user_id_4, t0.playable_id AS playable_id_5 FROM playback t0 WHERE t0.playable_id = ?
Parameters:
[
467
]
|
| 12 | 0.25 ms |
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
468
]
|
| 13 | 0.32 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip AS ip_3, t0.user_id AS user_id_4, t0.playable_id AS playable_id_5 FROM playback t0 WHERE t0.playable_id = ?
Parameters:
[
468
]
|
| 14 | 0.27 ms |
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
469
]
|
| 15 | 0.31 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip AS ip_3, t0.user_id AS user_id_4, t0.playable_id AS playable_id_5 FROM playback t0 WHERE t0.playable_id = ?
Parameters:
[
469
]
|
| 16 | 0.25 ms |
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
470
]
|
| 17 | 0.35 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip AS ip_3, t0.user_id AS user_id_4, t0.playable_id AS playable_id_5 FROM playback t0 WHERE t0.playable_id = ?
Parameters:
[
470
]
|
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\File | No errors. |
| App\Entity\Action | No errors. |
| App\Entity\FileAction | No errors. |
| App\Entity\Playable | No errors. |
| App\Entity\MusicStyle | No errors. |
| App\Entity\Folder | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\FileBandMember | No errors. |
| App\Entity\Band | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CommonInformation | No errors. |
| App\Entity\BandMember | No errors. |
| App\Entity\NewMemberSearch | No errors. |
| App\Entity\PeopleAction | No errors. |
| App\Entity\EventAction | No errors. |
| App\Entity\Invitation | No errors. |
| App\Entity\Thread | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Playback | No errors. |