https://dev.whiplay.fr/profile/59

Query Metrics

12 Database Queries
11 Different statements
21.76 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.23 ms
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.birthday AS birthday_3, t0.influential_artists AS influential_artists_4, t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.enabled AS enabled_8, t0.available_to_collaborate AS available_to_collaborate_9, t0.salt AS salt_10, t0.password AS password_11, t0.last_login AS last_login_12, t0.roles AS roles_13, t0.common_information_id AS common_information_id_14 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  "59"
]
2 5.21 ms
SELECT v0_.id AS id_0, v0_.created_at AS created_at_1, v0_.ip AS ip_2, v0_.user_id AS user_id_3, v0_.common_information_id AS common_information_id_4 FROM visit v0_ WHERE v0_.ip = ? AND v0_.common_information_id = ? AND v0_.created_at > ?
Parameters:
[
  "216.73.216.48"
  129
  "2025-12-11 05:37:47"
]
3 0.25 ms
"START TRANSACTION"
Parameters:
[]
4 0.63 ms
INSERT INTO visit (created_at, ip, user_id, common_information_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "2025-12-11 05:42:47"
  2 => "216.73.216.48"
  3 => null
  4 => 129
]
5 4.80 ms
"COMMIT"
Parameters:
[]
6 0.62 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:
[
  129
]
7 0.50 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:
[
  445
]
8 0.50 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:
[
  449
]
9 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:
[
  59
]
10 6.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.common_information_id AS common_information_id_5 FROM visit t0 WHERE t0.common_information_id = ?
Parameters:
[
  129
]
11 0.64 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:
[
  129
]
12 0.43 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:
[
  59
]

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\User No errors.
App\Entity\CommonInformation No errors.
App\Entity\Instrument No errors.
App\Entity\BandMember No errors.
App\Entity\Band No errors.
App\Entity\Action No errors.
App\Entity\PeopleAction 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\Picture No errors.
App\Entity\MusicStyle No errors.