https://prod.golmanagerpanel.com/api/es/register?p=api%2Fes%2Fregister

Query Metrics

8 Database Queries
8 Different statements
13.13 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.95 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.plain_password AS plain_password_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.surname AS surname_9, t0.address AS address_10, t0.celular AS celular_11, t0.image AS image_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.country_id AS country_id_15, t0.season_active AS season_active_16, t0.type_account AS type_account_17, t0.is_pro AS is_pro_18, t0.purchase AS purchase_19, t0.purchase_platform AS purchase_platform_20, t0.membership_id AS membership_id_21, t0.coupon_status AS coupon_status_22, t0.phone AS phone_23, t0.google_auth_code AS google_auth_code_24, t0.google_auth_code_verified AS google_auth_code_verified_25, t0.date_of_birth AS date_of_birth_26, t0.deleted_at AS deleted_at_27, t0.is_deleted AS is_deleted_28, t0.country_id AS country_id_29 FROM customer t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "almarcha1978@gmail.com"
]
2 1.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.flag AS flag_4, t0.updated_at AS updated_at_5 FROM country t0 WHERE t0.id IN (?) LIMIT 1
Parameters:
[
  [
    2
    "Spain"
    "ES"
    "https://prod.golmanagerpanel.com/uploads/images/country/5f9dbfcbdf865193215551.png"
  ]
]
3 1.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number_players AS number_players_3 FROM type_soccer t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "U11"
]
4 0.22 ms
"START TRANSACTION"
Parameters:
[]
5 4.19 ms
INSERT INTO customer (email, username, roles, PASSWORD, plain_password, enabled, name, surname, address, celular, image, created_at, updated_at, country_id, season_active, type_account, is_pro, purchase, purchase_platform, membership_id, coupon_status, phone, google_auth_code, google_auth_code_verified, date_of_birth, deleted_at, is_deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "almarcha1978@gmail.com"
  2 => null
  3 => "["ROLE_CUSTOMER"]"
  4 => "$argon2id$v=19$m=65536,t=4,p=1$R2pLbFouL3NFWDlsRVduNg$xjPUP5BA8xatFoNdw3KUZjd/PohOVPwor7rx4CrRxis"
  5 => "panchulin"
  6 => 1
  7 => "Jesús "
  8 => "almarcha"
  9 => null
  10 => null
  11 => null
  12 => "2024-11-06 15:44:48"
  13 => null
  14 => 2
  15 => null
  16 => "APP"
  17 => null
  18 => null
  19 => null
  20 => null
  21 => null
  22 => null
  23 => null
  24 => null
  25 => null
  26 => null
  27 => null
]
6 2.84 ms
INSERT INTO team (name, image, image_trainer, updated_at, category, monthly_cost, kit_payment_cost, other_payment_cost, stadium_name, number_clubes_league, type_soccer_id, alignment_default_u7_id, alignment_default_u8_id, alignment_default_u11_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "petrelense "
  2 => "672bf16066fcd136795429.jpg"
  3 => "672bf1606cc62667806685.jpg"
  4 => "2024-11-06 15:44:48"
  5 => "juvenil "
  6 => null
  7 => null
  8 => null
  9 => null
  10 => null
  11 => 3
  12 => null
  13 => null
  14 => null
]
7 1.95 ms
INSERT INTO season (year, is_active, team_id, customer_id, country_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  1 => 24
  2 => 1
  3 => 26705
  4 => 26599
  5 => 2
]
8 0.28 ms
"COMMIT"
Parameters:
[]

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\Customer
  • The association App\Entity\Customer#exerciseQualifications refers to the owning side field App\Entity\ExerciseQualification#customer_id which does not exist.
App\Entity\Country No errors.
App\Entity\Season No errors.
App\Entity\TypeSoccer No errors.
App\Entity\Tactic No errors.
App\Entity\Team
  • The association App\Entity\Team#typeSoccer refers to the inverse side field App\Entity\TypeSoccer#teams which does not exist.
App\Entity\SeasonPlayer
  • The association App\Entity\SeasonPlayer#minutes refers to the owning side field App\Entity\Minutes#player_id which does not exist.
  • The association App\Entity\SeasonPlayer#playerWeights refers to the owning side field App\Entity\PlayerWeight#season_player_id which does not exist.
  • The mappings App\Entity\SeasonPlayer#captainInGames and App\Entity\GameAlignment#seasonplayer are inconsistent with each other.
App\Entity\Game
  • The association App\Entity\Game#minutes refers to the owning side field App\Entity\Minutes#game_id which does not exist.
  • The mappings App\Entity\Game#rival_alignment and App\Entity\GameAlignment#game are inconsistent with each other.
  • The mappings App\Entity\Game#seasonplayer and App\Entity\GamePlayerStatistics#game are inconsistent with each other.
App\Entity\TrainingAsist No errors.
App\Entity\ExerciseCalendar
  • The association App\Entity\ExerciseCalendar#exerciseUser refers to the inverse side field App\Entity\ExerciseUser#exerciseCalendar which does not exist.
App\Entity\PlayerJustification No errors.
App\Entity\Suggestion No errors.
App\Entity\CouponCustomer No errors.
App\Entity\Notification No errors.
App\Entity\ExerciseQualification
  • The association App\Entity\ExerciseQualification#exercise refers to the inverse side field App\Entity\Exercise#qualifications which does not exist.
  • The association App\Entity\ExerciseQualification#customer refers to the inverse side field App\Entity\Customer#exerciseQualification which does not exist.
  • The association App\Entity\ExerciseQualification#exercises refers to the owning side field App\Entity\Exercise#qualifications which does not exist.
App\Entity\Strategy No errors.