Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

91.84 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	41.22 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY"] 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.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	50.62 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY"] 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.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

41.22 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY"
]

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.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

50.62 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY"
]

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.eyJpYXQiOjE3NDc5MDEyNTIsImV4cCI6MTc0NzkwNDg1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.cYQFj6O70SXJTx61qGjGl7o1-peu-eCTDAMIaOP0kexsHW0nqxk-TWI8js6lpRUgJqMQRSE9uUfGlD5FbRWfDEYKEERbQ3V1RwdEBnruUMr5dEJnoCHxL4gf5-iilMy8E7ztqzb8GFapY66tuS0jIgeHSFmegtO5su6sjGYBtAWcGnbPw7wP3yWGa_MONEPypmOkJGg3nbYUlfk9JEjfMHlsD6fYxiTfjmnHU3kn4B_EcpvZbiMX0Cu8_J58CVNWHRQFiGiocJvW7RDD1u7ocbkr1BjNgpzbA7zyBi4UEmHEBG4c0-F3EeeVzZdwRtnaxqw57p9FuLj3Z6zccBZOW5EjeDcKcmvXuM_M2RY6RDrlX6Pv9ihe8-bi9ukUcyLogUngXejKAdBEFINmajqk3iRIfDHuISz0h7LtfikIk9OPxqWawPLpgvy4XRWOF4Z2Wxv4PPLIKPM8lOA7CWU5oMgAPgWwyLB6CvGlQKih2VSnGufAM7tiyzrfzN-VylbN4GjF9zs7bTQ8N7YNnghEANVsRC38zKt5ZotQvmsvPQiZSK3eKCILCVUeKLgPpwoV0IPeanaM3USP-GOsKZgnXllEoo462m5MzN79DDEJSUbpnv0ZlW9Z_XSwu_fBGUoRoTG9g9zWGpxHOrFcWKs5KYgPHTKrIEnYzgCvIIUJ0PY' 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