Symfony Profiler

Query Metrics

57 Database Queries

5 Different statements

34.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.22 ms
(26.49%)

SELECT t0.id AS id_1, t0.uri AS uri_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.listing_id AS listing_id_5 FROM media t0 WHERE t0.listing_id = ?

Parameters:

[
  319
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uri AS uri_2,
  t0.type AS type_3,
  t0.created_at AS created_at_4,
  t0.listing_id AS listing_id_5
FROM
  media t0
WHERE
  t0.listing_id = ?

SELECT t0.id AS id_1, t0.uri AS uri_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.listing_id AS listing_id_5 FROM media t0 WHERE t0.listing_id = 319;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 409)
8	Doctrine\ORM\PersistentCollection->containsKey (line 498)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1476)
10	twig_get_attribute (line 51)
11	__TwigTemplate_f9ccfe4def516c16263f7e74fda4d65a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 1347)
16	twig_include (line 78)
17	__TwigTemplate_8bd8b8fb627539fa7b04f38dcafe01d1->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 379)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 1347)
22	twig_include (line 96)
23	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->block_body (line 171)
24	Twig\Template->displayBlock (line 96)
25	__TwigTemplate_b946d09f1186cc635aa1589eeb0e8e2c->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 49)
28	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 379)
31	Twig\Template->render (line 38)
32	Twig\TemplateWrapper->render (line 280)
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 27)
37	App\Controller\MainController->homepage (line 178)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

8.65 ms
(24.87%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.price AS price_3, t0.currency AS currency_4, t0.model_id AS model_id_5 FROM pricing t0 WHERE t0.id = ?

Parameters:

[
  321
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.price AS price_3,
  t0.currency AS currency_4,
  t0.model_id AS model_id_5
FROM
  pricing t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.price AS price_3, t0.currency AS currency_4, t0.model_id AS model_id_5 FROM pricing t0 WHERE t0.id = 321;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Pricing::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Pricing->__get (line 61)
8	App\Entity\Pricing->getPrice (line 1635)
9	twig_get_attribute (line 114)
10	__TwigTemplate_f9ccfe4def516c16263f7e74fda4d65a->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 1347)
15	twig_include (line 78)
16	__TwigTemplate_8bd8b8fb627539fa7b04f38dcafe01d1->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 1347)
21	twig_include (line 96)
22	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->block_body (line 171)
23	Twig\Template->displayBlock (line 96)
24	__TwigTemplate_b946d09f1186cc635aa1589eeb0e8e2c->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 49)
27	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->doDisplay (line 394)
28	Twig\Template->displayWithErrorHandling (line 367)
29	Twig\Template->display (line 379)
30	Twig\Template->render (line 38)
31	Twig\TemplateWrapper->render (line 280)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 27)
36	App\Controller\MainController->homepage (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

8.55 ms
(24.57%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_provider AS is_provider_6, t0.name AS name_7, t0.alias AS alias_8, t0.slug AS slug_9, t0.created_at AS created_at_10, t0.last_updated_at AS last_updated_at_11, t0.phone AS phone_12, t0.avatar AS avatar_13, t14.id AS id_15, t14.tagline AS tagline_16, t14.profile_status AS profile_status_17, t14.is_verified AS is_verified_18, t14.biography AS biography_19, t14.socials AS socials_20, t14.rating AS rating_21, t14.created_at AS created_at_22, t14.last_updated_at AS last_updated_at_23, t14.user_id AS user_id_24 FROM user t0 LEFT JOIN farmer_profile t14 ON t14.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  454
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.is_provider AS is_provider_6,
  t0.name AS name_7,
  t0.alias AS alias_8,
  t0.slug AS slug_9,
  t0.created_at AS created_at_10,
  t0.last_updated_at AS last_updated_at_11,
  t0.phone AS phone_12,
  t0.avatar AS avatar_13,
  t14.id AS id_15,
  t14.tagline AS tagline_16,
  t14.profile_status AS profile_status_17,
  t14.is_verified AS is_verified_18,
  t14.biography AS biography_19,
  t14.socials AS socials_20,
  t14.rating AS rating_21,
  t14.created_at AS created_at_22,
  t14.last_updated_at AS last_updated_at_23,
  t14.user_id AS user_id_24
FROM
  user t0
  LEFT JOIN farmer_profile t14 ON t14.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_provider AS is_provider_6, t0.name AS name_7, t0.alias AS alias_8, t0.slug AS slug_9, t0.created_at AS created_at_10, t0.last_updated_at AS last_updated_at_11, t0.phone AS phone_12, t0.avatar AS avatar_13, t14.id AS id_15, t14.tagline AS tagline_16, t14.profile_status AS profile_status_17, t14.is_verified AS is_verified_18, t14.biography AS biography_19, t14.socials AS socials_20, t14.rating AS rating_21, t14.created_at AS created_at_22, t14.last_updated_at AS last_updated_at_23, t14.user_id AS user_id_24 FROM user t0 LEFT JOIN farmer_profile t14 ON t14.user_id = t0.id WHERE t0.id = 454;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\User->__get (line 440)
8	App\Entity\User->getAvatar (line 1635)
9	twig_get_attribute (line 62)
10	__TwigTemplate_f9ccfe4def516c16263f7e74fda4d65a->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 1347)
15	twig_include (line 78)
16	__TwigTemplate_8bd8b8fb627539fa7b04f38dcafe01d1->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 1347)
21	twig_include (line 96)
22	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->block_body (line 171)
23	Twig\Template->displayBlock (line 96)
24	__TwigTemplate_b946d09f1186cc635aa1589eeb0e8e2c->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 49)
27	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->doDisplay (line 394)
28	Twig\Template->displayWithErrorHandling (line 367)
29	Twig\Template->display (line 379)
30	Twig\Template->render (line 38)
31	Twig\TemplateWrapper->render (line 280)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 27)
36	App\Controller\MainController->homepage (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

6.81 ms
(19.57%)

SELECT t0.id AS id_1, t0.tagline AS tagline_2, t0.profile_status AS profile_status_3, t0.is_verified AS is_verified_4, t0.biography AS biography_5, t0.socials AS socials_6, t0.rating AS rating_7, t0.created_at AS created_at_8, t0.last_updated_at AS last_updated_at_9, t0.user_id AS user_id_10 FROM farmer_profile t0 WHERE t0.id = ?

Parameters:

[
  134
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tagline AS tagline_2,
  t0.profile_status AS profile_status_3,
  t0.is_verified AS is_verified_4,
  t0.biography AS biography_5,
  t0.socials AS socials_6,
  t0.rating AS rating_7,
  t0.created_at AS created_at_8,
  t0.last_updated_at AS last_updated_at_9,
  t0.user_id AS user_id_10
FROM
  farmer_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.tagline AS tagline_2, t0.profile_status AS profile_status_3, t0.is_verified AS is_verified_4, t0.biography AS biography_5, t0.socials AS socials_6, t0.rating AS rating_7, t0.created_at AS created_at_8, t0.last_updated_at AS last_updated_at_9, t0.user_id AS user_id_10 FROM farmer_profile t0 WHERE t0.id = 134;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\FarmerProfile::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\FarmerProfile->__get (line 149)
8	App\Entity\FarmerProfile->getUser (line 1635)
9	twig_get_attribute (line 62)
10	__TwigTemplate_f9ccfe4def516c16263f7e74fda4d65a->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 1347)
15	twig_include (line 78)
16	__TwigTemplate_8bd8b8fb627539fa7b04f38dcafe01d1->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 1347)
21	twig_include (line 96)
22	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->block_body (line 171)
23	Twig\Template->displayBlock (line 96)
24	__TwigTemplate_b946d09f1186cc635aa1589eeb0e8e2c->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 49)
27	__TwigTemplate_91ec165b66799a407a3cc8017c86519b->doDisplay (line 394)
28	Twig\Template->displayWithErrorHandling (line 367)
29	Twig\Template->display (line 379)
30	Twig\Template->render (line 38)
31	Twig\TemplateWrapper->render (line 280)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 27)
36	App\Controller\MainController->homepage (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

1.56 ms
(4.49%)

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.area AS area_3, l0_.slug AS slug_4, l0_.created_at AS created_at_5, l0_.last_updated_at AS last_updated_at_6, l0_.short_description AS short_description_7, l0_.other AS other_8, l0_.is_published AS is_published_9, l0_.published_at AS published_at_10, l0_.min_duration AS min_duration_11, l0_.max_duration AS max_duration_12, l0_.duration_units AS duration_units_13, l0_.area_units AS area_units_14, l0_.map_drawing_data AS map_drawing_data_15, l0_.status AS status_16, l0_.farmer_id AS farmer_id_17, l0_.pricing_id AS pricing_id_18, l0_.address_id AS address_id_19 FROM listing l0_ LEFT JOIN pricing p1_ ON l0_.pricing_id = p1_.id WHERE p1_.enabled = ? AND l0_.is_published = ? ORDER BY l0_.id DESC LIMIT 16

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.description AS description_2,
  l0_.area AS area_3,
  l0_.slug AS slug_4,
  l0_.created_at AS created_at_5,
  l0_.last_updated_at AS last_updated_at_6,
  l0_.short_description AS short_description_7,
  l0_.other AS other_8,
  l0_.is_published AS is_published_9,
  l0_.published_at AS published_at_10,
  l0_.min_duration AS min_duration_11,
  l0_.max_duration AS max_duration_12,
  l0_.duration_units AS duration_units_13,
  l0_.area_units AS area_units_14,
  l0_.map_drawing_data AS map_drawing_data_15,
  l0_.status AS status_16,
  l0_.farmer_id AS farmer_id_17,
  l0_.pricing_id AS pricing_id_18,
  l0_.address_id AS address_id_19
FROM
  listing l0_
  LEFT JOIN pricing p1_ ON l0_.pricing_id = p1_.id
WHERE
  p1_.enabled = ?
  AND l0_.is_published = ?
ORDER BY
  l0_.id DESC
LIMIT
  16

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.area AS area_3, l0_.slug AS slug_4, l0_.created_at AS created_at_5, l0_.last_updated_at AS last_updated_at_6, l0_.short_description AS short_description_7, l0_.other AS other_8, l0_.is_published AS is_published_9, l0_.published_at AS published_at_10, l0_.min_duration AS min_duration_11, l0_.max_duration AS max_duration_12, l0_.duration_units AS duration_units_13, l0_.area_units AS area_units_14, l0_.map_drawing_data AS map_drawing_data_15, l0_.status AS status_16, l0_.farmer_id AS farmer_id_17, l0_.pricing_id AS pricing_id_18, l0_.address_id AS address_id_19 FROM listing l0_ LEFT JOIN pricing p1_ ON l0_.pricing_id = p1_.id WHERE p1_.enabled = 1 AND l0_.is_published = 1 ORDER BY l0_.id DESC LIMIT 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 52)
7	App\Repository\ListingRepository->findForHomepage (line 25)
8	App\Controller\MainController->homepage (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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\Listing	No errors.
App\Entity\Pricing	No errors.
App\Entity\FarmerProfile	No errors.
App\Entity\Address	No errors.
App\Entity\Produce	No errors.
App\Entity\Media	No errors.
App\Entity\Reservation	No errors.
App\Entity\ListingAvailability	No errors.
App\Entity\ListingFeature	No errors.
App\Entity\Polygon	No errors.
App\Entity\User	No errors.
App\Entity\Message	No errors.
App\Entity\Conversation	No errors.
App\Entity\Notification	No errors.
App\Entity\PricingModel	No errors.

Symfony Profiler

GET http://agribit.io/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping