Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

70.77 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	22.03 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM"] 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.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	48.74 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM"] 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.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

22.03 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM"
]

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.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

48.74 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM"
]

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.eyJpYXQiOjE3NTAxOTY2NDUsImV4cCI6MTc1MDIwMDI0NSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmluYXNwb3J0bXhAZ21haWwuY29tIn0.YWwvIZxX7LbAmpsItIsI-sy-Ll908Y96puqJVAKzDAvXANlreVsEpP5Brl46QgwJ2-TvOPUeyKQuJyuZwcHb9p30OfcJ3x0-W37tSw3QPvs0lhdQQkZqf4Dih8XFXge-lSgYaWiSiPXDmtYoE4FE8Bd2saaiSuyAzbCrEiP8LSeQnNTaOc6cErVSQq9PK0UU8KpFn7uFAs0CeHqmoHe34XvlzFYf8SD8IyLZMN7LDievLcsciBBafB1pUytsX4XrdOfFZpqymYJogcbLxDhR_L7hri-5xRRuF-NM4PFe9yECcnTPzkr4AICEh_iBafRaIJSAu7asICUb9woWZNstNC4JWMr3oZtuIzGst8viM3Ln9mxH-wHU4Gi_I8DbpPwh4_MIRMuc4aYwnbF20PKN6NCdixNUaVIhY7AZrVhgpd2_rxkzTNpDe6TCvhQ1wuEMsrxyFUqbWTEH_p8Jjzu2oJU_F7t_iM4pOqO0JJnh-o79iFKpdA2UyIXOXdq-UMOkIroIk5irbCZEI6EMfqjtZknq_BzeGcwVsIcPGORWqEeAAN8CJJs5rBoDg66mzK_7SrzsP0GpZC5EHOtvsBm7u4nZlyhpStYbLJnppGu7G6ZW5pmo2uF8hfD9fstUnQEzdFHWIBbiQt5260GJrjlXIJ1iI888oD_YfHgojg9vqeM' 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=5.0.5

Configuration Settings

Theme