Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

43.16 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	19.17 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4"] 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.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	23.99 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4"] 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.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

19.17 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4"
]

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.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

23.99 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4"
]

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.eyJpYXQiOjE3MzkyMzkyMTUsImV4cCI6MTczOTI0MjgxNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InJvbnlzYW1hbmllZ28wODNAZ21haWwuY29tIn0.P5-P7nE8nScD6b4LfWpnNq0LkU1gaMQtS7YcU5UqbqrdOIlfV2YM6FWRMfHDA8vmhimkaqGteSdKa4AKjdZ0NKqRi7MJzq2-iaweXmxEqJhh4abjg0UVKdhChpSmeUN2KTk7gcVkvdHApR6-eh3J_behUXeYS1dBHClVGUrSiafbEPUkytFJfR9HBh5033MI1hrw3FU9uP-pqDU1we2wbzSO8O9YiWOnUf2BGo-O56UKvrQXptlluqjB8SsOpzo4PZzpHVnVrOAnMje3HjVpqY5G0MoDCbyJSiN798Ww3LgItscjS3nJnMznIoIpm3zl5FVojK_HXke76fec_B0KSLnxMTuhK7cFAiMNLVeVvZYtiERdUCkBPvhUHqb9b4Iz_9cMX3UzQLScsNGvP4G3FQgWwM6dh8dTps3pLj2UOyS_rTMgmqhSh5W2iXHEdcIT8Io6KRX5BcAcNMQVy3WtKHnAyMM8w1Bmvt9iJ5YHX6x78LTjgatXC4U6kdAGTvGPePdsfJ-K4_n9QbCMHV5qYfp0aAxDjLW4FlM3aCC1tUMdtveOkFphbOkNmCdpjZU0lh82J9xCWG7chRk5hkPqrhkGYD71SbHV3kmF93-gIGLh9ctmYOkt-isAV0rKceYv72QEa3_FAVYqZsgw-1IcQM-OFo3PQePMKNBl3G6qRj4' 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=true&p=api%2Fes%2Fcustomer%2Fdevice%2Flist&version_app=5.0.2

Configuration Settings

Theme