Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.86 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.92 ms
(39.61%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.enabled AS enabled_6, t0.roles AS roles_7, t0.currency AS currency_8, t0.locale AS locale_9, t0.timezone AS timezone_10, t0.date_format AS date_format_11, t0.disk_space_allowed AS disk_space_allowed_12, t0.visibility AS visibility_13, t0.last_date_of_activity AS last_date_of_activity_14, t0.theme AS theme_15, t0.wishlists_feature_enabled AS wishlists_feature_enabled_16, t0.tags_feature_enabled AS tags_feature_enabled_17, t0.signs_feature_enabled AS signs_feature_enabled_18, t0.albums_feature_enabled AS albums_feature_enabled_19, t0.loans_feature_enabled AS loans_feature_enabled_20, t0.templates_feature_enabled AS templates_feature_enabled_21, t0.history_feature_enabled AS history_feature_enabled_22, t0.statistics_feature_enabled AS statistics_feature_enabled_23, t0.scraping_feature_enabled AS scraping_feature_enabled_24, t0.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_25, t0.display_items_name_in_grid_view AS display_items_name_in_grid_view_26, t0.search_results_display_mode AS search_results_display_mode_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.collections_display_configuration_id AS collections_display_configuration_id_30, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_31, t0.albums_display_configuration_id AS albums_display_configuration_id_32 FROM koi_user t0 WHERE t0.id = ?

Parameters:

[
  "019c0687-41d4-74e8-8215-d23474287253"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.avatar AS avatar_5,
  t0.enabled AS enabled_6,
  t0.roles AS roles_7,
  t0.currency AS currency_8,
  t0.locale AS locale_9,
  t0.timezone AS timezone_10,
  t0.date_format AS date_format_11,
  t0.disk_space_allowed AS disk_space_allowed_12,
  t0.visibility AS visibility_13,
  t0.last_date_of_activity AS last_date_of_activity_14,
  t0.theme AS theme_15,
  t0.wishlists_feature_enabled AS wishlists_feature_enabled_16,
  t0.tags_feature_enabled AS tags_feature_enabled_17,
  t0.signs_feature_enabled AS signs_feature_enabled_18,
  t0.albums_feature_enabled AS albums_feature_enabled_19,
  t0.loans_feature_enabled AS loans_feature_enabled_20,
  t0.templates_feature_enabled AS templates_feature_enabled_21,
  t0.history_feature_enabled AS history_feature_enabled_22,
  t0.statistics_feature_enabled AS statistics_feature_enabled_23,
  t0.scraping_feature_enabled AS scraping_feature_enabled_24,
  t0.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_25,
  t0.display_items_name_in_grid_view AS display_items_name_in_grid_view_26,
  t0.search_results_display_mode AS search_results_display_mode_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.collections_display_configuration_id AS collections_display_configuration_id_30,
  t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_31,
  t0.albums_display_configuration_id AS albums_display_configuration_id_32
FROM
  koi_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.enabled AS enabled_6, t0.roles AS roles_7, t0.currency AS currency_8, t0.locale AS locale_9, t0.timezone AS timezone_10, t0.date_format AS date_format_11, t0.disk_space_allowed AS disk_space_allowed_12, t0.visibility AS visibility_13, t0.last_date_of_activity AS last_date_of_activity_14, t0.theme AS theme_15, t0.wishlists_feature_enabled AS wishlists_feature_enabled_16, t0.tags_feature_enabled AS tags_feature_enabled_17, t0.signs_feature_enabled AS signs_feature_enabled_18, t0.albums_feature_enabled AS albums_feature_enabled_19, t0.loans_feature_enabled AS loans_feature_enabled_20, t0.templates_feature_enabled AS templates_feature_enabled_21, t0.history_feature_enabled AS history_feature_enabled_22, t0.statistics_feature_enabled AS statistics_feature_enabled_23, t0.scraping_feature_enabled AS scraping_feature_enabled_24, t0.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_25, t0.display_items_name_in_grid_view AS display_items_name_in_grid_view_26, t0.search_results_display_mode AS search_results_display_mode_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.collections_display_configuration_id AS collections_display_configuration_id_30, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_31, t0.albums_display_configuration_id AS albums_display_configuration_id_32 FROM koi_user t0 WHERE t0.id = '019c0687-41d4-74e8-8215-d23474287253';

#	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\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
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 52)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
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 191)
19	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
20	frankenphp_handle_request (line 57)
21	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
22	require_once (line 33)
23	require_once (line 5)

1.51 ms
(31.05%)

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.owner_id AS owner_id_5 FROM koi_template t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))

Parameters:

[
  "019c0883-e011-761a-bae7-568f38cb9369"
]

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.owner_id AS owner_id_5
FROM
  koi_template t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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.owner_id AS owner_id_5 FROM koi_template t0 WHERE t0.id = '019c0883-e011-761a-bae7-568f38cb9369' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

#	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\ServiceEntityRepository->find (line 66)
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 191)
14	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
15	frankenphp_handle_request (line 57)
16	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
17	require_once (line 33)
18	require_once (line 5)

1.43 ms
(29.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.type AS type_4, t0.visibility AS visibility_5, t0.choice_list_id AS choice_list_id_6, t0.template_id AS template_id_7, t0.owner_id AS owner_id_8 FROM koi_field t0 WHERE t0.template_id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253')) ORDER BY t0.position ASC

Parameters:

[
  "019c0883-e011-761a-bae7-568f38cb9369"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.type AS type_4,
  t0.visibility AS visibility_5,
  t0.choice_list_id AS choice_list_id_6,
  t0.template_id AS template_id_7,
  t0.owner_id AS owner_id_8
FROM
  koi_field t0
WHERE
  t0.template_id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.type AS type_4, t0.visibility AS visibility_5, t0.choice_list_id AS choice_list_id_6, t0.template_id AS template_id_7, t0.owner_id AS owner_id_8 FROM koi_field t0 WHERE t0.template_id = '019c0883-e011-761a-bae7-568f38cb9369' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253')) 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->getIterator (line 315)
7	App\Controller\TemplateController->getFields (line 111)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
12	frankenphp_handle_request (line 57)
13	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
14	require_once (line 33)
15	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\Field	5
App\Entity\DisplayConfiguration	3
App\Entity\User	1
App\Entity\Template	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\DisplayConfiguration	No errors.
App\Entity\Collection	No errors.
App\Entity\Tag	No errors.
App\Entity\TagCategory	No errors.
App\Entity\Wishlist	No errors.
App\Entity\Template	No errors.
App\Entity\Log	No errors.
App\Entity\Album	No errors.
App\Entity\Inventory	No errors.
App\Entity\Scraper	No errors.
App\Entity\ChoiceList	No errors.
App\Entity\Search	No errors.
App\Entity\Loan	No errors.
App\Entity\Item	No errors.
App\Entity\Datum	No errors.
App\Entity\Wish	No errors.
App\Entity\Field	No errors.
App\Entity\Photo	No errors.
App\Entity\Path	No errors.
App\Entity\SearchBlock	No errors.
App\Entity\SearchFilter	No errors.

Symfony Profiler

GET http://192.168.4.6:7655/templates/019c0883-e011-761a-bae7-568f38cb9369/fields

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping