Query Metrics
33
Database Queries
9
Different statements
15.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.86 ms |
SELECT u0_.first_name AS first_name_0, u0_.last_name AS last_name_1, u0_.birthday AS birthday_2, u0_.influential_artists AS influential_artists_3, u0_.id AS id_4, u0_.username AS username_5, u0_.email AS email_6, u0_.enabled AS enabled_7, u0_.available_to_collaborate AS available_to_collaborate_8, u0_.salt AS salt_9, u0_.password AS password_10, u0_.last_login AS last_login_11, u0_.roles AS roles_12, u0_.common_information_id AS common_information_id_13 FROM `user` u0_ LEFT JOIN common_information c1_ ON u0_.common_information_id = c1_.id LEFT JOIN common_information_music_style c3_ ON c1_.id = c3_.common_information_id LEFT JOIN music_style m2_ ON m2_.id = c3_.music_style_id LEFT JOIN user_instrument u5_ ON u0_.id = u5_.user_id LEFT JOIN instrument i4_ ON i4_.id = u5_.instrument_id LEFT JOIN action a6_ ON u0_.id = a6_.user_id AND a6_.discr IN ('file_action', 'people_action', 'share', 'event_action', 'event_participation') AND (a6_.action = 'like') WHERE u0_.available_to_collaborate = 1 GROUP BY u0_.id ORDER BY u0_.id DESC LIMIT 7
Parameters:
[] |
| 2 | 0.45 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1 FROM music_style m0_ ORDER BY m0_.name ASC
Parameters:
[] |
| 3 | 0.35 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.family AS family_2, i0_.default AS default_3 FROM instrument i0_ ORDER BY i0_.name ASC
Parameters:
[] |
| 4 | 0.33 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
469
]
|
| 5 | 0.23 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:
[
469
]
|
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
194
]
|
| 7 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
469
]
|
| 8 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.family AS family_3, t0.default AS default_4 FROM instrument t0 INNER JOIN user_instrument ON t0.id = user_instrument.instrument_id WHERE user_instrument.user_id = ?
Parameters:
[
194
]
|
| 9 | 0.70 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 194 "publish" "music" ] |
| 10 | 0.36 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
468
]
|
| 11 | 0.37 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
193
]
|
| 12 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
468
]
|
| 13 | 0.51 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 193 "publish" "music" ] |
| 14 | 0.24 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
467
]
|
| 15 | 0.24 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
192
]
|
| 16 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
467
]
|
| 17 | 0.60 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 192 "publish" "music" ] |
| 18 | 1.78 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
466
]
|
| 19 | 0.24 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
191
]
|
| 20 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
466
]
|
| 21 | 0.49 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 191 "publish" "music" ] |
| 22 | 0.25 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
465
]
|
| 23 | 2.03 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
190
]
|
| 24 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
465
]
|
| 25 | 0.49 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 190 "publish" "music" ] |
| 26 | 0.27 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
464
]
|
| 27 | 0.25 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
189
]
|
| 28 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
464
]
|
| 29 | 0.48 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 189 "publish" "music" ] |
| 30 | 0.22 ms |
SELECT t0.id AS id_1, t0.inscription_date AS inscription_date_2, t0.story AS story_3, t0.experience AS experience_4, t0.country AS country_5, t0.views_number AS views_number_6, t0.profile_picture_id AS profile_picture_id_7, t0.cover_picture_id AS cover_picture_id_8 FROM common_information t0 WHERE t0.id = ?
Parameters:
[
463
]
|
| 31 | 0.22 ms |
SELECT t0.id AS id_1, t0.story AS story_2, t0.role AS role_3, t0.band_id AS band_id_4, t0.user_id AS user_id_5 FROM band_member t0 WHERE t0.user_id = ?
Parameters:
[
188
]
|
| 32 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM music_style t0 INNER JOIN common_information_music_style ON t0.id = common_information_music_style.music_style_id WHERE common_information_music_style.common_information_id = ?
Parameters:
[
463
]
|
| 33 | 0.47 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 file_band_member f1_ ON f0_.id = f1_.file_id INNER JOIN band_member b2_ ON f1_.band_member_id = b2_.id INNER JOIN `user` u3_ ON b2_.user_id = u3_.id INNER JOIN action a4_ ON f0_.id = a4_.file_id AND a4_.discr IN ('file_action') WHERE u3_.id = ? AND f0_.deleted = 0 AND a4_.action = ? AND f0_.type = ? GROUP BY a4_.id ORDER BY a4_.created_at DESC LIMIT 4
Parameters:
[ 188 "publish" "music" ] |
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\MusicStyle | No errors. |
| App\Entity\Instrument | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CommonInformation | No errors. |
| App\Entity\Action | No errors. |
| App\Entity\FileAction | No errors. |
| App\Entity\PeopleAction | No errors. |
| App\Entity\Share | No errors. |
| App\Entity\EventAction | No errors. |
| App\Entity\EventParticipation | No errors. |
| App\Entity\BandMember | No errors. |
| App\Entity\Band | No errors. |
| App\Entity\Folder | No errors. |
| App\Entity\NewMemberSearch | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Playback | No errors. |
| App\Entity\Visit | No errors. |
| App\Entity\FileReport | No errors. |
| App\Entity\Playable | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\FileBandMember | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Project | No errors. |