Symfony Profiler

Query Metrics

3 Database Queries

1 Different statements

4.73 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.97 ms

SELECT p0_.id AS id_0, p0_.prayer_date AS prayer_date_1, p0_.hijri_date AS hijri_date_2, p0_.fajr AS fajr_3, p0_.sunrise AS sunrise_4, p0_.dhuhr AS dhuhr_5, p0_.asr AS asr_6, p0_.maghrib AS maghrib_7, p0_.isha AS isha_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.city AS city_11, p0_.country AS country_12 FROM prayer_time p0_ WHERE p0_.prayer_date >= ? AND p0_.prayer_date < ?

Parameters:

[
  "2026-06-01 00:00:00"
  "2026-06-01 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.prayer_date AS prayer_date_1,
  p0_.hijri_date AS hijri_date_2,
  p0_.fajr AS fajr_3,
  p0_.sunrise AS sunrise_4,
  p0_.dhuhr AS dhuhr_5,
  p0_.asr AS asr_6,
  p0_.maghrib AS maghrib_7,
  p0_.isha AS isha_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.city AS city_11,
  p0_.country AS country_12
FROM
  prayer_time p0_
WHERE
  p0_.prayer_date >= ?
  AND p0_.prayer_date < ?

SELECT p0_.id AS id_0, p0_.prayer_date AS prayer_date_1, p0_.hijri_date AS hijri_date_2, p0_.fajr AS fajr_3, p0_.sunrise AS sunrise_4, p0_.dhuhr AS dhuhr_5, p0_.asr AS asr_6, p0_.maghrib AS maghrib_7, p0_.isha AS isha_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.city AS city_11, p0_.country AS country_12 FROM prayer_time p0_ WHERE p0_.prayer_date >= '2026-06-01 00:00:00' AND p0_.prayer_date < '2026-06-01 23:59:59';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\PrayerTimeRepository->findByDate (line 33)
7	App\Controller\Site\PrayerController->show (line 128)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.36 ms

SELECT p0_.id AS id_0, p0_.prayer_date AS prayer_date_1, p0_.hijri_date AS hijri_date_2, p0_.fajr AS fajr_3, p0_.sunrise AS sunrise_4, p0_.dhuhr AS dhuhr_5, p0_.asr AS asr_6, p0_.maghrib AS maghrib_7, p0_.isha AS isha_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.city AS city_11, p0_.country AS country_12 FROM prayer_time p0_ WHERE p0_.prayer_date >= ? AND p0_.prayer_date < ?

Parameters:

[
  "2026-05-31 00:00:00"
  "2026-05-31 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.prayer_date AS prayer_date_1,
  p0_.hijri_date AS hijri_date_2,
  p0_.fajr AS fajr_3,
  p0_.sunrise AS sunrise_4,
  p0_.dhuhr AS dhuhr_5,
  p0_.asr AS asr_6,
  p0_.maghrib AS maghrib_7,
  p0_.isha AS isha_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.city AS city_11,
  p0_.country AS country_12
FROM
  prayer_time p0_
WHERE
  p0_.prayer_date >= ?
  AND p0_.prayer_date < ?

SELECT p0_.id AS id_0, p0_.prayer_date AS prayer_date_1, p0_.hijri_date AS hijri_date_2, p0_.fajr AS fajr_3, p0_.sunrise AS sunrise_4, p0_.dhuhr AS dhuhr_5, p0_.asr AS asr_6, p0_.maghrib AS maghrib_7, p0_.isha AS isha_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.city AS city_11, p0_.country AS country_12 FROM prayer_time p0_ WHERE p0_.prayer_date >= '2026-05-31 00:00:00' AND p0_.prayer_date < '2026-05-31 23:59:59';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\PrayerTimeRepository->findByDate (line 33)
7	App\Controller\Site\PrayerController->show (line 137)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.40 ms

SELECT p0_.id AS id_0, p0_.prayer_date AS prayer_date_1, p0_.hijri_date AS hijri_date_2, p0_.fajr AS fajr_3, p0_.sunrise AS sunrise_4, p0_.dhuhr AS dhuhr_5, p0_.asr AS asr_6, p0_.maghrib AS maghrib_7, p0_.isha AS isha_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.city AS city_11, p0_.country AS country_12 FROM prayer_time p0_ WHERE p0_.prayer_date >= ? AND p0_.prayer_date < ?

Parameters:

[
  "2026-06-02 00:00:00"
  "2026-06-02 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.prayer_date AS prayer_date_1,
  p0_.hijri_date AS hijri_date_2,
  p0_.fajr AS fajr_3,
  p0_.sunrise AS sunrise_4,
  p0_.dhuhr AS dhuhr_5,
  p0_.asr AS asr_6,
  p0_.maghrib AS maghrib_7,
  p0_.isha AS isha_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.city AS city_11,
  p0_.country AS country_12
FROM
  prayer_time p0_
WHERE
  p0_.prayer_date >= ?
  AND p0_.prayer_date < ?

SELECT p0_.id AS id_0, p0_.prayer_date AS prayer_date_1, p0_.hijri_date AS hijri_date_2, p0_.fajr AS fajr_3, p0_.sunrise AS sunrise_4, p0_.dhuhr AS dhuhr_5, p0_.asr AS asr_6, p0_.maghrib AS maghrib_7, p0_.isha AS isha_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.city AS city_11, p0_.country AS country_12 FROM prayer_time p0_ WHERE p0_.prayer_date >= '2026-06-02 00:00:00' AND p0_.prayer_date < '2026-06-02 23:59:59';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\PrayerTimeRepository->findByDate (line 33)
7	App\Controller\Site\PrayerController->show (line 138)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
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
App\Entity\PrayerTime	3

Entities Mapping

Class	Mapping errors
App\Entity\PrayerTime	No errors.

Symfony Profiler

GET https://mail.assalam-orleans.fr/prieres/2026-06-01

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping