Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

19.04 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.77 ms
(61.82%)

SELECT r0_.rsid AS rsid_0, r0_.locale AS locale_1, r0_.category AS category_2, r0_.title AS title_3, r0_.author AS author_4, r0_.ingredients AS ingredients_5, r0_.tags AS tags_6, r0_.impressions AS impressions_7, r1_.uuid AS uuid_8, r1_.slug AS slug_9, r1_.cuuid AS cuuid_10, r1_.category AS category_11, r1_.title AS title_12, r1_.description AS description_13, r1_.preparation AS preparation_14, r1_.ingredients AS ingredients_15, r1_.translation AS translation_16, r1_.source AS source_17, r1_.author AS author_18, r1_.cover AS cover_19, r1_.images AS images_20, r1_.impressions AS impressions_21, r1_.created_at AS created_at_22, r1_.updated_at AS updated_at_23, r1_.active AS active_24, r0_.recipe AS recipe_25 FROM recipe_search r0_ INNER JOIN recipe r1_ ON r0_.recipe = r1_.uuid WHERE r0_.locale = ? AND ((r0_.category LIKE ? OR r0_.title LIKE ? OR r0_.ingredients LIKE ? OR r0_.author LIKE ? OR r0_.ingredients LIKE ? OR r0_.tags LIKE ?)) ORDER BY r0_.impressions DESC LIMIT 24 OFFSET 24

Parameters:

[
  "en"
  "%alma%o%%"
  "%alma%o%%"
  "%alma%o%%"
  "%alma%o%%"
  "%alma%o%%"
  "%alma%o%%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.rsid AS rsid_0,
  r0_.locale AS locale_1,
  r0_.category AS category_2,
  r0_.title AS title_3,
  r0_.author AS author_4,
  r0_.ingredients AS ingredients_5,
  r0_.tags AS tags_6,
  r0_.impressions AS impressions_7,
  r1_.uuid AS uuid_8,
  r1_.slug AS slug_9,
  r1_.cuuid AS cuuid_10,
  r1_.category AS category_11,
  r1_.title AS title_12,
  r1_.description AS description_13,
  r1_.preparation AS preparation_14,
  r1_.ingredients AS ingredients_15,
  r1_.translation AS translation_16,
  r1_.source AS source_17,
  r1_.author AS author_18,
  r1_.cover AS cover_19,
  r1_.images AS images_20,
  r1_.impressions AS impressions_21,
  r1_.created_at AS created_at_22,
  r1_.updated_at AS updated_at_23,
  r1_.active AS active_24,
  r0_.recipe AS recipe_25
FROM
  recipe_search r0_
  INNER JOIN recipe r1_ ON r0_.recipe = r1_.uuid
WHERE
  r0_.locale = ?
  AND (
    (
      r0_.category LIKE ?
      OR r0_.title LIKE ?
      OR r0_.ingredients LIKE ?
      OR r0_.author LIKE ?
      OR r0_.ingredients LIKE ?
      OR r0_.tags LIKE ?
    )
  )
ORDER BY
  r0_.impressions DESC
LIMIT
  24
OFFSET
  24

SELECT r0_.rsid AS rsid_0, r0_.locale AS locale_1, r0_.category AS category_2, r0_.title AS title_3, r0_.author AS author_4, r0_.ingredients AS ingredients_5, r0_.tags AS tags_6, r0_.impressions AS impressions_7, r1_.uuid AS uuid_8, r1_.slug AS slug_9, r1_.cuuid AS cuuid_10, r1_.category AS category_11, r1_.title AS title_12, r1_.description AS description_13, r1_.preparation AS preparation_14, r1_.ingredients AS ingredients_15, r1_.translation AS translation_16, r1_.source AS source_17, r1_.author AS author_18, r1_.cover AS cover_19, r1_.images AS images_20, r1_.impressions AS impressions_21, r1_.created_at AS created_at_22, r1_.updated_at AS updated_at_23, r1_.active AS active_24, r0_.recipe AS recipe_25 FROM recipe_search r0_ INNER JOIN recipe r1_ ON r0_.recipe = r1_.uuid WHERE r0_.locale = 'en' AND ((r0_.category LIKE '%alma%o%%' OR r0_.title LIKE '%alma%o%%' OR r0_.ingredients LIKE '%alma%o%%' OR r0_.author LIKE '%alma%o%%' OR r0_.ingredients LIKE '%alma%o%%' OR r0_.tags LIKE '%alma%o%%')) ORDER BY r0_.impressions DESC LIMIT 24 OFFSET 24;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\RecipeSearchRepository->searchByTerm (line 60)
7	App\Controller\SearchController->{closure:App\Controller\SearchController::index():40} (line 42)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Controller\SearchController->index (line 40)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
20	frankenphp_handle_request (line 57)
21	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
22	require_once (line 32)
23	require_once (line 5)

7.27 ms
(38.18%)

SELECT c0_.uuid AS uuid_0, c0_.slug AS slug_1, c0_.section AS section_2, c0_.name AS name_3, c0_.cover AS cover_4, c0_.active AS active_5, c0_.translation AS translation_6 FROM category c0_ WHERE c0_.active = ? ORDER BY c0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.uuid AS uuid_0,
  c0_.slug AS slug_1,
  c0_.section AS section_2,
  c0_.name AS name_3,
  c0_.cover AS cover_4,
  c0_.active AS active_5,
  c0_.translation AS translation_6
FROM
  category c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.name ASC

SELECT c0_.uuid AS uuid_0, c0_.slug AS slug_1, c0_.section AS section_2, c0_.name AS name_3, c0_.cover AS cover_4, c0_.active AS active_5, c0_.translation AS translation_6 FROM category c0_ WHERE c0_.active = 1 ORDER BY c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findAllActiveOrderedBy (line 34)
7	App\Controller\SearchController->{closure:App\Controller\SearchController::index():20} (line 22)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Controller\SearchController->index (line 20)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
20	frankenphp_handle_request (line 57)
21	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
22	require_once (line 32)
23	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Category	7

Entities Mapping

Class	Mapping errors
App\Entity\RecipeSearch	No errors.
App\Entity\Recipe	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://rey.sorin.dok.twn.ro/en/search?page=2&term=Alma%20O.

Configuration Settings

Theme

Page Width