Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

62.48 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	20.77 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8"] 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.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	41.71 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8"] 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.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

20.77 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8"
]

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.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

41.71 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8"
]

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.eyJpYXQiOjE3MzY5ODY4NjcsImV4cCI6MTczNjk5MDQ2Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImpncHQ3MTNAZ21haWwuY29tIn0.BMypHpc6zyQjBjqMQ4vwnrurWmsUfEa8otBUAS6dgkWVnFNh0YnDS1_kjEkaehdskHcLAgpt7ubTyJsH1UF0BGwEDHmUEmO8jGi6dCLBDi8qaw_xPpRp3BoAPPwMBDEhEUzlvX-Kj2DdeaycIBs8bhjBot7gS6HEVtOpqkOHrWlrO1SPz8Ot8xvb_8sBYBWFB5qlqRLms9vjLNwxfHuVG9xO3yQVlJBODriPN-Mwk8OWeaQW7OzwYLLkDVB8sTx4T9zDEFIoLkN5YSd7Ivp30kbl1wMz3JaeMQiWOu05yUHYVynKA9hVWmdwxGb1qJQwVvFowXwBC0pvTJ8_vfnTwRxJFYgnsw8i7OU34kqR1BuTfVrRMQa4r7mX6MVzOMWQJvcjLF4ABrWBuEtrGF9fBKAjqhHxqY-bbtvRc0M_wHhEE4eDl2brJNbCbxWcqsE5xlZdRKGy-aq4UH2bYgyEICI8Ot-o__ajZZhqTJ0jB1pwGtn4rrrgf3x34ek9MTQ4WxRJE5s7n1ua5szeYIfrxoWMv7WaXXaEcAjSVj3OKJEbXaRYYSIyel3VCDbWQ-slZswkTqqKq7viE7hygBOnjREb_2WPrpP9qJOfxawt6-DUFwcUGPEZk1FTsxm-3mpqFmES9l7VyHwBfarJeBLs2ft52VvmFsPwN37f1bYLao8' 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/refresh_purchase?isIos=false&p=api%2Fes%2Fcustomer%2Frefresh_purchase&version_app=4.0.8

Configuration Settings

Theme