Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

52.12 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
32.64 ms (0.00%)	1	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8"] 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.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8' LIKE CONCAT(token,'%') AND `status` = 0 ;;
19.48 ms (0.00%)	1	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8"] 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.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8' LIKE CONCAT(token,'%') AND `status` = 0 ;

Time▼

Count

Info

32.64 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8"
]

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.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8' LIKE CONCAT(token,'%') AND `status` = 0 ;;

19.48 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8"
]

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.eyJpYXQiOjE3NDA0MTA4MTgsImV4cCI6MTc0MDQxNDQxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpvcmdlLmF2YWxvczEyQGdtYWlsLmNvbSJ9.OzdS4WnUuzSSJLI9ij17YKfQxKoj3Oqm0xYXo7tGtlapmNhJ_tYNGUYTPH0JomYnm-bgUyPj9hiKOCHymVGt1mHFCgFyJD0l1VI1u1O2jIjdTSCcMMBO5HxTyVrPGAfgedXC9ECfVoHpmxg0HrUA8OeDtiBQThI7Gr64fIK1L3BRoVmXmNgzpDj2CO7CF9DUTldwaFmsPpzfii0ZRi_W-RHYeP3r_rK-CN7w2lZ3I4aIp01MTDRPRW-i9C7bj8cBBU50PpJxVljiUmulVdNTd7UkBAAIzYcpHJhCfPVRU6lQ_ULm2hHkeHZ_oyVUSHfsgriq29clepia0YzYoNMMwh8luiOsTWnxJu7ROvAvJYSshfTbwaMILZ0isTIfDaUhwInfjivFYZKq7kD1BQEJ9pNiKYUZAglfVkL8FZV39fgA3eVr5nW43MsSHk4AjeO0C8bhg1lcDGr3d3nJMyuTWRL_uWcnKiSGHFNQ5tkKTPs3x-J9hIq1Uc5_oSWvZivkhRlmLJPFVwClwxmyjc2Z5CpgS1fNudeMvaL18-UK5AK1oMB5i11T1eImgXvVWEBtusQy_QqJ3kvU35s6OeaDTeGY9_aY2tEIFlbXn2WmNlHQWvdU0ILl7J8iz1biVVurYpAA_1FI7l4PHZBfHS6iT2xXFb0Siym2vFv8OqW5-E8' 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/notification/read/10?isIos=true&p=api%2Fes%2Fnotification%2Fread%2F10&version_app=5.0.2

Configuration Settings

Theme