https://rapbattleonline.com/beats

Query Metrics

13 Database Queries
7 Different statements
5.83 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.18 ms
(37.43%)
4
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.name AS name_13, t0.surname AS surname_14, t0.city AS city_15, t0.is_deleted AS is_deleted_16, t0.date_created AS date_created_17, t0.date_updated AS date_updated_18, t0.is_active AS is_active_19, t0.activated_at AS activated_at_20, t0.reset_password_hash AS reset_password_hash_21, t0.reset_password_hash_valid_to AS reset_password_hash_valid_to_22, t0.image_name AS image_name_23, t0.image_size AS image_size_24, t0.country_id AS country_id_25, t26.id AS id_27, t26.pseudoname AS pseudoname_28, t26.avatar_name AS avatar_name_29, t26.avatar_size AS avatar_size_30, t26.updated_at AS updated_at_31, t26.created_at AS created_at_32, t26.rapper_style AS rapper_style_33, t26.bio AS bio_34, t26.rank AS rank_35, t26.client_id AS client_id_36, t26.crew_id AS crew_id_37, t0.my_votes_id AS my_votes_id_38, t39.id AS id_40, t39.display_contact AS display_contact_41, t39.client_id AS client_id_42, t0.author_id AS author_id_43, t0.referal_id AS referal_id_44, t45.id AS id_46, t45.name AS name_47, t45.city AS city_48, t45.description AS description_49, t45.background_file_name AS background_file_name_50, t45.background_size AS background_size_51, t45.image_name AS image_name_52, t45.image_size AS image_size_53, t45.updated_at AS updated_at_54, t45.created_at AS created_at_55, t45.tag AS tag_56, t45.rank AS rank_57, t45.country_id AS country_id_58, t45.created_by_id AS created_by_id_59 FROM fos_user t0 LEFT JOIN rapper t26 ON t26.client_id = t0.id LEFT JOIN client_settings t39 ON t39.client_id = t0.id LEFT JOIN crew t45 ON t45.created_by_id = t0.id INNER JOIN client_beat ON t0.id = client_beat.client_id WHERE client_beat.beat_id = ?
Parameters:
[
  4
]
1.02 ms
(17.51%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.instrumental_file_name AS instrumental_file_name_2, b0_.instrumental_size AS instrumental_size_3, b0_.image_name AS image_name_4, b0_.image_size AS image_size_5, b0_.updated_at AS updated_at_6, b0_.beat_length AS beat_length_7, b0_.created_at AS created_at_8, b0_.author_id AS author_id_9 FROM beat b0_ ORDER BY b0_.created_at DESC
Parameters:
[]
0.68 ms
(11.60%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.pseudoname AS pseudoname_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.username AS username_10, t9.username_canonical AS username_canonical_11, t9.email AS email_12, t9.email_canonical AS email_canonical_13, t9.enabled AS enabled_14, t9.salt AS salt_15, t9.password AS password_16, t9.last_login AS last_login_17, t9.confirmation_token AS confirmation_token_18, t9.password_requested_at AS password_requested_at_19, t9.roles AS roles_20, t9.id AS id_21, t9.name AS name_22, t9.surname AS surname_23, t9.city AS city_24, t9.is_deleted AS is_deleted_25, t9.date_created AS date_created_26, t9.date_updated AS date_updated_27, t9.is_active AS is_active_28, t9.activated_at AS activated_at_29, t9.reset_password_hash AS reset_password_hash_30, t9.reset_password_hash_valid_to AS reset_password_hash_valid_to_31, t9.image_name AS image_name_32, t9.image_size AS image_size_33, t9.country_id AS country_id_34, t9.my_votes_id AS my_votes_id_35, t9.author_id AS author_id_36, t9.referal_id AS referal_id_37 FROM beat_author t0 LEFT JOIN fos_user t9 ON t9.author_id = t0.id
Parameters:
[]
0.58 ms
(10.00%)
2
SELECT t0.id AS id_1, t0.pseudoname AS pseudoname_2, t0.avatar_name AS avatar_name_3, t0.avatar_size AS avatar_size_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.rapper_style AS rapper_style_7, t0.bio AS bio_8, t0.rank AS rank_9, t0.client_id AS client_id_10, t0.crew_id AS crew_id_11 FROM rapper t0 WHERE t0.client_id = ?
Parameters:
[
  1
]
0.48 ms
(8.17%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.description AS description_4, t0.background_file_name AS background_file_name_5, t0.background_size AS background_size_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.tag AS tag_11, t0.rank AS rank_12, t0.country_id AS country_id_13, t0.created_by_id AS created_by_id_14 FROM crew t0 WHERE t0.created_by_id = ?
Parameters:
[
  1
]
0.45 ms
(7.65%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.instrumental_file_name AS instrumental_file_name_2, b0_.instrumental_size AS instrumental_size_3, b0_.image_name AS image_name_4, b0_.image_size AS image_size_5, b0_.updated_at AS updated_at_6, b0_.beat_length AS beat_length_7, b0_.created_at AS created_at_8, b0_.author_id AS author_id_9 FROM beat b0_ ORDER BY b0_.created_at ASC LIMIT 6
Parameters:
[]
0.45 ms
(7.65%)
2
SELECT t0.id AS id_1, t0.display_contact AS display_contact_2, t0.client_id AS client_id_3 FROM client_settings t0 WHERE t0.client_id = ?
Parameters:
[
  1
]

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\Beat No errors.
App\Entity\BeatAuthor No errors.
App\Entity\BeatCategory No errors.
App\Entity\Battle No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\Client
  • The field App\Entity\Client#myVotes is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Vote#voter does not contain the required 'mappedBy="myVotes"' attribute.
  • If association App\Entity\Client#myVotes is many-to-one, then the inversed side App\Entity\Vote#voter has to be one-to-many.
App\Entity\Country No errors.
App\Entity\Vote No errors.
App\Entity\Rapper No errors.
App\Entity\Crew No errors.
App\Entity\SocialLink No errors.
App\Entity\ClientActivationToken No errors.
App\Entity\ClientSettings No errors.
App\Entity\ClientMessage No errors.
App\Entity\ClientNotification No errors.
App\Entity\AuthorizationToken No errors.
App\Entity\BattleComment No errors.
App\Entity\BattleCommentLike No errors.