Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.03 ms Query time

0 Invalid entities

14 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.53 ms

SELECT t0.id AS id_1, t0.main_name AS main_name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.birth_date AS birth_date_6, t0.height AS height_7, t0.weight AS weight_8, t0.hair AS hair_9, t0.eyes AS eyes_10, t0.ethnicity AS ethnicity_11, t0.biography AS biography_12, t0.gender AS gender_13, t0.twitter AS twitter_14, t0.flirt4free AS flirt4free_15, t0.chaturbate AS chaturbate_16, t0.active AS active_17 FROM performers t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "thomas-lee"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.main_name AS main_name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.birth_date AS birth_date_6,
  t0.height AS height_7,
  t0.weight AS weight_8,
  t0.hair AS hair_9,
  t0.eyes AS eyes_10,
  t0.ethnicity AS ethnicity_11,
  t0.biography AS biography_12,
  t0.gender AS gender_13,
  t0.twitter AS twitter_14,
  t0.flirt4free AS flirt4free_15,
  t0.chaturbate AS chaturbate_16,
  t0.active AS active_17
FROM
  performers t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.main_name AS main_name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.birth_date AS birth_date_6, t0.height AS height_7, t0.weight AS weight_8, t0.hair AS hair_9, t0.eyes AS eyes_10, t0.ethnicity AS ethnicity_11, t0.biography AS biography_12, t0.gender AS gender_13, t0.twitter AS twitter_14, t0.flirt4free AS flirt4free_15, t0.chaturbate AS chaturbate_16, t0.active AS active_17 FROM performers t0 WHERE t0.slug = 'thomas-lee' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\CatalogController->performerShow (line 85)
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 34)
9	require_once (line 32)
10	require_once (line 5)

0.50 ms

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.normalized_name AS normalized_name_3, t0.source_type AS source_type_4, t0.source_id AS source_id_5, t0.external_aebn_id AS external_aebn_id_6, t0.image_path AS image_path_7, t0.image_source AS image_source_8, t0.image_url AS image_url_9, t0.image_site_id AS image_site_id_10, t0.performer_id AS performer_id_11 FROM performer_name_credits t0 WHERE t0.performer_id = ?

Parameters:

[
  42
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.normalized_name AS normalized_name_3,
  t0.source_type AS source_type_4,
  t0.source_id AS source_id_5,
  t0.external_aebn_id AS external_aebn_id_6,
  t0.image_path AS image_path_7,
  t0.image_source AS image_source_8,
  t0.image_url AS image_url_9,
  t0.image_site_id AS image_site_id_10,
  t0.performer_id AS performer_id_11
FROM
  performer_name_credits t0
WHERE
  t0.performer_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.normalized_name AS normalized_name_3, t0.source_type AS source_type_4, t0.source_id AS source_id_5, t0.external_aebn_id AS external_aebn_id_6, t0.image_path AS image_path_7, t0.image_source AS image_source_8, t0.image_url AS image_url_9, t0.image_site_id AS image_site_id_10, t0.performer_id AS performer_id_11 FROM performer_name_credits t0 WHERE t0.performer_id = 42;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 34)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->testEmpty (line 1466)
9	__TwigTemplate_50710bbcc054fdd86861e60aaf61cdfa::block_body (line 199)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_fac0044869f968b68e214d35200e49d6->doDisplay (line 137)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_50710bbcc054fdd86861e60aaf61cdfa->doDisplay (line 59)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
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\CatalogController->performerShow (line 90)
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 34)
27	require_once (line 32)
28	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\PerformerNameCredit	13
App\Entity\Performer	1

Entities Mapping

Class	Mapping errors
App\Entity\Performer	No errors.
App\Entity\PerformerNameCredit	No errors.
App\Entity\PerformerBiography	No errors.

Symfony Profiler

GET https://justgayindex.com/performers/thomas-lee

Configuration Settings

Theme

Page Width