Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.14 ms Query time

2 Invalid entities

33 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.52 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.product_images AS product_images_4, t0.description AS description_5, t0.status AS status_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.update_at AS update_at_9, t0.category_id AS category_id_10, t0.sub_category_id AS sub_category_id_11, t0.created_by_id AS created_by_id_12 FROM product t0 WHERE t0.category_id = ? AND t0.deleted_at IS NULL ORDER BY t0.created_at DESC LIMIT 30

Parameters:

[
  "11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.product_images AS product_images_4,
  t0.description AS description_5,
  t0.status AS status_6,
  t0.deleted_at AS deleted_at_7,
  t0.created_at AS created_at_8,
  t0.update_at AS update_at_9,
  t0.category_id AS category_id_10,
  t0.sub_category_id AS sub_category_id_11,
  t0.created_by_id AS created_by_id_12
FROM
  product t0
WHERE
  t0.category_id = ?
  AND t0.deleted_at IS NULL
ORDER BY
  t0.created_at DESC
LIMIT
  30

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.product_images AS product_images_4, t0.description AS description_5, t0.status AS status_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.update_at AS update_at_9, t0.category_id AS category_id_10, t0.sub_category_id AS sub_category_id_11, t0.created_by_id AS created_by_id_12 FROM product t0 WHERE t0.category_id = '11' AND t0.deleted_at IS NULL ORDER BY t0.created_at DESC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 24)
5	App\Controller\Controller->getCategoryByProduct (line 69)
6	App\Controller\IndexController->App\Controller\{closure} (line 57)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 62)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 61)
14	App\Controller\IndexController->index (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

1.66 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.product_images AS product_images_3, p0_.description AS description_4, p0_.status AS status_5, p0_.deleted_at AS deleted_at_6, p0_.created_at AS created_at_7, p0_.update_at AS update_at_8, p0_.category_id AS category_id_9, p0_.sub_category_id AS sub_category_id_10, p0_.created_by_id AS created_by_id_11 FROM product p0_ WHERE p0_.deleted_at IS NULL AND p0_.status = 1 ORDER BY p0_.created_at DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.product_images AS product_images_3,
  p0_.description AS description_4,
  p0_.status AS status_5,
  p0_.deleted_at AS deleted_at_6,
  p0_.created_at AS created_at_7,
  p0_.update_at AS update_at_8,
  p0_.category_id AS category_id_9,
  p0_.sub_category_id AS sub_category_id_10,
  p0_.created_by_id AS created_by_id_11
FROM
  product p0_
WHERE
  p0_.deleted_at IS NULL
  AND p0_.status = 1
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.product_images AS product_images_3, p0_.description AS description_4, p0_.status AS status_5, p0_.deleted_at AS deleted_at_6, p0_.created_at AS created_at_7, p0_.update_at AS update_at_8, p0_.category_id AS category_id_9, p0_.sub_category_id AS sub_category_id_10, p0_.created_by_id AS created_by_id_11 FROM product p0_ WHERE p0_.deleted_at IS NULL AND p0_.status = 1 ORDER BY p0_.created_at DESC LIMIT 5;

#	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 144)
7	App\Controller\IndexController->index (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)

1.32 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.deleted_at AS deleted_at_3, c0_.created_at AS created_at_4, c0_.update_at AS update_at_5, s1_.id AS id_6, s1_.name AS name_7, s1_.status AS status_8, s1_.deleted_at AS deleted_at_9, s1_.update_at AS update_at_10, s1_.created_at AS created_at_11, s1_.category_id AS category_id_12 FROM category c0_ LEFT JOIN sub_category s1_ ON c0_.id = s1_.category_id AND (s1_.status = 1 AND s1_.deleted_at IS NULL) WHERE c0_.deleted_at IS NULL AND c0_.status = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.status AS status_2,
  c0_.deleted_at AS deleted_at_3,
  c0_.created_at AS created_at_4,
  c0_.update_at AS update_at_5,
  s1_.id AS id_6,
  s1_.name AS name_7,
  s1_.status AS status_8,
  s1_.deleted_at AS deleted_at_9,
  s1_.update_at AS update_at_10,
  s1_.created_at AS created_at_11,
  s1_.category_id AS category_id_12
FROM
  category c0_
  LEFT JOIN sub_category s1_ ON c0_.id = s1_.category_id
  AND (
    s1_.status = 1
    AND s1_.deleted_at IS NULL
  )
WHERE
  c0_.deleted_at IS NULL
  AND c0_.status = 1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.deleted_at AS deleted_at_3, c0_.created_at AS created_at_4, c0_.update_at AS update_at_5, s1_.id AS id_6, s1_.name AS name_7, s1_.status AS status_8, s1_.deleted_at AS deleted_at_9, s1_.update_at AS update_at_10, s1_.created_at AS created_at_11, s1_.category_id AS category_id_12 FROM category c0_ LEFT JOIN sub_category s1_ ON c0_.id = s1_.category_id AND (s1_.status = 1 AND s1_.deleted_at IS NULL) WHERE c0_.deleted_at IS NULL AND c0_.status = 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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Twig\Extension\CategoryExtension->getGlobals (line 359)
8	Twig\ExtensionSet->getGlobals (line 900)
9	Twig\Environment->getGlobals (line 398)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 459)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
18	App\Controller\IndexController->index (line 183)
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.64 ms

SELECT s0_.payment_method_status AS payment_method_status_0 FROM site_settings s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.payment_method_status AS payment_method_status_0
FROM
  site_settings s0_

SELECT s0_.payment_method_status AS payment_method_status_0 FROM site_settings s0_;

#	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 30)
7	App\Twig\Extension\SiteSettingsExtension->getGlobals (line 359)
8	Twig\ExtensionSet->getGlobals (line 900)
9	Twig\Environment->getGlobals (line 398)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 459)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
18	App\Controller\IndexController->index (line 183)
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)

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\SubCategory	28
App\Category\Entity\Category	4
App\Product\Entity\Product	1

Entities Mapping

Class	Mapping errors
App\Product\Entity\Product	No errors.
App\Category\Entity\Category	The mappings App\Category\Entity\Category#subCategories and App\Entity\SubCategory#category are inconsistent with each other.
App\Entity\SubCategory	The association App\Entity\SubCategory#category refers to the inverse side field App\Category\Entity\Category#subCategory which does not exist.
App\Auth\Entity\User	No errors.
App\Entity\Order	No errors.
App\Entity\SiteSettings	No errors.

Symfony Profiler

GET https://api.ahenkcicekcilik.com.tr/?category=11

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping