Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

54.26 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	21.03 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ"] 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.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	33.23 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ"] 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.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

21.03 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ"
]

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.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

33.23 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ"
]

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.eyJpYXQiOjE3MzY5NDg4MzIsImV4cCI6MTczNjk1MjQzMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyb2RwYWQ3OEBnbWFpbC5jb20ifQ.nG9SB5hzjx7tAsy-Cvz0UZ6zlWWjmQE_qIEySpHXHcOqrDBE9vmNn62GnsbtBqloJIarbyGYt1KkPyMh_dayyhxR8XOrFlZ6Lkr_ppIiiBp_MaJjBBHa4B_vP_Wf6Zu8moMjuRJgcpLB2CFmVV2OxYwYI9rxEVDCdkl0soUx0vTo2VzXNS9kPRPt61miahX9kzVmcwNe1fvlMYO4s8WuA_mckJqmGPIdRa_-Zr5UOrEow4uYY9ai2mPi_WpcsHUoGzBIplotNMK1fAoEdoefS2zliNMi0nkW_RonrCjRYELSF8EecMuWEF_BXBauzopjdHxVo22biOcrK2oCg1fcIKweN7697bAj3U_0GVFT3IJP4DbkvD-HYmQgJm2_r4l31jJLzw5Tv53tV7x2PdcKO8MrYl02e8wcqMEeMKPJre1U3jggEfjWt8ncMs9Swg-xTKk4TZ_zwNvHhFcGtCfZaSLBpH8Ud_i7o_LRMJlldI9i1nVoZIv8DfCAG7xYBj3WoTSYtg3zEEcLWLcMyLj5TPGOK4PxjgtPOhe0029hvXUFU3l937Za7PpYju42fMiJBZNgbUbDPamSPEpWq4KMHvEIOdUfIb6jY0QbN59fVrIhHYSAciowYJk7l2TyArMDrT9Sew8kDU46qJMuTArz-yH8jcBWZt1jWDpWbNqfGEQ' 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=4.0.8

Configuration Settings

Theme