Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

152.50 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	77.36 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4"] 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.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	75.14 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4"] 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.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

77.36 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4"
]

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.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

75.14 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4"
]

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.eyJpYXQiOjE3MjY4MjUxNTYsImV4cCI6MTcyNjgyODc1Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImJhcmVhMjlAaG90bWFpbC5jb20ifQ.VoOr5-W6_niU9KAta670W_6wwTMsSfWxHZjtkiXBabwkPPrUW20SHNuwl0YR6mMNu3_x80Iz8EzwdVamwCEhJgQlqHkfNcwnpx1vY3mTLQUTFvyJOIPdi8xhYOEoIqovNwkMVPR1OyBrYunuIIdJGAlhON0cWgw71pbp8ctTDKh_XmUyUSVQbkEMI4DTuiPUqmg0lD27GpdLz74WxkcuZI_8w9h6Gz4Sj24fn0jnsUg-36m1RcMI6OAHj_x-ca6STDJfm2OZQY0sc9s8-URPvgVbEJoSPJpq_QzdqHb3uLVZsAWlfEjGWSJaodlEGna4xcQlUDbDvYJ3hip3cfB1rUheS01UJWHgz6-rF31ef8UKXkuDJTowcNCxIr93p6odSGWXjTcOIH1YcJPKKAD3PsohegUmkKfpNAfvIA_aUQiv1uDCfKfjDMkrZ6jibqmia6rb-fZVX7sO-a-duaW8WSLumGAIfF9G2xrm1nsCJFE7kzz24e0dtOi46ubSulfg2dk3gTOV7rA7ofRHx0XRBFG_0PsRvypFhAFx08M2jDnYd6UwTql6m0EB-oGVJw4CSdYNwU0m2pQKQa70d-cgZux0YU0ph0QGqxO1mNnpoAcbfmRpXNKbVXj29IN_hmmG0FA50AX4n1CWid6gBIBdS0d6yOwYbPa4Nh8PS8-hXf4' 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.7

Configuration Settings

Theme