GET https://www.redix-hosting.com/panel?routeName=admin_overview

Query Metrics

111 Database Queries
16 Different statements
17.19 ms Query time
0 Invalid entities
118 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.74 ms
(39.22%)
86
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.section AS section_5, t0.is_system AS is_system_6, t0.plugin_name AS plugin_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM permission t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "access_admin_overview"
]
4.32 ms
(25.14%)
1
"COMMIT"
Parameters:
[]
1.88 ms
(10.93%)
1
SELECT p0_.state AS state_0, COUNT(p0_.id) AS sclr_1 FROM plugin p0_ GROUP BY p0_.state
Parameters:
[]
1.01 ms
(5.87%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.context AS context_5, t0.hierarchy AS hierarchy_6, t0.nullable AS nullable_7 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "site_title"
]
0.79 ms
(4.62%)
3
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"
]
0.49 ms
(2.84%)
3
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:
[
  4
]
0.29 ms
(1.67%)
1
SELECT COUNT(s0_.id) AS sclr_0 FROM server s0_ WHERE s0_.is_suspended = 0 AND s0_.deleted_at IS NULL
Parameters:
[]
0.28 ms
(1.65%)
1
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.email = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  "[email protected]"
]
0.22 ms
(1.28%)
1
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
]
0.21 ms
(1.22%)
1
SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.created_at > ?
Parameters:
[
  "2026-03-21 22:13:57"
]
0.20 ms
(1.19%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.section AS section_5, t0.is_system AS is_system_6, t0.plugin_name AS plugin_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = ?
Parameters:
[
  1
]
0.19 ms
(1.09%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM payment p0_ WHERE p0_.created_at > ?
Parameters:
[
  "2026-03-21 22:13:57"
]
0.18 ms
(1.06%)
1
SELECT u0_.id AS id_0, u0_.pterodactyl_user_id AS pterodactyl_user_id_1, u0_.pterodactyl_user_api_key AS pterodactyl_user_api_key_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.balance AS balance_5, u0_.name AS name_6, u0_.surname AS surname_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.is_verified AS is_verified_10, u0_.is_blocked AS is_blocked_11, u0_.avatar_path AS avatar_path_12, u0_.deleted_at AS deleted_at_13, u0_.password AS password_14 FROM user u0_ WHERE u0_.deleted_at IS NULL ORDER BY u0_.created_at DESC LIMIT 5
Parameters:
[]
0.17 ms
(0.97%)
1
INSERT INTO log (action_id, details, ip_address, created_at, user_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "login"
  "[]"
  "172.70.243.187"
  "2026-04-21 22:13:57"
  1
]
0.13 ms
(0.78%)
1
SELECT p0_.id AS id_0, p0_.session_id AS session_id_1, p0_.status AS status_2, p0_.amount AS amount_3, p0_.currency AS currency_4, p0_.gateway AS gateway_5, p0_.balance_amount AS balance_amount_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.used_voucher AS used_voucher_9, p0_.user_id AS user_id_10 FROM payment p0_ ORDER BY p0_.created_at DESC LIMIT 5
Parameters:
[]
0.08 ms
(0.47%)
1
"START TRANSACTION"
Parameters:
[]

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\Permission 93
App\Core\Entity\User 9
App\Core\Entity\Setting 6
App\Core\Entity\Payment 5
App\Core\Entity\Plugin 3
App\Core\Entity\Role 1
App\Core\Entity\Log 1

Entities Mapping