https://dev.whiplay.fr/band/10/files/picture

Query Metrics

56 Database Queries
20 Different statements
42.68 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.89 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 WHERE t0.id = ?
Parameters:
[
  "10"
]
2 0.56 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:
[
  10
]
3 0.30 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:
[
  128
]
4 0.96 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 folder f1_ ON f0_.folder_id = f1_.id INNER JOIN band b2_ ON f1_.owner_id = b2_.id INNER JOIN action a3_ ON f0_.id = a3_.file_id AND a3_.discr IN ('file_action') WHERE b2_.id = ? AND a3_.action = ? AND f0_.status = ? AND f0_.deleted = 0 AND f0_.type = ? GROUP BY a3_.id ORDER BY a3_.created_at DESC
Parameters:
[
  10
  "favorite"
  "public"
  "picture"
]
5 0.71 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 folder f1_ ON f0_.folder_id = f1_.id INNER JOIN band b2_ ON f1_.owner_id = b2_.id INNER JOIN action a3_ ON f0_.id = a3_.file_id AND a3_.discr IN ('file_action') WHERE b2_.id = ? AND a3_.action = ? AND f0_.status = ? AND f0_.deleted = 0 AND f0_.type = ? AND a3_.id < ? GROUP BY a3_.id ORDER BY a3_.created_at DESC LIMIT 20
Parameters:
[
  10
  "publish"
  "public"
  "picture"
  999999999
]
6 0.66 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 folder f1_ ON f0_.folder_id = f1_.id INNER JOIN band b2_ ON f1_.owner_id = b2_.id INNER JOIN action a3_ ON f0_.id = a3_.file_id AND a3_.discr IN ('file_action') WHERE b2_.id = ? AND a3_.action = ? AND f0_.status = ? AND f0_.deleted = 0 AND f0_.type = ? AND a3_.id < ? GROUP BY a3_.id ORDER BY a3_.created_at DESC LIMIT 50
Parameters:
[
  10
  "publish"
  "public"
  "picture"
  999999999
]
7 8.69 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"
  10
  "2025-12-09 17:01:29"
]
8 0.24 ms
"START TRANSACTION"
Parameters:
[]
9 0.80 ms
INSERT INTO visit (created_at, ip, user_id, common_information_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "2025-12-09 17:06:29"
  2 => "216.73.216.48"
  3 => null
  4 => 10
]
10 4.58 ms
"COMMIT"
Parameters:
[]
11 0.53 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.owner_id = ?
Parameters:
[
  10
]
12 0.35 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:
[
  370
]
13 0.28 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.band_id AS band_id_5, t0.createdBy AS createdBy_6 FROM new_member_search t0 WHERE t0.band_id = ?
Parameters:
[
  10
]
14 0.29 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:
[
  10
]
15 11.07 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:
[
  10
]
16 0.71 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.type AS type_5, t0.status AS status_6, t0.extension AS extension_7, t0.mime_type AS mime_type_8, t0.real_name AS real_name_9, t0.description AS description_10, t0.url AS url_11, t0.folder_id AS folder_id_12, t0.project_id AS project_id_13, t0.playable_id AS playable_id_14, t0.picture_id AS picture_id_15 FROM file t0 WHERE t0.folder_id = ?
Parameters:
[
  63
]
17 0.39 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.type AS type_5, t0.status AS status_6, t0.extension AS extension_7, t0.mime_type AS mime_type_8, t0.real_name AS real_name_9, t0.description AS description_10, t0.url AS url_11, t0.folder_id AS folder_id_12, t0.project_id AS project_id_13, t0.playable_id AS playable_id_14, t0.picture_id AS picture_id_15 FROM file t0 WHERE t0.folder_id = ?
Parameters:
[
  67
]
18 0.31 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.type AS type_5, t0.status AS status_6, t0.extension AS extension_7, t0.mime_type AS mime_type_8, t0.real_name AS real_name_9, t0.description AS description_10, t0.url AS url_11, t0.folder_id AS folder_id_12, t0.project_id AS project_id_13, t0.playable_id AS playable_id_14, t0.picture_id AS picture_id_15 FROM file t0 WHERE t0.folder_id = ?
Parameters:
[
  68
]
19 0.37 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.type AS type_5, t0.status AS status_6, t0.extension AS extension_7, t0.mime_type AS mime_type_8, t0.real_name AS real_name_9, t0.description AS description_10, t0.url AS url_11, t0.folder_id AS folder_id_12, t0.project_id AS project_id_13, t0.playable_id AS playable_id_14, t0.picture_id AS picture_id_15 FROM file t0 WHERE t0.folder_id = ?
Parameters:
[
  310
]
20 0.57 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  300
]
21 0.49 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:
[
  300
]
22 0.22 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  301
]
23 0.26 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:
[
  301
]
24 0.33 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  302
]
25 0.38 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:
[
  302
]
26 0.35 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  303
]
27 0.34 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:
[
  303
]
28 0.24 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  304
]
29 0.30 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:
[
  304
]
30 0.32 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  280
]
31 0.30 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:
[
  280
]
32 0.20 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  281
]
33 0.24 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:
[
  281
]
34 0.19 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  282
]
35 0.26 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:
[
  282
]
36 0.18 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  283
]
37 0.26 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:
[
  283
]
38 0.20 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  284
]
39 0.22 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:
[
  284
]
40 0.16 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  285
]
41 0.20 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:
[
  285
]
42 0.18 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  286
]
43 0.25 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:
[
  286
]
44 0.21 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  287
]
45 0.23 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:
[
  287
]
46 0.17 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  288
]
47 0.21 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:
[
  288
]
48 0.23 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  289
]
49 0.25 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:
[
  289
]
50 0.17 ms
SELECT t0.id AS id_1 FROM playable t0 WHERE t0.id = ?
Parameters:
[
  290
]
51 0.24 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:
[
  290
]
52 0.35 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.description AS description_3, t0.status AS status_4, t0.action AS action_5, t0.user_id AS user_id_6, t0.band_people_id AS band_people_id_7, t0.user_people_id AS user_people_id_8, t0.discr FROM action t0 WHERE t0.band_people_id = ? AND t0.discr IN ('people_action')
Parameters:
[
  10
]
53 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.band_id = ?
Parameters:
[
  10
]
54 0.34 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:
[
  2
]
55 0.37 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:
[
  22
]
56 0.29 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:
[
  346
]

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\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\Action No errors.
App\Entity\PeopleAction No errors.
App\Entity\Folder No errors.
App\Entity\EventAction No errors.
App\Entity\Invitation No errors.
App\Entity\Thread No errors.
App\Entity\Order No errors.
App\Entity\Project No errors.
App\Entity\Picture No errors.
App\Entity\MusicStyle No errors.
App\Entity\Visit No errors.
App\Entity\File No errors.
App\Entity\FileAction No errors.
App\Entity\Playable No errors.
App\Entity\FileBandMember No errors.
App\Entity\Playback No errors.
App\Entity\Share No errors.
App\Entity\Instrument No errors.
App\Entity\FileReport No errors.