Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

56.23 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	27.61 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI"] 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.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	28.62 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI"] 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.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

27.61 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI"
]

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.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

28.62 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI"
]

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.eyJpYXQiOjE3NDc3MTY2MjcsImV4cCI6MTc0NzcyMDIyNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InlhaXJyZWEyQGdtYWlsLmNvbSJ9.QTG256T8M0A2OMDf-E-cjXkOOknmoGXfnu4lYXQffBDxu3O2WGHPC5taTPZNkmxD1RPMD3fGOH7lOQH7WUi-yf0hjG-4MGf56DVGTdpyKF13kaExqtCBF18KPzJy37gawwhSE5lo2RRAtt6am7gdQPINOS09TnOBMEGYWTV8FQrGu9Np01I4_Emt6gZznroLn3N-jEkSdiMBdHAE4FdU5VEnhGZW8U7X6ogx35ljnJtMEmToS53-lzoaMDfWRa81LrQzxs4Lr-yIdihrc5-PsAdksMfLTV-ZWgV893jvIR0Z9rupK9150LlId5lQl9fy8IsGjht0GZtovcT8qEl5opHptYPcDGMOVa3KZs4pe7Da0BosBuWLby86epeU_dMkHXtSXHAvqmRyZkse-lF0pODX-F5hNqZR6uhDxjapFlSysfDbRlR0pHWc-vZo1r67XiU2cjXQbGBO5uX6szGzo9vxQVF-b5YVzDB1aav7qmexIQR_k9i5Rx2sHxbClSLRXurtEZteyGmkUnUtT8h_Z5HmwzDBDHii6_rZ4HIrB1_QAL0v1Rj1gJfp5RhjXr3z22El4daXJak0HBAwz59-8hksi4JOePIkjctun5akYzUxI-Wqh4GB0A7BC-iLLOKLOFnbcv21kkK_CXFukJYRlpWqoU1WTBfpSl5U6XqznTI' 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.5

Configuration Settings

Theme