Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

144.04 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	55.76 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og"] View formatted query View runnable query Explain query SELECT * FROM customer_device WHERE :token LIKE CONCAT(token, '%') AND `status` = 0 SELECT * FROM customer_device WHERE 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	88.28 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og"] View formatted query View runnable query Explain query DELETE FROM customer_device WHERE :token LIKE CONCAT(token, '%') AND `status` = 0; DELETE FROM customer_device WHERE 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

55.76 ms

SELECT
        *
        FROM
        customer_device
        WHERE
            :token LIKE CONCAT(token,'%') AND
            `status` = 0

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og"
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  customer_device
WHERE
  :token LIKE CONCAT(token, '%')
  AND `status` = 0

SELECT
        *
        FROM
        customer_device
        WHERE
            'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

88.28 ms

DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ;

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og"
]

View formatted query View runnable query Explain query

DELETE FROM
  customer_device
WHERE
  :token LIKE CONCAT(token, '%')
  AND `status` = 0;

DELETE FROM customer_device WHERE 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzk0NzUyNzQsImV4cCI6MTczOTQ3ODg3NCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.aMkqDVvpPQSTaDv1r51g6ouwVxeHDQboYHlP-QMbh1LpwXe1Hxla23tvn69fvgMNR7FUANGrY4vT5cpJkUC-0Oob-eteg3PrQrVuvgmPhX9sbCTOukJk6VHqJrLZdnP8DSLY3bZkptoI1aHmJp9uU9OWIFEZBK6pwTaMMthigtRzQjESZITk6CZfpKYZEyGXpJqmy87kBe0zMYLOkMH7BsIGo2VvHLFGGFVH2mdgQP40EK3dpIO8-dFm-fwRqiBkTL2O-PtBIToW88ZBS6IrffvhiYzmo2X9Ba7IU26yq8bUWphgebu92_qWQ4D97Z5eWvSQP1qOOZoSKeSGy_3JlSStGU24QXLssIsfyUUQSHK7kzIYYBGg0VEg8ac9k3UKenVkUd6Opv42cT67Ys16d8zGIzL3HLljvE1_9CqfkqO5G0Kq_xMWs46FMZogR00OFoa4sD3xmovndZNRI_JcWvwsWEdgsc9hj1xkcMrHiTM2gpdOuMFtvUQdoLNeoM6UmzHlLsGx4oSD85jHEFb2LJnWcY-h2Y91OQKXxJBeO5Sh0kGtkwP5fpqBckyS5VFfBy5dlT7fTGdUXwi_tRqzAu-8ZpsP2h6nVgkZ7U5mSr5cm7h3cJtOnFAccDgO6u4WGFUZC4ROpVsDJjoacb3MbJ5REEKvfjcS6KXQ5I-R_Og' LIKE CONCAT(token,'%') AND `status` = 0 ;;

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

No loaded entities.

Symfony Profiler

https://prod.golmanagerpanel.com/api/es/customer/device/list?isIos=false&p=api%2Fes%2Fcustomer%2Fdevice%2Flist&version_app=5.0.2

Configuration Settings

Theme