Query Metrics
3
Database Queries
3
Different statements
24.23 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 21.92 ms |
SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0
Parameters:
[ "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc0MTE3NTIsImV4cCI6MTc0NzQxNTM1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.ddxNxnWEsqIloPYqt3vrHXVCnY83ewLZTbHg9pJqqn6Qq285cMAZObmH4L7IfTX-uPTzxd4HklEgy52-YbrOAaQ6KQ4xZWiMTJ0BW1620fUlI_rZj3Q8-v8g5-tasljk_xm_PaNK4fR_PQIqbRzPSd8u7SftzCrsD3fZvuLMr3YQ460bYuIaP96-dTuuCmlbp-Ok4SPYRYNq2GwSE3sWzpCS5Zl5PzI7UC6kqDX7j46K0BRy4Ux1tI1lnP6RoPnIhscGRQPArStpcG3MPEE-32gnEznrCPh7oqAhoDIJRRe-MD8BSM0ztBT0H8lxLJsDiluBgqAEeiDL08uNJ7ktR8uN7e1g0GKXm69MkZher9PA5F2E8ImHpy5HpDkKhP-f76hwzI01XTfxBwY746MZqR3vdLGzYHePcmz9JNCE_6-mPQ7ueXfbyicQ6uPotj3vEgaHOfBZFu4UEGC-sn6JK9Hfqq__RJ8oJs1Dm4qwN2cooSFT19evE4fGbB8oBPkg5mW2F2Tlalh_QaSsNKY6XPlOfIeT4LdGMQkBFBB4epuLcMl12XCNy4Mc0akBefUGifDy-YT06pHbHYm9WXyIPYsBIxD0c4SOq-EHky57-4tFlviw13qyaqNUbMb2pHK6vX-xtkMNXB8SB4Oxlf5Cf7ywWziIj69kfBO5keX9oV0" ] |
2 | 0.97 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:
[
"yairrea2@gmail.com"
]
|
3 | 1.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.image AS image_7, t0.customer_id AS customer_id_8 FROM strategy t0 WHERE t0.customer_id = ?
Parameters:
[
27173
]
|
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. |