https://rapbattleonline.com/author/3

Query Metrics

7 Database Queries
7 Different statements
2.09 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
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, t0.bio AS bio_9, t10.username AS username_11, t10.username_canonical AS username_canonical_12, t10.email AS email_13, t10.email_canonical AS email_canonical_14, t10.enabled AS enabled_15, t10.salt AS salt_16, t10.password AS password_17, t10.last_login AS last_login_18, t10.confirmation_token AS confirmation_token_19, t10.password_requested_at AS password_requested_at_20, t10.roles AS roles_21, t10.id AS id_22, t10.name AS name_23, t10.surname AS surname_24, t10.city AS city_25, t10.is_deleted AS is_deleted_26, t10.date_created AS date_created_27, t10.date_updated AS date_updated_28, t10.is_active AS is_active_29, t10.activated_at AS activated_at_30, t10.reset_password_hash AS reset_password_hash_31, t10.reset_password_hash_valid_to AS reset_password_hash_valid_to_32, t10.image_name AS image_name_33, t10.image_size AS image_size_34, t10.country_id AS country_id_35, t10.my_votes_id AS my_votes_id_36, t10.author_id AS author_id_37, t10.referal_id AS referal_id_38 FROM beat_author t0 LEFT JOIN fos_user t10 ON t10.author_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "3"
]
2 0.22 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.client_id = ?
Parameters:
[
  2
]
3 0.14 ms
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:
[
  2
]
4 0.18 ms
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:
[
  2
]
5 0.39 ms
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_ LEFT JOIN client_beat c2_ ON b0_.id = c2_.beat_id LEFT JOIN fos_user f1_ ON f1_.id = c2_.client_id WHERE b0_.author_id = ? GROUP BY b0_.id ORDER BY COUNT(f1_.id) DESC LIMIT 6
Parameters:
[
  3
]
6 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3 FROM country t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instrumental_file_name AS instrumental_file_name_3, t0.instrumental_size AS instrumental_size_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7, t0.beat_length AS beat_length_8, t0.created_at AS created_at_9, t0.author_id AS author_id_10 FROM beat t0 WHERE t0.author_id = ?
Parameters:
[
  3
]

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\BeatAuthor 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\Beat No errors.
App\Entity\Rapper No errors.
App\Entity\Crew No errors.
App\Entity\Battle 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.