Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.91 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.92 ms
(66.31%)

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.quantity AS quantity_2, k0_.image AS image_3, k0_.image_small_thumbnail AS image_small_thumbnail_4, k0_.image_large_thumbnail AS image_large_thumbnail_5, k0_.seen_counter AS seen_counter_6, k0_.visibility AS visibility_7, k0_.parent_visibility AS parent_visibility_8, k0_.final_visibility AS final_visibility_9, k0_.scraped_from_url AS scraped_from_url_10, k0_.created_at AS created_at_11, k0_.updated_at AS updated_at_12, k1_.id AS id_13, k1_.type AS type_14, k1_.label AS label_15, k1_.value AS value_16, k1_.position AS position_17, k1_.currency AS currency_18, k1_.image AS image_19, k1_.image_small_thumbnail AS image_small_thumbnail_20, k1_.image_large_thumbnail AS image_large_thumbnail_21, k1_.file AS file_22, k1_.video AS video_23, k1_.original_filename AS original_filename_24, k1_.visibility AS visibility_25, k1_.parent_visibility AS parent_visibility_26, k1_.final_visibility AS final_visibility_27, k1_.created_at AS created_at_28, k1_.updated_at AS updated_at_29, k0_.collection_id AS collection_id_30, k0_.owner_id AS owner_id_31, k1_.item_id AS item_id_32, k1_.collection_id AS collection_id_33, k1_.choice_list_id AS choice_list_id_34, k1_.owner_id AS owner_id_35 FROM koi_item k0_ LEFT JOIN koi_datum k1_ ON k0_.id = k1_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.final_visibility = 'public') WHERE (k1_.type = ?) AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public') ORDER BY k0_.name ASC, k1_.position ASC

Parameters:

[
  "sign"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.quantity AS quantity_2,
  k0_.image AS image_3,
  k0_.image_small_thumbnail AS image_small_thumbnail_4,
  k0_.image_large_thumbnail AS image_large_thumbnail_5,
  k0_.seen_counter AS seen_counter_6,
  k0_.visibility AS visibility_7,
  k0_.parent_visibility AS parent_visibility_8,
  k0_.final_visibility AS final_visibility_9,
  k0_.scraped_from_url AS scraped_from_url_10,
  k0_.created_at AS created_at_11,
  k0_.updated_at AS updated_at_12,
  k1_.id AS id_13,
  k1_.type AS type_14,
  k1_.label AS label_15,
  k1_.value AS value_16,
  k1_.position AS position_17,
  k1_.currency AS currency_18,
  k1_.image AS image_19,
  k1_.image_small_thumbnail AS image_small_thumbnail_20,
  k1_.image_large_thumbnail AS image_large_thumbnail_21,
  k1_.file AS file_22,
  k1_.video AS video_23,
  k1_.original_filename AS original_filename_24,
  k1_.visibility AS visibility_25,
  k1_.parent_visibility AS parent_visibility_26,
  k1_.final_visibility AS final_visibility_27,
  k1_.created_at AS created_at_28,
  k1_.updated_at AS updated_at_29,
  k0_.collection_id AS collection_id_30,
  k0_.owner_id AS owner_id_31,
  k1_.item_id AS item_id_32,
  k1_.collection_id AS collection_id_33,
  k1_.choice_list_id AS choice_list_id_34,
  k1_.owner_id AS owner_id_35
FROM
  koi_item k0_
  LEFT JOIN koi_datum k1_ ON k0_.id = k1_.item_id
  AND (
    k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k1_.final_visibility = 'public')
WHERE
  (k1_.type = ?)
  AND (
    k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k0_.final_visibility = 'public')
ORDER BY
  k0_.name ASC,
  k1_.position ASC

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.quantity AS quantity_2, k0_.image AS image_3, k0_.image_small_thumbnail AS image_small_thumbnail_4, k0_.image_large_thumbnail AS image_large_thumbnail_5, k0_.seen_counter AS seen_counter_6, k0_.visibility AS visibility_7, k0_.parent_visibility AS parent_visibility_8, k0_.final_visibility AS final_visibility_9, k0_.scraped_from_url AS scraped_from_url_10, k0_.created_at AS created_at_11, k0_.updated_at AS updated_at_12, k1_.id AS id_13, k1_.type AS type_14, k1_.label AS label_15, k1_.value AS value_16, k1_.position AS position_17, k1_.currency AS currency_18, k1_.image AS image_19, k1_.image_small_thumbnail AS image_small_thumbnail_20, k1_.image_large_thumbnail AS image_large_thumbnail_21, k1_.file AS file_22, k1_.video AS video_23, k1_.original_filename AS original_filename_24, k1_.visibility AS visibility_25, k1_.parent_visibility AS parent_visibility_26, k1_.final_visibility AS final_visibility_27, k1_.created_at AS created_at_28, k1_.updated_at AS updated_at_29, k0_.collection_id AS collection_id_30, k0_.owner_id AS owner_id_31, k1_.item_id AS item_id_32, k1_.collection_id AS collection_id_33, k1_.choice_list_id AS choice_list_id_34, k1_.owner_id AS owner_id_35 FROM koi_item k0_ LEFT JOIN koi_datum k1_ ON k0_.id = k1_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.final_visibility = 'public') WHERE (k1_.type = 'sign') AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public') ORDER BY k0_.name ASC, k1_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ItemRepository->findWithSigns (line 192)
7	App\Controller\SignController->index (line 20)
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)

1.99 ms
(33.69%)

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_39, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_40, t0.albums_display_configuration_id AS albums_display_configuration_id_41 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_39,
  t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_40,
  t0.albums_display_configuration_id AS albums_display_configuration_id_41
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_39, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_40, t0.albums_display_configuration_id AS albums_display_configuration_id_41 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)

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	3
App\Entity\User	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/signatures

Configuration Settings

Theme

Page Width