https://prod.golmanagerpanel.com/admin/?action=edit&entity=Exercise&id=5593&menuIndex=8&p=admin%2F&page=1&referer=%252Fadmin%252F%253Fp%253Dadmin%252F%2526entity%253DExercise%2526action%253Dlist%2526menuIndex%253D8%2526submenuIndex%253D0%2526sortField%253Did%2526sortDirection%253DDESC%2526page%253D1&sortDirection=DESC&sortField=id&submenuIndex=0 Return to referer URL

Query Metrics

17 Database Queries
10 Different statements
8.85 ms Query time
8 Invalid entities

Queries

Group similar statements

# Time Info
1 1.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.85 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:
[
  "5593"
]
3 0.93 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:
[
  5593
]
4 0.83 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 WHERE t0.id = ?
Parameters:
[
  5
]
5 1.09 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3 FROM material t0 INNER JOIN exercise_material ON t0.id = exercise_material.material_id WHERE exercise_material.exercise_id = ?
Parameters:
[
  5593
]
6 0.58 ms
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.is_visible AS is_visible_2, c0_.updated_at AS updated_at_3 FROM category c0_ WHERE c0_.id IN (?)
Parameters:
[
  [
    "5"
  ]
]
7 0.41 ms
SELECT m0_.id AS id_0, m0_.image AS image_1, m0_.updated_at AS updated_at_2 FROM material m0_ WHERE m0_.id IN (?)
Parameters:
[
  [
    "5"
    "6"
  ]
]
8 0.37 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:
[
  5593
]
9 0.20 ms
"START TRANSACTION"
Parameters:
[]
10 0.47 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Posição 2 equipas + wild cards e golo"
  2 => """
    A tarefa é realizada com 2 equipas, limitando o número de jogadores que temos.\r\n
    \r\n
    Violeta: Apoiam sempre o portador da bola e estão fora dos wild cards. Quando a equipa defensora recupera e ataca o grande golo, não participam.\r\n
    \r\n
    Verdes: São a equipa defensora, os verdes ou os azuis iniciam sempre o jogo e têm de recuperar a bola e tentar marcar um golo na baliza grande.\r\n
    \r\n
    Vermelhos: A equipa começa sempre com a bola e deve mantê-la durante toda a tarefa. Quando a perdem, todos devem pressionar para não sofrer golos e recuperar a bola.\r\n
    \r\n
    A cada 5 minutos os papéis das equipas mudam.\r\n
    \r\n
    * Altere também os jogadores joker.
    """
  3 => 5593
  4 => "pt"
]
11 0.24 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Position 2 teams + wild cards and goal"
  2 => """
    The task is carried out by two teams, limiting the number of players available.\r\n
    \r\n
    Purple: They always support the ball holder and are outside the wildcards. When the defending team recovers the ball and attacks the large goal, they do not participate.\r\n
    \r\n
    Green: They are the defending team. The green or blue team always starts the game, and they must recover the ball and try to score a goal in the large goal.\r\n
    \r\n
    Red: The team always starts with the ball. During the task, they must have the ball. When they lose it, everyone presses to avoid conceding a goal and recover the ball.\r\n
    \r\n
    The team roles are changed every 5 minutes.\r\n
    \r\n
    * Change the wildcard players as well.
    """
  3 => 5593
  4 => "en"
]
12 0.30 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Position 2 Teams + Wild Cards und Tor"
  2 => """
    Die Aufgabe wird mit 2 Teams durchgeführt, wodurch die Anzahl der Spieler begrenzt ist.\r\n
    \r\n
    Violett: Sie unterstützen immer den Ballhalter und stehen außerhalb der Joker. Wenn die verteidigende Mannschaft sich erholt und das große Tor angreift, nimmt sie nicht teil.\r\n
    \r\n
    Grüne: Sie sind die verteidigende Mannschaft. Die Grünen oder die Blauen beginnen immer das Spiel und müssen den Ball zurückerobern und versuchen, ein Tor in das große Tor zu schießen.\r\n
    \r\n
    Rot: Die Mannschaft beginnt immer mit dem Ball und muss ihn für die Dauer der Aufgabe behalten. Wenn sie den Ball verlieren, müssen alle Druck machen, um ein Gegentor zu vermeiden und ihn zurückzuerobern.\r\n
    \r\n
    Alle 5 Minuten wechseln die Rollen der Teams.\r\n
    \r\n
    * Ändern Sie auch die Wildcard-Spieler.
    """
  3 => 5593
  4 => "de"
]
13 0.19 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Posizione 2 squadre + wild card e goal"
  2 => """
    Il compito viene svolto da 2 squadre, limitando il numero di giocatori a nostra disposizione.\r\n
    \r\n
    Viola: Sostengono sempre il portatore di palla e sono fuori dalle jolly. Quando la squadra in difesa si riprende e attacca la porta grande, non partecipa.\r\n
    \r\n
    Verdi: Sono la squadra in difesa, iniziano sempre la partita i verdi o i blu e devono recuperare palla e cercare di segnare un gol nella porta grande.\r\n
    \r\n
    Rossi: la squadra inizia sempre con la palla e deve mantenerla per tutta la durata della partita. Quando la perdono, tutti devono spingere per non subire gol e recuperare la palla.\r\n
    \r\n
    Ogni 5 minuti i ruoli delle squadre cambiano.\r\n
    \r\n
    * Cambia anche i giocatori jolly.
    """
  3 => 5593
  4 => "it"
]
14 0.18 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Équipes de position 2 + wild cards et but"
  2 => """
    La tâche est réalisée avec 2 équipes, en limitant le nombre de joueurs dont nous disposons.\r\n
    \r\n
    Violet : Ils soutiennent toujours le porteur du ballon et sont en dehors des wild cards. Lorsque l'équipe en défense récupère et attaque le grand but, elle ne participe pas.\r\n
    \r\n
    Les Verts : C'est l'équipe qui défend, les verts ou les bleus commencent toujours le jeu et ils doivent récupérer le ballon et essayer de marquer un but dans le grand but.\r\n
    \r\n
    Rouges : L'équipe commence toujours avec le ballon et doit l'avoir pendant toute la durée de la tâche. Lorsqu'ils le perdent, tout le monde doit pousser pour éviter d'encaisser un but et récupérer le ballon.\r\n
    \r\n
    Toutes les 5 minutes, les rôles des équipes changent.\r\n
    \r\n
    * Changez également les joueurs joker.
    """
  3 => 5593
  4 => "fr"
]
15 0.23 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Команды 2-й позиции + wild card и гол"
  2 => """
    Задание выполняется двумя командами, что ограничивает количество игроков.\r\n
    \r\n
    Фиолетовый: Они всегда поддерживают владельца мяча и не входят в число игроков-«джокеров». Когда защищающаяся команда восстанавливается и атакует большие ворота, они не участвуют.\r\n
    \r\n
    Зелёные: Это защищающаяся команда, «зелёные» или «синие» всегда начинают игру, и они должны вернуть мяч и попытаться забить гол в большие ворота.\r\n
    \r\n
    Красные: Команда всегда начинает с мячом, и она должна владеть мячом на протяжении всего задания. Если мяч пропадает, всем приходится прилагать усилия, чтобы не пропустить гол и вернуть его себе.\r\n
    \r\n
    Каждые 5 минут роли команд меняются.\r\n
    \r\n
    * Также измените игроков-джокеров.
    """
  3 => 5593
  4 => "ru"
]
16 0.16 ms
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "Pozisyon 2 takım + joker kartlar ve gol"
  2 => """
    Görev 2 takımla gerçekleştiriliyor, bu yüzden oyuncu sayımız sınırlı.\r\n
    \r\n
    Violet: Her zaman top tutanı desteklerler ve joker kartların dışındadırlar. Savunma yapan takım toparlanıp büyük kaleye hücum ettiğinde ise katılımda bulunmuyorlar.\r\n
    \r\n
    Yeşiller: Savunma yapan takımdır, yeşiller veya maviler her zaman oyuna başlar ve topu geri kazanıp büyük kaleye gol atmaya çalışırlar.\r\n
    \r\n
    Kırmızılar: Takım her zaman topla başlar ve görev süresince top onlarda olmalıdır. Kaybettikleri zaman ise herkesin gol yememek için baskı yapması ve topu geri kazanması gerekiyor.\r\n
    \r\n
    Her 5 dakikada bir takımların rolleri değişiyor.\r\n
    \r\n
    * Joker oyuncuları da değiştirilsin.
    """
  3 => 5593
  4 => "tr"
]
17 0.20 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\User No 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\AppModule
  • The association App\Entity\AppModule#supports refers to the owning side field App\Entity\Support#app_module which does not exist.
App\Entity\Support
  • The mappings App\Entity\Support#AppModule and App\Entity\AppModule#supports are inconsistent with each other.
  • The mappings App\Entity\Support#supportFilesTemplate and App\Entity\SupportFile#Support are inconsistent with each other.
App\Entity\Tactic No errors.
App\Entity\TypeNotification No errors.
App\Entity\TypeSoccer No errors.
App\Entity\Category No errors.
App\Entity\Collaborator No errors.
App\Entity\Competition No errors.
App\Entity\Config No errors.
App\Entity\Country No errors.
App\Entity\Coupon No errors.
App\Entity\CouponCustomer No errors.
App\Entity\Difficulty 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\JustificationType No errors.
App\Entity\Locality No errors.
App\Entity\Material No errors.
App\Entity\Membership No errors.
App\Entity\MembershipAttr No errors.
App\Entity\MembershipDesc No errors.
App\Entity\MembershipItems
  • The field App\Entity\MembershipItems#translatable_id is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Membership#membershipItems does not contain the required 'inversedBy="translatable_id"' attribute.
  • The association App\Entity\MembershipItems#membershipTranslation refers to the inverse side field App\Entity\MembershipTranslation#membership_id which does not exist.
App\Entity\Notification No errors.
App\Entity\NotificationAutomaticMessage No errors.
App\Entity\NotificationAutomaticTranslation No errors.
App\Entity\Position No errors.
App\Entity\Suggestion 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\AppModuleTranslation No errors.
App\Entity\TypeNotificationTranslation No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\CompetitionTranslation No errors.
App\Entity\DifficultyTranslation No errors.
App\Entity\ExerciseTranslation No errors.
App\Entity\JustificationTypeTranslation No errors.
App\Entity\LocalityTranslation No errors.
App\Entity\MaterialTranslation No errors.
App\Entity\MembershipTranslation No errors.
App\Entity\MembershipAttrTranslation No errors.
App\Entity\MembershipDescTranslation No errors.
App\Entity\NotificationTranslation No errors.
App\Entity\PositionTranslation 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\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\ExerciseUser No errors.