Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

120.24 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
68.25 ms (0.00%)	1	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc"] 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.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc' LIKE CONCAT(token,'%') AND `status` = 0 ;
51.99 ms (0.00%)	1	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc"] 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.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc' LIKE CONCAT(token,'%') AND `status` = 0 ;;

Time▼

Count

Info

68.25 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc"
]

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.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

51.99 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc"
]

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.eyJpYXQiOjE3MzE4NzExMjAsImV4cCI6MTczMTg3NDcyMCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Im1hcmlvYXN0dWRpbGxvXzc4QGhvdG1haWwuY29tIn0.HjVBHa5HjlFxJDWefG6BOTH5iwK97aQwfFxtEoHmzJtnc2iJrWbbqWv60LsIzdM12OC3CrOXw7BGVLs7yZ1w0h2T1ZEeOIbDWCgMYXs3qwjS8dDuSNk1sHWJYMC2uSvTEsNczhVBuvIZ8F17DHSX5wu0dRPETci9B0g9fVb3T_EyH59eoII2725cjZoAzFUxbTu688Zut-SLJurCEAr0WW6S-LUtJsdLGLOpPEhQxkMGBcJhOdv3xa7JRgW_jEcG4WC4pjLIYRI1fy4Ch-0teeNAqXfE-nYF6kEJR6VltQ5ugZjrTgGkAtvOpeRqcEq6d8u0eUsM2-LEmrm2MtzJJLOwpYfL8zHX-XUcOZ8wHQif7majfYcv-HlDgAr9iwsDxp1PJSDMRRIlxxeq_h39CzweqCVsd17XgF5OL0MskwCk5bUTt6pqxzEwr-ISKIDPKii5mU8Cnw-7Wnl7AfKG8jfZ5RVTld0qP2rGID6ufRkWi6N-suHvVxOlrz66qoRSPdhUaiFiJV4tpQcnCJTcbtCj6-TeNH_C-1cdpM_mD_KJfpdBKBxrYoffN5cf_-QSK8fqYoqXib2Kf604S1W0olHL52RiJ3RBbd6J6frpZxrPsjaGfmxKE0sn0sgxeKbAaaUsuWEBZdzor8FxFkRumXn6606ai0yATjuXIMuuKIc' 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=4.0.8

Configuration Settings

Theme