Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.72 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.19 ms

SELECT s0_.id AS id_0, s0_.width AS width_1, s0_.length AS length_2, s0_.thickness AS thickness_3, s0_.dimensions AS dimensions_4, s0_.quantity AS quantity_5, s0_.description AS description_6, s0_.image_name AS image_name_7, s0_.image_size AS image_size_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.type AS type_11, s0_.show_address AS show_address_12, s0_.price AS price_13, s0_.deleted AS deleted_14, s0_.name AS name_15, s0_.verified AS verified_16, s0_.decor_id AS decor_id_17, s0_.owner_id AS owner_id_18, s0_.plywood_type_id AS plywood_type_id_19 FROM surplus s0_ WHERE s0_.type = ? AND s0_.deleted = 0 AND s0_.verified = 1 ORDER BY s0_.id DESC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.width AS width_1,
  s0_.length AS length_2,
  s0_.thickness AS thickness_3,
  s0_.dimensions AS dimensions_4,
  s0_.quantity AS quantity_5,
  s0_.description AS description_6,
  s0_.image_name AS image_name_7,
  s0_.image_size AS image_size_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s0_.type AS type_11,
  s0_.show_address AS show_address_12,
  s0_.price AS price_13,
  s0_.deleted AS deleted_14,
  s0_.name AS name_15,
  s0_.verified AS verified_16,
  s0_.decor_id AS decor_id_17,
  s0_.owner_id AS owner_id_18,
  s0_.plywood_type_id AS plywood_type_id_19
FROM
  surplus s0_
WHERE
  s0_.type = ?
  AND s0_.deleted = 0
  AND s0_.verified = 1
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.width AS width_1, s0_.length AS length_2, s0_.thickness AS thickness_3, s0_.dimensions AS dimensions_4, s0_.quantity AS quantity_5, s0_.description AS description_6, s0_.image_name AS image_name_7, s0_.image_size AS image_size_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.type AS type_11, s0_.show_address AS show_address_12, s0_.price AS price_13, s0_.deleted AS deleted_14, s0_.name AS name_15, s0_.verified AS verified_16, s0_.decor_id AS decor_id_17, s0_.owner_id AS owner_id_18, s0_.plywood_type_id AS plywood_type_id_19 FROM surplus s0_ WHERE s0_.type = 0 AND s0_.deleted = 0 AND s0_.verified = 1 ORDER BY s0_.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 57)
7	App\Repository\SurplusRepository->findSearchedSurplus (line 211)
8	App\Controller\SurplusController->list (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 5)

3.53 ms

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.is_other AS is_other_2, b0_.hidden AS hidden_3 FROM brand b0_ WHERE b0_.hidden = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.is_other AS is_other_2,
  b0_.hidden AS hidden_3
FROM
  brand b0_
WHERE
  b0_.hidden = 0

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.is_other AS is_other_2, b0_.hidden AS hidden_3 FROM brand b0_ WHERE b0_.hidden = 0;

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 124)
24	App\Controller\SearchController->searchFrom (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 97)
32	__TwigTemplate_a6b9258041373cfe6ff0e76fb3ab001c->block_body (line 430)
33	Twig\Template->yieldBlock (line 113)
34	__TwigTemplate_f19dace10040baf46d12a3e8c214348f->doDisplay (line 360)
35	Twig\Template->yield (line 50)
36	__TwigTemplate_a6b9258041373cfe6ff0e76fb3ab001c->doDisplay (line 360)
37	Twig\Template->yield (line 335)
38	Twig\Template->render (line 38)
39	Twig\TemplateWrapper->render (line 307)
40	Twig\Environment->render (line 431)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 212)
44	App\Controller\SurplusController->list (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
47	Symfony\Component\HttpKernel\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	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\Surplus	No errors.
App\Entity\Decor	No errors.
App\Entity\User	No errors.
App\Entity\PlywoodType	No errors.
App\Entity\Brand	No errors.
App\Entity\DecorCollection	No errors.
App\Entity\Configurator	The mappings App\Entity\Configurator#fabricBrands and App\Entity\FabricBrand#configurators are inconsistent with each other.

Symfony Profiler

GET https://woodcycle.vps.ar-range.app/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CSearchController%253A%253AsearchFrom

Configuration Settings

Theme