Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

91.09 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
61.26 ms (0.00%)	1	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM"] 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.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM' LIKE CONCAT(token,'%') AND `status` = 0 ;;
29.83 ms (0.00%)	1	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM"] 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.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM' LIKE CONCAT(token,'%') AND `status` = 0 ;

Time▼

Count

Info

61.26 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM"
]

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.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM' LIKE CONCAT(token,'%') AND `status` = 0 ;;

29.83 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM"
]

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.eyJpYXQiOjE3Mjc3OTc2MzksImV4cCI6MTcyNzgwMTIzOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im5pY29tYXN0aWVyaUBnbWFpbC5jb20ifQ.WgoUOePZIY91h4jLwIYIyOiivfxsOuk-TXvWb-_ORSXmnb698pselhWpVnv0xzG1HHLDTy52AS56mNPxe4x4HA6wE_8pO6CwQLKe-T2ewKJZI7ih67L0gwbW2xFGILIxbqsqrwlmVsK--681dCluA6P5fI0w6i8kdPBP2pEvLVoJZGSfQv2ak-VQ4rEbgFHHfi3GjnhwGGZaMvno21lLh5UDiTNhf-nJjoAuBrJk4iu89Y_YThTh52oYxiYVM0pvoPJhitHDdPxGpmADKBj7wmO5xSd06ff6_2FrJYMZ7u3DGDKwa112AA_cLzA4ucPYnb-fWCmvjhrUR8tbEfpJ3TSW-ENP-WWPNrWwonZcpS3XoD_0uauUySnNq8dRwExSqjh77CnnEi2slBJvXB4lGzFpiHgzJiUUlsY0LD1wgycsl94kVGYSlHGtEczC96nYeEdla_-5zmwTkB0fI2gP1JZZUD43MYQx2aijEPUdvv9Lajbx2RNJrLc_ReCXnflU47Yq9nzhr9TJDfGg5wuBd9LiOyM9z6Dbq8cLykknfJhL3GWPmQiPEMBzj2lO6mSIvGhbyv54eTZf8fNuecw7qUSPbrOwT3BH6NhruPWIKfatx9QYUClnVoSCXmv_l34DWhmADRNY19kyt4KTGhr8BHjeNhUN0HZpFkdm0X4YnGM' 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/user_data?p=api%2Fes%2Fuser_data Return to referer URL

Configuration Settings

Theme