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

Query Metrics

8 Database Queries
7 Different statements
6.08 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.80 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 1.40 ms
SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.description AS description_2, a0_.status AS status_3, a0_.action AS action_4, a0_.name AS name_5, a0_.place AS place_6, a0_.date AS date_7, a0_.type AS type_8, a0_.price AS price_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.discr AS discr_12, a0_.user_id AS user_id_13, a0_.file_id AS file_id_14, a0_.band_people_id AS band_people_id_15, a0_.user_people_id AS user_people_id_16, a0_.base_action_id AS base_action_id_17, a0_.band_id AS band_id_18, a0_.event_id AS event_id_19, a0_.sender_id AS sender_id_20 FROM action a0_ LEFT JOIN action a1_ ON (a1_.id = a0_.id) AND a1_.discr IN ('file_action') INNER JOIN file f2_ ON a1_.file_id = f2_.id INNER JOIN `user` u3_ ON a1_.user_id = u3_.id WHERE (f2_.status = ? AND u3_.id = ? AND f2_.deleted = 0 AND a1_.action = ? AND f2_.type = ?) AND a0_.discr IN ('file_action', 'people_action', 'share', 'event_action', 'event_participation') GROUP BY a0_.id ORDER BY a0_.created_at DESC LIMIT 20
Parameters:
[
  "public"
  59
  "like"
  "music"
]
3 1.12 ms
SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.description AS description_2, a0_.status AS status_3, a0_.action AS action_4, a0_.name AS name_5, a0_.place AS place_6, a0_.date AS date_7, a0_.type AS type_8, a0_.price AS price_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.discr AS discr_12, a0_.user_id AS user_id_13, a0_.file_id AS file_id_14, a0_.band_people_id AS band_people_id_15, a0_.user_people_id AS user_people_id_16, a0_.base_action_id AS base_action_id_17, a0_.band_id AS band_id_18, a0_.event_id AS event_id_19, a0_.sender_id AS sender_id_20 FROM action a0_ LEFT JOIN action a1_ ON (a1_.id = a0_.id) AND a1_.discr IN ('file_action') INNER JOIN file f2_ ON a1_.file_id = f2_.id INNER JOIN `user` u3_ ON a1_.user_id = u3_.id WHERE (f2_.status = ? AND u3_.id = ? AND f2_.deleted = 0 AND a1_.action = ? AND f2_.type = ?) AND a0_.discr IN ('file_action', 'people_action', 'share', 'event_action', 'event_participation') GROUP BY a0_.id ORDER BY a0_.created_at DESC
Parameters:
[
  "public"
  59
  "like"
  "music"
]
4 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:
[
  129
]
5 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
]
6 0.59 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
]
7 0.56 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
]
8 0.56 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
]

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\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\Picture No errors.
App\Entity\MusicStyle No errors.