Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

81.40 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	34.34 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk"] 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.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	47.06 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk"] 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.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

34.34 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk"
]

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.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

47.06 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk"
]

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.eyJpYXQiOjE3NDk5MzM4MTAsImV4cCI6MTc0OTkzNzQxMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxpbG9kakBob3RtYWlsLmNvbSJ9.iso4YI63eUkSyagezs5D9epB6flFqHqPqB8796YUh9cxUFi2X5jdRNwMIuX-DTiwXZi7F_F-ZP-wMCqhUwqbBXZ3vVaCzCsuYMH2NJhUsVpSRiAJo4_tcaIsnGq5afV8EuZg4Trcd_ZUwKwmHxbGddORgIX9CCrmBbsuuTtJdspQAARwvxWZAOU7HMtbi89RlecQSGkkBYCbMQL53WP6vANAr-AVB7LWOwHZqST5VrEVV2EP4mgWCN_rutvpjUpFEqL_85nXePA-mjoRKWuhbdNKHIE5ep0PGmLmz6eqmgi8EJ5VZjTOPaipJx6Os6IU9r5UmNWeLiWOSR2EiiS4fRr9ZY0yW4hRwoNtGTcx-2DqeLI2DLVg7YeJEwwDw3rdS6DGXgVFE_qIi4ShE8OdbonjWYIVsVvk4H6tjiMgKFJ6j8-A2viCHTSRk_xMNdfViP1Ab835oTxv3fDIOhRJJmuM-tPNkmEHmV1s6ilezaG15q_hOIVol6ks3Cx-U58w7zHsFoQ2H27OIsiPcnhGFoLPlNBEIZVAZ4OkOfdlHGSaRKv-4df9q-7njtQafdz6rFAERYQek0wNV9cGaU_dmKbuOq8nuTPxZyyT9x1rj0pvjDdI0eh_VV2n5T0tHwEcmhfVNPCAKC90F0ldoZBRzyeopy6jvwHb4DL5m49Lysk' 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