https://prod.golmanagerpanel.com/api/es/exercise/5405/shared?isIos=false&p=api%2Fes%2Fexercise%2F5405%2Fshared&version_app=4.0.8

Query Metrics

34 Database Queries
9 Different statements
164.91 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 51.57 ms
SELECT
        *
        FROM
        customer_device
        WHERE
            :token LIKE CONCAT(token,'%') AND
            `status` = 0
Parameters:
[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzYzNDYyODQsImV4cCI6MTczNjM0OTg4NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.A2fhQwkF65B8nn5XccbfhOF4VuFEVikQno33TQl7lQ3Da2KzGyywDBg3-kQEqrGkbNTaK6Dqpra4lzkRalv4vnvSk0ul-byLzUYCYDo0sUIAVPNpIZ5_Fxh0tlxfXjZL_In77UMjQKXpOfQhqUuH8lT4dFeYMRDsO7GhYqZen5a0q1gZ37oM2Zxu7y8INwCuMSMC45POa-P9h1e-VXLdOM3VTxpL9Sse69a1Dl8dMJglEUqxZ9WZ67fqABoCgjR92CzoXgbos8ZtD10SjaHyPOBHh_AM6JReCChAg4F_6rH7NVxbIXpu5e7mL84umQKEtFlL3Q10uo-_pgfTquijchg4pY9KEW-HdCu7A29KZBVkZZeCmYk1x7SWnuvfMJM_-oC_3I8pZN9V3qr3qPYSlMVtdZ9k8oG2ZQUnQ_8fO2dm5ucXUEtBqVW9C5386XfMFLPuwdDs-cDioAGKPw_b7Ok5U8Pf90mgzViVu1_Vd3GU9ACw0u20vi3QftqrfzyRFo7JKGI9IERPKQtzZ5KH-0ejw9kPrflIcuZ_sP58L6kSorHCSp_qLNx7NWlo_ZXqCBbTk2xmP0WHUs33heVi8G0thp3YzPMj_ZY68Uhq1LjqX8sy4dIs2k0sV_xfAnEG3cWXQ1xk1LYFpk8TmS-jC0M9TOavRnKFY0hVo2lxuYg"
]
2 4.56 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:
[
  "zinkdavid@hotmail.com"
]
3 2.05 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.id = ?
Parameters:
[
  "5405"
]
4 1.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "en"
]
5 4.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5405
]
6 0.57 ms
"START TRANSACTION"
Parameters:
[]
7 4.65 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3x2 and then centers"
  2 => """
    A pass is made from the baseline (green) and they pass to blue and they begin a 3 against 2 attack. Green attack the two small goals.\n
    \n
    """
  3 => 5405
  4 => "en"
]
8 3.90 ms
UPDATE exercise SET is_shared = ? WHERE id = ?
Parameters:
[
  1
  5405
]
9 3.92 ms
"COMMIT"
Parameters:
[]
10 3.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "es"
]
11 3.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "de"
]
12 4.29 ms
"START TRANSACTION"
Parameters:
[]
13 3.52 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3x2 und dann Mitten"
  2 => """
    Von der Grundlinie (Grün) aus wird ein Pass ausgeführt, der zu Blau passt und einen 3-gegen-2-Angriff auf die beiden kleinen Tore beginnt.\n
    \n
    """
  3 => 5405
  4 => "de"
]
14 3.65 ms
"COMMIT"
Parameters:
[]
15 3.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "it"
]
16 0.73 ms
"START TRANSACTION"
Parameters:
[]
17 2.25 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3x2 e poi centri"
  2 => """
    Viene effettuato un passaggio dalla linea di fondo (verde) e passano ai blu e iniziano un attacco 3 contro 2. I verdi attaccano le due porte piccole.\n
    \n
    """
  3 => 5405
  4 => "it"
]
18 0.55 ms
"COMMIT"
Parameters:
[]
19 3.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "fr"
]
20 3.67 ms
"START TRANSACTION"
Parameters:
[]
21 3.72 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3x2 puis centres"
  2 => """
    Une passe est faite depuis la ligne de fond (vert) et ils passent au bleu et ils commencent une attaque à 3 contre 2. Vert attaque les deux petits buts.\n
    \n
    """
  3 => 5405
  4 => "fr"
]
22 3.89 ms
"COMMIT"
Parameters:
[]
23 3.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "pt"
]
24 2.84 ms
"START TRANSACTION"
Parameters:
[]
25 0.95 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3x2 e depois centraliza"
  2 => """
    É feito um passe da linha de base (verde) e eles passam para o azul e iniciam um ataque 3 contra 2 dos Verdes aos dois pequenos gols.\n
    \n
    """
  3 => 5405
  4 => "pt"
]
26 4.32 ms
"COMMIT"
Parameters:
[]
27 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "ru"
]
28 5.13 ms
"START TRANSACTION"
Parameters:
[]
29 9.46 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3х2, а затем по центру"
  2 => """
    Пас делается от базовой линии (зеленой), они передают пас синему и начинают атаку 3 против 2. Зеленые атакуют две маленькие цели.\n
    \n
    """
  3 => 5405
  4 => "ru"
]
30 2.75 ms
"COMMIT"
Parameters:
[]
31 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.translatable_id AS translatable_id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM exercise_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5405
  "tr"
]
32 8.21 ms
"START TRANSACTION"
Parameters:
[]
33 1.50 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "3x2 ve ardından merkezler"
  2 => """
    Taban çizgisinden (yeşil) bir pas yapılır ve maviye pas verilir ve Green iki küçük kaleye 3'e 2 atak başlatır.\n
    \n
    """
  3 => 5405
  4 => "tr"
]
34 5.95 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\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\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\Category No errors.
App\Entity\Material No errors.
App\Entity\NoteExercise 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\ExerciseTranslation No errors.