Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.89 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.44 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surename AS surename_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.last_activity_at AS last_activity_at_9, t0.trainer_id AS trainer_id_10, t0.company_id AS company_id_11 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surename AS surename_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.is_verified AS is_verified_7,
  t0.avatar AS avatar_8,
  t0.last_activity_at AS last_activity_at_9,
  t0.trainer_id AS trainer_id_10,
  t0.company_id AS company_id_11
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surename AS surename_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.last_activity_at AS last_activity_at_9, t0.trainer_id AS trainer_id_10, t0.company_id AS company_id_11 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.45 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.original_filename AS original_filename_3, t0.stored_filename AS stored_filename_4, t0.file_path AS file_path_5, t0.thumbnail_path AS thumbnail_path_6, t0.mime_type AS mime_type_7, t0.file_size AS file_size_8, t0.sha1_hash AS sha1_hash_9, t0.source_type AS source_type_10, t0.extracted_text AS extracted_text_11, t0.source_meta AS source_meta_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.structure_proposal AS structure_proposal_16, t0.user_id AS user_id_17 FROM source_document t0 WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.original_filename AS original_filename_3,
  t0.stored_filename AS stored_filename_4,
  t0.file_path AS file_path_5,
  t0.thumbnail_path AS thumbnail_path_6,
  t0.mime_type AS mime_type_7,
  t0.file_size AS file_size_8,
  t0.sha1_hash AS sha1_hash_9,
  t0.source_type AS source_type_10,
  t0.extracted_text AS extracted_text_11,
  t0.source_meta AS source_meta_12,
  t0.status AS status_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.structure_proposal AS structure_proposal_16,
  t0.user_id AS user_id_17
FROM
  source_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.original_filename AS original_filename_3, t0.stored_filename AS stored_filename_4, t0.file_path AS file_path_5, t0.thumbnail_path AS thumbnail_path_6, t0.mime_type AS mime_type_7, t0.file_size AS file_size_8, t0.sha1_hash AS sha1_hash_9, t0.source_type AS source_type_10, t0.extracted_text AS extracted_text_11, t0.source_meta AS source_meta_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.structure_proposal AS structure_proposal_16, t0.user_id AS user_id_17 FROM source_document t0 WHERE t0.id = '3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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\User	1
App\Entity\Company	1
App\Entity\SourceDocument	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Course	No errors.
App\Entity\CardSet	No errors.
App\Entity\CardProgress	No errors.
App\Entity\CardAiNote	No errors.
App\Entity\Participant	No errors.
App\Entity\Message	No errors.
App\Entity\Conversation	No errors.
App\Entity\CourseAnnouncement	No errors.
App\Entity\CourseAnnouncementRead	No errors.
App\Entity\Notification	No errors.
App\Entity\NotificationUser	No errors.
App\Entity\SourceDocument	No errors.
App\Entity\SourceDocumentChunk	No errors.
App\Entity\SourceDocumentSection	No errors.

Symfony Profiler

GET https://courseforge.info/api/source-documents/3/file

Configuration Settings

Theme

Page Width