Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.83 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.01 ms

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.from_date AS from_date_2, f0_.from_time AS from_time_3, f0_.to_date AS to_date_4, f0_.to_time AS to_time_5, f0_.description AS description_6, f0_.location AS location_7, f0_.country_code AS country_code_8, f0_.website AS website_9 FROM festival f0_ WHERE f0_.from_date > ? ORDER BY f0_.from_date ASC LIMIT 1

Parameters:

[
  "2026-01-14 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.from_date AS from_date_2,
  f0_.from_time AS from_time_3,
  f0_.to_date AS to_date_4,
  f0_.to_time AS to_time_5,
  f0_.description AS description_6,
  f0_.location AS location_7,
  f0_.country_code AS country_code_8,
  f0_.website AS website_9
FROM
  festival f0_
WHERE
  f0_.from_date > ?
ORDER BY
  f0_.from_date ASC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.from_date AS from_date_2, f0_.from_time AS from_time_3, f0_.to_date AS to_date_4, f0_.to_time AS to_time_5, f0_.description AS description_6, f0_.location AS location_7, f0_.country_code AS country_code_8, f0_.website AS website_9 FROM festival f0_ WHERE f0_.from_date > '2026-01-14 00:00:00' ORDER BY f0_.from_date ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 303)
7	App\Controller\FestivalController->getNextFestival (line 16)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.82 ms

SELECT a0_.location AS location_0, COUNT(a0_.id) AS sclr_1 FROM artist a0_ WHERE a0_.location IS NOT NULL AND a0_.location <> ? GROUP BY a0_.location ORDER BY sclr_1 DESC

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.location AS location_0,
  COUNT(a0_.id) AS sclr_1
FROM
  artist a0_
WHERE
  a0_.location IS NOT NULL
  AND a0_.location <> ?
GROUP BY
  a0_.location
ORDER BY
  sclr_1 DESC

SELECT a0_.location AS location_0, COUNT(a0_.id) AS sclr_1 FROM artist a0_ WHERE a0_.location IS NOT NULL AND a0_.location <> '' GROUP BY a0_.location ORDER BY sclr_1 DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 50)
7	App\Repository\ArtistRepository->countArtistsByLocation (line 20)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Festival	No errors.
App\Entity\Artist	No errors.

Symfony Profiler

GET https://semaphore.fth-srv.net/

Configuration Settings

Theme

Page Width