https://dev.whiplay.fr/search/musicians

Query Metrics

33 Database Queries
9 Different statements
15.25 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.