Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

2.46 ms Query time

0 Invalid entities

11 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.66 ms

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_36, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_37, t0.albums_display_configuration_id AS albums_display_configuration_id_38 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_36,
  t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_37,
  t0.albums_display_configuration_id AS albums_display_configuration_id_38
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_36, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_37, t0.albums_display_configuration_id AS albums_display_configuration_id_38 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)

0.54 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.image AS image_4, t0.image_small_thumbnail AS image_small_thumbnail_5, t0.image_large_thumbnail AS image_large_thumbnail_6, t0.seen_counter AS seen_counter_7, t0.visibility AS visibility_8, t0.parent_visibility AS parent_visibility_9, t0.final_visibility AS final_visibility_10, t0.scraped_from_url AS scraped_from_url_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.collection_id AS collection_id_14, t0.owner_id AS owner_id_15 FROM koi_item t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))

Parameters:

[
  "019c0887-d7d1-739a-8cf6-bdce0319d11f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.quantity AS quantity_3,
  t0.image AS image_4,
  t0.image_small_thumbnail AS image_small_thumbnail_5,
  t0.image_large_thumbnail AS image_large_thumbnail_6,
  t0.seen_counter AS seen_counter_7,
  t0.visibility AS visibility_8,
  t0.parent_visibility AS parent_visibility_9,
  t0.final_visibility AS final_visibility_10,
  t0.scraped_from_url AS scraped_from_url_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.collection_id AS collection_id_14,
  t0.owner_id AS owner_id_15
FROM
  koi_item 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.quantity AS quantity_3, t0.image AS image_4, t0.image_small_thumbnail AS image_small_thumbnail_5, t0.image_large_thumbnail AS image_large_thumbnail_6, t0.seen_counter AS seen_counter_7, t0.visibility AS visibility_8, t0.parent_visibility AS parent_visibility_9, t0.final_visibility AS final_visibility_10, t0.scraped_from_url AS scraped_from_url_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.collection_id AS collection_id_14, t0.owner_id AS owner_id_15 FROM koi_item t0 WHERE t0.id = '019c0887-d7d1-739a-8cf6-bdce0319d11f' 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)

0.72 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_13, t0.parent_id AS parent_id_14, t0.owner_id AS owner_id_15, t0.items_display_configuration_id AS items_display_configuration_id_16, t0.items_default_template_id AS items_default_template_id_17 FROM koi_collection t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))

Parameters:

[
  "019c069c-1868-75d3-85d0-acd25fad1f31"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.color AS color_3,
  t0.image AS image_4,
  t0.seen_counter AS seen_counter_5,
  t0.cached_values AS cached_values_6,
  t0.visibility AS visibility_7,
  t0.parent_visibility AS parent_visibility_8,
  t0.final_visibility AS final_visibility_9,
  t0.scraped_from_url AS scraped_from_url_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.children_display_configuration_id AS children_display_configuration_id_13,
  t0.parent_id AS parent_id_14,
  t0.owner_id AS owner_id_15,
  t0.items_display_configuration_id AS items_display_configuration_id_16,
  t0.items_default_template_id AS items_default_template_id_17
FROM
  koi_collection t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_13, t0.parent_id AS parent_id_14, t0.owner_id AS owner_id_15, t0.items_display_configuration_id AS items_display_configuration_id_16, t0.items_default_template_id AS items_default_template_id_17 FROM koi_collection t0 WHERE t0.id = '019c069c-1868-75d3-85d0-acd25fad1f31' 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\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Collection::getTitle (line 200)
5	App\Entity\Collection->__toString (line 178)
6	App\Service\BreadcrumbBuilder->build (line 24)
7	App\Service\BreadcrumbBuilder->build (line 39)
8	App\Twig\BreadcrumbExtension->buildBreadcrumb (line 37)
9	__TwigTemplate_0a7024506260ccf6e2f1e6c93412a84a->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\ItemController->loan (line 180)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
23	frankenphp_handle_request (line 57)
24	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
25	require_once (line 33)
26	require_once (line 5)

0.54 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_13, t0.parent_id AS parent_id_14, t0.owner_id AS owner_id_15, t0.items_display_configuration_id AS items_display_configuration_id_16, t0.items_default_template_id AS items_default_template_id_17 FROM koi_collection t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))

Parameters:

[
  "019c0688-c713-75a5-978b-4985aad181ea"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.color AS color_3,
  t0.image AS image_4,
  t0.seen_counter AS seen_counter_5,
  t0.cached_values AS cached_values_6,
  t0.visibility AS visibility_7,
  t0.parent_visibility AS parent_visibility_8,
  t0.final_visibility AS final_visibility_9,
  t0.scraped_from_url AS scraped_from_url_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.children_display_configuration_id AS children_display_configuration_id_13,
  t0.parent_id AS parent_id_14,
  t0.owner_id AS owner_id_15,
  t0.items_display_configuration_id AS items_display_configuration_id_16,
  t0.items_default_template_id AS items_default_template_id_17
FROM
  koi_collection t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_13, t0.parent_id AS parent_id_14, t0.owner_id AS owner_id_15, t0.items_display_configuration_id AS items_display_configuration_id_16, t0.items_default_template_id AS items_default_template_id_17 FROM koi_collection t0 WHERE t0.id = '019c0688-c713-75a5-978b-4985aad181ea' 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\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Collection::getTitle (line 200)
5	App\Entity\Collection->__toString (line 178)
6	App\Service\BreadcrumbBuilder->build (line 24)
7	App\Service\BreadcrumbBuilder->build (line 32)
8	App\Service\BreadcrumbBuilder->build (line 39)
9	App\Twig\BreadcrumbExtension->buildBreadcrumb (line 37)
10	__TwigTemplate_0a7024506260ccf6e2f1e6c93412a84a->doDisplay (line 55)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Controller\ItemController->loan (line 180)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
24	frankenphp_handle_request (line 57)
25	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
26	require_once (line 33)
27	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\DisplayConfiguration	7
App\Entity\Collection	2
App\Entity\User	1
App\Entity\Item	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.
App\Entity\Configuration	No errors.

Symfony Profiler

GET http://192.168.4.6:7655/items/019c0887-d7d1-739a-8cf6-bdce0319d11f/loan

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping