Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

159.35 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	34.18 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4"] 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.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	125.17 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4"] 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.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

34.18 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4"
]

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.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

125.17 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4"
]

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.eyJpYXQiOjE3MzE5NTE4ODgsImV4cCI6MTczMTk1NTQ4OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFseHBpcG9AZ21haWwuY29tIn0.gTxPJMuxoQkRvXwRgvlhIYfUcwinZwHmBFMKjCu0G1Wgcnvz9DyI31qL38Xv0_UGtVlsZgbo1its8iPNWm14xqUOJQpGTxtUrtm1QrdJzMY4S6iHw7qapW2fbhbx_gtbDMfOKYnkxILIqyPfpGyzb__URJe9ULFO2Mm9kgrVF59f1hdDXyjfzKJVhO4AwLovf0Y-bPiT00rgAtzo2NrGEayg-53szfbL0qB0Gt0bsE3N0fxbv0Ol35SSp5alcJ93YXyliDxhMc51tQYQKtnyviPsslKVaOCELvbX__eJJxP3Q6WHpxdZJRJfbvjPlNuXKpgngK7DJ1RDcHDqrwht1BauiVZ2Nimb23E1RhZvhs9tq8lypinsGlLM64gU8Izpq7h_sJi9bVruZbK6_iD1MERpv5B8rE66JxIEEHiI997tzmrByHuAhJpKMGtxFUYMXMYvcHCF9iglvzYJmFNyeNY4JgC9KdftC9x3O9muNZt2I3jdDICcv3JCeVdNZ84gouRtDTzBvsR1qMM-Om2zTFIaYQKJh1KJDyNEIrWSGQhTw9Xqnyu9euWW6zPH27QlL8CfhrFjWecujvsWimrLnGrwsiZ5jlOADdb4UQKryeVOoyal0jT1CK2LDbDyqE-BnL3yeTtKOYKL5EMCHOWzx2gA0ktEbiONM_0vDVe7XR4' 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/competition/list?isIos=false&p=api%2Fes%2Fcompetition%2Flist&version_app=4.0.8

Configuration Settings

Theme