Symfony Profiler

Query Metrics

54 Database Queries

21 Different statements

31.47 ms Query time

0 Invalid entities

50 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.34 ms
(23.31%)

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 67)
28	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->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 388)
37	App\Controller\Main\Product\ProductController->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)

6.96 ms
(22.10%)

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\Product\Product\ProductHelper->getDefaultLang (line 374)
6	App\Helper\Main\Product\Product\ProductHelper->getProductLang (line 96)
7	App\Service\Twig\Extensions\Functions\EntityLangFunction->getProductLang (line 56)
8	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->doDisplay (line 402)
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 388)
17	App\Controller\Main\Product\ProductController->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)

1.95 ms
(6.20%)

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.79 ms
(5.68%)

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 385)
5	App\Controller\Main\Product\ProductController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 10)

1.57 ms
(4.99%)

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 67)
28	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->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 388)
37	App\Controller\Main\Product\ProductController->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.29 ms
(4.10%)

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.16 ms
(3.69%)

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 67)
28	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->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 388)
37	App\Controller\Main\Product\ProductController->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.02 ms
(3.24%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.del = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sira AS sira_3,
  t0.barcode AS barcode_4,
  t0.product_code AS product_code_5,
  t0.is_enabled AS is_enabled_6,
  t0.del AS del_7,
  t0.new_product AS new_product_8,
  t0.show_home AS show_home_9,
  t0.is_variant AS is_variant_10,
  t0.avarage_rating AS avarage_rating_11,
  t0.total_visited AS total_visited_12,
  t0.position AS position_13,
  t0.total_sales AS total_sales_14,
  t0.audio_file AS audio_file_15,
  t0.uuid AS uuid_16,
  t0.length AS length_17,
  t0.depth AS depth_18,
  t0.height AS height_19,
  t0.weight AS weight_20,
  t0.product_material AS product_material_21,
  t0.product_color AS product_color_22,
  t0.product_suggestion AS product_suggestion_23,
  t0.product_paint_type AS product_paint_type_24,
  t0.delivery_time AS delivery_time_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.is_jewel_price AS is_jewel_price_28,
  t0.brand_id AS brand_id_29,
  t0.main_category_id AS main_category_id_30,
  t0.blog_id AS blog_id_31,
  t32.id AS id_33,
  t32.amount AS amount_34,
  t32.created_at AS created_at_35,
  t32.updated_at AS updated_at_36,
  t32.product_id AS product_id_37,
  t32.jewel_id AS jewel_id_38
FROM
  main_products t0
  LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id
WHERE
  t0.del = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.del = 0;

#	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 372)
5	App\Controller\Main\Product\ProductController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 10)

1.01 ms
(3.22%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6, t0.lang_id AS lang_id_7 FROM main_page_langs t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.page_id AS page_id_6,
  t0.lang_id AS lang_id_7
FROM
  main_page_langs t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6, t0.lang_id AS lang_id_7 FROM main_page_langs t0 WHERE t0.id = 11 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 376)
5	App\Controller\Main\Product\ProductController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 10)

1.00 ms
(3.16%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sira AS sira_3,
  t0.barcode AS barcode_4,
  t0.product_code AS product_code_5,
  t0.is_enabled AS is_enabled_6,
  t0.del AS del_7,
  t0.new_product AS new_product_8,
  t0.show_home AS show_home_9,
  t0.is_variant AS is_variant_10,
  t0.avarage_rating AS avarage_rating_11,
  t0.total_visited AS total_visited_12,
  t0.position AS position_13,
  t0.total_sales AS total_sales_14,
  t0.audio_file AS audio_file_15,
  t0.uuid AS uuid_16,
  t0.length AS length_17,
  t0.depth AS depth_18,
  t0.height AS height_19,
  t0.weight AS weight_20,
  t0.product_material AS product_material_21,
  t0.product_color AS product_color_22,
  t0.product_suggestion AS product_suggestion_23,
  t0.product_paint_type AS product_paint_type_24,
  t0.delivery_time AS delivery_time_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.is_jewel_price AS is_jewel_price_28,
  t0.brand_id AS brand_id_29,
  t0.main_category_id AS main_category_id_30,
  t0.blog_id AS blog_id_31,
  t32.id AS id_33,
  t32.amount AS amount_34,
  t32.created_at AS created_at_35,
  t32.updated_at AS updated_at_36,
  t32.product_id AS product_id_37,
  t32.jewel_id AS jewel_id_38
FROM
  main_products t0
  LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.sira AS sira_3, t0.barcode AS barcode_4, t0.product_code AS product_code_5, t0.is_enabled AS is_enabled_6, t0.del AS del_7, t0.new_product AS new_product_8, t0.show_home AS show_home_9, t0.is_variant AS is_variant_10, t0.avarage_rating AS avarage_rating_11, t0.total_visited AS total_visited_12, t0.position AS position_13, t0.total_sales AS total_sales_14, t0.audio_file AS audio_file_15, t0.uuid AS uuid_16, t0.length AS length_17, t0.depth AS depth_18, t0.height AS height_19, t0.weight AS weight_20, t0.product_material AS product_material_21, t0.product_color AS product_color_22, t0.product_suggestion AS product_suggestion_23, t0.product_paint_type AS product_paint_type_24, t0.delivery_time AS delivery_time_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_jewel_price AS is_jewel_price_28, t0.brand_id AS brand_id_29, t0.main_category_id AS main_category_id_30, t0.blog_id AS blog_id_31, t32.id AS id_33, t32.amount AS amount_34, t32.created_at AS created_at_35, t32.updated_at AS updated_at_36, t32.product_id AS product_id_37, t32.jewel_id AS jewel_id_38 FROM main_products t0 LEFT JOIN main_product_jewels t32 ON t32.product_id = t0.id 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 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 10)

0.99 ms
(3.15%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 913)
5	App\Helper\Main\Product\Product\ProductHelper->updateTotalVisited (line 369)
6	App\Controller\Main\Product\ProductController->show (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 10)

0.70 ms
(2.23%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.description AS description_4, t0.description_long AS description_long_5, t0.description_cargo AS description_cargo_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.short_description AS short_description_10, t0.product_id AS product_id_11, t0.lang_id AS lang_id_12 FROM main_product_lang t0 WHERE t0.lang_id = ? AND t0.product_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.description AS description_4,
  t0.description_long AS description_long_5,
  t0.description_cargo AS description_cargo_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.short_description AS short_description_10,
  t0.product_id AS product_id_11,
  t0.lang_id AS lang_id_12
FROM
  main_product_lang t0
WHERE
  t0.lang_id = ?
  AND t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.description AS description_4, t0.description_long AS description_long_5, t0.description_cargo AS description_cargo_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.short_description AS short_description_10, t0.product_id AS product_id_11, t0.lang_id AS lang_id_12 FROM main_product_lang t0 WHERE t0.lang_id = 1 AND t0.product_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 375)
5	App\Helper\Main\Product\Product\ProductHelper->getProductLang (line 96)
6	App\Service\Twig\Extensions\Functions\EntityLangFunction->getProductLang (line 56)
7	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->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 388)
16	App\Controller\Main\Product\ProductController->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.65 ms
(2.07%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.rating AS rating_4, t0.is_enabled AS is_enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8, t0.user_id AS user_id_9 FROM main_product_reviews t0 WHERE t0.is_enabled = ? AND t0.product_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.comment AS comment_3,
  t0.rating AS rating_4,
  t0.is_enabled AS is_enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.product_id AS product_id_8,
  t0.user_id AS user_id_9
FROM
  main_product_reviews t0
WHERE
  t0.is_enabled = ?
  AND t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.rating AS rating_4, t0.is_enabled AS is_enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8, t0.user_id AS user_id_9 FROM main_product_reviews t0 WHERE t0.is_enabled = 1 AND t0.product_id = 1;

#	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 380)
5	App\Controller\Main\Product\ProductController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 10)

0.63 ms
(2.00%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.resim AS resim_3, t0.taksit1 AS taksit1_4, t0.taksit2 AS taksit2_5, t0.taksit3 AS taksit3_6, t0.taksit6 AS taksit6_7, t0.taksit9 AS taksit9_8, t0.taksit12 AS taksit12_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM main_credit_card t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.resim AS resim_3,
  t0.taksit1 AS taksit1_4,
  t0.taksit2 AS taksit2_5,
  t0.taksit3 AS taksit3_6,
  t0.taksit6 AS taksit6_7,
  t0.taksit9 AS taksit9_8,
  t0.taksit12 AS taksit12_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  main_credit_card t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.resim AS resim_3, t0.taksit1 AS taksit1_4, t0.taksit2 AS taksit2_5, t0.taksit3 AS taksit3_6, t0.taksit6 AS taksit6_7, t0.taksit9 AS taksit9_8, t0.taksit12 AS taksit12_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM main_credit_card 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 374)
6	App\Controller\Main\Product\ProductController->show (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 10)

0.61 ms
(1.93%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.simular_product_id AS simular_product_id_3 FROM main_simular_products t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.simular_product_id AS simular_product_id_3
FROM
  main_simular_products t0

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.simular_product_id AS simular_product_id_3 FROM main_simular_products 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 373)
6	App\Controller\Main\Product\ProductController->show (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 10)

0.56 ms
(1.79%)

UPDATE main_products SET total_visited = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  main_products
SET
  total_visited = ?
WHERE
  id = ?

UPDATE main_products SET total_visited = 65 WHERE id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 496)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 380)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1139)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 407)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 913)
7	App\Helper\Main\Product\Product\ProductHelper->updateTotalVisited (line 369)
8	App\Controller\Main\Product\ProductController->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)

0.53 ms
(1.70%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.comment AS comment_2, m0_.rating AS rating_3, m0_.is_enabled AS is_enabled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.product_id AS product_id_7, m0_.user_id AS user_id_8 FROM main_product_reviews m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id WHERE m1_.id = ? AND m0_.is_enabled = 1 ORDER BY m0_.id DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.comment AS comment_2,
  m0_.rating AS rating_3,
  m0_.is_enabled AS is_enabled_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.product_id AS product_id_7,
  m0_.user_id AS user_id_8
FROM
  main_product_reviews m0_
  LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id
WHERE
  m1_.id = ?
  AND m0_.is_enabled = 1
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.comment AS comment_2, m0_.rating AS rating_3, m0_.is_enabled AS is_enabled_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.product_id AS product_id_7, m0_.user_id AS user_id_8 FROM main_product_reviews m0_ LEFT JOIN main_products m1_ ON m0_.product_id = m1_.id WHERE m1_.id = 1 AND m0_.is_enabled = 1 ORDER BY m0_.id 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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 212)
7	App\Service\Twig\Extensions\Functions\SiteFunction->getProductReviews (line 60)
8	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->doDisplay (line 402)
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 388)
17	App\Controller\Main\Product\ProductController->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.51 ms
(1.64%)

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 67)
11	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->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 388)
20	App\Controller\Main\Product\ProductController->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.43 ms
(1.36%)

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 67)
10	__TwigTemplate_554af03f38c57b47f7d0391b7396d9cf->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 388)
19	App\Controller\Main\Product\ProductController->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)

0.41 ms
(1.31%)

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 388)
17	App\Controller\Main\Product\ProductController->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.35 ms
(1.11%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 913)
4	App\Helper\Main\Product\Product\ProductHelper->updateTotalVisited (line 369)
5	App\Controller\Main\Product\ProductController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Product\SimularProduct	19
App\Entity\Main\Product\Product	12
App\Entity\Main\Page\Page	9
App\Entity\Main\Product\Category	3
App\Entity\Main\Order\CreditCart	1
App\Entity\Main\Page\PageLang	1
App\Entity\System\Lang	1
App\Entity\Main\Thema\Thema	1
App\Entity\Main\Product\ProductLang	1
App\Entity\FirmaSiteAyar	1
App\Entity\Main\Setting\GlobalSetting	1

Entities Mapping

Class	Mapping errors
App\Entity\System\Currency	No errors.
App\Entity\Main\Product\Product	No errors.
App\Entity\Main\Product\Brand	No errors.
App\Entity\Main\Product\Category	No errors.
App\Entity\Main\Blog\Blog	No errors.
App\Entity\Main\Product\ProductJewel	No errors.
App\Entity\System\Jewel	No errors.
App\Entity\Main\Product\ProductGroupAssing	No errors.
App\Entity\Main\Product\ProductImages	No errors.
App\Entity\Main\Product\ProductCatalogMarker	No errors.
App\Entity\Main\Product\ProductLang	No errors.
App\Entity\Main\Product\ProductOtherCategory	No errors.
App\Entity\Main\Product\ProductVariant	No errors.
App\Entity\Main\Product\ProductPricing	No errors.
App\Entity\Main\Product\ProductReview	No errors.
App\Entity\Main\Product\ProductVariantAssing	No errors.
App\Entity\Main\Order\Cart	No errors.
App\Entity\Main\Order\OrderItem	No errors.
App\Entity\Main\Product\SimularProduct	No errors.
App\Entity\Main\Product\WishlistProduct	No errors.
App\Entity\Main\Product\ProductJewelPricing	No errors.
App\Entity\Main\Banner\Banner	No errors.
App\Entity\Main\Order\CreditCart	No errors.
App\Entity\Main\Page\PageLang	No errors.
App\Entity\Main\Page\Page	No errors.
App\Entity\System\Lang	No errors.
App\Entity\Auth\User	No errors.
App\Entity\Main\Thema\Thema	No errors.
App\Entity\Main\Page\PageSection	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\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\FirmaSiteAyar	No errors.
App\Entity\Tema	No errors.
App\Entity\AbonePaket	No errors.
App\Entity\Main\Setting\GlobalSetting	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