Symfony Profiler

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 = ?

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 = 3;

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 = ?

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 = '5402';

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 = ?

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 = 5402;

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 = ?

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 = 5;

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 = ?

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 = 5402;

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 (?)

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 ('5');

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 (?)

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 ('5', '6');

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 = ?

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 = 5402;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO exercise_translation (
  name, description, translatable_id,
  locale
)
VALUES
  (?, ?, ?, ?)

INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES ('4 zonas joker (Posse)', 'A tarefa é realizada num quadrado dividido em 4 zonas, em cada zona existirá 1 joker. (Tamanho a adaptar consoante o número de jogadores).

O resto dos jogadores (2 equipas) deslocam-se livremente pela praça.


- A superioridade é conseguida pela equipa que tem a posse de bola em cada zona com esse joker.
- A equipa defensora, ao recuperar a bola, passa a jogar com superioridade numérica e pode jogar com todos os jokers; Ele tem de possuir a bola aproveitando os jokers.
- Pode ser adicionada limitação de toques por jogador.', 5402, 'pt');

INSERT INTO exercise_translation (
  name, description, translatable_id,
  locale
)
VALUES
  (?, ?, ?, ?)

INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES ('4 wildcard zones (Possession)', 'The task is carried out in a square divided into 4 zones, in each zone there will be 1 wild card. (Size to be adjusted according to the number of players).

The rest of the players (2 teams) move freely around the square.

- The team that has possession of the ball in each zone with that wild card is superior.
- The defending team, when it recovers the ball, plays in numerical superiority and can play with all the wild cards; it has to take possession of the ball using the wild cards.
- A limit of touches per player can be added.', 5402, 'en');

INSERT INTO exercise_translation (
  name, description, translatable_id,
  locale
)
VALUES
  (?, ?, ?, ?)

INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES ('4 Wildcard-Zonen (Besitz)', 'Die Aufgabe wird in einem Quadrat ausgeführt, das in 4 Zonen unterteilt ist. In jeder Zone gibt es 1 Platzhalter. (Größe muss je nach Spieleranzahl angepasst werden).

Die restlichen Spieler (2 Teams) bewegen sich frei auf dem Platz.


- Die Überlegenheit wird von der Mannschaft erreicht, die in jeder Zone mit dieser Wildcard Ballbesitz hat.
- Die verteidigende Mannschaft beginnt, wenn sie den Ball zurückerobert, mit zahlenmäßiger Überlegenheit zu spielen und kann mit allen Wild Cards spielen; Er muss den Ball besitzen und die Wildcards ausnutzen.
- Eine Begrenzung der Berührungen pro Spieler kann hinzugefügt werden.', 5402, 'de');

UPDATE
  exercise_translation
SET
  description = ?
WHERE
  id = ?

UPDATE exercise_translation SET description = 'Se realiza la tarea en un cuadrado dividido en 4 zonas, en cada zona habrá 1 comodín. ( Tamaño a adecuar según el numero de jugadores).

El resto de jugadores ( 2 equipos) se mueven libre por el cuadrado.


- Se realiza superioridad el equipo que dispone de la posesión de balón en cada zona con ese comodín.
- El equipo que defiende, cuando recupera el balón, pasa a jugar en superioridad numérica pudiendo jugar con todos los comodines; tiene que realizar la posesión de balón aprovechando los comodines.
- Se puede añadir limitación de toques por jugador.' WHERE id = 8255;

"COMMIT"

"COMMIT";