Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

215.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
167.19 ms (0.00%)	1	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU"] 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.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU' LIKE CONCAT(token,'%') AND `status` = 0 ;;
48.16 ms (0.00%)	1	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU"] 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.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU' LIKE CONCAT(token,'%') AND `status` = 0 ;

Time▼

Count

Info

167.19 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU"
]

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.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU' LIKE CONCAT(token,'%') AND `status` = 0 ;;

48.16 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU"
]

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.eyJpYXQiOjE3NDQ3NjUzNTAsImV4cCI6MTc0NDc2ODk1MCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hdXJvZ29uQHBsYW5pc2ZlcmlvLmNvbS5hciJ9.HSFGr2JYZ7XjyVCjiX1sBAr7fdO6oRjN-daSPQQldMHdQuwluUQkSINSc6ITDIHEOFSK8veaCMXn8Sb9txZwp4qsLCuBkLo77y1wHLxF_8Vi3NnUebTGGbIi3aBL_bekQyzVrX5V3En281ueaA-phIVXW1fmALHdJp-1UbwfEFBqSFUU8S0_PUtyDk_1GBn45NhStQRuO4qpLIOl2mO3-936G0pFmW8eI_2xiyPT4szgC4_36yQqYgyey6RvodiIRBnwT0k90RnZfCNvwou7w4klPfyDYnQNdN4vyJV7KQM07biAKAB6scLJq2YanTBCRC4HJnkOgUmOFk9uvyigAWzbESx58tL6AcRcBCswS8aX2F1d2pqKpRmrSl1q8KGniMOMoQ5xfAwYlJ35nKOPcnHj5vLASaK_2tDNJDTPHnhTrojYeAKfLov3oEr5QD4t5bM9rstFFJJGYsgtinIADkNiVNkSWQg5MwXhkKPafCfcp0phjy1P2BfYJSCEaJW90N5gnAAPh5uUZy4_PJSMlV90xXryQkUh_9ZO2NFJoMS-iW4Z9qC0Qj5i4P7IDakKla1swhfjB4y-yAYjkh-pZmb7u3eT092DgCoimJJSi3zXwC1YK90uXfhQZI4kT1xuu6FQMdxF4OKg7XqgAVV0QoATi3jFT5nioatIuY15ykU' 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/add?isIos=false&p=api%2Fes%2Fcustomer%2Fdevice%2Fadd&version_app=5.0.4

Configuration Settings

Theme