Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.27 ms Query time

0 Invalid entities

17 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.91 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_33, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_34, t0.albums_display_configuration_id AS albums_display_configuration_id_35 FROM koi_user t0 WHERE t0.username = ? AND ((t0.visibility = 'public')) LIMIT 1

Parameters:

[
  "FieserOstfriese"
]

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_33,
  t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_34,
  t0.albums_display_configuration_id AS albums_display_configuration_id_35
FROM
  koi_user t0
WHERE
  t0.username = ?
  AND (
    (t0.visibility = 'public')
  )
LIMIT
  1

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_33, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_34, t0.albums_display_configuration_id AS albums_display_configuration_id_35 FROM koi_user t0 WHERE t0.username = 'FieserOstfriese' AND ((t0.visibility = 'public')) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\EventListener\FilterListener->setContextUser (line 60)
5	App\EventListener\FilterListener->onKernelRequest (line 44)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
14	frankenphp_handle_request (line 57)
15	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
16	require_once (line 33)
17	require_once (line 5)

1.00 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_18, t0.parent_id AS parent_id_19, t0.owner_id AS owner_id_20, t0.items_display_configuration_id AS items_display_configuration_id_21, t0.items_default_template_id AS items_default_template_id_22 FROM koi_collection t0 WHERE t0.parent_id IS NULL AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.title ASC

Parameters:

[]

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_18,
  t0.parent_id AS parent_id_19,
  t0.owner_id AS owner_id_20,
  t0.items_display_configuration_id AS items_display_configuration_id_21,
  t0.items_default_template_id AS items_default_template_id_22
FROM
  koi_collection t0
WHERE
  t0.parent_id IS NULL
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
    AND (t0.final_visibility = 'public')
  )
ORDER BY
  t0.title ASC

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_18, t0.parent_id AS parent_id_19, t0.owner_id AS owner_id_20, t0.items_display_configuration_id AS items_display_configuration_id_21, t0.items_default_template_id AS items_default_template_id_22 FROM koi_collection t0 WHERE t0.parent_id IS NULL AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.title ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\CollectionController->index (line 36)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
9	frankenphp_handle_request (line 57)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
11	require_once (line 33)
12	require_once (line 5)

1.37 ms

SELECT t0.id AS id_1, t0.label AS label_2, t0.display_mode AS display_mode_3, t0.sorting_property AS sorting_property_4, t0.sorting_type AS sorting_type_5, t0.sorting_direction AS sorting_direction_6, t0.show_visibility AS show_visibility_7, t0.show_actions AS show_actions_8, t0.show_number_of_children AS show_number_of_children_9, t0.show_number_of_items AS show_number_of_items_10, t0.show_item_quantities AS show_item_quantities_11, t0.columns AS columns_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_16 FROM koi_display_configuration t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))

Parameters:

[
  "019c0687-41d4-7320-8215-d234723464ed"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.display_mode AS display_mode_3,
  t0.sorting_property AS sorting_property_4,
  t0.sorting_type AS sorting_type_5,
  t0.sorting_direction AS sorting_direction_6,
  t0.show_visibility AS show_visibility_7,
  t0.show_actions AS show_actions_8,
  t0.show_number_of_children AS show_number_of_children_9,
  t0.show_number_of_items AS show_number_of_items_10,
  t0.show_item_quantities AS show_item_quantities_11,
  t0.columns AS columns_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.owner_id AS owner_id_16
FROM
  koi_display_configuration t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

SELECT t0.id AS id_1, t0.label AS label_2, t0.display_mode AS display_mode_3, t0.sorting_property AS sorting_property_4, t0.sorting_type AS sorting_type_5, t0.sorting_direction AS sorting_direction_6, t0.show_visibility AS show_visibility_7, t0.show_actions AS show_actions_8, t0.show_number_of_children AS show_number_of_children_9, t0.show_number_of_items AS show_number_of_items_10, t0.show_item_quantities AS show_item_quantities_11, t0.columns AS columns_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_16 FROM koi_display_configuration t0 WHERE t0.id = '019c0687-41d4-7320-8215-d234723464ed' 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	Twig\Extension\CoreExtension::getAttribute (line 1787)
5	__TwigTemplate_a3a94b001adf9cc9010bcee918a028ca::block_content (line 245)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_2112c8446f0893135c48a5c1d1006b18->block_body (line 249)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_d9a605cc6c40e7834cc6d497384ad913->doDisplay (line 179)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_2112c8446f0893135c48a5c1d1006b18->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a3a94b001adf9cc9010bcee918a028ca->doDisplay (line 59)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\CollectionController->index (line 45)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
27	frankenphp_handle_request (line 57)
28	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
29	require_once (line 33)
30	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	11
App\Entity\Collection	4
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\Field	No errors.
App\Entity\Item	No errors.
App\Entity\Datum	No errors.
App\Entity\Wish	No errors.
App\Entity\Photo	No errors.
App\Entity\Path	No errors.
App\Entity\SearchBlock	No errors.
App\Entity\Loan	No errors.
App\Entity\SearchFilter	No errors.
App\Entity\Configuration	No errors.
App\Entity\Error	No errors.

Symfony Profiler

GET https://games.tenorweb.de/user/FieserOstfriese

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping