https://prod.golmanagerpanel.com/api/es/game/edit/35828?isIos=true&p=api%2Fes%2Fgame%2Fedit%2F35828&version_app=4.0.6

Query Metrics

8 Database Queries
8 Different statements
26.48 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.54 ms
(0.00%)
1
SELECT
        *
        FROM
        customer_device
        WHERE
            :token LIKE CONCAT(token,'%') AND
            `status` = 0
Parameters:
[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4NTI4MTUsImV4cCI6MTcyNjg1NjQxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNlbGFkYXllaXNvbkBnbWFpbC5jb20ifQ.ivMRhUguLvvUv9BPaRVWfxM5bGRgUFqXawCvgHv7vo9VpHfR6NBmZbDA9qYUMpO4ELo5uePLoU2ZQJIvShMJdIV5orqju3vhmlEPY2mxsM_TAnKQU5241pisWNE9v1Q42CEj2vA-uRc8gFCwIBAt1T7ULtLdtUqaeyPFQO2g8OOL-djPMzrWYpzO7t89CWPv0YJlOveDtJUWYMbRGk0SPdOX5_okzY603BRDSKu1E9rFhMYki3EhbwWr6ajTN5smUITt22PEe1igm2xdhvBqMnV5QsjZADxH5-1CLG-gnhjP4H4WrwFmQf-iUrdTbJ2jvXweAQFOgBPpGLSJ-096VoYdk4ehHtJvx1cVuomixwo1d4mhAg2eDWeXzqbFlsxrpYoXtjVFf3g4oODwyy4UTgBExdo_nwgn22T5y4Toa-hHhq5j7cdWGFuZulFsM2CFiq7pimqDJk3jF0ij94iuOUdXydr2S_uk1fdezsguXkAh8NWXJHzgHjhpr5wR58cl_FocXHpTn2zAQ4QAwj4iwnUO7vR5fAjlT5mBAfnxaBoVUwO90nJ-m-To7kBJxngRzZbbqYJ2iB2VsdmzAsKBtusKBfrqYxnv6e0qX-VA9s2D43soCrmcuW3SadqrWk_xfiCRs6AzBgT4Wg8aXCpO8VCyApBQ3ArfPprL4vvED08"
]
1.67 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.rival AS rival_2, t0.day AS day_3, t0.date AS date_4, t0.goals AS goals_5, t0.rival_goals AS rival_goals_6, t0.image AS image_7, t0.updated_at AS updated_at_8, t0.shots_goal AS shots_goal_9, t0.shots_opponent AS shots_opponent_10, t0.corners_favor AS corners_favor_11, t0.corners_against AS corners_against_12, t0.penalties_favor AS penalties_favor_13, t0.penalties_against AS penalties_against_14, t0.fouls_favor AS fouls_favor_15, t0.fouls_against AS fouls_against_16, t0.time_match AS time_match_17, t0.category AS category_18, t0.total_shots AS total_shots_19, t0.total_shots_against AS total_shots_against_20, t0.yellow_cards AS yellow_cards_21, t0.yellow_cards_against AS yellow_cards_against_22, t0.red_cards AS red_cards_23, t0.red_cards_against AS red_cards_against_24, t0.current_position_league AS current_position_league_25, t0.opponent_current_position_league AS opponent_current_position_league_26, t0.deleted_at AS deleted_at_27, t0.season_id AS season_id_28, t0.locality_id AS locality_id_29, t30.id AS id_31, t30.game_id AS game_id_32, t0.competition_id AS competition_id_33, t0.alignment_id AS alignment_id_34, t0.rival_alignment_id AS rival_alignment_id_35, t0.pressure_rival_id AS pressure_rival_id_36 FROM game t0 LEFT JOIN convocatoria t30 ON t30.game_id = t0.id WHERE t0.season_id = ? AND t0.id = ? LIMIT 1
Parameters:
[
  25750
  "35828"
]
1.36 ms
(0.00%)
1
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:
[
  "celadayeison@gmail.com"
]
0.96 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.year AS year_2, t0.is_active AS is_active_3, t0.team_id AS team_id_4, t0.customer_id AS customer_id_5, t0.country_id AS country_id_6 FROM season t0 WHERE t0.customer_id = ?
Parameters:
[
  21230
]
0.80 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM difficulty t0 WHERE t0.id = ?
Parameters:
[
  0
]
0.67 ms
(0.00%)
1
UPDATE game SET DAY = ?, date = ?, opponent_current_position_league = ? WHERE id = ?
Parameters:
[
  14
  "2024-09-15 10:00:00"
  0
  35828
]
0.24 ms
(0.00%)
1
"COMMIT"
Parameters:
[]
0.23 ms
(0.00%)
1
"START TRANSACTION"
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\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.
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.
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\Locality No errors.
App\Entity\Convocatoria
  • The association App\Entity\Convocatoria#players refers to the owning side field App\Entity\ConvocatoriaPlayer#convocatoria which does not exist.
App\Entity\Competition No errors.
App\Entity\GameAlignment No errors.
App\Entity\Difficulty No errors.
App\Entity\Minutes No errors.
App\Entity\KilometersTraveled No errors.
App\Entity\ShotsOnGoal No errors.
App\Entity\GamePlayerStatistics No errors.
App\Entity\TypeSoccer No errors.
App\Entity\Tactic No errors.