Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

51.36 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	18.12 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0"] 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.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	33.24 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0"] 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.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

18.12 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0"
]

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.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

33.24 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0"
]

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.eyJpYXQiOjE3MzE4ODI2MDksImV4cCI6MTczMTg4NjIwOSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imdvb2xjb2xvbWJpYUBob3RtYWlsLmVzIn0.nSHnB4gWTdl3Z0m1zjc-vc_8r8B9gf7gjtLSuM0DT4IHtOxGZI1PrfoyANooU9VW2xKXNwMOyOY-pbJSfPuBE-fdgNRsxzKawofJGgvpxpa3aH5EiqBJExfY3BEIuFN3Ea9SiF6xCv2AskWW0y9QdUmHeiKhdJxoY2TNMM0EXlXQEP1Pl5umLgxxTt4S2fjz1uTL6jxvNOT3rgyhzaFbGwDb_l0f9feuS6_t7rj2OeC4YCIUQYCDNtLwJVWrKXX5SBW_ItDQ4DMlXQH7QZ71YsMcj3pnMiQjwAmPCNqAHde_U-hOttoGpYlt9w7v5igU2M2jGjn6PybHN0-EMAJj7e0DF5tl_pAEbEFdfucQ-xqTwqDNRyqj0EyZ6S0vY05VyXuc-aE01xMb6Fl5JT8ZmhPuQC4A1yBe9dRaIjK0JMOoATZtBqE9SPyYce81oZxTLPARH0fLnRpHQN428hnKR0VlanqCuDmuf5bX_Bqid-qcu5ST6qfpLPmqXfORbsk_GmsOpQqZoI1vhbQK0S-C2wbJx8kU7rfiakg98M-Cm_GzX_N7op30V_XZ-VFrhVyyl1lWtvIi3kwxGEfLFAKb_x4C4FrfeFiJHDRLMaFAw4kqLDYnWwYVB5_xgQey_T-T5F0lh_8YtatDdQSGmq0q20kXMjEQVCQ_7oP2yy09uz0' 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=4.0.8

Configuration Settings

Theme