Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

192.81 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	58.17 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY"] 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.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	134.64 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY"] 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.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

58.17 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY"
]

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.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

134.64 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY"
]

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.eyJpYXQiOjE3MzE3ODMzMDgsImV4cCI6MTczMTc4NjkwOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImFkcmlzaWNpMjFAZ21haWwuY29tIn0.a87-5jhQLd5YKRPHQlDVgGKUrnokQ4N828EpS9n5xcvr2rNoi89ReaBsjaHbVPNc5bwh0H62ynOhzFkaqODOpkqSLY1428fo-DjLI10cIE2gv3uWbmqsQJjY-7v0huYMaGqh05xjcPlyKFhdzETJWBo1jNwNliFs44GHeUQ1OQS4ByJVs-3tOCN8ISREtpOks-g2JpMVFx0B5r8t8XfzBjPzmJVZe9DL4zW9g1vm9RJNb49X7cD-AL357WeJrJjZoZimOZmCtXc_021CTwYt7oddVsKoc8N-14TeQio3-b2VazkUTBm9QVklAFU5D4SxqWKjktNGdsy4K1DRc8Q7sXr_X2acJTL0lBiQwKZbBkgx-zVqrLSKySTG6Ut-FZQTS_lY7cRbWc_14csYFw-HrFJFokMDdRt_2bUsugHXjMRCYzZJvWnPjQgPBPGX4vpEVo2pQtNUYfr7QUmHsGogNPxhC5aNuJqS1gW4MnglXRlP5pNe55iu3WT-_rQgmF9cliTUhnf2liif9twzbOtshMuYy78Y_ZWn_SVlHo99pa3dKyKtkXkmX5oFzgWhRjLYINbmVIVfp-wsntoO48yBj0Ug2_pocxWwUHCperOKVlB5Az5ezwuFDrcCUVeduE1nFCD8TtDRVp_rCIfPb5uKXyaT8yqB_BrS1ChcYJsI3mY' 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/refresh_purchase?p=api%2Fes%2Fcustomer%2Frefresh_purchase Return to referer URL

Configuration Settings

Theme