Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.01 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.74 ms
(37.02%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.id_card AS id_card_6, t0.cover AS cover_7, t0.idno AS idno_8, t0.is_resigned AS is_resigned_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_deleted AS is_deleted_12, t0.merchant_id AS merchant_id_13 FROM student t0 WHERE t0.id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.id_card AS id_card_6,
  t0.cover AS cover_7,
  t0.idno AS idno_8,
  t0.is_resigned AS is_resigned_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.is_deleted AS is_deleted_12,
  t0.merchant_id AS merchant_id_13
FROM
  student t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.id_card AS id_card_6, t0.cover AS cover_7, t0.idno AS idno_8, t0.is_resigned AS is_resigned_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_deleted AS is_deleted_12, t0.merchant_id AS merchant_id_13 FROM student t0 WHERE t0.id = 39;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 43)
7	App\Controller\Api\WatchController->new (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.34 ms
(17.01%)

SELECT t0.id AS id_1, t0.is_completed AS is_completed_2, t0.watch_seconds AS watch_seconds_3, t0.ip AS ip_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_deleted AS is_deleted_9, t0.student_id AS student_id_10, t0.video_id AS video_id_11 FROM video_watch_log t0 WHERE t0.student_id = ? AND t0.video_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_completed AS is_completed_2,
  t0.watch_seconds AS watch_seconds_3,
  t0.ip AS ip_4,
  t0.start_time AS start_time_5,
  t0.end_time AS end_time_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.is_deleted AS is_deleted_9,
  t0.student_id AS student_id_10,
  t0.video_id AS video_id_11
FROM
  video_watch_log t0
WHERE
  t0.student_id = ?
  AND t0.video_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_completed AS is_completed_2, t0.watch_seconds AS watch_seconds_3, t0.ip AS ip_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_deleted AS is_deleted_9, t0.student_id AS student_id_10, t0.video_id AS video_id_11 FROM video_watch_log t0 WHERE t0.student_id = 39 AND t0.video_id = 31 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 53)
5	App\Controller\Api\WatchController->new (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.29 ms
(14.33%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.file_id AS file_id_4, t0.teacher AS teacher_5, t0.duration AS duration_6, t0.credit_hours AS credit_hours_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_deleted AS is_deleted_10, t0.chapter_id AS chapter_id_11 FROM video t0 WHERE t0.id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.file_id AS file_id_4,
  t0.teacher AS teacher_5,
  t0.duration AS duration_6,
  t0.credit_hours AS credit_hours_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_deleted AS is_deleted_10,
  t0.chapter_id AS chapter_id_11
FROM
  video t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.file_id AS file_id_4, t0.teacher AS teacher_5, t0.duration AS duration_6, t0.credit_hours AS credit_hours_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_deleted AS is_deleted_10, t0.chapter_id AS chapter_id_11 FROM video t0 WHERE t0.id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 47)
7	App\Controller\Api\WatchController->new (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.25 ms
(12.59%)

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = ? AND t0.video_id = ? AND t0.start_time = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.action_target AS action_target_4,
  t0.action_type AS action_type_5,
  t0.platform AS platform_6,
  t0.ip AS ip_7,
  t0.duration AS duration_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_deleted AS is_deleted_11,
  t0.student_id AS student_id_12,
  t0.video_id AS video_id_13
FROM
  learn_track t0
WHERE
  t0.student_id = ?
  AND t0.video_id = ?
  AND t0.start_time = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = 39 AND t0.video_id = 31 AND t0.start_time = 1782202099 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 55)
5	App\Controller\Api\WatchController->new (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.20 ms
(10.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_deleted AS is_deleted_5, t0.major_id AS major_id_6 FROM chapter t0 WHERE t0.id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.is_deleted AS is_deleted_5,
  t0.major_id AS major_id_6
FROM
  chapter t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_deleted AS is_deleted_5, t0.major_id AS major_id_6 FROM chapter t0 WHERE t0.id = 23;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Chapter::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Chapter->__get (line 61)
8	App\Entity\Chapter->getMajor (line 51)
9	App\Controller\Api\WatchController->new (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.18 ms
(9.05%)

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = ? AND t0.video_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.action_target AS action_target_4,
  t0.action_type AS action_type_5,
  t0.platform AS platform_6,
  t0.ip AS ip_7,
  t0.duration AS duration_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_deleted AS is_deleted_11,
  t0.student_id AS student_id_12,
  t0.video_id AS video_id_13
FROM
  learn_track t0
WHERE
  t0.student_id = ?
  AND t0.video_id = ?

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = 39 AND t0.video_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 108)
5	App\Controller\Api\WatchController->new (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Student	1
App\Entity\Merchant	1
App\Entity\Video	1
App\Entity\Chapter	1
App\Entity\Major	1
App\Entity\VideoWatchLog	1
App\Entity\LearnTrack	1

Entities Mapping

Class	Mapping errors
App\Entity\Student	No errors.
App\Entity\Merchant	No errors.
App\Entity\VideoWatchLog	No errors.
App\Entity\VerificationLog	No errors.
App\Entity\LearnTrack	No errors.
App\Entity\GradeStudent	No errors.
App\Entity\StudentMajor	No errors.
App\Entity\Video	No errors.
App\Entity\Chapter	No errors.
App\Entity\Major	No errors.

Symfony Profiler

POST https://www.penghongzx.com/api/watch

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping