Query Metrics
14
Database Queries
11
Different statements
35.25 ms
Query time
8
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 7.55 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 | 3.23 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:
[
"5401"
]
|
3 | 3.43 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:
[
5401
]
|
4 | 3.23 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 | 2.97 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:
[
5401
]
|
6 | 4.19 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 | 1.22 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" "9" ] ] |
8 | 0.80 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:
[
5401
]
|
9 | 0.66 ms |
"START TRANSACTION"
Parameters:
[] |
10 | 2.75 ms |
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "Golo (golo pequeno) ataca ambos os golos." 2 => """ É disputado um jogo de posição de bola onde ao marcar um golo em qualquer um dos 4 golos pequenos (escantos), o treinador (Rosa) ou um joker apresenta a bola à equipa que marcou o golo e atacam os dois golos grandes.\r\n \r\n A equipa adversária deve tentar evitar marcar golos enquanto não tiver a posse de bola, e tentar mudar o papel na hora de recuperar a bola. """ 3 => 5401 4 => "pt" ] |
11 | 1.64 ms |
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "Goal (small goal) attack both goals." 2 => """ A ball position game is played where, when a goal is scored in any of the 4 small goals (corners), the coach (Rosa) or a wildcard passes the ball to the team that scored the goal and they attack both large goals.\r\n \r\n The opposing team must try to prevent the goal from being scored in the goals while they do not have possession of the ball, and try to change roles when they recover the ball. """ 3 => 5401 4 => "en" ] |
12 | 1.45 ms |
INSERT INTO exercise_translation (name, description, translatable_id, locale) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "Tor (kleines Tor) beide Tore angreifen." 2 => """ Es wird ein Ballpositionsspiel gespielt, bei dem beim Erzielen eines Tores in einem der vier kleinen Tore (Ecken) der Trainer (Rosa) oder ein Joker den Ball der Mannschaft zuspielt, die das Tor geschossen hat, und diese beide großen Tore angreift.\r\n \r\n Die gegnerische Mannschaft muss versuchen, ein Tor zu vermeiden, solange sie nicht im Ballbesitz ist, und muss versuchen, die Rolle bei der Balleroberung zu ändern. """ 3 => 5401 4 => "de" ] |
13 | 1.48 ms |
UPDATE exercise_translation SET description = ? WHERE id = ?
Parameters:
[ """ Se realiza un juego de posición de balón donde al realizar gol en cualquiera de las 4 porterías pequeñas ( esquinas), el entrenador (Rosa) o un comodín introduce balón al equipo que realizo el gol y atacan ambas porterías grandes.\r\n \r\n El equipo contrario debe intentar evitar el gol en las porterías mientras no tiene la posesión de balón, e intentar cambiar el rol al recuperar la pelota. """ 8251 ] |
14 | 0.65 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 |
|
App\Entity\AppModule |
|
App\Entity\Support |
|
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 |
|
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 |
|
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 |
|
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 |
|
App\Entity\ExerciseQualification |
|
App\Entity\ExerciseUser | No errors. |