https://dev.whiplay.fr/

Query Metrics

17 Database Queries
6 Different statements
8.75 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.33 ms
(38.03%)
1
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.09 ms
(23.88%)
6
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
]
1.65 ms
(18.90%)
6
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  486
]
0.59 ms
(6.79%)
2
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
]
0.55 ms
(6.33%)
1
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:
[]
0.53 ms
(6.07%)
1
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
]

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.