Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.90 ms Query time

5 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.44 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.version AS version_4, t0.author AS author_5, t0.description AS description_6, t0.license AS license_7, t0.state AS state_8, t0.path AS path_9, t0.manifest AS manifest_10, t0.pteroca_min_version AS pteroca_min_version_11, t0.pteroca_max_version AS pteroca_max_version_12, t0.enabled_at AS enabled_at_13, t0.disabled_at AS disabled_at_14, t0.fault_reason AS fault_reason_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM plugin t0 WHERE t0.state = ? ORDER BY t0.name ASC

Parameters:

[
  "enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.version AS version_4,
  t0.author AS author_5,
  t0.description AS description_6,
  t0.license AS license_7,
  t0.state AS state_8,
  t0.path AS path_9,
  t0.manifest AS manifest_10,
  t0.pteroca_min_version AS pteroca_min_version_11,
  t0.pteroca_max_version AS pteroca_max_version_12,
  t0.enabled_at AS enabled_at_13,
  t0.disabled_at AS disabled_at_14,
  t0.fault_reason AS fault_reason_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  plugin t0
WHERE
  t0.state = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.version AS version_4, t0.author AS author_5, t0.description AS description_6, t0.license AS license_7, t0.state AS state_8, t0.path AS path_9, t0.manifest AS manifest_10, t0.pteroca_min_version AS pteroca_min_version_11, t0.pteroca_max_version AS pteroca_max_version_12, t0.enabled_at AS enabled_at_13, t0.disabled_at AS disabled_at_14, t0.fault_reason AS fault_reason_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM plugin t0 WHERE t0.state = 'enabled' ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Core\Repository\PluginRepository->findByState (line 28)
5	App\Core\Repository\PluginRepository->findEnabled (line 36)
6	App\Core\EventSubscriber\Plugin\PluginBootSubscriber->onKernelRequest (line 63)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 7)

0.24 ms

SELECT t0.id AS id_1, t0.pterodactyl_user_id AS pterodactyl_user_id_2, t0.pterodactyl_user_api_key AS pterodactyl_user_api_key_3, t0.email AS email_4, t0.roles AS roles_5, t0.balance AS balance_6, t0.name AS name_7, t0.surname AS surname_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.is_blocked AS is_blocked_12, t0.avatar_path AS avatar_path_13, t0.deleted_at AS deleted_at_14, t0.password AS password_15 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pterodactyl_user_id AS pterodactyl_user_id_2,
  t0.pterodactyl_user_api_key AS pterodactyl_user_api_key_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.balance AS balance_6,
  t0.name AS name_7,
  t0.surname AS surname_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_verified AS is_verified_11,
  t0.is_blocked AS is_blocked_12,
  t0.avatar_path AS avatar_path_13,
  t0.deleted_at AS deleted_at_14,
  t0.password AS password_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.pterodactyl_user_id AS pterodactyl_user_id_2, t0.pterodactyl_user_api_key AS pterodactyl_user_api_key_3, t0.email AS email_4, t0.roles AS roles_5, t0.balance AS balance_6, t0.name AS name_7, t0.surname AS surname_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.is_blocked AS is_blocked_12, t0.avatar_path AS avatar_path_13, t0.deleted_at AS deleted_at_14, t0.password AS password_15 FROM user t0 WHERE t0.id = 1;

#	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\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
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 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 7)

0.21 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.is_system AS is_system_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.description AS description_4,
  t0.is_system AS is_system_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.is_system AS is_system_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Core\Entity\User->getRoles (line 147)
8	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 318)
9	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 7)

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\Core\Entity\User	1
App\Core\Entity\Role	1

Entities Mapping

Class	Mapping errors
App\Core\Entity\Plugin	No errors.
App\Core\Entity\User	The field 'App\Core\Entity\User#balance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Core\Entity\User#logs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Core\Entity\Log#user does not contain the required 'inversedBy: "logs"' attribute.
App\Core\Entity\Log	No errors.
App\Core\Entity\Role	No errors.
App\Core\Entity\Permission	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Core\Entity\Payment	The field 'App\Core\Entity\Payment#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Core\Entity\Payment#balanceAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Core\Entity\Server	No errors.
App\Core\Entity\VoucherUsage	No errors.
App\Core\Entity\Panel\UserAccount	No errors.
App\Core\Entity\Panel\UserPayment	The field 'App\Core\Entity\Panel\UserPayment#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Core\Entity\Panel\UserPayment#balanceAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Core\Entity\ProductPrice	The field 'App\Core\Entity\ProductPrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Core\Entity\ServerProductPrice	The field 'App\Core\Entity\ServerProductPrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Core\Entity\Setting	No errors.
App\Core\Entity\ServerSubuser	No errors.
App\Core\Entity\EmailLog	No errors.
App\Core\Entity\ServerLog	No errors.
App\Core\Entity\Voucher	No errors.
App\Core\Entity\PasswordResetRequest	No errors.
App\Core\Entity\Category	No errors.
App\Core\Entity\PurchaseToken	No errors.
App\Core\Entity\Product	No errors.
App\Core\Entity\ServerProduct	No errors.
App\Core\Entity\SettingOption	No errors.

Symfony Profiler

GET https://www.redix-hosting.com/panel/server/56/mods

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping