Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.67 ms Query time

2 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.21 ms
(31.25%)

SELECT t0.id AS id_1, t0.pterodactyl_server_id AS pterodactyl_server_id_2, t0.pterodactyl_server_identifier AS pterodactyl_server_identifier_3, t0.name AS name_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.expires_at AS expires_at_7, t0.is_suspended AS is_suspended_8, t0.auto_renewal AS auto_renewal_9, t10.selected_node_id AS selected_node_id_11, t10.id AS id_12, t10.name AS name_13, t10.disk_space AS disk_space_14, t10.memory AS memory_15, t10.io AS io_16, t10.cpu AS cpu_17, t10.threads AS threads_18, t10.db_count AS db_count_19, t10.swap AS swap_20, t10.backups AS backups_21, t10.ports AS ports_22, t10.schedules AS schedules_23, t10.nodes AS nodes_24, t10.nest AS nest_25, t10.eggs AS eggs_26, t10.eggs_configuration AS eggs_configuration_27, t10.allow_change_egg AS allow_change_egg_28, t10.allow_auto_renewal AS allow_auto_renewal_29, t10.allow_user_select_location AS allow_user_select_location_30, t10.server_id AS server_id_31, t10.original_product_id AS original_product_id_32, t0.user_id AS user_id_33 FROM server t0 LEFT JOIN server_product t10 ON t10.server_id = t0.id WHERE t0.id = ?

Parameters:

[
  "57"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pterodactyl_server_id AS pterodactyl_server_id_2,
  t0.pterodactyl_server_identifier AS pterodactyl_server_identifier_3,
  t0.name AS name_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.expires_at AS expires_at_7,
  t0.is_suspended AS is_suspended_8,
  t0.auto_renewal AS auto_renewal_9,
  t10.selected_node_id AS selected_node_id_11,
  t10.id AS id_12,
  t10.name AS name_13,
  t10.disk_space AS disk_space_14,
  t10.memory AS memory_15,
  t10.io AS io_16,
  t10.cpu AS cpu_17,
  t10.threads AS threads_18,
  t10.db_count AS db_count_19,
  t10.swap AS swap_20,
  t10.backups AS backups_21,
  t10.ports AS ports_22,
  t10.schedules AS schedules_23,
  t10.nodes AS nodes_24,
  t10.nest AS nest_25,
  t10.eggs AS eggs_26,
  t10.eggs_configuration AS eggs_configuration_27,
  t10.allow_change_egg AS allow_change_egg_28,
  t10.allow_auto_renewal AS allow_auto_renewal_29,
  t10.allow_user_select_location AS allow_user_select_location_30,
  t10.server_id AS server_id_31,
  t10.original_product_id AS original_product_id_32,
  t0.user_id AS user_id_33
FROM
  server t0
  LEFT JOIN server_product t10 ON t10.server_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.pterodactyl_server_id AS pterodactyl_server_id_2, t0.pterodactyl_server_identifier AS pterodactyl_server_identifier_3, t0.name AS name_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.expires_at AS expires_at_7, t0.is_suspended AS is_suspended_8, t0.auto_renewal AS auto_renewal_9, t10.selected_node_id AS selected_node_id_11, t10.id AS id_12, t10.name AS name_13, t10.disk_space AS disk_space_14, t10.memory AS memory_15, t10.io AS io_16, t10.cpu AS cpu_17, t10.threads AS threads_18, t10.db_count AS db_count_19, t10.swap AS swap_20, t10.backups AS backups_21, t10.ports AS ports_22, t10.schedules AS schedules_23, t10.nodes AS nodes_24, t10.nest AS nest_25, t10.eggs AS eggs_26, t10.eggs_configuration AS eggs_configuration_27, t10.allow_change_egg AS allow_change_egg_28, t10.allow_auto_renewal AS allow_auto_renewal_29, t10.allow_user_select_location AS allow_user_select_location_30, t10.server_id AS server_id_31, t10.original_product_id AS original_product_id_32, t0.user_id AS user_id_33 FROM server t0 LEFT JOIN server_product t10 ON t10.server_id = t0.id WHERE t0.id = '57';

#	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\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 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 7)

0.16 ms
(24.23%)

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:

[
  13
]

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 = 13;

#	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)

0.16 ms
(23.24%)

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:

[
  13
]

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 = 13;

#	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.14 ms
(21.28%)

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)

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
App\Core\Entity\Server	1
App\Core\Entity\ServerProduct	1
App\Core\Entity\Product	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.
App\Core\Entity\Server	No errors.
App\Core\Entity\ServerProduct	No errors.
App\Core\Entity\Product	No errors.
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.

Symfony Profiler

GET https://www.redix-hosting.com/panel/server/57/files/list?dir=%2F

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping