Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.96 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.38 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.99 ms

SELECT d0_.id AS id_0 FROM destek_itiraz d0_ INNER JOIN destek d1_ ON d0_.destek_id = d1_.id ORDER BY d0_.tarih DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0
FROM
  destek_itiraz d0_
  INNER JOIN destek d1_ ON d0_.destek_id = d1_.id
ORDER BY
  d0_.tarih DESC

SELECT d0_.id AS id_0 FROM destek_itiraz d0_ INNER JOIN destek d1_ ON d0_.destek_id = d1_.id ORDER BY d0_.tarih 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 79)
7	App\Controller\DestekItirazController->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.27 ms

SELECT d0_.id AS id_0 FROM destek_itiraz d0_ INNER JOIN destek d1_ ON d0_.destek_id = d1_.id WHERE d0_.id IS NOT NULL ORDER BY d0_.tarih DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0
FROM
  destek_itiraz d0_
  INNER JOIN destek d1_ ON d0_.destek_id = d1_.id
WHERE
  d0_.id IS NOT NULL
ORDER BY
  d0_.tarih DESC

SELECT d0_.id AS id_0 FROM destek_itiraz d0_ INNER JOIN destek d1_ ON d0_.destek_id = d1_.id WHERE d0_.id IS NOT NULL ORDER BY d0_.tarih 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 89)
7	App\Controller\DestekItirazController->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.32 ms

SELECT d0_.id AS id_0, d0_.adsoyad AS adsoyad_1, d0_.telefon AS telefon_2, d0_.aciklama AS aciklama_3, d0_.tarih AS tarih_4, d0_.okuma AS okuma_5, d0_.donus AS donus_6, d1_.id AS id_7, d1_.adi AS adi_8, d1_.tarih AS tarih_9, d1_.dosya AS dosya_10, d1_.sorgulama_harf AS sorgulama_harf_11, d1_.baslangic_satir_sayi AS baslangic_satir_sayi_12, d1_.bitis_satir_sayi AS bitis_satir_sayi_13, d1_.baslangic_harf AS baslangic_harf_14, d1_.bitis_harf AS bitis_harf_15, d1_.tip AS tip_16, d1_.durum AS durum_17, d1_.dogum_tarihi_harf AS dogum_tarihi_harf_18 FROM destek_itiraz d0_ INNER JOIN destek d1_ ON d0_.destek_id = d1_.id WHERE d0_.id IS NOT NULL ORDER BY d0_.tarih DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.adsoyad AS adsoyad_1,
  d0_.telefon AS telefon_2,
  d0_.aciklama AS aciklama_3,
  d0_.tarih AS tarih_4,
  d0_.okuma AS okuma_5,
  d0_.donus AS donus_6,
  d1_.id AS id_7,
  d1_.adi AS adi_8,
  d1_.tarih AS tarih_9,
  d1_.dosya AS dosya_10,
  d1_.sorgulama_harf AS sorgulama_harf_11,
  d1_.baslangic_satir_sayi AS baslangic_satir_sayi_12,
  d1_.bitis_satir_sayi AS bitis_satir_sayi_13,
  d1_.baslangic_harf AS baslangic_harf_14,
  d1_.bitis_harf AS bitis_harf_15,
  d1_.tip AS tip_16,
  d1_.durum AS durum_17,
  d1_.dogum_tarihi_harf AS dogum_tarihi_harf_18
FROM
  destek_itiraz d0_
  INNER JOIN destek d1_ ON d0_.destek_id = d1_.id
WHERE
  d0_.id IS NOT NULL
ORDER BY
  d0_.tarih DESC
LIMIT
  10

SELECT d0_.id AS id_0, d0_.adsoyad AS adsoyad_1, d0_.telefon AS telefon_2, d0_.aciklama AS aciklama_3, d0_.tarih AS tarih_4, d0_.okuma AS okuma_5, d0_.donus AS donus_6, d1_.id AS id_7, d1_.adi AS adi_8, d1_.tarih AS tarih_9, d1_.dosya AS dosya_10, d1_.sorgulama_harf AS sorgulama_harf_11, d1_.baslangic_satir_sayi AS baslangic_satir_sayi_12, d1_.bitis_satir_sayi AS bitis_satir_sayi_13, d1_.baslangic_harf AS baslangic_harf_14, d1_.bitis_harf AS bitis_harf_15, d1_.tip AS tip_16, d1_.durum AS durum_17, d1_.dogum_tarihi_harf AS dogum_tarihi_harf_18 FROM destek_itiraz d0_ INNER JOIN destek d1_ ON d0_.destek_id = d1_.id WHERE d0_.id IS NOT NULL ORDER BY d0_.tarih DESC LIMIT 10;

#	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 101)
7	App\Controller\DestekItirazController->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\DestekItiraz	No errors.
App\Entity\Destek	No errors.

Symfony Profiler

POST https://www.app.efelertarimapp.com.tr/d/destek-itiraz/result

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping