https://prod.golmanagerpanel.com/api/es/exercise/add?isIos=true&p=api%2Fes%2Fexercise%2Fadd&version_app=4.0.8

Query Metrics

27 Database Queries
13 Different statements
37.09 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 19.97 ms
SELECT
        *
        FROM
        customer_device
        WHERE
            :token LIKE CONCAT(token,'%') AND
            `status` = 0
Parameters:
[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzA4OTg4MDAsImV4cCI6MTczMDkwMjQwMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFybWFuZG9xdWludGFzMTdAZ21haWwuY29tIn0.T_TQK5BVZpEDEUulsig5AYHAE03P-h2Vr-9zl4bW-4lZD7s6HRk_1V9BXhpew56KmUSVG0Gd1_n-pQjXeNP3zv8l6iS0z8kEGMppTWdwL2aQNIJ_3lZPjksISFtWm9OjL4xD_5gVnOqhyJrCC-LHsDEL5U5duH7wDU4nu9HQLd9eDyRzCuYpOx60XjNEIw82k1yZE4yi3FXh8HgpHR2fUtXTxhsLjfPdJRBeq4h-zRZ9a_4z3lwoccboZPCSe616yqo3ZGrF-vls-ep7SrhZLYZx0Wy9B9ncVH-qab0-WmvgE98ylz0GmYsD0VcIs5q4z6N08r9oAQxFZ62XMqqBuDI5U0IxTXLhybg6PhZbpPu6yz6dndRvDK78X0Ht6KWpj-IgaMbdjIzlePxzSb8vCTxdsGCKgzRTbsNNBtSrCB3S32-IV0D55GXHNV1XQ2_UV5M8VXxReGodtdX2TtNxq37RTrugGm9eEvLBXIzXyjXdLJ4syUjTFyT0e3FSlqCLBkziMCloKJ6Ah6tKFXYpChDEzw0VUsvOyg-l4WeSghjQCBwQVVDDXPl77XmBXIO3NZYLlpdiGchiCWTf9e3dmaVSsybxDNSrabCg4QkJSI3kqmfRzPrvjs8EDb6bsO-A1SrFiUr9b589QwMk-J04kv_tOTeMGeBYQjmhPB1BrB4"
]
2 1.28 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:
[
  "armandoquintas17@gmail.com"
]
3 2.47 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_visible AS is_visible_3, t0.updated_at AS updated_at_4 FROM category t0
Parameters:
[]
4 0.79 ms
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:
[
  26085
]
5 0.90 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3 FROM material t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
6 0.36 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3 FROM material t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
7 0.30 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3 FROM material t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
8 0.27 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3 FROM material t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
9 0.23 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3 FROM material t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
10 0.32 ms
"START TRANSACTION"
Parameters:
[]
11 1.99 ms
INSERT INTO exercise (image, updated_at, poster, dificulty, intensity, duration, customer_id, category_id, is_shared, deleted_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "Rndo movil.png"
  2 => "2024-11-06 06:25:21"
  3 => null
  4 => "MEDIUM"
  5 => "HIGH"
  6 => 0
  7 => 26085
  8 => 2
  9 => null
  10 => null
]
12 1.81 ms
INSERT INTO exercise_material (exercise_id, material_id) VALUES (?, ?)
Parameters:
[
  5259
  1
]
13 0.58 ms
INSERT INTO exercise_material (exercise_id, material_id) VALUES (?, ?)
Parameters:
[
  5259
  2
]
14 0.38 ms
INSERT INTO exercise_material (exercise_id, material_id) VALUES (?, ?)
Parameters:
[
  5259
  5
]
15 0.29 ms
INSERT INTO exercise_material (exercise_id, material_id) VALUES (?, ?)
Parameters:
[
  5259
  6
]
16 0.25 ms
INSERT INTO exercise_material (exercise_id, material_id) VALUES (?, ?)
Parameters:
[
  5259
  9
]
17 0.21 ms
"COMMIT"
Parameters:
[]
18 0.65 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.poster AS poster_4, t0.dificulty AS dificulty_5, t0.intensity AS intensity_6, t0.duration AS duration_7, t0.customer_id AS customer_id_8, t0.category_id AS category_id_9, t0.is_shared AS is_shared_10, t0.deleted_at AS deleted_at_11, t0.category_id AS category_id_12 FROM exercise t0 WHERE t0.customer_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  26085
]
19 0.25 ms
"START TRANSACTION"
Parameters:
[]
20 0.97 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Rndo movil "
  2 => """
    se haran tres grupos de 4. Por tiempo cada grupo realizara la tarea de presion y los otros dos estarán en los rondos. \n
    El ejercicio consta de por parejas , salen a la vez y realizan el zigzag para posteriormente salir cada miembro de la pareja a sprint a robar al rondo. Tras robar tendran que volver para meter el balon en una mini porteria. El que primero mets el balon en la miniporteria tendra opcion de recibir un balon en el area y rematarlo. \n
    Es una competencia entre los miembros del grupo.
    """
  3 => 5259
  4 => "es"
]
21 0.41 ms
UPDATE exercise SET poster = ? WHERE id = ?
Parameters:
[
  "Rndo movil.png"
  5259
]
22 0.19 ms
"COMMIT"
Parameters:
[]
23 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
24 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
25 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
26 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
27 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]

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\Category No errors.
App\Entity\Exercise
  • The field App\Entity\Exercise#notes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NoteExercise#exercise does not contain the required 'inversedBy="notes"' attribute.
  • The mappings App\Entity\Exercise#exerciseQualifications and App\Entity\ExerciseQualification#exercise are inconsistent with each other.
App\Entity\CategoryTranslation 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\Material No errors.
App\Entity\ExerciseUser No errors.
App\Entity\MaterialTranslation No errors.
App\Entity\NoteExercise No errors.
App\Entity\ExerciseTranslation No errors.