Query Metrics
27
Database Queries
13
Different statements
37.09 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
19.97 ms (0.00%) |
1 |
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" ] |
3.31 ms (0.00%) |
5 |
INSERT INTO exercise_material (exercise_id, material_id) VALUES (?, ?)
Parameters:
[ 5259 1 ] |
2.47 ms (0.00%) |
1 |
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:
[] |
2.24 ms (0.00%) |
5 |
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
]
|
2.06 ms (0.00%) |
5 |
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"
]
|
1.99 ms (0.00%) |
1 |
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 ] |
1.28 ms (0.00%) |
1 |
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"
]
|
0.97 ms (0.00%) |
1 |
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" ] |
0.79 ms (0.00%) |
1 |
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
]
|
0.65 ms (0.00%) |
1 |
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
]
|
0.56 ms (0.00%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.41 ms (0.00%) |
1 |
UPDATE exercise SET poster = ? WHERE id = ?
Parameters:
[ "Rndo movil.png" 5259 ] |
0.40 ms (0.00%) |
2 |
"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 |
|
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 |
|
App\Entity\Strategy | No errors. |
App\Entity\Category | No errors. |
App\Entity\Exercise |
|
App\Entity\CategoryTranslation | No errors. |
App\Entity\Team |
|
App\Entity\SeasonPlayer |
|
App\Entity\Game |
|
App\Entity\TrainingAsist | No errors. |
App\Entity\ExerciseCalendar |
|
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. |