Symfony Profiler

Query Metrics

21 Database Queries

8 Different statements

26.09 ms Query time

3 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.16 ms
(27.44%)

SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.contact AS contact_3,
  t0.phone1 AS phone1_4,
  t0.phone2 AS phone2_5,
  t0.phone3 AS phone3_6,
  t0.email2 AS email2_7,
  t0.email3 AS email3_8,
  t0.name AS name_9,
  t0.company_name AS company_name_10,
  t0.web_address AS web_address_11,
  t0.callback_url AS callback_url_12,
  t0.pay_now_commission_percent AS pay_now_commission_percent_13,
  t0.pay_later_commission_percent AS pay_later_commission_percent_14,
  t0.instalment_commission_percent AS instalment_commission_percent_15,
  t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16,
  t0.instalment4_commission_percent AS instalment4_commission_percent_17,
  t0.instalment6_commission_percent AS instalment6_commission_percent_18,
  t0.eik AS eik_19,
  t0.purchase_expiration_hours AS purchase_expiration_hours_20,
  t0.unshipped_purchase_days AS unshipped_purchase_days_21,
  t0.pay_now_allowed AS pay_now_allowed_22,
  t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23,
  t0.minimum_amount_for_payment AS minimum_amount_for_payment_24,
  t0.platform AS platform_25,
  t0.grace_start_date AS grace_start_date_26,
  t0.grace_duration_days AS grace_duration_days_27,
  t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.cover_image_id AS cover_image_id_31,
  t0.shop_id AS shop_id_32
FROM
  shop_profile t0
WHERE
  t0.shop_id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 878)
3	Doctrine\ORM\UnitOfWork->createEntity (line 3035)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 149)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 272)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1231)
9	Doctrine\ORM\AbstractQuery->execute (line 1172)
10	Doctrine\ORM\AbstractQuery->getResult (line 907)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
12	iterator_to_array (line 45)
13	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
18	Knp\Component\Pager\Paginator->paginate (line 97)
19	ContainerAa0bS1m\PaginatorProxy9cc2a8f->paginate (line 25)
20	App\Controller\PartnersController->index (line 42)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 7)

5.77 ms
(22.11%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1

Parameters:

[
  "partners_per_page"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.ui_label AS ui_label_2,
  s0_.value AS value_3,
  s0_.readonly AS readonly_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  setting s0_
WHERE
  s0_.name = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'partners_per_page' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
3	Doctrine\DBAL\Connection->executeQuery (line 1084)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
5	Doctrine\ORM\Query->_doExecute (line 330)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
7	Doctrine\ORM\AbstractQuery->execute (line 1172)
8	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 959)
9	App\Repository\SettingRepository->get (line 46)
10	App\Controller\BaseController->getSetting (line 39)
11	App\Controller\PartnersController->index (line 42)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 7)

4.44 ms
(17.04%)

SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.percent AS percent_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.shop_id AS shop_id_7
FROM
  instalment6_interest_rate_promotion t0
WHERE
  t0.shop_id = ?

SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 878)
3	Doctrine\ORM\UnitOfWork->createEntity (line 3035)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 149)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 272)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1231)
9	Doctrine\ORM\AbstractQuery->execute (line 1172)
10	Doctrine\ORM\AbstractQuery->getResult (line 907)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
12	iterator_to_array (line 45)
13	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
18	Knp\Component\Pager\Paginator->paginate (line 97)
19	ContainerAa0bS1m\PaginatorProxy9cc2a8f->paginate (line 25)
20	App\Controller\PartnersController->index (line 42)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 7)

3.21 ms
(12.30%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.position_index AS position_index_3, s1_.id AS id_4, s1_.name AS name_5, s1_.active AS active_6, s1_.position_index AS position_index_7, s0_.parent_id AS parent_id_8, s1_.parent_id AS parent_id_9 FROM shop_category s0_ LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id WHERE s0_.active = 1 ORDER BY s1_.position_index ASC, s0_.position_index ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.active AS active_2,
  s0_.position_index AS position_index_3,
  s1_.id AS id_4,
  s1_.name AS name_5,
  s1_.active AS active_6,
  s1_.position_index AS position_index_7,
  s0_.parent_id AS parent_id_8,
  s1_.parent_id AS parent_id_9
FROM
  shop_category s0_
  LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id
WHERE
  s0_.active = 1
ORDER BY
  s1_.position_index ASC,
  s0_.position_index ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.position_index AS position_index_3, s1_.id AS id_4, s1_.name AS name_5, s1_.active AS active_6, s1_.position_index AS position_index_7, s0_.parent_id AS parent_id_8, s1_.parent_id AS parent_id_9 FROM shop_category s0_ LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id WHERE s0_.active = 1 ORDER BY s1_.position_index ASC, s0_.position_index ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\ShopCategoryRepository->findAllOrdered (line 56)
7	App\Controller\PartnersController->index (line 47)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 7)

1.52 ms
(5.82%)

SELECT DISTINCT u0_.id AS id_0, u0_.position_index AS position_index_1 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.position_index AS position_index_1
FROM
  users u0_
WHERE
  (u0_.active = 1)
  AND u0_.dtype IN ('shop')
ORDER BY
  u0_.position_index ASC
LIMIT
  16

SELECT DISTINCT u0_.id AS id_0, u0_.position_index AS position_index_1 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 943)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 153)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerAa0bS1m\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\PartnersController->index (line 42)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 7)

1.47 ms
(5.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.size AS size_4, t0.original_name AS original_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dtype FROM file t0 WHERE t0.id = ? AND t0.dtype IN ('image')

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.mime AS mime_3,
  t0.size AS size_4,
  t0.original_name AS original_name_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.dtype
FROM
  file t0
WHERE
  t0.id = ?
  AND t0.dtype IN ('image')

SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.size AS size_4, t0.original_name AS original_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dtype FROM file t0 WHERE t0.id = 1 AND t0.dtype IN ('image');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 799)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 365)
4	Proxies\__CG__\App\Entity\Image::Doctrine\ORM\Proxy\{closure} (line 472)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Image->__get (line 184)
7	App\Entity\File->getName (line 39)
8	App\Entity\Image->getFilePath (line 13)
9	Twig\Extension\CoreExtension->getAttribute (line 1909)
10	__TwigTemplate_759c2c8573c0adf1559140c1fc988fca::block_content (line 339)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_c9594029a8492b24c1afff79719c89b7->doDisplay (line 173)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_759c2c8573c0adf1559140c1fc988fca->doDisplay (line 56)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
23	App\Controller\PartnersController->index (line 49)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 7)

1.45 ms
(5.56%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.`key` AS key_7, u0_.secret AS secret_8, u0_.shipping_confirmation_required AS shipping_confirmation_required_9, u0_.calculation_strategy AS calculation_strategy_10, u0_.developer_password AS developer_password_11, u0_.allowed_products AS allowed_products_12, u0_.position_index AS position_index_13, u0_.dtype AS dtype_14, u0_.receiving_bank_account_id AS receiving_bank_account_id_15, u0_.sending_bank_account_id AS sending_bank_account_id_16, u0_.api_token_id AS api_token_id_17 FROM users u0_ WHERE (u0_.active = 1 AND u0_.id IN (?, ?, ?, ?, ?, ?)) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.active AS active_4,
  u0_.created_at AS created_at_5,
  u0_.updated_at AS updated_at_6,
  u0_.`key` AS key_7,
  u0_.secret AS secret_8,
  u0_.shipping_confirmation_required AS shipping_confirmation_required_9,
  u0_.calculation_strategy AS calculation_strategy_10,
  u0_.developer_password AS developer_password_11,
  u0_.allowed_products AS allowed_products_12,
  u0_.position_index AS position_index_13,
  u0_.dtype AS dtype_14,
  u0_.receiving_bank_account_id AS receiving_bank_account_id_15,
  u0_.sending_bank_account_id AS sending_bank_account_id_16,
  u0_.api_token_id AS api_token_id_17
FROM
  users u0_
WHERE
  (
    u0_.active = 1
    AND u0_.id IN (?, ?, ?, ?, ?, ?)
  )
  AND u0_.dtype IN ('shop')
ORDER BY
  u0_.position_index ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.`key` AS key_7, u0_.secret AS secret_8, u0_.shipping_confirmation_required AS shipping_confirmation_required_9, u0_.calculation_strategy AS calculation_strategy_10, u0_.developer_password AS developer_password_11, u0_.allowed_products AS allowed_products_12, u0_.position_index AS position_index_13, u0_.dtype AS dtype_14, u0_.receiving_bank_account_id AS receiving_bank_account_id_15, u0_.sending_bank_account_id AS sending_bank_account_id_16, u0_.api_token_id AS api_token_id_17 FROM users u0_ WHERE (u0_.active = 1 AND u0_.id IN (9, 10, 11, 12, 13, 14)) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerAa0bS1m\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\PartnersController->index (line 42)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 7)

1.07 ms
(4.11%)

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  users u0_
WHERE
  (u0_.active = 1)
  AND u0_.dtype IN ('shop')

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 943)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerAa0bS1m\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\PartnersController->index (line 42)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 7)

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\User	6
App\Entity\ShopProfile	6
App\Entity\Instalment6InterestRatePromotion	6
App\Entity\Setting	4
App\Entity\File	1
App\Entity\ApiToken	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Shop	No errors.
App\Entity\Setting	No errors.
App\Entity\BankAccount	No errors.
App\Entity\ApiToken	No errors.
App\Entity\Permission\Group	No errors.
App\Entity\DatabaseNotification	No errors.
App\Entity\Purchase	The field 'App\Entity\Purchase#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ShopPayment	The field 'App\Entity\ShopPayment#payNowCommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ShopPayment#payLaterCommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ShopPayment#instalmentCommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ShopPayment#payLaterV2CommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ShopPayment#instalment4CommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ShopPayment#instalment6CommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ShopProfile	The field 'App\Entity\ShopProfile#minimumAmountForPayment' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\File	No errors.
App\Entity\Image	No errors.
App\Entity\Instalment6InterestRatePromotion	No errors.
App\Entity\ShopCategory	No errors.

Symfony Profiler

GET https://newpay6.ruychev.ssft.me/partners

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping