POST https://api.mmafriend.com/api/bettingGroupUser

Query Metrics

10 Database Queries
4 Different statements
3.52 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.28 ms
(36.34%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.date_string AS date_string_4, t0.link_ufc_site AS link_ufc_site_5, t0.location AS location_6 FROM event t0 INNER JOIN betting_group_event ON t0.id = betting_group_event.event_id WHERE betting_group_event.betting_group_id = ?
Parameters:
[
  4
]
1.21 ms
(34.33%)
4
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.full_name AS full_name_6, t0.nickname AS nickname_7, t0.avatar AS avatar_8 FROM user t0 INNER JOIN betting_group_user ON t0.id = betting_group_user.user_id WHERE betting_group_user.betting_group_id = ?
Parameters:
[
  4
]
0.57 ms
(16.29%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.creation_date AS creation_date_3, b0_.access_code AS access_code_4, b0_.expirate_date AS expirate_date_5, b0_.leader_id AS leader_id_6 FROM betting_group b0_ LEFT JOIN betting_group_user b2_ ON b0_.id = b2_.betting_group_id LEFT JOIN user u1_ ON u1_.id = b2_.user_id WHERE b0_.leader_id = ? OR u1_.id = ?
Parameters:
[
  2
  2
]
0.46 ms
(13.05%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.full_name AS full_name_6, t0.nickname AS nickname_7, t0.avatar AS avatar_8 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "swan.daphne@gmail.com"
]

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
  • The association App\Entity\User#bettingGroupStats refers to the owning side field App\Entity\BettingGroupStats#User which does not exist.
App\Entity\Bet No errors.
App\Entity\BettingGroup No errors.
App\Entity\BettingGroupStats
  • The mappings App\Entity\BettingGroupStats#user and App\Entity\User#bettingGroupStats are inconsistent with each other.
App\Entity\Event No errors.
App\Entity\Fights No errors.
App\Entity\Images No errors.