Symfony Profiler

Query Metrics

16 Database Queries

12 Different statements

55.45 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

46.53 ms
(83.91%)

SELECT
  p.id,
  ts_rank((
  setweight(to_tsvector('german', coalesce(p.name,'')), 'A') ||
  setweight(to_tsvector('german', coalesce(p.teaser,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(p.seo_keywords,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(regexp_replace(p.content, '<[^>]+>', ' ', 'g'),'')), 'C')
), websearch_to_tsquery('german', ?)) AS rank,
  g.name AS group_name,
  g.slug AS group_slug,
  c.name AS category_name,
  c.slug AS category_slug,
  CASE WHEN c.id = ? THEN 1 ELSE 0 END AS same_category
FROM settings_content_page p
JOIN settings_content_group g ON g.id = p.group_id
JOIN settings_content_category c ON c.id = g.category_id
WHERE
  c.client_id = ?
  AND p.id <> ?
  AND ((
  setweight(to_tsvector('german', coalesce(p.name,'')), 'A') ||
  setweight(to_tsvector('german', coalesce(p.teaser,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(p.seo_keywords,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(regexp_replace(p.content, '<[^>]+>', ' ', 'g'),'')), 'C')
)) @@ websearch_to_tsquery('german', ?)
ORDER BY same_category DESC, rank DESC, p.updated_at DESC
LIMIT ?

Parameters:

[
  "analysierst OR die OR auslastung OR deiner OR objekte OR welche OR sind OR ausgebucht OR kaum OR gefragt"
  41
  2
  456
  "analysierst OR die OR auslastung OR deiner OR objekte OR welche OR sind OR ausgebucht OR kaum OR gefragt"
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.id,
  ts_rank(
    (
      setweight(
        to_tsvector(
          'german',
          coalesce(p.name, '')
        ),
        'A'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.teaser, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.seo_keywords, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(
            regexp_replace(p.content, '<[^>]+>', ' ', 'g'),
            ''
          )
        ),
        'C'
      )
    ),
    websearch_to_tsquery('german', ?)
  ) AS rank,
  g.name AS group_name,
  g.slug AS group_slug,
  c.name AS category_name,
  c.slug AS category_slug,
  CASE WHEN c.id = ? THEN
    1
  ELSE
    0
  END AS same_category
FROM
  settings_content_page p
  JOIN settings_content_group g ON g.id = p.group_id
  JOIN settings_content_category c ON c.id = g.category_id
WHERE
  c.client_id = ?
  AND p.id <> ?
  AND (
    (
      setweight(
        to_tsvector(
          'german',
          coalesce(p.name, '')
        ),
        'A'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.teaser, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.seo_keywords, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(
            regexp_replace(p.content, '<[^>]+>', ' ', 'g'),
            ''
          )
        ),
        'C'
      )
    )
  ) @@ websearch_to_tsquery('german', ?)
ORDER BY
  same_category DESC,
  rank DESC,
  p.updated_at DESC
LIMIT
  ?

SELECT
  p.id,
  ts_rank((
  setweight(to_tsvector('german', coalesce(p.name,'')), 'A') ||
  setweight(to_tsvector('german', coalesce(p.teaser,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(p.seo_keywords,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(regexp_replace(p.content, '<[^>]+>', ' ', 'g'),'')), 'C')
), websearch_to_tsquery('german', 'analysierst OR die OR auslastung OR deiner OR objekte OR welche OR sind OR ausgebucht OR kaum OR gefragt')) AS rank,
  g.name AS group_name,
  g.slug AS group_slug,
  c.name AS category_name,
  c.slug AS category_slug,
  CASE WHEN c.id = 41 THEN 1 ELSE 0 END AS same_category
FROM settings_content_page p
JOIN settings_content_group g ON g.id = p.group_id
JOIN settings_content_category c ON c.id = g.category_id
WHERE
  c.client_id = 2
  AND p.id <> 456
  AND ((
  setweight(to_tsvector('german', coalesce(p.name,'')), 'A') ||
  setweight(to_tsvector('german', coalesce(p.teaser,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(p.seo_keywords,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(regexp_replace(p.content, '<[^>]+>', ' ', 'g'),'')), 'C')
)) @@ websearch_to_tsquery('german', 'analysierst OR die OR auslastung OR deiner OR objekte OR welche OR sind OR ausgebucht OR kaum OR gefragt')
ORDER BY same_category DESC, rank DESC, p.updated_at DESC
LIMIT 5;

#	File/Call
1	App\Repository\Content\PageRepository->findSimilarForClient (line 113)
2	App\Controller\Content\IndexController->page_view (line 378)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

2.38 ms
(4.29%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company AS company_4, t0.email AS email_5, t0.branch AS branch_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.telephone AS telephone_9, t0.subdomain AS subdomain_10, t0.status AS status_11, t0.layout_id AS layout_id_12 FROM client t0 WHERE t0.subdomain = ? LIMIT 1

Parameters:

[
  "rentsoft"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.company AS company_4,
  t0.email AS email_5,
  t0.branch AS branch_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.telephone AS telephone_9,
  t0.subdomain AS subdomain_10,
  t0.status AS status_11,
  t0.layout_id AS layout_id_12
FROM
  client t0
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company AS company_4, t0.email AS email_5, t0.branch AS branch_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.telephone AS telephone_9, t0.subdomain AS subdomain_10, t0.status AS status_11, t0.layout_id AS layout_id_12 FROM client t0 WHERE t0.subdomain = 'rentsoft' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\BaseController->__construct (line 56)
4	Container8qbHT77\getIndexController2Service->do (line 25)
5	Container8qbHT77\App_KernelDevDebugContainer::load (line 600)
6	Symfony\Component\DependencyInjection\Container->make (line 221)
7	Symfony\Component\DependencyInjection\Container::get (line 203)
8	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
9	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
12	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

1.11 ms
(1.99%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.teaser AS teaser_6, t0.icon AS icon_7, t0.content AS content_8, t0.priority AS priority_9, t0.visible AS visible_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_description AS seo_meta_description_12, t0.page_view_counter AS page_view_counter_13, t0.deleted_at AS deleted_at_14, t0.group_id AS group_id_15 FROM settings_content_page t0 WHERE t0.slug = ? AND t0.group_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "auslastung-analysieren"
  133
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.teaser AS teaser_6,
  t0.icon AS icon_7,
  t0.content AS content_8,
  t0.priority AS priority_9,
  t0.visible AS visible_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.seo_meta_description AS seo_meta_description_12,
  t0.page_view_counter AS page_view_counter_13,
  t0.deleted_at AS deleted_at_14,
  t0.group_id AS group_id_15
FROM
  settings_content_page t0
WHERE
  t0.slug = ?
  AND t0.group_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.teaser AS teaser_6, t0.icon AS icon_7, t0.content AS content_8, t0.priority AS priority_9, t0.visible AS visible_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_description AS seo_meta_description_12, t0.page_view_counter AS page_view_counter_13, t0.deleted_at AS deleted_at_14, t0.group_id AS group_id_15 FROM settings_content_page t0 WHERE t0.slug = 'auslastung-analysieren' AND t0.group_id = 133 AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\Content\IndexController->page_view (line 375)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

1.04 ms
(1.88%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.slug = ? AND t0.client_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "auswertungen-reports"
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.icon AS icon_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.visible AS visible_9,
  t0.deleted_at AS deleted_at_10,
  t0.client_id AS client_id_11,
  t0.user_id AS user_id_12
FROM
  settings_content_category t0
WHERE
  t0.slug = ?
  AND t0.client_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.slug = 'auswertungen-reports' AND t0.client_id = 2 AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\Content\IndexController->page_view (line 371)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

1.01 ms
(1.83%)

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.slug = ? AND t0.category_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "objekt-reports"
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.deleted_at AS deleted_at_7,
  t0.category_id AS category_id_8
FROM
  settings_content_group t0
WHERE
  t0.slug = ?
  AND t0.category_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.slug = 'objekt-reports' AND t0.category_id = 41 AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\Content\IndexController->page_view (line 372)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.84 ms
(1.52%)

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  131
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.deleted_at AS deleted_at_7,
  t0.category_id AS category_id_8
FROM
  settings_content_group t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = 131 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Content\Group::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Content\Group->__get (line 153)
7	App\Entity\Content\Group->getCategory (line 99)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_722e358c4c24b18aaca53706b63ae6e7::block_body (line 293)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_625f84f7cfdf39e0254fce8d41d94e2f->doDisplay (line 172)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_722e358c4c24b18aaca53706b63ae6e7->doDisplay (line 59)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Content\IndexController->page_view (line 387)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.62 ms
(1.12%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Controller\Content\IndexController->page_view (line 385)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.55 ms
(1.00%)

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ WHERE (s0_.id IN (?, ?, ?, ?, ?)) AND (s0_.deleted_at IS NULL)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.name AS name_3,
  s0_.slug AS slug_4,
  s0_.teaser AS teaser_5,
  s0_.icon AS icon_6,
  s0_.content AS content_7,
  s0_.priority AS priority_8,
  s0_.visible AS visible_9,
  s0_.seo_keywords AS seo_keywords_10,
  s0_.seo_meta_description AS seo_meta_description_11,
  s0_.page_view_counter AS page_view_counter_12,
  s0_.deleted_at AS deleted_at_13,
  s0_.group_id AS group_id_14
FROM
  settings_content_page s0_
WHERE
  (
    s0_.id IN (?, ?, ?, ?, ?)
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ WHERE (s0_.id IN (457, 452, 455, 321, 373)) AND (s0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\Content\PageRepository->hydrateSimilarRows (line 383)
7	App\Repository\Content\PageRepository->findSimilarForClient (line 132)
8	App\Controller\Content\IndexController->page_view (line 378)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.43 ms
(0.78%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  34
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.icon AS icon_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.visible AS visible_9,
  t0.deleted_at AS deleted_at_10,
  t0.client_id AS client_id_11,
  t0.user_id AS user_id_12
FROM
  settings_content_category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.id = 34 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Content\Category::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Content\Category->__get (line 153)
7	App\Entity\Content\Category->getSlug (line 196)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_722e358c4c24b18aaca53706b63ae6e7::block_body (line 293)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_625f84f7cfdf39e0254fce8d41d94e2f->doDisplay (line 172)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_722e358c4c24b18aaca53706b63ae6e7->doDisplay (line 59)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Content\IndexController->page_view (line 387)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.41 ms
(0.74%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo AS logo_4, t0.logo_footer AS logo_footer_5, t0.favicon AS favicon_6, t0.link_imprint AS link_imprint_7, t0.link_agb AS link_agb_8, t0.seo_main_keywords AS seo_main_keywords_9, t0.seo_main_description AS seo_main_description_10, t0.header_background_color AS header_background_color_11, t0.primary_color AS primary_color_12, t0.dark_mode_default AS dark_mode_default_13, t0.hero_image AS hero_image_14 FROM client_layout t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.logo AS logo_4,
  t0.logo_footer AS logo_footer_5,
  t0.favicon AS favicon_6,
  t0.link_imprint AS link_imprint_7,
  t0.link_agb AS link_agb_8,
  t0.seo_main_keywords AS seo_main_keywords_9,
  t0.seo_main_description AS seo_main_description_10,
  t0.header_background_color AS header_background_color_11,
  t0.primary_color AS primary_color_12,
  t0.dark_mode_default AS dark_mode_default_13,
  t0.hero_image AS hero_image_14
FROM
  client_layout t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo AS logo_4, t0.logo_footer AS logo_footer_5, t0.favicon AS favicon_6, t0.link_imprint AS link_imprint_7, t0.link_agb AS link_agb_8, t0.seo_main_keywords AS seo_main_keywords_9, t0.seo_main_description AS seo_main_description_10, t0.header_background_color AS header_background_color_11, t0.primary_color AS primary_color_12, t0.dark_mode_default AS dark_mode_default_13, t0.hero_image AS hero_image_14 FROM client_layout t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Client\Layout::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Client\Layout->__get (line 153)
7	App\Entity\Client\Layout->getPrimaryColor (line 173)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_625f84f7cfdf39e0254fce8d41d94e2f::doDisplay (line 67)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_722e358c4c24b18aaca53706b63ae6e7->doDisplay (line 59)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Content\IndexController->page_view (line 387)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.37 ms
(0.68%)

UPDATE settings_content_page SET page_view_counter = ?, updated_at = ? WHERE id = ?

Parameters:

[
  7
  "2026-06-10 09:12:11"
  456
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  settings_content_page
SET
  page_view_counter = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE settings_content_page SET page_view_counter = 7, updated_at = '2026-06-10 09:12:11' WHERE id = 456;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 536)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 422)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1283)
4	Doctrine\ORM\UnitOfWork->commit (line 456)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Controller\Content\IndexController->page_view (line 385)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.14 ms
(0.26%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Controller\Content\IndexController->page_view (line 385)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	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\Content\Page	6
App\Entity\Content\Group	5
App\Entity\Content\Category	3
App\Entity\Client\Client	1
App\Entity\Client\Layout	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Client\Client	No errors.
App\Entity\Client\Layout	No errors.
App\Entity\Settings\General	No errors.
App\Entity\User	No errors.
App\Entity\Content\Category	No errors.
App\Entity\Content\Group	No errors.
App\Entity\Content\Page	No errors.
App\Entity\Content\PageRating	No errors.

Symfony Profiler

GET https://hilfe.rentsoft.de/de/a/auswertungen-reports/objekt-reports/auslastung-analysieren

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping