Symfony Profiler

Query Metrics

44 Database Queries

12 Different statements

27.32 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.13 ms
(29.74%)

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.is_enabled = 1 AND m0_.parent_category_id = ? ORDER BY m0_.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.is_enabled AS is_enabled_2,
  m1_.name AS name_3,
  m2_.filename AS filename_4,
  m0_.image AS image_5,
  m1_.alias AS alias_6,
  m1_.meta_description AS meta_description_7,
  m3_.id AS id_8
FROM
  main_categories m0_
  LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id
  LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id
  LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id
WHERE
  m0_.del = 0
  AND m0_.del = ?
  AND m3_.id = ?
  AND m1_.lang_id = ?
  AND m0_.is_enabled = 1
  AND m0_.parent_category_id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = 0 AND m3_.id = 45 AND m1_.lang_id = 1 AND m0_.is_enabled = 1 AND m0_.parent_category_id = 45 ORDER BY m0_.position ASC;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 56)
7	App\Helper\Main\Product\CategoryHelper->getCategories (line 196)
8	App\Service\Twig\Extensions\Functions\CommonFunction->getCategoryList (line 114)
9	__TwigTemplate_f403abf7cdb35ca5cb6b60300b691fc6->doDisplay (line 402)
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 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
18	App\Controller\Main\DefaultController->header (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 154)
26	__TwigTemplate_579f79640374751d4c68554ebc2fbfd6->doDisplay (line 402)
27	Twig\Template->yield (line 65)
28	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
37	App\Controller\Main\Blog\BlogController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 10)

7.36 ms
(26.95%)

SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.short_title AS short_title_2,
  t0.name AS name_3,
  t0.is_default AS is_default_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  sys_langs t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.name AS name_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sys_langs t0 WHERE t0.is_default = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 11)
5	App\Helper\Main\Blog\BlogHelper->getDefaultLang (line 60)
6	App\Helper\Main\Blog\BlogHelper->getBlogList (line 92)
7	App\Helper\Main\Blog\BlogHelper->getBlog (line 37)
8	App\Controller\Main\Blog\BlogController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 10)

2.00 ms
(7.34%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.symbol AS symbol_3,
  t0.short_title AS short_title_4,
  t0.code AS code_5,
  t0.tcmb_code AS tcmb_code_6,
  t0.currency_number AS currency_number_7,
  t0.exchange_rate AS exchange_rate_8,
  t0.is_default AS is_default_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  sys_currencies t0
WHERE
  t0.short_title IS NULL
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title IS NULL AND t0.is_enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 166)
5	App\Helper\System\Currency\CurrencyHelper->getCurrency (line 115)
6	App\Helper\System\Currency\CurrencyHelper->currencySelectByVisitorInfo (line 106)
7	App\Helper\System\Currency\CurrencyHelper->currencyControl (line 49)
8	App\Subscriber\RequestSubscriber->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

1.96 ms
(7.16%)

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m1_.lang_id = ? AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.is_enabled AS is_enabled_2,
  m1_.name AS name_3,
  m2_.filename AS filename_4,
  m0_.image AS image_5,
  m1_.alias AS alias_6,
  m1_.meta_description AS meta_description_7,
  m3_.id AS id_8
FROM
  main_categories m0_
  LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id
  LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id
  LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id
WHERE
  m0_.del = 0
  AND m0_.del = ?
  AND m1_.lang_id = ?
  AND m3_.id IS NULL
  AND m0_.is_enabled = 1
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = 0 AND m1_.lang_id = 1 AND m3_.id IS NULL AND m0_.is_enabled = 1 ORDER BY m0_.position ASC;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 56)
7	App\Helper\Main\Product\CategoryHelper->getCategories (line 196)
8	App\Service\Twig\Extensions\Functions\CommonFunction->getCategoryList (line 48)
9	__TwigTemplate_f403abf7cdb35ca5cb6b60300b691fc6->doDisplay (line 402)
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 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
18	App\Controller\Main\DefaultController->header (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 154)
26	__TwigTemplate_579f79640374751d4c68554ebc2fbfd6->doDisplay (line 402)
27	Twig\Template->yield (line 65)
28	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
37	App\Controller\Main\Blog\BlogController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 10)

1.73 ms
(6.34%)

SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_enabled AS is_enabled_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  main_thema t0
WHERE
  t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM main_thema t0 WHERE t0.is_enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 68)
5	App\Helper\Main\Thema\ThemaHelper->selectThema (line 62)
6	App\Twig\AppExtension->getThemaType (line 129)
7	__TwigTemplate_579f79640374751d4c68554ebc2fbfd6->doDisplay (line 402)
8	Twig\Template->yield (line 65)
9	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
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 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
18	App\Controller\Main\Blog\BlogController->show (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 10)

1.37 ms
(5.03%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = ? AND t0.is_enabled = ? LIMIT 1

Parameters:

[
  "USD"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.symbol AS symbol_3,
  t0.short_title AS short_title_4,
  t0.code AS code_5,
  t0.tcmb_code AS tcmb_code_6,
  t0.currency_number AS currency_number_7,
  t0.exchange_rate AS exchange_rate_8,
  t0.is_default AS is_default_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  sys_currencies t0
WHERE
  t0.short_title = ?
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.symbol AS symbol_3, t0.short_title AS short_title_4, t0.code AS code_5, t0.tcmb_code AS tcmb_code_6, t0.currency_number AS currency_number_7, t0.exchange_rate AS exchange_rate_8, t0.is_default AS is_default_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM sys_currencies t0 WHERE t0.short_title = 'USD' AND t0.is_enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 44)
5	App\Helper\System\Currency\CurrencyHelper->changeCurrency (line 131)
6	App\Helper\System\Currency\CurrencyHelper->currencySelectByVisitorInfo (line 106)
7	App\Helper\System\Currency\CurrencyHelper->currencyControl (line 49)
8	App\Subscriber\RequestSubscriber->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

1.36 ms
(5.00%)

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.is_enabled AS is_enabled_2, m0_.image_file AS image_file_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5 FROM main_blogs m0_ LEFT JOIN main_blog_langs m1_ ON m0_.id = m1_.blog_id LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id WHERE s2_.id = ? AND m0_.is_enabled = 1 AND m1_.alias = ? ORDER BY m0_.id DESC LIMIT 1

Parameters:

[
  1
  "tavuk-yumurtasi-icin-kulucka-sartlari-nelerdir"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.uuid AS uuid_1,
  m0_.is_enabled AS is_enabled_2,
  m0_.image_file AS image_file_3,
  m0_.created_at AS created_at_4,
  m0_.updated_at AS updated_at_5
FROM
  main_blogs m0_
  LEFT JOIN main_blog_langs m1_ ON m0_.id = m1_.blog_id
  LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id
WHERE
  s2_.id = ?
  AND m0_.is_enabled = 1
  AND m1_.alias = ?
ORDER BY
  m0_.id DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.is_enabled AS is_enabled_2, m0_.image_file AS image_file_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5 FROM main_blogs m0_ LEFT JOIN main_blog_langs m1_ ON m0_.id = m1_.blog_id LEFT JOIN sys_langs s2_ ON m1_.lang_id = s2_.id WHERE s2_.id = 1 AND m0_.is_enabled = 1 AND m1_.alias = 'tavuk-yumurtasi-icin-kulucka-sartlari-nelerdir' ORDER BY m0_.id DESC LIMIT 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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 100)
7	App\Helper\Main\Blog\BlogHelper->getBlog (line 37)
8	App\Controller\Main\Blog\BlogController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 10)

1.34 ms
(4.89%)

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = ? AND m3_.id = ? AND m1_.lang_id = ? AND m0_.parent_category_id = ? ORDER BY m0_.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.is_enabled AS is_enabled_2,
  m1_.name AS name_3,
  m2_.filename AS filename_4,
  m0_.image AS image_5,
  m1_.alias AS alias_6,
  m1_.meta_description AS meta_description_7,
  m3_.id AS id_8
FROM
  main_categories m0_
  LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id
  LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id
  LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id
WHERE
  m0_.del = 0
  AND m0_.del = ?
  AND m3_.id = ?
  AND m1_.lang_id = ?
  AND m0_.parent_category_id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m1_.name AS name_3, m2_.filename AS filename_4, m0_.image AS image_5, m1_.alias AS alias_6, m1_.meta_description AS meta_description_7, m3_.id AS id_8 FROM main_categories m0_ LEFT JOIN main_categories m3_ ON m0_.parent_category_id = m3_.id LEFT JOIN main_category_lang m1_ ON m0_.id = m1_.category_id LEFT JOIN main_category_images m2_ ON m0_.id = m2_.category_id WHERE m0_.del = 0 AND m0_.del = 0 AND m3_.id = 45 AND m1_.lang_id = 1 AND m0_.parent_category_id = 45 ORDER BY m0_.position ASC;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 56)
7	App\Helper\Main\Product\CategoryHelper->getCategories (line 196)
8	App\Service\Twig\Extensions\Functions\CommonFunction->getCategoryList (line 368)
9	__TwigTemplate_f403abf7cdb35ca5cb6b60300b691fc6->doDisplay (line 402)
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 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
18	App\Controller\Main\DefaultController->header (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 154)
26	__TwigTemplate_579f79640374751d4c68554ebc2fbfd6->doDisplay (line 402)
27	Twig\Template->yield (line 65)
28	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
37	App\Controller\Main\Blog\BlogController->show (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 10)

0.67 ms
(2.44%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.blog_id AS blog_id_9, t0.lang_id AS lang_id_10 FROM main_blog_langs t0 WHERE t0.blog_id = ? AND t0.lang_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.alias AS alias_3,
  t0.description AS description_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.blog_id AS blog_id_9,
  t0.lang_id AS lang_id_10
FROM
  main_blog_langs t0
WHERE
  t0.blog_id = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.blog_id AS blog_id_9, t0.lang_id AS lang_id_10 FROM main_blog_langs t0 WHERE t0.blog_id = 4 AND t0.lang_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 28)
5	App\Helper\Main\Blog\BlogHelper->getBlogLang (line 187)
6	App\Service\Twig\Extensions\Functions\EntityLangFunction->getBlogLang (line 56)
7	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
16	App\Controller\Main\Blog\BlogController->show (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 10)

0.58 ms
(2.11%)

SELECT t0.id AS id_1, t0.system_mail AS system_mail_2, t0.system_phone AS system_phone_3, t0.system_instagram AS system_instagram_4, t0.system_linkedin AS system_linkedin_5, t0.system_youtube AS system_youtube_6, t0.system_pinterest AS system_pinterest_7, t0.google_analystic_code AS google_analystic_code_8, t0.monthly_order_target AS monthly_order_target_9, t0.yearly_order_target AS yearly_order_target_10, t0.logo AS logo_11, t0.logo_sabit_menu AS logo_sabit_menu_12, t0.logo_footer AS logo_footer_13, t0.favicon AS favicon_14, t0.free_shipping_limit AS free_shipping_limit_15, t0.cargo_price AS cargo_price_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM main_setting_global_settings t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.system_mail AS system_mail_2,
  t0.system_phone AS system_phone_3,
  t0.system_instagram AS system_instagram_4,
  t0.system_linkedin AS system_linkedin_5,
  t0.system_youtube AS system_youtube_6,
  t0.system_pinterest AS system_pinterest_7,
  t0.google_analystic_code AS google_analystic_code_8,
  t0.monthly_order_target AS monthly_order_target_9,
  t0.yearly_order_target AS yearly_order_target_10,
  t0.logo AS logo_11,
  t0.logo_sabit_menu AS logo_sabit_menu_12,
  t0.logo_footer AS logo_footer_13,
  t0.favicon AS favicon_14,
  t0.free_shipping_limit AS free_shipping_limit_15,
  t0.cargo_price AS cargo_price_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  main_setting_global_settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.system_mail AS system_mail_2, t0.system_phone AS system_phone_3, t0.system_instagram AS system_instagram_4, t0.system_linkedin AS system_linkedin_5, t0.system_youtube AS system_youtube_6, t0.system_pinterest AS system_pinterest_7, t0.google_analystic_code AS google_analystic_code_8, t0.monthly_order_target AS monthly_order_target_9, t0.yearly_order_target AS yearly_order_target_10, t0.logo AS logo_11, t0.logo_sabit_menu AS logo_sabit_menu_12, t0.logo_footer AS logo_footer_13, t0.favicon AS favicon_14, t0.free_shipping_limit AS free_shipping_limit_15, t0.cargo_price AS cargo_price_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM main_setting_global_settings t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 27)
7	App\Helper\Main\Setting\GlobalSetting\GlobalSettingHelper->getSetting (line 131)
8	App\Service\Twig\Extensions\Functions\SiteFunction->getSetting (line 67)
9	__TwigTemplate_579f79640374751d4c68554ebc2fbfd6->doDisplay (line 402)
10	Twig\Template->yield (line 65)
11	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
20	App\Controller\Main\Blog\BlogController->show (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.42 ms
(1.53%)

SELECT t0.id AS id_1, t0.alias AS alias_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM main_pages t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.alias AS alias_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  main_pages t0

SELECT t0.id AS id_1, t0.alias AS alias_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM main_pages t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 52)
6	App\Twig\AppExtension->getGlobals (line 359)
7	Twig\ExtensionSet->getGlobals (line 900)
8	Twig\Environment->getGlobals (line 398)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 333)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
17	App\Controller\Main\Blog\BlogController->show (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 10)

0.41 ms
(1.49%)

SELECT t0.id AS id_1, t0.baslama_tarihi AS baslama_tarihi_2, t0.bitis_tarihi AS bitis_tarihi_3, t0.alan_adi AS alan_adi_4, t0.tip_alias AS tip_alias_5, t0.tema_id AS tema_id_6, t0.abone_paket_id AS abone_paket_id_7 FROM firma_site_ayar t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.baslama_tarihi AS baslama_tarihi_2,
  t0.bitis_tarihi AS bitis_tarihi_3,
  t0.alan_adi AS alan_adi_4,
  t0.tip_alias AS tip_alias_5,
  t0.tema_id AS tema_id_6,
  t0.abone_paket_id AS abone_paket_id_7
FROM
  firma_site_ayar t0
LIMIT
  1

SELECT t0.id AS id_1, t0.baslama_tarihi AS baslama_tarihi_2, t0.bitis_tarihi AS bitis_tarihi_3, t0.alan_adi AS alan_adi_4, t0.tip_alias AS tip_alias_5, t0.tema_id AS tema_id_6, t0.abone_paket_id AS abone_paket_id_7 FROM firma_site_ayar t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 186)
5	App\Service\Php\Core\SystemSettings->getSiteAyar (line 197)
6	App\Service\Php\Core\SystemSettings->uyelikKalanSure (line 72)
7	App\Twig\AppExtension->uyelikKalanSure (line 52)
8	__TwigTemplate_579f79640374751d4c68554ebc2fbfd6->doDisplay (line 402)
9	Twig\Template->yield (line 65)
10	__TwigTemplate_ac8b800f842324bd9b7d467cae8e403a->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
19	App\Controller\Main\Blog\BlogController->show (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 10)

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\Main\Page\Page	8
App\Entity\System\Lang	1
App\Entity\Main\Blog\Blog	1
App\Entity\Main\Blog\BlogLang	1
App\Entity\FirmaSiteAyar	1
App\Entity\Main\Setting\GlobalSetting	1
App\Entity\Main\Thema\Thema	1

Entities Mapping

Class	Mapping errors
App\Entity\System\Currency	No errors.
App\Entity\System\Lang	No errors.
App\Entity\Main\Banner\BannerLang	No errors.
App\Entity\Main\Blog\BlogLang	No errors.
App\Entity\Main\Campaign\CampaignLang	No errors.
App\Entity\Main\Product\CategoryLang	No errors.
App\Entity\Main\Product\ProductLang	No errors.
App\Entity\Main\Faq\FaqLang	No errors.
App\Entity\Main\PopUp\PopUpLang	No errors.
App\Entity\Main\Product\VariantLang	No errors.
App\Entity\Main\Product\VariantValueLang	No errors.
App\Entity\Main\Setting\GlobalSettingLang	No errors.
App\Entity\Main\StaticText\StaticTextLang	No errors.
App\Entity\Main\Video\VideoLang	No errors.
App\Entity\Main\Instagram\InstagramLang	No errors.
App\Entity\Main\Blog\Blog	No errors.
App\Entity\Main\Product\Product	No errors.
App\Entity\Main\Page\Page	No errors.
App\Entity\Main\Page\PageLang	No errors.
App\Entity\Main\Page\PageSection	No errors.
App\Entity\FirmaSiteAyar	No errors.
App\Entity\Tema	No errors.
App\Entity\AbonePaket	No errors.
App\Entity\Main\Setting\GlobalSetting	No errors.
App\Entity\Main\Thema\Thema	No errors.
App\Entity\Main\Product\Category	No errors.
App\Entity\Main\Product\CategoryImages	No errors.

Symfony Profiler

GET https://thema5.e-ticaret.biz/_fragment?_path=_format%3Dhtml%26_locale%3Dtr%26_controller%3DApp%255CController%255CMain%255CDefaultController%253A%253Aheader

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping