Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

11.02 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.02 ms
(100.00%)

SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  COUNT(a1_.id) AS sclr_2
FROM
  artisan_post a1_
  INNER JOIN category c0_ ON a1_.category_id = c0_.id
GROUP BY
  c0_.id,
  c0_.name
ORDER BY
  sclr_2 DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 100)
7	App\Repository\ArtisanPostRepository->findMostUsedCategories (line 23)
8	App\Service\ArtisanCategoryService->getMostUsedCategories (line 44)
9	App\Twig\WishlistExtension->getMostUsedCategories (line 102)
10	__TwigTemplate_186a6b0bfa758eac5f0d76ac83b41544->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 100)
16	__TwigTemplate_f0d35264450899d2aa96258172358766->doDisplay (line 388)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_ce9a7c693302bbaec039830d36285e63->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
27	App\Controller\SecurityController->login (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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\ArtisanPost	The field 'App\Entity\ArtisanPost#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\ArtisanPost#maxPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Category	No errors.

Symfony Profiler

GET http://7arfti.com/ar/login

Configuration Settings

Theme