Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

44.20 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
25.00 ms (0.00%)	1	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys"] 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.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys' LIKE CONCAT(token,'%') AND `status` = 0 ;;
19.21 ms (0.00%)	1	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys"] 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.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys' LIKE CONCAT(token,'%') AND `status` = 0 ;

Time▼

Count

Info

25.00 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys"
]

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.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys' LIKE CONCAT(token,'%') AND `status` = 0 ;;

19.21 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys"
]

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.eyJpYXQiOjE3MzEwNjYxMDUsImV4cCI6MTczMTA2OTcwNSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5tYW51ZWxnb3BlQGdtYWlsLmNvbSJ9.sEyKbllDTyH0PBuBDMSMkdMJf6QfpS2fWZoeYVdvskmlPHPdKtJ40s0_RyHzt9a35irzoMpTfHZPR8lC10YWr8e7bAcJSfVr6yi7lYAN6j2_hcEyhpDCFcwGi9idwXqrdJW1EQDzqjdo8LXX2TQACbi9Ic4YIIhBodaDiuiIAUhU-P9v9Zwv71nAPp6J2m1UoxU23DKg_92-DoI5UNJPPRcui6apSOJoM4E98QaIa78IjPoo28kAydyUBld7JeMPilvXjf8jR6QrK-S00lvUKcQAbvPjXaG6MzFTT6N8ZeYUipWxhyfPTBfnGS7-ZzZUKxz4t8gdelRRzzVEOv6AOIOGKEn-8f7WQS0OA3R5Pzt5hDRQ32K6uD0PGAN-yrIfzFcP0xRCxeoB3PX7cXfbeHRIEOqkpwVHDp3-Y1h2vtVLEZMrLiDth9ol0_AdUJeefX2a2PPs0-kz5p9ppoWplPiaGLzbh-SoEFVASYKTalEbjHMAn8Gcry1YHkzrmPQTv4eujM2YZxhICH4zboD_GhGlq8KFU9URyXAxIUFrpMZfFTPQ7JLz0i1tQ2fxaAVChPd4ZHwnK9JPEmoOMitaZXMcZdQA9BcJN0O9pqzeoCIrx64M4kDPlMarKJP3iAEGsGTb0FhOSZ_db8YTyoxvHMRg-A1jrGuedtvCfV3nGys' 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/user_data?p=api%2Fes%2Fuser_data Return to referer URL

Configuration Settings

Theme