Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

4.03 ms Query time

0 Invalid entities

Time▼	Count	Info
2.89 ms (71.63%)	2	SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = ? Parameters: [`"2QzGduvnucU9CWeJnXFm8FBwreoy5I6b"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = ? SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = '2QzGduvnucU9CWeJnXFm8FBwreoy5I6b';
1.14 ms (28.37%)	1	SELECT concat(plz,' ',title) plz FROM plz where plz like :plz and title IS NOT NULL order by plz Parameters: [`":plz" => "90579%"`] View formatted query View runnable query Explain query SELECT concat(plz, ' ', title) plz FROM plz where plz like :plz and title IS NOT NULL order by plz SELECT concat(plz,' ',title) plz FROM plz where plz like :plz and title IS NOT NULL order by plz;

Time▼

Count

Info

2.89 ms
(71.63%)

SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = ?

Parameters:

[
  "2QzGduvnucU9CWeJnXFm8FBwreoy5I6b"
]

View formatted query View runnable query Explain query

SELECT
  t0_.id AS id_0,
  t0_.token AS token_1,
  t0_.app_id AS app_id_2
FROM
  tokens t0_
WHERE
  t0_.token = ?

SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = '2QzGduvnucU9CWeJnXFm8FBwreoy5I6b';

1.14 ms
(28.37%)

SELECT concat(plz,' ',title) plz FROM plz where plz like :plz and title IS NOT NULL order by plz

Parameters:

[
  ":plz" => "90579%"
]

View formatted query View runnable query Explain query

SELECT
  concat(plz, ' ', title) plz
FROM
  plz
where
  plz like :plz
  and title IS NOT NULL
order by
  plz

SELECT concat(plz,' ',title) plz FROM plz where plz like :plz and title IS NOT NULL order by plz;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\Tokens	No errors.
App\Entity\Apps	No errors.