Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

71.44 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	32.53 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY"] 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.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	38.91 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY"] 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.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

32.53 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY"
]

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.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

38.91 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY"
]

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.eyJpYXQiOjE3NDc5NDQ4MzcsImV4cCI6MTc0Nzk0ODQzNywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VPpMwATvLFsbxt7HWqbr84JOEEin2AbQS1IssUSS7E_4ebIDNDzAhX9GMm2U7d5eTGgegKuPkczme8lnaa3-vlejuvremlkqZBzJRKwhXbqwGjjczS3QGbTielk4ctVnNhlQpMMtzWpfz1UZ45OnuMUwF7GArzVSZ2TsNUf5H-FajCQE0d7vCZ36cWvC9QJqakukFtfNh5DHzJTtQwoiKX9-ojCuZ-dSkp5K9J13Vcl_QUQtujLaYxBmapWFYdd10bZgrFaLBN0s8t2PaxPJk3gAGVt61hawLYfA2cB1AuJ_42ImIpQ6aWq0ciaJ0tqPewIPsDPTSmt3Mn2AgSTL74SkDViG7FtcyG7LHa5b5PhyOrieRA60gWb_zwXozpuckgQ3QYXhUx_oCC6ACf7FMeamFzeNObC2qg11M88nqyl8hajSZ79IvuZ0eMzx0Fjhjt6fy44SRLtvMr6bxbIGtUITnZkuEBhXfMfVLpghh0_-Ld_EvfXxq9Y0o9UEFB7-QY_mMCdiEbQ_AFENgLd4d1GXHXTKL0XISSDgVdkxDBkdZ2Ysp2ED6_-zwoF64Bv3iGG0HJrraRvXcXgwZA7MaqaEpf8_5ySkDcCgE6v-dOvjpYTER6eX5XFRPV-FCViytk3LtZJgFlJOIPbkZnyCNADUG4I_FlBxHRY4uG9TAQY' 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