Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

4.05 ms Query time

0 Invalid entities

Time▼	Count	Info
2.85 ms (70.26%)	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.20 ms (29.74%)	1	SELECT concat(plz,' ',title) plz FROM plz where plz like :plz and title IS NOT NULL order by plz Parameters: [`":plz" => "24944%"`] 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.85 ms
(70.26%)

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.20 ms
(29.74%)

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

Parameters:

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

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.