Symfony Profiler

Query Metrics

15 Database Queries

12 Different statements

4877.99 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4133.87 ms
(84.75%)

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:

[
  "juana_tropic"
  "girlofurdreamsxxxxox"
  "starlighttcrystall"
  "beyons3"
  "brunette_from_the_moon"
  "missestephy1997"
  "sammy_greyy1"
  1
  13
  2
  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 ('juana_tropic', 'girlofurdreamsxxxxox', 'starlighttcrystall', 'beyons3', 'brunette_from_the_moon', 'missestephy1997', 'sammy_greyy1') AND p0_.partner_id IN (1, 13, 2, 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)

388.80 ms
(7.97%)

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 19:18:36"
  "findom"
  "twerk"
  1
  13
  2
  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 19:18:36' 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 = 'findom') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'twerk') WHERE p0_.partner_id IN (1, 13, 2, 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)

234.97 ms
(4.82%)

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 19:18:36"
  "findom"
  "twerk"
  1
  13
  2
  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 19:18:36' 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 = 'findom') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'twerk') WHERE p0_.partner_id IN (1, 13, 2, 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)

65.85 ms
(1.35%)

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)

36.32 ms
(0.74%)

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 (562628, 25720, 306652, 229606, 114768, 112592, 68953);

#	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)

15.73 ms
(0.32%)

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:

[
  "xxxplace.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 = 'xxxplace.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)

1.42 ms
(0.03%)

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 19:18:36"
  "findom"
  "twerk"
  1
  13
  2
  14
  15
  7
  11
  562628
  25720
  306652
  229606
  114768
  112592
  68953
]

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 19:18:36' 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 = 'findom') INNER JOIN performer_tag p2_ ON (p2_.performer_id = p0_.id AND p2_.tag = 'twerk') WHERE p0_.partner_id IN (1, 13, 2, 14, 15, 7, 11) AND p0_.id IN (562628, 25720, 306652, 229606, 114768, 112592, 68953) 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.49 ms
(0.01%)

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 (562628, 25720, 306652, 229606, 114768, 112592, 68953);

#	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.16 ms
(0.00%)

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:

[
  53
]

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 = 53;

#	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)

0.14 ms
(0.00%)

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.13 ms
(0.00%)

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:

[
  "xxxplace.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 = 'xxxplace.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.12 ms
(0.00%)

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)

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://xxxplace.net/list?tag=findom&tag2=twerk

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping