Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.93 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.93 ms
(100.00%)

SELECT k0_.id AS id_0, k0_.username AS username_1, k0_.email AS email_2, k0_.password AS password_3, k0_.avatar AS avatar_4, k0_.enabled AS enabled_5, k0_.roles AS roles_6, k0_.currency AS currency_7, k0_.locale AS locale_8, k0_.timezone AS timezone_9, k0_.date_format AS date_format_10, k0_.disk_space_allowed AS disk_space_allowed_11, k0_.visibility AS visibility_12, k0_.last_date_of_activity AS last_date_of_activity_13, k0_.theme AS theme_14, k0_.wishlists_feature_enabled AS wishlists_feature_enabled_15, k0_.tags_feature_enabled AS tags_feature_enabled_16, k0_.signs_feature_enabled AS signs_feature_enabled_17, k0_.albums_feature_enabled AS albums_feature_enabled_18, k0_.loans_feature_enabled AS loans_feature_enabled_19, k0_.templates_feature_enabled AS templates_feature_enabled_20, k0_.history_feature_enabled AS history_feature_enabled_21, k0_.statistics_feature_enabled AS statistics_feature_enabled_22, k0_.scraping_feature_enabled AS scraping_feature_enabled_23, k0_.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_24, k0_.display_items_name_in_grid_view AS display_items_name_in_grid_view_25, k0_.search_results_display_mode AS search_results_display_mode_26, k0_.created_at AS created_at_27, k0_.updated_at AS updated_at_28, k0_.collections_display_configuration_id AS collections_display_configuration_id_29, k0_.wishlists_display_configuration_id AS wishlists_display_configuration_id_30, k0_.albums_display_configuration_id AS albums_display_configuration_id_31 FROM koi_user k0_ WHERE k0_.username = ? OR k0_.email = ?

Parameters:

[
  "g.tenor@tenoronline.net"
  "g.tenor@tenoronline.net"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k0_.id AS id_0,
  k0_.username AS username_1,
  k0_.email AS email_2,
  k0_.password AS password_3,
  k0_.avatar AS avatar_4,
  k0_.enabled AS enabled_5,
  k0_.roles AS roles_6,
  k0_.currency AS currency_7,
  k0_.locale AS locale_8,
  k0_.timezone AS timezone_9,
  k0_.date_format AS date_format_10,
  k0_.disk_space_allowed AS disk_space_allowed_11,
  k0_.visibility AS visibility_12,
  k0_.last_date_of_activity AS last_date_of_activity_13,
  k0_.theme AS theme_14,
  k0_.wishlists_feature_enabled AS wishlists_feature_enabled_15,
  k0_.tags_feature_enabled AS tags_feature_enabled_16,
  k0_.signs_feature_enabled AS signs_feature_enabled_17,
  k0_.albums_feature_enabled AS albums_feature_enabled_18,
  k0_.loans_feature_enabled AS loans_feature_enabled_19,
  k0_.templates_feature_enabled AS templates_feature_enabled_20,
  k0_.history_feature_enabled AS history_feature_enabled_21,
  k0_.statistics_feature_enabled AS statistics_feature_enabled_22,
  k0_.scraping_feature_enabled AS scraping_feature_enabled_23,
  k0_.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_24,
  k0_.display_items_name_in_grid_view AS display_items_name_in_grid_view_25,
  k0_.search_results_display_mode AS search_results_display_mode_26,
  k0_.created_at AS created_at_27,
  k0_.updated_at AS updated_at_28,
  k0_.collections_display_configuration_id AS collections_display_configuration_id_29,
  k0_.wishlists_display_configuration_id AS wishlists_display_configuration_id_30,
  k0_.albums_display_configuration_id AS albums_display_configuration_id_31
FROM
  koi_user k0_
WHERE
  k0_.username = ?
  OR k0_.email = ?

SELECT k0_.id AS id_0, k0_.username AS username_1, k0_.email AS email_2, k0_.password AS password_3, k0_.avatar AS avatar_4, k0_.enabled AS enabled_5, k0_.roles AS roles_6, k0_.currency AS currency_7, k0_.locale AS locale_8, k0_.timezone AS timezone_9, k0_.date_format AS date_format_10, k0_.disk_space_allowed AS disk_space_allowed_11, k0_.visibility AS visibility_12, k0_.last_date_of_activity AS last_date_of_activity_13, k0_.theme AS theme_14, k0_.wishlists_feature_enabled AS wishlists_feature_enabled_15, k0_.tags_feature_enabled AS tags_feature_enabled_16, k0_.signs_feature_enabled AS signs_feature_enabled_17, k0_.albums_feature_enabled AS albums_feature_enabled_18, k0_.loans_feature_enabled AS loans_feature_enabled_19, k0_.templates_feature_enabled AS templates_feature_enabled_20, k0_.history_feature_enabled AS history_feature_enabled_21, k0_.statistics_feature_enabled AS statistics_feature_enabled_22, k0_.scraping_feature_enabled AS scraping_feature_enabled_23, k0_.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_24, k0_.display_items_name_in_grid_view AS display_items_name_in_grid_view_25, k0_.search_results_display_mode AS search_results_display_mode_26, k0_.created_at AS created_at_27, k0_.updated_at AS updated_at_28, k0_.collections_display_configuration_id AS collections_display_configuration_id_29, k0_.wishlists_display_configuration_id AS wishlists_display_configuration_id_30, k0_.albums_display_configuration_id AS albums_display_configuration_id_31 FROM koi_user k0_ WHERE k0_.username = 'g.tenor@tenoronline.net' OR k0_.email = 'g.tenor@tenoronline.net';

#	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->getOneOrNullResult (line 737)
6	App\Repository\UserRepository->findOneByUsernameOrEmail (line 28)
7	App\Security\UsernameOrEmailPasswordAuthenticator->{closure:App\Security\UsernameOrEmailPasswordAuthenticator::authenticate():42} (line 43)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
31	frankenphp_handle_request (line 57)
32	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
33	require_once (line 33)
34	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\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\Loan	No errors.
App\Entity\SearchFilter	No errors.

Symfony Profiler

POST http://192.168.4.6:7655/

Configuration Settings

Theme

Page Width