Symfony Profiler

Query Metrics

19 Database Queries

14 Different statements

1108.94 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1012.54 ms
(91.31%)

SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, p0_.partner_id AS partner_id_6, p0_.category_id AS category_id_7 FROM performer p0_ WHERE LOWER(p0_.performer_code) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "asianchubwayne"
  "caugusto91"
  "slipperyrichard__420"
  "brighteyesbigdick"
  "uff421"
  "cesar_rose"
  "muphenpls"
  "dspuncloudy"
  "istanbullian"
  "tom_cooper_1"
  "420seducer"
  "hard14utosuck"
  "henry_barbarian_"
  "vividerblock45"
  "slipperyrichard_420"
  "speedoguy78"
  1
  2
  5
  13
  6
  14
  15
  7
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.performer_code AS performer_code_1,
  p0_.last_online AS last_online_2,
  p0_.description AS description_3,
  p0_.chat_room_url AS chat_room_url_4,
  p0_.picture_url AS picture_url_5,
  p0_.partner_id AS partner_id_6,
  p0_.category_id AS category_id_7
FROM
  performer p0_
WHERE
  LOWER(p0_.performer_code) IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, p0_.partner_id AS partner_id_6, p0_.category_id AS category_id_7 FROM performer p0_ WHERE LOWER(p0_.performer_code) IN ('asianchubwayne', 'caugusto91', 'slipperyrichard__420', 'brighteyesbigdick', 'uff421', 'cesar_rose', 'muphenpls', 'dspuncloudy', 'istanbullian', 'tom_cooper_1', '420seducer', 'hard14utosuck', 'henry_barbarian_', 'vividerblock45', 'slipperyrichard_420', 'speedoguy78') AND p0_.partner_id IN (1, 2, 5, 13, 6, 14, 15, 7, 11);

#	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 39)
6	App\Services\PerformerService->convertToPerformerBundles (line 78)
7	App\Controller\Public\ListController->listing (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

46.80 ms
(4.22%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_6 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > ? THEN 1 ELSE 0 END) AS sclr_6, p1_.id AS id_7, p1_.tag AS tag_8, p2_.id AS id_9, p2_.tag AS tag_10 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result_inner ORDER BY sclr_6 DESC, id_0 DESC) dctrn_result LIMIT 30

Parameters:

[
  "2025-04-21 18:41:48"
  "smoke"
  "edging"
  1
  2
  5
  13
  6
  14
  15
  7
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_6
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.performer_code AS performer_code_1,
          p0_.last_online AS last_online_2,
          p0_.description AS description_3,
          p0_.chat_room_url AS chat_room_url_4,
          p0_.picture_url AS picture_url_5,
          (
            CASE WHEN p0_.last_online > ? THEN
              1
            ELSE
              0
            END
          ) AS sclr_6,
          p1_.id AS id_7,
          p1_.tag AS tag_8,
          p2_.id AS id_9,
          p2_.tag AS tag_10
        FROM
          performer p0_
          INNER JOIN performer_tag p1_ ON (
            p1_.performer_id = p0_.id
            AND p1_.tag = ?
          )
          INNER JOIN performer_tag p2_ ON (
            p2_.performer_id = p0_.id
            AND p2_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
      ) dctrn_result_inner
    ORDER BY
      sclr_6 DESC,
      id_0 DESC
  ) dctrn_result
LIMIT
  30

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_6 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > '2025-04-21 18:41:48' THEN 1 ELSE 0 END) AS sclr_6, p1_.id AS id_7, p1_.tag AS tag_8, p2_.id AS id_9, p2_.tag AS tag_10 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'smoke') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'edging') WHERE p0_.partner_id IN (1, 2, 5, 13, 6, 14, 15, 7, 11)) dctrn_result_inner ORDER BY sclr_6 DESC, id_0 DESC) dctrn_result LIMIT 30;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 159)
9	App\Repository\PerformerRepository->paginateQueryBuilder (line 120)
10	App\Repository\PerformerRepository->getPerformersOnList (line 77)
11	App\Controller\Public\ListController->listing (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

25.39 ms
(2.29%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > ? THEN 1 ELSE 0 END) AS sclr_6 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  "2025-04-21 18:41:48"
  "smoke"
  "edging"
  1
  2
  5
  13
  6
  14
  15
  7
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.performer_code AS performer_code_1,
          p0_.last_online AS last_online_2,
          p0_.description AS description_3,
          p0_.chat_room_url AS chat_room_url_4,
          p0_.picture_url AS picture_url_5,
          (
            CASE WHEN p0_.last_online > ? THEN
              1
            ELSE
              0
            END
          ) AS sclr_6
        FROM
          performer p0_
          INNER JOIN performer_tag p1_ ON (
            p1_.performer_id = p0_.id
            AND p1_.tag = ?
          )
          INNER JOIN performer_tag p2_ ON (
            p2_.performer_id = p0_.id
            AND p2_.tag = ?
          )
        WHERE
          p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
        ORDER BY
          sclr_6 DESC,
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > '2025-04-21 18:41:48' THEN 1 ELSE 0 END) AS sclr_6 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'smoke') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'edging') WHERE p0_.partner_id IN (1, 2, 5, 13, 6, 14, 15, 7, 11) ORDER BY sclr_6 DESC, p0_.id DESC) dctrn_result) dctrn_table;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 158)
9	App\Repository\PerformerRepository->paginateQueryBuilder (line 120)
10	App\Repository\PerformerRepository->getPerformersOnList (line 77)
11	App\Controller\Public\ListController->listing (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

18.25 ms
(1.65%)

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (?)

Parameters:

[
  177788
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.performer_id AS performer_id_3
FROM
  performer_tag t0
WHERE
  t0.performer_id IN (?)

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (177788);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 39)
9	App\Services\PerformerService->convertToPerformerBundles (line 78)
10	App\Controller\Public\ListController->listing (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.55 ms
(0.23%)

SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > ? THEN 1 ELSE 0 END) AS sclr_6, p0_.partner_id AS partner_id_7, p0_.category_id AS category_id_8 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = ?) INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = ?) WHERE p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_6 DESC, p0_.id DESC

Parameters:

[
  "2025-04-21 18:41:48"
  "smoke"
  "edging"
  1
  2
  5
  13
  6
  14
  15
  7
  11
  177712
  474099
  373734
  299778
  293875
  276972
  276676
  268414
  212547
  210573
  205222
  203835
  191675
  177729
  171951
  169523
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.performer_code AS performer_code_1,
  p0_.last_online AS last_online_2,
  p0_.description AS description_3,
  p0_.chat_room_url AS chat_room_url_4,
  p0_.picture_url AS picture_url_5,
  (
    CASE WHEN p0_.last_online > ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_6,
  p0_.partner_id AS partner_id_7,
  p0_.category_id AS category_id_8
FROM
  performer p0_
  INNER JOIN performer_tag p1_ ON (
    p1_.performer_id = p0_.id
    AND p1_.tag = ?
  )
  INNER JOIN performer_tag p2_ ON (
    p2_.performer_id = p0_.id
    AND p2_.tag = ?
  )
WHERE
  p0_.partner_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  sclr_6 DESC,
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.performer_code AS performer_code_1, p0_.last_online AS last_online_2, p0_.description AS description_3, p0_.chat_room_url AS chat_room_url_4, p0_.picture_url AS picture_url_5, (CASE WHEN p0_.last_online > '2025-04-21 18:41:48' THEN 1 ELSE 0 END) AS sclr_6, p0_.partner_id AS partner_id_7, p0_.category_id AS category_id_8 FROM performer p0_ INNER JOIN performer_tag p1_ ON (p1_.performer_id = p0_.id AND p1_.tag = 'smoke') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'edging') WHERE p0_.partner_id IN (1, 2, 5, 13, 6, 14, 15, 7, 11) AND p0_.id IN (177712, 474099, 373734, 299778, 293875, 276972, 276676, 268414, 212547, 210573, 205222, 203835, 191675, 177729, 171951, 169523) ORDER BY sclr_6 DESC, p0_.id DESC;

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 159)
9	App\Repository\PerformerRepository->paginateQueryBuilder (line 120)
10	App\Repository\PerformerRepository->getPerformersOnList (line 77)
11	App\Controller\Public\ListController->listing (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.90 ms
(0.08%)

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.performer_id AS performer_id_3
FROM
  performer_tag t0
WHERE
  t0.performer_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.performer_id AS performer_id_3 FROM performer_tag t0 WHERE t0.performer_id IN (177712, 474099, 373734, 299778, 293875, 276972, 276676, 268414, 212547, 210573, 205222, 203835, 191675, 177729, 171951, 169523);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 145)
10	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
11	iterator_to_array (line 159)
12	App\Repository\PerformerRepository->paginateQueryBuilder (line 120)
13	App\Repository\PerformerRepository->getPerformersOnList (line 77)
14	App\Controller\Public\ListController->listing (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.67 ms
(0.06%)

SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0._key AS _key_2,
  t0._value AS _value_3,
  t0.performer_id AS performer_id_4
FROM
  performer_info t0
WHERE
  t0.performer_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (177712, 474099, 373734, 299778, 293875, 276972, 276676, 268414, 212547, 210573, 205222, 203835, 191675, 177729, 171951, 169523);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 145)
10	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
11	iterator_to_array (line 159)
12	App\Repository\PerformerRepository->paginateQueryBuilder (line 120)
13	App\Repository\PerformerRepository->getPerformersOnList (line 77)
14	App\Controller\Public\ListController->listing (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.41 ms
(0.04%)

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM category t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Category::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Category->__get (line 31)
8	App\Entity\Category->getCategoryName (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 97)
10	__TwigTemplate_3bc351f03b9caab93286840783110bd1->doDisplay (line 393)
11	Twig\Template->yield (line 131)
12	__TwigTemplate_1ab33b8d456e4dc2833e4d6249ced4ac->doDisplay (line 393)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_d5ddaa6a80205febd2cfe387985ddf24->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 88)
23	App\Controller\Public\ListController->listing (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.28 ms
(0.03%)

SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (?)

Parameters:

[
  177788
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0._key AS _key_2,
  t0._value AS _value_3,
  t0.performer_id AS performer_id_4
FROM
  performer_info t0
WHERE
  t0.performer_id IN (?)

SELECT t0.id AS id_1, t0._key AS _key_2, t0._value AS _value_3, t0.performer_id AS performer_id_4 FROM performer_info t0 WHERE t0.performer_id IN (177788);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 39)
9	App\Services\PerformerService->convertToPerformerBundles (line 78)
10	App\Controller\Public\ListController->listing (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.27 ms
(0.02%)

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.domain = ?

Parameters:

[
  "sexcenter.net"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.partner_link_template AS partner_link_template_2,
  t0.partner_link_offline_template AS partner_link_offline_template_3,
  t0.partner_f_link_title AS partner_f_link_title_4,
  t0.partner_f_link_template AS partner_f_link_template_5,
  t0.partner_f_link_offline_template AS partner_f_link_offline_template_6,
  t0.partner_m_link_title AS partner_m_link_title_7,
  t0.partner_m_link_template AS partner_m_link_template_8,
  t0.partner_m_link_offline_template AS partner_m_link_offline_template_9,
  t0.partner_c_link_title AS partner_c_link_title_10,
  t0.partner_c_link_template AS partner_c_link_template_11,
  t0.partner_c_link_offline_template AS partner_c_link_offline_template_12,
  t0.partner_t_link_title AS partner_t_link_title_13,
  t0.partner_t_link_template AS partner_t_link_template_14,
  t0.partner_t_link_offline_template AS partner_t_link_offline_template_15,
  t0.domain AS domain_16,
  t0.partner_id AS partner_id_17
FROM
  domain_partner t0
WHERE
  t0.domain = ?

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.domain = 'sexcenter.net';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 257)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 103)
8	App\Entity\Domain->getPartnerIDs (line 93)
9	App\Repository\PerformerRepository->getPerformersOnList (line 77)
10	App\Controller\Public\ListController->listing (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.26 ms
(0.02%)

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.partner_link_template AS partner_link_template_2,
  t0.partner_link_offline_template AS partner_link_offline_template_3,
  t0.partner_f_link_title AS partner_f_link_title_4,
  t0.partner_f_link_template AS partner_f_link_template_5,
  t0.partner_f_link_offline_template AS partner_f_link_offline_template_6,
  t0.partner_m_link_title AS partner_m_link_title_7,
  t0.partner_m_link_template AS partner_m_link_template_8,
  t0.partner_m_link_offline_template AS partner_m_link_offline_template_9,
  t0.partner_c_link_title AS partner_c_link_title_10,
  t0.partner_c_link_template AS partner_c_link_template_11,
  t0.partner_c_link_offline_template AS partner_c_link_offline_template_12,
  t0.partner_t_link_title AS partner_t_link_title_13,
  t0.partner_t_link_template AS partner_t_link_template_14,
  t0.partner_t_link_offline_template AS partner_t_link_offline_template_15,
  t0.domain AS domain_16,
  t0.partner_id AS partner_id_17
FROM
  domain_partner t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.partner_link_template AS partner_link_template_2, t0.partner_link_offline_template AS partner_link_offline_template_3, t0.partner_f_link_title AS partner_f_link_title_4, t0.partner_f_link_template AS partner_f_link_template_5, t0.partner_f_link_offline_template AS partner_f_link_offline_template_6, t0.partner_m_link_title AS partner_m_link_title_7, t0.partner_m_link_template AS partner_m_link_template_8, t0.partner_m_link_offline_template AS partner_m_link_offline_template_9, t0.partner_c_link_title AS partner_c_link_title_10, t0.partner_c_link_template AS partner_c_link_template_11, t0.partner_c_link_offline_template AS partner_c_link_offline_template_12, t0.partner_t_link_title AS partner_t_link_title_13, t0.partner_t_link_template AS partner_t_link_template_14, t0.partner_t_link_offline_template AS partner_t_link_offline_template_15, t0.domain AS domain_16, t0.partner_id AS partner_id_17 FROM domain_partner t0 WHERE t0.partner_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 26)
8	App\Entity\Partner->findDomainPartner (line 98)
9	App\Entity\Performer->calculatePerformerLink (line 1754)
10	Twig\Extension\CoreExtension::getAttribute (line 96)
11	__TwigTemplate_f7d8f6bb44b37b50ae3ce3049fdbf275->doDisplay (line 393)
12	Twig\Template->yield (line 97)
13	__TwigTemplate_d5ddaa6a80205febd2cfe387985ddf24->block_body (line 437)
14	Twig\Template->yieldBlock (line 179)
15	__TwigTemplate_1ab33b8d456e4dc2833e4d6249ced4ac->doDisplay (line 393)
16	Twig\Template->yield (line 53)
17	__TwigTemplate_d5ddaa6a80205febd2cfe387985ddf24->doDisplay (line 393)
18	Twig\Template->yield (line 349)
19	Twig\Template->display (line 364)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 306)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 88)
26	App\Controller\Public\ListController->listing (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.25 ms
(0.02%)

SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.partner_name AS partner_name_2
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.partner_name AS partner_name_2 FROM partner t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Partner::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Partner->__get (line 26)
8	App\Entity\Partner->findDomainPartner (line 98)
9	App\Entity\Performer->calculatePerformerLink (line 1754)
10	Twig\Extension\CoreExtension::getAttribute (line 96)
11	__TwigTemplate_f7d8f6bb44b37b50ae3ce3049fdbf275->doDisplay (line 393)
12	Twig\Template->yield (line 97)
13	__TwigTemplate_d5ddaa6a80205febd2cfe387985ddf24->block_body (line 437)
14	Twig\Template->yieldBlock (line 179)
15	__TwigTemplate_1ab33b8d456e4dc2833e4d6249ced4ac->doDisplay (line 393)
16	Twig\Template->yield (line 53)
17	__TwigTemplate_d5ddaa6a80205febd2cfe387985ddf24->doDisplay (line 393)
18	Twig\Template->yield (line 349)
19	Twig\Template->display (line 364)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 306)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 88)
26	App\Controller\Public\ListController->listing (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.20 ms
(0.02%)

SELECT t0.domain AS domain_1, t0.alias AS alias_2, t0.domain_css AS domain_css_3, t0.domain_js AS domain_js_4, t0.homepage_title AS homepage_title_5, t0.logo_font_size AS logo_font_size_6, t0.header_background_color AS header_background_color_7, t0.logo_font_id AS logo_font_id_8 FROM domain t0 WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "sexcenter.net"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.domain AS domain_1,
  t0.alias AS alias_2,
  t0.domain_css AS domain_css_3,
  t0.domain_js AS domain_js_4,
  t0.homepage_title AS homepage_title_5,
  t0.logo_font_size AS logo_font_size_6,
  t0.header_background_color AS header_background_color_7,
  t0.logo_font_id AS logo_font_id_8
FROM
  domain t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.domain AS domain_1, t0.alias AS alias_2, t0.domain_css AS domain_css_3, t0.domain_js AS domain_js_4, t0.homepage_title AS homepage_title_5, t0.logo_font_size AS logo_font_size_6, t0.header_background_color AS header_background_color_7, t0.logo_font_id AS logo_font_id_8 FROM domain t0 WHERE t0.domain = 'sexcenter.net' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 24)
5	App\Services\CurrentDomainService->getCurrentDomain (line 36)
6	App\Controller\Public\ListController->listing (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.16 ms
(0.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.css AS css_3, t0.family AS family_4 FROM font t0 WHERE t0.id = ?

Parameters:

[
  47
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.css AS css_3,
  t0.family AS family_4
FROM
  font t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.css AS css_3, t0.family AS family_4 FROM font t0 WHERE t0.id = 47;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Font::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Font->__get (line 53)
8	App\Entity\Font->getCss (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 92)
10	__TwigTemplate_1ab33b8d456e4dc2833e4d6249ced4ac->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_d5ddaa6a80205febd2cfe387985ddf24->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 88)
21	App\Controller\Public\ListController->listing (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Domain	The mappings App\Entity\Domain#domainPartners and App\Entity\DomainPartner#domain are inconsistent with each other.
App\Entity\Font	No errors.
App\Entity\DomainPartner	The association App\Entity\DomainPartner#domain refers to the inverse side field App\Entity\Domain#partners which does not exist.
App\Entity\Partner	No errors.
App\Entity\Performer	No errors.
App\Entity\PerformerTag	No errors.
App\Entity\Category	No errors.
App\Entity\PerformerInfo	No errors.

Symfony Profiler

GET https://sexcenter.net/list?tag=smoke&tag2=edging

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping