Symfony Profiler

Query Metrics

12 Database Queries

10 Different statements

2.57 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.62 ms
(24.02%)

SELECT t0._id AS _id_1, t0.cost_inr AS cost_inr_2, t0.cost_usd AS cost_usd_3 FROM async_price t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.cost_inr AS cost_inr_2,
  t0.cost_usd AS cost_usd_3
FROM
  async_price t0
LIMIT
  1

SELECT t0._id AS _id_1, t0.cost_inr AS cost_inr_2, t0.cost_usd AS cost_usd_3 FROM async_price t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 14)
4	App\Service\AsyncPriceService->__construct (line 23)
5	Container7TZdUxV\getAsyncPriceServiceService::do (line 484)
6	Container7TZdUxV\App_KernelDevDebugContainer->load (line 389)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 57)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 37)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
12	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 6)

0.48 ms
(18.65%)

SELECT t0._id AS _id_1, t0.image AS image_2, t0.page AS page_3, t0.placement AS placement_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM brand t0 WHERE t0.page = ? AND t0.placement = ? ORDER BY t0.createdOn DESC

Parameters:

[
  "home"
  "universities"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.image AS image_2,
  t0.page AS page_3,
  t0.placement AS placement_4,
  t0.createdOn AS createdOn_5,
  t0.updatedOn AS updatedOn_6
FROM
  brand t0
WHERE
  t0.page = ?
  AND t0.placement = ?
ORDER BY
  t0.createdOn DESC

SELECT t0._id AS _id_1, t0.image AS image_2, t0.page AS page_3, t0.placement AS placement_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM brand t0 WHERE t0.page = 'home' AND t0.placement = 'universities' ORDER BY t0.createdOn DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 62)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.22 ms
(8.61%)

SELECT t0._id AS _id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM offer t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.active AS active_4,
  t0.createdOn AS createdOn_5,
  t0.updatedOn AS updatedOn_6
FROM
  offer t0
LIMIT
  1

SELECT t0._id AS _id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM offer t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 44)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.21 ms
(8.25%)

SELECT t0._id AS _id_1, t0.title AS title_2, t0.subhead AS subhead_3, t0.points AS points_4, t0.placement AS placement_5, t0.createdOn AS createdOn_6, t0.updatedOn AS updatedOn_7 FROM banner t0 WHERE t0.placement = ? LIMIT 1

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.title AS title_2,
  t0.subhead AS subhead_3,
  t0.points AS points_4,
  t0.placement AS placement_5,
  t0.createdOn AS createdOn_6,
  t0.updatedOn AS updatedOn_7
FROM
  banner t0
WHERE
  t0.placement = ?
LIMIT
  1

SELECT t0._id AS _id_1, t0.title AS title_2, t0.subhead AS subhead_3, t0.points AS points_4, t0.placement AS placement_5, t0.createdOn AS createdOn_6, t0.updatedOn AS updatedOn_7 FROM banner t0 WHERE t0.placement = 'home' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 47)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.21 ms
(8.10%)

SELECT t0._id AS _id_1, t0.name AS name_2, t0.type AS type_3, t0.country AS country_4, t0.date AS date_5, t0.feedback AS feedback_6, t0.dp AS dp_7, t0.placement AS placement_8, t0.ratings AS ratings_9, t0.createdOn AS createdOn_10, t0.updatedOn AS updatedOn_11 FROM testimonial t0 WHERE t0.placement = ? ORDER BY t0.createdOn DESC

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.country AS country_4,
  t0.date AS date_5,
  t0.feedback AS feedback_6,
  t0.dp AS dp_7,
  t0.placement AS placement_8,
  t0.ratings AS ratings_9,
  t0.createdOn AS createdOn_10,
  t0.updatedOn AS updatedOn_11
FROM
  testimonial t0
WHERE
  t0.placement = ?
ORDER BY
  t0.createdOn DESC

SELECT t0._id AS _id_1, t0.name AS name_2, t0.type AS type_3, t0.country AS country_4, t0.date AS date_5, t0.feedback AS feedback_6, t0.dp AS dp_7, t0.placement AS placement_8, t0.ratings AS ratings_9, t0.createdOn AS createdOn_10, t0.updatedOn AS updatedOn_11 FROM testimonial t0 WHERE t0.placement = 'home' ORDER BY t0.createdOn DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 50)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.20 ms
(7.79%)

SELECT t0._id AS _id_1, t0.title AS title_2, t0.description AS description_3, t0.active AS active_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6, t0.coupon_id AS coupon_id_7 FROM subscribe_popup t0 WHERE t0.active = ? 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.description AS description_3,
  t0.active AS active_4,
  t0.createdOn AS createdOn_5,
  t0.updatedOn AS updatedOn_6,
  t0.coupon_id AS coupon_id_7
FROM
  subscribe_popup t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0._id AS _id_1, t0.title AS title_2, t0.description AS description_3, t0.active AS active_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6, t0.coupon_id AS coupon_id_7 FROM subscribe_popup t0 WHERE t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 91)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.17 ms
(6.58%)

SELECT t0._id AS _id_1, t0.experience AS experience_2, t0.duration AS duration_3, t0.cost_inr AS cost_inr_4, t0.cost_usd AS cost_usd_5 FROM price t0 WHERE t0.duration = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.experience AS experience_2,
  t0.duration AS duration_3,
  t0.cost_inr AS cost_inr_4,
  t0.cost_usd AS cost_usd_5
FROM
  price t0
WHERE
  t0.duration = ?

SELECT t0._id AS _id_1, t0.experience AS experience_2, t0.duration AS duration_3, t0.cost_inr AS cost_inr_4, t0.cost_usd AS cost_usd_5 FROM price t0 WHERE t0.duration = 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.16 ms
(6.28%)

SELECT t0._id AS _id_1, t0.name AS name_2, t0.dp AS dp_3, t0.bio AS bio_4, t0.placement AS placement_5, t0.createdOn AS createdOn_6, t0.updatedOn AS updatedOn_7 FROM expert t0 WHERE t0.placement = ? ORDER BY t0.createdOn DESC

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.name AS name_2,
  t0.dp AS dp_3,
  t0.bio AS bio_4,
  t0.placement AS placement_5,
  t0.createdOn AS createdOn_6,
  t0.updatedOn AS updatedOn_7
FROM
  expert t0
WHERE
  t0.placement = ?
ORDER BY
  t0.createdOn DESC

SELECT t0._id AS _id_1, t0.name AS name_2, t0.dp AS dp_3, t0.bio AS bio_4, t0.placement AS placement_5, t0.createdOn AS createdOn_6, t0.updatedOn AS updatedOn_7 FROM expert t0 WHERE t0.placement = 'home' ORDER BY t0.createdOn DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 85)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.15 ms
(5.96%)

SELECT t0._id AS _id_1, t0.image AS image_2, t0.title AS title_3, t0.createdOn AS createdOn_4, t0.updatedOn AS updatedOn_5 FROM domain t0 ORDER BY t0.createdOn DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.image AS image_2,
  t0.title AS title_3,
  t0.createdOn AS createdOn_4,
  t0.updatedOn AS updatedOn_5
FROM
  domain t0
ORDER BY
  t0.createdOn DESC

SELECT t0._id AS _id_1, t0.image AS image_2, t0.title AS title_3, t0.createdOn AS createdOn_4, t0.updatedOn AS updatedOn_5 FROM domain t0 ORDER BY t0.createdOn DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 59)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 6)

0.15 ms
(5.77%)

SELECT t0._id AS _id_1, t0.quote AS quote_2, t0.domain_title AS domain_title_3, t0.domain_description AS domain_description_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM other t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._id AS _id_1,
  t0.quote AS quote_2,
  t0.domain_title AS domain_title_3,
  t0.domain_description AS domain_description_4,
  t0.createdOn AS createdOn_5,
  t0.updatedOn AS updatedOn_6
FROM
  other t0
LIMIT
  1

SELECT t0._id AS _id_1, t0.quote AS quote_2, t0.domain_title AS domain_title_3, t0.domain_description AS domain_description_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM other t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 56)
4	App\Controller\WebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Price	4
App\Entity\AsyncPrice	1
App\Entity\Offer	1
App\Entity\Banner	1
App\Entity\Testimonial	1
App\Entity\Other	1

Entities Mapping

Class	Mapping errors
App\Entity\AsyncPrice	No errors.
App\Entity\Offer	No errors.
App\Entity\Banner	No errors.
App\Entity\Testimonial	No errors.
App\Entity\Other	No errors.
App\Entity\Domain	No errors.
App\Entity\Brand	No errors.
App\Entity\Price	No errors.
App\Entity\Expert	No errors.
App\Entity\SubscribePopup	No errors.
App\Entity\Coupon	No errors.

Symfony Profiler

GET https://interviewbuddy.portfolio.kumardeepak.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping