Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

113.34 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	49.23 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ"] 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.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	64.11 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ"] 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.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

49.23 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ"
]

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.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

64.11 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ"
]

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.eyJpYXQiOjE3MzE5NTc2NjksImV4cCI6MTczMTk2MTI2OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InppbmtkYXZpZEBob3RtYWlsLmNvbSJ9.nlkfXIdZPGwLk8TFKRCdUqx4FD_Uqeeve1qrdWpKmDIuTYxCOasOEVuC89xCqv0Fp960ABlHXPRKE2wpfn5P2H4StWCfV5GD75iz5R5zlkai44ZqdIpAZp7b2LM678htw2mSW9EyrvLpMG2ek6S2U-wyJEiI1I63XIbOby08S8oburNbfreUUoKc-63c3UwLfypw-ESUPvIjy573JhKxo7C0KeAUg12SEEUM2wKYJVESQtXQdbsaIwIuky6Dbf1Mox-2kK5P1k-Ww12FUNyCBYoVH6U8eYggEsPY711bGjdfSsBvcKWuhfZwbcj8vXVqWZ0_wQ9POktq5q3o95t8lStqdY6gmrWNhTzZCJBmHn4nhr10kSIcJYONNY6Ec2cVh-cM3hnQUjktMjKaiRsHQLSPHmDg-O8bzJmScerF_LuFX9SJcLzntNnEYGvGaMrMtfW69dsM5P9IdGbNwg2IxslVzVesBsVXNcywVA54X1pcmR3bl4mB6yVlzihrW3mv6ydZ33iRIA_varnv3zS0xKrNkBZwBapif_GeyKqkLlEmin0Vu0fIGH56_G9hBnWQEjkyFUX1yjV7AESJLoqwQ4hiai_TxA1ZwykXSGK9ikk3j6PRZ4WCIEHetU4O3g_yZQ2tBStxMNP3Qiqv05jfJaFJM8TVMDnpj7tfiKvI7vQ' 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.7

Configuration Settings

Theme