Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.04 ms Query time

0 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.79 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.68 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.ai_document AS ai_document_4, t0.ai_text AS ai_text_5, t0.is_active AS is_active_6, t0.public AS public_7, t0.source_document_id AS source_document_id_8, t0.user_id AS user_id_9 FROM card_set t0 WHERE t0.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.ai_document AS ai_document_4,
  t0.ai_text AS ai_text_5,
  t0.is_active AS is_active_6,
  t0.public AS public_7,
  t0.source_document_id AS source_document_id_8,
  t0.user_id AS user_id_9
FROM
  card_set t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.ai_document AS ai_document_4, t0.ai_text AS ai_text_5, t0.is_active AS is_active_6, t0.public AS public_7, t0.source_document_id AS source_document_id_8, t0.user_id AS user_id_9 FROM card_set t0 WHERE t0.user_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Api\CardSetController->list (line 37)
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.84 ms

SELECT t0.id AS id_1, t0.question AS question_2, t0.description AS description_3, t0.source_text AS source_text_4, t0.source_meta AS source_meta_5, t0.position AS position_6, t0.choice_type AS choice_type_7, t0.type AS type_8, t0.expected_answer AS expected_answer_9, t0.rubric AS rubric_10, t0.keywords AS keywords_11, t0.explanation AS explanation_12, t0.active AS active_13, t0.public AS public_14, t0.card_set_id AS card_set_id_15 FROM card t0 WHERE t0.card_set_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.description AS description_3,
  t0.source_text AS source_text_4,
  t0.source_meta AS source_meta_5,
  t0.position AS position_6,
  t0.choice_type AS choice_type_7,
  t0.type AS type_8,
  t0.expected_answer AS expected_answer_9,
  t0.rubric AS rubric_10,
  t0.keywords AS keywords_11,
  t0.explanation AS explanation_12,
  t0.active AS active_13,
  t0.public AS public_14,
  t0.card_set_id AS card_set_id_15
FROM
  card t0
WHERE
  t0.card_set_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.question AS question_2, t0.description AS description_3, t0.source_text AS source_text_4, t0.source_meta AS source_meta_5, t0.position AS position_6, t0.choice_type AS choice_type_7, t0.type AS type_8, t0.expected_answer AS expected_answer_9, t0.rubric AS rubric_10, t0.keywords AS keywords_11, t0.explanation AS explanation_12, t0.active AS active_13, t0.public AS public_14, t0.card_set_id AS card_set_id_15 FROM card t0 WHERE t0.card_set_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 228)
9	App\Entity\CardSet::getCardCount (line 228)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
12	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 115)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Serializer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 170)
17	Symfony\Component\Serializer\Serializer->serialize (line 131)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
20	App\Controller\Api\CardSetController->list (line 38)
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.72 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.course_type AS course_type_6, t0.max_participants AS max_participants_7, t0.course_code AS course_code_8, t0.is_active AS is_active_9, t0.public AS public_10, t0.user_id AS user_id_11, t0.source_document_id AS source_document_id_12 FROM course t0 INNER JOIN course_card_set ON t0.id = course_card_set.course_id WHERE course_card_set.card_set_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.course_type AS course_type_6,
  t0.max_participants AS max_participants_7,
  t0.course_code AS course_code_8,
  t0.is_active AS is_active_9,
  t0.public AS public_10,
  t0.user_id AS user_id_11,
  t0.source_document_id AS source_document_id_12
FROM
  course t0
  INNER JOIN course_card_set ON t0.id = course_card_set.course_id
WHERE
  course_card_set.card_set_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.course_type AS course_type_6, t0.max_participants AS max_participants_7, t0.course_code AS course_code_8, t0.is_active AS is_active_9, t0.public AS public_10, t0.user_id AS user_id_11, t0.source_document_id AS source_document_id_12 FROM course t0 INNER JOIN course_card_set ON t0.id = course_card_set.course_id WHERE course_card_set.card_set_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 228)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Serializer->serialize (line 131)
13	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
15	App\Controller\Api\CardSetController->list (line 38)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

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\Card	4
App\Entity\User	1
App\Entity\Company	1
App\Entity\CardSet	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\Card	No errors.
App\Entity\Module	No errors.
App\Entity\CardAnswer	No errors.
App\Entity\Tag	No errors.

Symfony Profiler

GET https://courseforge.info/api/cardsets

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping