Symfony Profiler

Query Metrics

11 Database Queries

4 Different statements

155.81 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

153.28 ms
(98.38%)

SELECT t0.id AS id_1, t0.judul_artikel AS judul_artikel_2, t0.tanggal_post_artikel AS tanggal_post_artikel_3, t0.deskripsi_artikel AS deskripsi_artikel_4, t0.photo_artikel AS photo_artikel_5, t0.kategori_artikel_id AS kategori_artikel_id_6 FROM artikel t0 WHERE t0.kategori_artikel_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.judul_artikel AS judul_artikel_2,
  t0.tanggal_post_artikel AS tanggal_post_artikel_3,
  t0.deskripsi_artikel AS deskripsi_artikel_4,
  t0.photo_artikel AS photo_artikel_5,
  t0.kategori_artikel_id AS kategori_artikel_id_6
FROM
  artikel t0
WHERE
  t0.kategori_artikel_id = ?

SELECT t0.id AS id_1, t0.judul_artikel AS judul_artikel_2, t0.tanggal_post_artikel AS tanggal_post_artikel_3, t0.deskripsi_artikel AS deskripsi_artikel_4, t0.photo_artikel AS photo_artikel_5, t0.kategori_artikel_id AS kategori_artikel_id_6 FROM artikel t0 WHERE t0.kategori_artikel_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 106)
4	App\Controller\DefaultController->Post (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.29 ms
(0.83%)

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.singkatan AS singkatan_3, t0.logo AS logo_4, t0.deskripsi AS deskripsi_5, t0.alamat AS alamat_6, t0.contact_person AS contact_person_7, t0.email AS email_8, t0.x AS x_9, t0.instagram AS instagram_10, t0.facebook AS facebook_11 FROM pengaturan t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nama AS nama_2,
  t0.singkatan AS singkatan_3,
  t0.logo AS logo_4,
  t0.deskripsi AS deskripsi_5,
  t0.alamat AS alamat_6,
  t0.contact_person AS contact_person_7,
  t0.email AS email_8,
  t0.x AS x_9,
  t0.instagram AS instagram_10,
  t0.facebook AS facebook_11
FROM
  pengaturan t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nama AS nama_2, t0.singkatan AS singkatan_3, t0.logo AS logo_4, t0.deskripsi AS deskripsi_5, t0.alamat AS alamat_6, t0.contact_person AS contact_person_7, t0.email AS email_8, t0.x AS x_9, t0.instagram AS instagram_10, t0.facebook AS facebook_11 FROM pengaturan t0 WHERE t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 103)
4	App\Controller\DefaultController->Post (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.82 ms
(0.52%)

SELECT t0.id AS id_1, t0.judul_artikel AS judul_artikel_2, t0.tanggal_post_artikel AS tanggal_post_artikel_3, t0.deskripsi_artikel AS deskripsi_artikel_4, t0.photo_artikel AS photo_artikel_5, t0.kategori_artikel_id AS kategori_artikel_id_6 FROM artikel t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.judul_artikel AS judul_artikel_2,
  t0.tanggal_post_artikel AS tanggal_post_artikel_3,
  t0.deskripsi_artikel AS deskripsi_artikel_4,
  t0.photo_artikel AS photo_artikel_5,
  t0.kategori_artikel_id AS kategori_artikel_id_6
FROM
  artikel t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.judul_artikel AS judul_artikel_2, t0.tanggal_post_artikel AS tanggal_post_artikel_3, t0.deskripsi_artikel AS deskripsi_artikel_4, t0.photo_artikel AS photo_artikel_5, t0.kategori_artikel_id AS kategori_artikel_id_6 FROM artikel t0 WHERE t0.id = '9' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 105)
4	App\Controller\DefaultController->Post (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.42 ms
(0.27%)

SELECT t0.id AS id_1, t0.nama_kategori_artikel AS nama_kategori_artikel_2 FROM kategori_artikel t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nama_kategori_artikel AS nama_kategori_artikel_2
FROM
  kategori_artikel t0

SELECT t0.id AS id_1, t0.nama_kategori_artikel AS nama_kategori_artikel_2 FROM kategori_artikel t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 104)
5	App\Controller\DefaultController->Post (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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.

Entities Mapping

Class	Mapping errors
App\Entity\Pengaturan	No errors.
App\Entity\KategoriArtikel	No errors.
App\Entity\Artikel	No errors.

Symfony Profiler

GET https://espmi.undhirabali.ac.id/post/9

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping