Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

53.89 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	28.26 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI"] 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.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	25.63 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI"] 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.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

28.26 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI"
]

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.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

25.63 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI"
]

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.eyJpYXQiOjE3NDgxMzk2MTgsImV4cCI6MTc0ODE0MzIxOCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImNoaWNvbGlrZUBnbWFpbC5jb20ifQ.OZYis2v8C3SUScvVvMNDsXTt48Hdam8XJvQrXmGcp2uSV6Dl64GpTT8x8PiG-MH5YrASYhI0Ra_xbMuRPW17LN4Zr6Y-mor6IRlZHvo2baISM047uxdE8C6rc-sd2SsJj7nxDeX-bFB9JNn4HcJ06W6C7rhRjykfj0_Lna6PBV9BikkU23QWPB5VDjmFlWQCWi0JYlkIYWWR54HRNboKnIkQDnFdzOc988oQoL1I0xO7Gu5WMOwHdD-89Jo60xf4VcOf5lFQ2YXabB15QQOwCvnw8U1ovAyvmFAEoy3UlXCmHCVdudLQUgIxuRhtTpfmRztU4PHbWNi7HiQE5P7DI0OZZoXynSXB-xxYx93o28kBpyi2rw_Rhn2p8zyx-nJXwRRMQNE6sPJukhYTa-jHhd3W2RjA9Xh7MkZZnloNGJ0Ll3dFW8aDOhPliWXLLQXp2xjps6mM8M2Ix1R4CL_BNnO0zhCWDAMxEQzJoQfxycBIRN4s-Fj93-LItQXG6hphaFrUkjNt0vMFWkiOeL-uK6e9-zQUevzfWuug0RRMLKBEUg6LTcHPDLsO7Pev7YjfEpOl2pCYoAuo0GTgwWoOguSNdog73B4Q7hjxLt17cDT9Yy2rkhru3UoNyuRbRyFWemuG6kOcc83kYGODSF94bK4DKRStczv_aiHlous_biI' 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=5.0.3

Configuration Settings

Theme