Symfony Profiler

Query Metrics

11 Database Queries

11 Different statements

8.27 ms Query time

0 Invalid entities

66 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.94 ms
(35.48%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\BaseController->__construct (line 55)
4	ContainerGH7gbdN\App_KernelDevDebugContainer->getSalesContractService (line 1886)
5	Symfony\Component\DependencyInjection\Container::make (line 231)
6	Symfony\Component\DependencyInjection\Container::get (line 211)
7	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
8	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
9	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
11	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	handle (line 25)

1.09 ms
(13.18%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.status AS status_2
FROM
  page_category p0_
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      page p1_
    WHERE
      p1_.page_category_id = p0_.id
  ) > 0
ORDER BY
  p0_.status ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Controller\BaseController->response (line 224)
7	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 25)

0.78 ms
(9.44%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.meta_title AS meta_title_3,
  c0_.meta_description AS meta_description_4,
  c0_.meta_keyword AS meta_keyword_5,
  c0_.seo AS seo_6,
  c0_.order AS order_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\CategoryRepository->findAllCategories (line 72)
7	App\Controller\BaseController->response (line 219)
8	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 25)

0.56 ms
(6.82%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Controller\BaseController->response (line 120)
5	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 25)

0.54 ms
(6.58%)

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?

Parameters:

[
  "firstPageIsLogin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2
FROM
  setting s0_
WHERE
  s0_.`key` = ?

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = 'firstPageIsLogin';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 959)
6	App\Repository\SettingRepository->getSetting (line 17)
7	App\Repository\SettingRepository->getBoolean (line 21)
8	App\Controller\BaseController->__construct (line 59)
9	ContainerGH7gbdN\App_KernelDevDebugContainer->getSalesContractService (line 1886)
10	Symfony\Component\DependencyInjection\Container::make (line 231)
11	Symfony\Component\DependencyInjection\Container::get (line 211)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 40)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 26)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 96)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	handle (line 25)

0.48 ms
(5.78%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.seo AS seo_5,
  p0_.sortStatus AS sortStatus_6,
  p0_.page_category_id AS page_category_id_7
FROM
  page p0_
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Controller\BaseController->response (line 220)
7	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 25)

0.47 ms
(5.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.description AS description_7,
  t0.logo AS logo_8,
  t0.whatsapp AS whatsapp_9,
  t0.social_media AS social_media_10,
  t0.whatsapp_control AS whatsapp_control_11
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 799)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\BaseController->response (line 134)
6	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 25)

0.36 ms
(4.37%)

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = ? LIMIT 1

Parameters:

[
  "defaultCurrency"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3
FROM
  setting t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = 'defaultCurrency' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\BaseController->getCurrencies (line 366)
4	App\Controller\BaseController->response (line 158)
5	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 25)

0.36 ms
(4.35%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.seo AS seo_5,
  p0_.sortStatus AS sortStatus_6,
  p0_.page_category_id AS page_category_id_7
FROM
  page p0_
GROUP BY
  p0_.page_category_id

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Controller\BaseController->response (line 230)
7	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 25)

0.35 ms
(4.25%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4,
  t0.exchangeRate AS exchangeRate_5
FROM
  currency t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Controller\BaseController->getCurrencies (line 365)
5	App\Controller\BaseController->response (line 158)
6	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 25)

0.34 ms
(4.09%)

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.customer_number AS customer_number_4, c0_.is_discounted AS is_discounted_5, c0_.product_id AS product_id_6, c0_.user_id AS user_id_7, c0_.product_unit_id AS product_unit_id_8 FROM cart c0_ WHERE c0_.session_id = ?

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.var1 AS var1_2,
  c0_.quantity AS quantity_3,
  c0_.customer_number AS customer_number_4,
  c0_.is_discounted AS is_discounted_5,
  c0_.product_id AS product_id_6,
  c0_.user_id AS user_id_7,
  c0_.product_unit_id AS product_unit_id_8
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.customer_number AS customer_number_4, c0_.is_discounted AS is_discounted_5, c0_.product_id AS product_id_6, c0_.user_id AS user_id_7, c0_.product_unit_id AS product_unit_id_8 FROM cart c0_ WHERE c0_.session_id = NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\CartRepository->findCartItemsByCookie (line 26)
7	App\Controller\BaseController->getCart (line 404)
8	App\Controller\BaseController->response (line 182)
9	App\Controller\Catalog\FooterContracts\SalesContract->index (line 15)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 25)

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\Setting	58
App\Entity\Category	4
App\Entity\Currency	3
App\Entity\Store	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Setting	No errors.
App\Entity\Store	No errors.
App\Entity\Currency	No errors.
App\Entity\Cart	No errors.
App\Entity\Page	No errors.
App\Entity\PageCategory	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.

Symfony Profiler

GET https://devb2b.webticari.net/satis-sozlesmesi

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping