https://dev.whiplay.fr/profile/151/subscriptions

Query Metrics

9 Database Queries
8 Different statements
18.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.01 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:
[
  "151"
]
2 0.94 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:
[
  420
]
3 0.81 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.user_people_id = ? AND t0.discr IN ('people_action')
Parameters:
[
  151
]
4 10.45 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.discr, t0.file_id AS file_id_7, t0.band_people_id AS band_people_id_8, t0.user_people_id AS user_people_id_9, t0.base_action_id AS base_action_id_10, t0.name AS name_11, t0.place AS place_12, t0.date AS date_13, t0.type AS type_14, t0.price AS price_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.band_id AS band_id_18, t0.event_id AS event_id_19, t0.sender_id AS sender_id_20 FROM action t0 WHERE t0.user_id = ? AND t0.discr IN ('file_action', 'people_action', 'share', 'event_action', 'event_participation')
Parameters:
[
  151
]
5 3.91 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:
[
  420
]
6 0.53 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:
[
  151
]
7 0.31 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:
[
  2
]
8 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:
[
  2
]
9 0.28 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:
[
  463
]

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.
App\Entity\FileAction No errors.
App\Entity\File No errors.
App\Entity\Share No errors.
App\Entity\EventAction No errors.
App\Entity\EventParticipation No errors.
App\Entity\Invitation No errors.
App\Entity\Thread No errors.
App\Entity\Project No errors.