Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.62 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.50 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.is_verified AS is_verified_3, t0.is_password AS is_password_4, t0.roles AS roles_5, t0.password AS password_6, t0.adsoyad AS adsoyad_7, t0.unvan AS unvan_8, t0.telefon AS telefon_9, t0.resim AS resim_10, t0.last_login AS last_login_11, t0.reset_token AS reset_token_12, t0.remove AS remove_13, t0.ziraat_odasi AS ziraat_odasi_14, t0.rol_id AS rol_id_15 FROM user t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.is_verified AS is_verified_3,
  t0.is_password AS is_password_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.adsoyad AS adsoyad_7,
  t0.unvan AS unvan_8,
  t0.telefon AS telefon_9,
  t0.resim AS resim_10,
  t0.last_login AS last_login_11,
  t0.reset_token AS reset_token_12,
  t0.remove AS remove_13,
  t0.ziraat_odasi AS ziraat_odasi_14,
  t0.rol_id AS rol_id_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.is_verified AS is_verified_3, t0.is_password AS is_password_4, t0.roles AS roles_5, t0.password AS password_6, t0.adsoyad AS adsoyad_7, t0.unvan AS unvan_8, t0.telefon AS telefon_9, t0.resim AS resim_10, t0.last_login AS last_login_11, t0.reset_token AS reset_token_12, t0.remove AS remove_13, t0.ziraat_odasi AS ziraat_odasi_14, t0.rol_id AS rol_id_15 FROM user t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.41 ms

SELECT d0_.id AS id_0, CASE WHEN d0_.tip = 1 THEN 'Askı İcmalleri' WHEN d0_.tip = 2 THEN 'Kesin İcmaller' WHEN d0_.tip = 3 THEN 'Hayvancılık' ELSE '-' END AS sclr_1 FROM destek d0_ ORDER BY d0_.baslangic_satir_sayi DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  CASE WHEN d0_.tip = 1 THEN
    'Askı İcmalleri'
  WHEN d0_.tip = 2 THEN
    'Kesin İcmaller'
  WHEN d0_.tip = 3 THEN
    'Hayvancılık'
  ELSE
    '-'
  END AS sclr_1
FROM
  destek d0_
ORDER BY
  d0_.baslangic_satir_sayi DESC

SELECT d0_.id AS id_0, CASE WHEN d0_.tip = 1 THEN 'Askı İcmalleri' WHEN d0_.tip = 2 THEN 'Kesin İcmaller' WHEN d0_.tip = 3 THEN 'Hayvancılık' ELSE '-' END AS sclr_1 FROM destek d0_ ORDER BY d0_.baslangic_satir_sayi 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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 74)
7	App\Controller\DestekController->result (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.33 ms

SELECT d0_.id AS id_0, CASE WHEN d0_.tip = 1 THEN 'Askı İcmalleri' WHEN d0_.tip = 2 THEN 'Kesin İcmaller' WHEN d0_.tip = 3 THEN 'Hayvancılık' ELSE '-' END AS sclr_1 FROM destek d0_ WHERE d0_.id IS NOT NULL ORDER BY d0_.baslangic_satir_sayi DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  CASE WHEN d0_.tip = 1 THEN
    'Askı İcmalleri'
  WHEN d0_.tip = 2 THEN
    'Kesin İcmaller'
  WHEN d0_.tip = 3 THEN
    'Hayvancılık'
  ELSE
    '-'
  END AS sclr_1
FROM
  destek d0_
WHERE
  d0_.id IS NOT NULL
ORDER BY
  d0_.baslangic_satir_sayi DESC

SELECT d0_.id AS id_0, CASE WHEN d0_.tip = 1 THEN 'Askı İcmalleri' WHEN d0_.tip = 2 THEN 'Kesin İcmaller' WHEN d0_.tip = 3 THEN 'Hayvancılık' ELSE '-' END AS sclr_1 FROM destek d0_ WHERE d0_.id IS NOT NULL ORDER BY d0_.baslangic_satir_sayi 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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 83)
7	App\Controller\DestekController->result (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.38 ms

SELECT d0_.id AS id_0, d0_.adi AS adi_1, d0_.tarih AS tarih_2, d0_.dosya AS dosya_3, d0_.sorgulama_harf AS sorgulama_harf_4, d0_.baslangic_satir_sayi AS baslangic_satir_sayi_5, d0_.bitis_satir_sayi AS bitis_satir_sayi_6, d0_.baslangic_harf AS baslangic_harf_7, d0_.bitis_harf AS bitis_harf_8, d0_.tip AS tip_9, d0_.durum AS durum_10, d0_.dogum_tarihi_harf AS dogum_tarihi_harf_11, CASE WHEN d0_.tip = 1 THEN 'Askı İcmalleri' WHEN d0_.tip = 2 THEN 'Kesin İcmaller' WHEN d0_.tip = 3 THEN 'Hayvancılık' ELSE '-' END AS sclr_12 FROM destek d0_ WHERE d0_.id IS NOT NULL ORDER BY d0_.baslangic_satir_sayi DESC LIMIT 25

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.adi AS adi_1,
  d0_.tarih AS tarih_2,
  d0_.dosya AS dosya_3,
  d0_.sorgulama_harf AS sorgulama_harf_4,
  d0_.baslangic_satir_sayi AS baslangic_satir_sayi_5,
  d0_.bitis_satir_sayi AS bitis_satir_sayi_6,
  d0_.baslangic_harf AS baslangic_harf_7,
  d0_.bitis_harf AS bitis_harf_8,
  d0_.tip AS tip_9,
  d0_.durum AS durum_10,
  d0_.dogum_tarihi_harf AS dogum_tarihi_harf_11,
  CASE WHEN d0_.tip = 1 THEN
    'Askı İcmalleri'
  WHEN d0_.tip = 2 THEN
    'Kesin İcmaller'
  WHEN d0_.tip = 3 THEN
    'Hayvancılık'
  ELSE
    '-'
  END AS sclr_12
FROM
  destek d0_
WHERE
  d0_.id IS NOT NULL
ORDER BY
  d0_.baslangic_satir_sayi DESC
LIMIT
  25

SELECT d0_.id AS id_0, d0_.adi AS adi_1, d0_.tarih AS tarih_2, d0_.dosya AS dosya_3, d0_.sorgulama_harf AS sorgulama_harf_4, d0_.baslangic_satir_sayi AS baslangic_satir_sayi_5, d0_.bitis_satir_sayi AS bitis_satir_sayi_6, d0_.baslangic_harf AS baslangic_harf_7, d0_.bitis_harf AS bitis_harf_8, d0_.tip AS tip_9, d0_.durum AS durum_10, d0_.dogum_tarihi_harf AS dogum_tarihi_harf_11, CASE WHEN d0_.tip = 1 THEN 'Askı İcmalleri' WHEN d0_.tip = 2 THEN 'Kesin İcmaller' WHEN d0_.tip = 3 THEN 'Hayvancılık' ELSE '-' END AS sclr_12 FROM destek d0_ WHERE d0_.id IS NOT NULL ORDER BY d0_.baslangic_satir_sayi DESC LIMIT 25;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 94)
7	App\Controller\DestekController->result (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\User	1
App\Entity\Rol	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Rol	No errors.
App\Entity\Destek	No errors.

Symfony Profiler

POST https://www.app.efelertarimapp.com.tr/d/destekler/result

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping