Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

82.41 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
50.46 ms (0.00%)	1	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs"] 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.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs' LIKE CONCAT(token,'%') AND `status` = 0 ;;
31.95 ms (0.00%)	1	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs"] 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.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs' LIKE CONCAT(token,'%') AND `status` = 0 ;

Time▼

Count

Info

50.46 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs"
]

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.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs' LIKE CONCAT(token,'%') AND `status` = 0 ;;

31.95 ms
(0.00%)

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs"
]

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.eyJpYXQiOjE3MjY4NjM1NjIsImV4cCI6MTcyNjg2NzE2Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImZyYW5sb3NvcmlvQGdtYWlsLmNvbSJ9.v8GLTVR4kwuLZ4dT4PR33ypLw_rReHXEfRi3at_gfvuPh8UYeidujqSCn3j7SJBhT54Mn8-aGe4MR4NQmw8wMarTy9sRlXngQWJI5u2C4WTYGVHij9QPMZZEEL7ZqDmpgp2-4smKuKpbyaEiaJG2m-t-tRkmV8EdFLw1TxXKTOxZAaW0CdReKLhTfECN8erV-eBfOuEtPeyx2--MDhJYfzDvsUm4ZDeDmxIqyMjgKV239CpV1JY7OGskyZlsRwdd_MocTRjXTYS6dJZzliTF7xdZie4cO-At-hPSki0IdQoLBgpxrlzVdlRf1Hg_Xo3N3ArwJQAF39vZfkdQkrt0Ooce0EY8V1Dpnz1UypKcQum0q-lEAN2xCGPTrwhnhpJDX0zQoWio8LR35yBXZ1VUFUpP7BWCvY8cN-HSbl8DIGvcQQ3v9Nko8PezSOespdkEmp1hlg4CKKdHSHP0knCZ7dTBkKn4TijEMkJFu7kElytDF0RbyA9ZceEdALChqxqly5pw5KTAUhmLQAsk0lDBWjX9EY3UJRUyMorPvn7p-zNfyFOzUIl8isLVUw_r1SudRJoWVuFceo_3Q3AoxlV8at3HfC4kH2JWKXsv2K3gkL_pwKb9SYuylXkUYs9YyEznY19eLNKEoZYkQYO4a-RrDiQYHy-sCJYqFK2xWaIz-Vs' 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/add?isIos=false&p=api%2Fes%2Fcustomer%2Fdevice%2Fadd&version_app=4.0.7

Configuration Settings

Theme