Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

80.83 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	35.53 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8"] 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.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	45.30 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8"] 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.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

35.53 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8"
]

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.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

45.30 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8"
]

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.eyJpYXQiOjE3MzE3OTI1MTUsImV4cCI6MTczMTc5NjExNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Implc29uc2FuY2hlejEwQGdtYWlsLmNvbSJ9.atzvBLIRogYjPWnZT7RfddcJKE6KnflOspWlBXKusyqzr2L9Q9bmEDKI9TGu7I42QUyxdxSS5U2h2mBqDp3C5SYtO_hVmAWQXhyuOLglgZ_vJQ3fn80hQa_PGzFydypwnRm-RwmUi2Q7hJIia6c1q6Or-RldLMcjEufsxX1rOs2OZ2oZkF_Rt_fcbRwc6S-1MqyuF1d_0DdKtx6L5_pdXEX2qx0YwQGqZRKdcg-r_cvlpJCUsIMqktH_XfytJPz2Ye_cvuMmcetukeX61bNVQt07Rf2IJC_IaAQHM8IQ00DmWVAR28kjvLy-S4SqKIrobQ0-6MH-0y09GdclPedziQzS-FJABvnAh_sZ-M9p9gzsr8HXm0lOeZ4yl2MR-xOiyp0cx589XBRYNJdBoVNIusNFHlXlerOHEE7MmKJUiaeKCGcAOHhxsAkJtDFasXQ6Ag0U8rg1uFGLS410kww7x2ItbI6MLD2BCi3ZF5oUetbrvxvpmlxIsrj_J5HQg26m-Cm7YDiTPR6fa3SLxrLreR_BbQOMflcHYm4yXZDWjEs9hVwqXyRg4efMJXtigUPH9i9NqTT9vS4j-qHcsvG9yHdlZ0ZLkbMaXlS9pp1AnUlhOAtyT5A65xiWCn_uxUZA2umWdViy67YgNTVsR_DVVwKjZn2aCM_dRLXJq9DEIZ8' 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/season/list?p=api%2Fes%2Fseason%2Flist Return to referer URL

Configuration Settings

Theme