https://rapbattleonline.com/battles

Query Metrics

6 Database Queries
5 Different statements
3.60 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.89 ms
SELECT t0.id AS id_1, t0.battle_ends AS battle_ends_2, t0.battle_file_name AS battle_file_name_3, t0.battle_size AS battle_size_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.is_confirmed AS is_confirmed_7, t0.is_completed AS is_completed_8, t0.is_canceled AS is_canceled_9, t0.challenger_id AS challenger_id_10, t0.oponnent_id AS oponnent_id_11, t0.beat_id AS beat_id_12, t0.winner_id AS winner_id_13, t14.id AS id_15, t14.token AS token_16, t14.status AS status_17, t14.created_at AS created_at_18, t14.valid_to AS valid_to_19, t14.battle_id AS battle_id_20 FROM battle t0 LEFT JOIN battle_invite t14 ON t14.battle_id = t0.id
Parameters:
[]
2 0.94 ms
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_battle ON t0.id = client_battle.client_id WHERE client_battle.battle_id = ?
Parameters:
[
  1
]
3 0.37 ms
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.id = ?
Parameters:
[
  2
]
4 0.40 ms
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.id = ?
Parameters:
[
  5
]
5 0.59 ms
SELECT v0_.id AS id_0, v0_.vote_value AS vote_value_1, v0_.battle_id AS battle_id_2, v0_.voter_id AS voter_id_3 FROM vote v0_ WHERE v0_.battle_id = ? AND v0_.vote_value = 1
Parameters:
[
  1
]
6 0.40 ms
SELECT v0_.id AS id_0, v0_.vote_value AS vote_value_1, v0_.battle_id AS battle_id_2, v0_.voter_id AS voter_id_3 FROM vote v0_ WHERE v0_.battle_id = ? AND v0_.vote_value = 2
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\Battle No errors.
App\Entity\Rapper No errors.
App\Entity\Beat No errors.
App\Entity\BattleInvite No errors.
App\Entity\Vote No errors.
App\Entity\BattleComment 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\Crew No errors.
App\Entity\ClientSettings No errors.
App\Entity\BeatAuthor No errors.
App\Entity\SocialLink No errors.