Symfony Profiler

Query Metrics

21 Database Queries

10 Different statements

10.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.96 ms
(27.42%)

SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT b0_.id) AS sclr_0
FROM
  blog b0_
  LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id

SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerRM3ujOd\PaginatorProxy9cc2a8f->paginate (line 106)
16	App\Repository\BlogRepository->paginate (line 42)
17	App\Controller\BlogController->index (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 6)

2.67 ms
(24.80%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_name_ar AS site_name_ar_3,
  t0.description AS description_4,
  t0.description_ar AS description_ar_5,
  t0.favicon AS favicon_6,
  t0.logo AS logo_7,
  t0.logo_ar AS logo_ar_8,
  t0.header_tag AS header_tag_9,
  t0.header_tag_ar AS header_tag_ar_10,
  t0.copyright AS copyright_11,
  t0.copyright_ar AS copyright_ar_12,
  t0.social_link AS social_link_13,
  t0.contact_details AS contact_details_14,
  t0.meal_calories_approx AS meal_calories_approx_15,
  t0.earning_percentage AS earning_percentage_16,
  t0.earning_percentage_expert AS earning_percentage_expert_17,
  t0.earning_percentage_restaurant AS earning_percentage_restaurant_18,
  t0.account_approval_method AS account_approval_method_19,
  t0.favicon_ar AS favicon_ar_20,
  t0.contact_us_image AS contact_us_image_21,
  t0.max_delivery_distance AS max_delivery_distance_22,
  t0.cancel_duration_allowance AS cancel_duration_allowance_23,
  t0.program_commission AS program_commission_24,
  t0.restaurant_commission AS restaurant_commission_25,
  t0.platform_administrative_commission AS platform_administrative_commission_26
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 150)
5	App\Twig\AppExtension->getSettings (line 285)
6	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 50)
9	__TwigTemplate_51090f21c9d376b0628e61dbe2a0debb->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 54)
18	App\Controller\BlogController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 6)

1.58 ms
(14.64%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM tag 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.title_ar AS title_ar_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  tag t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM tag t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 36)
6	App\Controller\BlogController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 6)

1.22 ms
(11.28%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.title_ar AS title_ar_2, b0_.description AS description_3, b0_.description_ar AS description_ar_4, b0_.content AS content_5, b0_.content_ar AS content_ar_6, b0_.image AS image_7, b0_.published AS published_8, b0_.meta_tags AS meta_tags_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11, b0_.blog_category_id AS blog_category_id_12 FROM blog b0_ LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id WHERE b0_.id IN (?, ?, ?) ORDER BY b0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.title_ar AS title_ar_2,
  b0_.description AS description_3,
  b0_.description_ar AS description_ar_4,
  b0_.content AS content_5,
  b0_.content_ar AS content_ar_6,
  b0_.image AS image_7,
  b0_.published AS published_8,
  b0_.meta_tags AS meta_tags_9,
  b0_.created_at AS created_at_10,
  b0_.updated_at AS updated_at_11,
  b0_.blog_category_id AS blog_category_id_12
FROM
  blog b0_
  LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id
WHERE
  b0_.id IN (?, ?, ?)
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.title_ar AS title_ar_2, b0_.description AS description_3, b0_.description_ar AS description_ar_4, b0_.content AS content_5, b0_.content_ar AS content_ar_6, b0_.image AS image_7, b0_.published AS published_8, b0_.meta_tags AS meta_tags_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11, b0_.blog_category_id AS blog_category_id_12 FROM blog b0_ LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id WHERE b0_.id IN (8, 7, 6) ORDER BY b0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerRM3ujOd\PaginatorProxy9cc2a8f->paginate (line 106)
16	App\Repository\BlogRepository->paginate (line 42)
17	App\Controller\BlogController->index (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 6)

0.79 ms
(7.34%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.content AS content_6, t0.type AS type_7, t0.content_ar AS content_ar_8, t0.for_role AS for_role_9, t0.video AS video_10, t0.video_ar AS video_ar_11 FROM PAGE t0 WHERE t0.for_role IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_ar AS title_ar_3,
  t0.description AS description_4,
  t0.description_ar AS description_ar_5,
  t0.content AS content_6,
  t0.type AS type_7,
  t0.content_ar AS content_ar_8,
  t0.for_role AS for_role_9,
  t0.video AS video_10,
  t0.video_ar AS video_ar_11
FROM
  PAGE t0
WHERE
  t0.for_role IS NULL

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.content AS content_6, t0.type AS type_7, t0.content_ar AS content_ar_8, t0.for_role AS for_role_9, t0.video AS video_10, t0.video_ar AS video_ar_11 FROM PAGE t0 WHERE t0.for_role IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 94)
5	App\Twig\AppExtension->getAllPages (line 53)
6	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 357)
9	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 50)
12	__TwigTemplate_51090f21c9d376b0628e61dbe2a0debb->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 54)
21	App\Controller\BlogController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 6)

0.40 ms
(3.70%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category 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.title_ar AS title_ar_3
FROM
  blog_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 37)
6	App\Controller\BlogController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 6)

0.36 ms
(3.30%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.minor_units AS minor_units_3,
  t0.symbol AS symbol_4,
  t0.active AS active_5
FROM
  currencies t0

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	Doctrine\ORM\EntityRepository->findAll (line 187)
5	App\Twig\AppExtension->getAllCurrencies (line 117)
6	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 357)
9	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 50)
12	__TwigTemplate_51090f21c9d376b0628e61dbe2a0debb->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 54)
21	App\Controller\BlogController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 6)

0.32 ms
(2.97%)

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM blog b0_ LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id ORDER BY b0_.id DESC LIMIT 9

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.id AS id_1
FROM
  blog b0_
  LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id
ORDER BY
  b0_.id DESC
LIMIT
  9

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM blog b0_ LEFT JOIN blog_category b1_ ON b0_.blog_category_id = b1_.id ORDER BY b0_.id DESC LIMIT 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerRM3ujOd\PaginatorProxy9cc2a8f->paginate (line 106)
16	App\Repository\BlogRepository->paginate (line 42)
17	App\Controller\BlogController->index (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 6)

0.26 ms
(2.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.is_default AS is_default_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6 FROM price_lists 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.name AS name_2,
  t0.currency_code AS currency_code_3,
  t0.is_default AS is_default_4,
  t0.valid_from AS valid_from_5,
  t0.valid_to AS valid_to_6
FROM
  price_lists t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.is_default AS is_default_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6 FROM price_lists t0 WHERE t0.is_default = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 47)
4	App\Helper\CurrencyPriceHelper->getCurrentCurrency (line 212)
5	App\Twig\AppExtension->getDefaultCurrency (line 193)
6	App\Twig\AppExtension->getCurrentCurrency (line 99)
7	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 357)
10	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 50)
13	__TwigTemplate_51090f21c9d376b0628e61dbe2a0debb->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 54)
22	App\Controller\BlogController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 6)

0.23 ms
(2.15%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "OMR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.minor_units AS minor_units_3,
  t0.symbol AS symbol_4,
  t0.active AS active_5
FROM
  currencies t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = 'OMR' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 48)
4	App\Helper\CurrencyPriceHelper->getCurrentCurrency (line 212)
5	App\Twig\AppExtension->getDefaultCurrency (line 193)
6	App\Twig\AppExtension->getCurrentCurrency (line 99)
7	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 357)
10	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 50)
13	__TwigTemplate_51090f21c9d376b0628e61dbe2a0debb->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 54)
22	App\Controller\BlogController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 6)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Tag	No errors.
App\Entity\Blog	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\PriceList	No errors.
App\Entity\Currency	No errors.

Symfony Profiler

GET https://dev.badnii.com/php_info.php.bak/blogs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping