Query Metrics
10
Database Queries
10
Different statements
41.31 ms
Query time
8
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 30.66 ms |
SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0
Parameters:
[ "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzA4MzIzOTYsImV4cCI6MTczMDgzNTk5Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImRhbnkubGxhbmVzQGljbG91ZC5jb20ifQ.p4xjNpDsfBRDu3HLgSVi2UI3RyHomp-7o-dUrnKEqDauhaxFWpiafG_2dPf5xH_itHROAc-wDHmExYc7ghiNzg8OXdUYIqWxa8GlVM34kYpV7zGblE-TumoxxQc42CeJn1WS2h9r3pfj9Yywa-iEfVuc7eErOyKqPjdBOTXEB_rsZOWYqtBl_Ldt_klcdlVlwbNaAiJuDPR8lFNL37bSD3U6BDgLUhv5eLf7lt0u8I6BHiGpZduMtIbTlAOi03fB-nwcM0FjuxBfJjBrxmdo6jUZ5QSkYgq7IAdezVmv8GqkLvTh0WRVpXWP_lDZsVP1R5p7WgXC6vD-2cW1PUyzyvcPaI_mddarwMPWotD-pgpuXLp1_17hGNesydo1ocHYnVxsOdjj2TceH4Fap4UiVnxYuh_MnoPGjtZFdOxjAFPxj1kuQmzkAUYr1q_obZMA-tvwoUBLd4LFuj7PBiY_rbaoAciQ3OueVXhBakULDR3sW4nMp6bm6Fg1ufzWkjM8San0ddqSFr7MRrfXnFk_X97St5dLopMnryhbie-lLjb8G1ezmynuHT0Z0aT-oXWR8pTSDGUcS9lX2OTg4GgLfDbD18HSfztxvm9r7kZe0h8yug5CHFnyLGaVBKmowkvKk3sR30YSRaOtIParV3Mvj5pPmcwJeeEeCNXNPj5EMc4" ] |
2 | 2.36 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:
[
"dany.llanes@icloud.com"
]
|
3 | 1.92 ms |
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:
[
26554
]
|
4 | 1.08 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM locality t0 WHERE t0.id = ?
Parameters:
[
2
]
|
5 | 1.00 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM competition t0 WHERE t0.id = ?
Parameters:
[
1
]
|
6 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
7 | 2.11 ms |
INSERT INTO game (rival, DAY, date, goals, rival_goals, image, updated_at, shots_goal, shots_opponent, corners_favor, corners_against, penalties_favor, penalties_against, fouls_favor, fouls_against, time_match, category, total_shots, total_shots_against, yellow_cards, yellow_cards_against, red_cards, red_cards_against, current_position_league, opponent_current_position_league, deleted_at, season_id, locality_id, competition_id, alignment_id, rival_alignment_id, pressure_rival_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "RAYADOS GUADALUPE" 2 => 1 3 => "2024-08-31 10:00:00" 4 => 0 5 => 4 6 => null 7 => null 8 => 5 9 => 15 10 => 1 11 => 6 12 => 0 13 => 0 14 => 5 15 => 13 16 => 50 17 => 11 18 => 2 19 => 9 20 => null 21 => null 22 => null 23 => null 24 => 7 25 => null 26 => null 27 => 27829 28 => 2 29 => 1 30 => null 31 => null 32 => null ] |
8 | 0.28 ms |
"COMMIT"
Parameters:
[] |
9 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.translatable_id AS translatable_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM locality_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
10 | 0.74 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 competition_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
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\Team |
|
App\Entity\SeasonPlayer |
|
App\Entity\Game |
|
App\Entity\TrainingAsist | No errors. |
App\Entity\ExerciseCalendar |
|
App\Entity\PlayerJustification | No errors. |
App\Entity\Locality | No errors. |
App\Entity\LocalityTranslation | No errors. |
App\Entity\Competition | No errors. |
App\Entity\CompetitionTranslation | No errors. |
App\Entity\Minutes | No errors. |
App\Entity\KilometersTraveled | No errors. |
App\Entity\ShotsOnGoal | No errors. |
App\Entity\GamePlayerStatistics | No errors. |
App\Entity\GameAlignment |
|
App\Entity\Difficulty | No errors. |
App\Entity\Player |
|
App\Entity\Position | No errors. |
App\Entity\TypeSoccer | No errors. |
App\Entity\Tactic | No errors. |