Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

205.70 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	29.65 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg"] 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.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	176.05 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg"] 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.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

29.65 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg"
]

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.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

176.05 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg"
]

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.eyJpYXQiOjE3NDY1MjI5MjIsImV4cCI6MTc0NjUyNjUyMiwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImdhcmNpYXJvbWFuZGF2aWQ3QGdtYWlsLmNvbSJ9.em6mYkhVbOKmP9_Haw1jAr6g3vUf6W8mFvaikgwvo6UjwE1zD7l51xYs6_1L_zNJld4_Tbr-om6wBbgddDJZOQ6VE_HsIlXSyAbYGesDre_z_gqx41k7YR3t0nyFVK5OkWBFmVrhDQBCHJhkrGVz9brNX6yKi4exyhl-d6u0_PRCV0WrKgbgTWgJagD56cMW-t0S_cATy0B4vG-BxUf8nP6zYVUvcwynE1ivtC6lklhKguw1duWt0UPCFOb4_7UksKlRgiBXokDhLCqAkK1ZesGSwUdPKBWXjL4J6qzlk05LhPzCKIZ-pa1t4lquXsyrwHdza5wQZebjp_2d21DyYW8jxCIoM09pqQ_dwdL0kcjJ5wWg3OuZfPN-C1cCmmEu9ILuDmi53ylsIh6bOHDug8GcB1TDawklc97e4H26fs7TAwDgEGZG_3dQ43RpwnhTbEnnC_SlYSWlTDkE9hsJfDxg3-WyRhqY7z0I3IGr1z7RGK9yZKjo0y-UoSFz30lNTKbV4DH5m446L7ldFVzngPx1pl99NX-uA8ZakBfri2VMmhaPlBt7CnLrLbWQRq54oheKi2Vif4sQwrrDdhyiAwVwvEYjyknsdMmw-bDkD3cCVEEjDL3E1qmNwqCCf53DucQYRxeS9l_CTLl8zcTbj04Ck1gSIzOiDAk8j6gA3fg' 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/game/list?p=api%2Fes%2Fgame%2Flist Return to referer URL

Configuration Settings

Theme