Symfony Profiler

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.zip_hash AS zip_hash_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
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.zip_hash AS zip_hash_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM plugin t0 WHERE t0.state = 'enabled' ORDER BY t0.name ASC;

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

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

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

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 = 'purchase_server' LIMIT 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 = ?

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

SELECT
  p0_.id AS id_0,
  p0_.token AS token_1,
  p0_.type AS type_2,
  p0_.created_at AS created_at_3,
  p0_.user_id AS user_id_4
FROM
  purchase_token p0_
WHERE
  p0_.token = ?
  AND p0_.user_id = ?
  AND p0_.type = ?

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.type AS type_2, p0_.created_at AS created_at_3, p0_.user_id AS user_id_4 FROM purchase_token p0_ WHERE p0_.token = '4515606a7fccec2c00e54d216762603a5bb885643d4c02aab5d78e18a9a59f8d' AND p0_.user_id = 2 AND p0_.type = 'buy';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  balance = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET balance = 100001.01, updated_at = '2026-04-21 11:17:33' WHERE id = 2;

DELETE FROM
  purchase_token
WHERE
  id = ?

DELETE FROM purchase_token WHERE id = 9;

"COMMIT"

"COMMIT";

SELECT
  t0.description AS description_1,
  t0.short_description AS short_description_2,
  t0.is_active AS is_active_3,
  t0.priority AS priority_4,
  t0.featured AS featured_5,
  t0.image_path AS image_path_6,
  t0.banner_path AS banner_path_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.id AS id_11,
  t0.name AS name_12,
  t0.disk_space AS disk_space_13,
  t0.memory AS memory_14,
  t0.io AS io_15,
  t0.cpu AS cpu_16,
  t0.threads AS threads_17,
  t0.db_count AS db_count_18,
  t0.swap AS swap_19,
  t0.backups AS backups_20,
  t0.ports AS ports_21,
  t0.schedules AS schedules_22,
  t0.nodes AS nodes_23,
  t0.nest AS nest_24,
  t0.eggs AS eggs_25,
  t0.eggs_configuration AS eggs_configuration_26,
  t0.allow_change_egg AS allow_change_egg_27,
  t0.allow_auto_renewal AS allow_auto_renewal_28,
  t0.allow_user_select_location AS allow_user_select_location_29,
  t0.setup_fee AS setup_fee_30,
  t0.category_id AS category_id_31
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.description AS description_1, t0.short_description AS short_description_2, t0.is_active AS is_active_3, t0.priority AS priority_4, t0.featured AS featured_5, t0.image_path AS image_path_6, t0.banner_path AS banner_path_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.name AS name_12, t0.disk_space AS disk_space_13, t0.memory AS memory_14, t0.io AS io_15, t0.cpu AS cpu_16, t0.threads AS threads_17, t0.db_count AS db_count_18, t0.swap AS swap_19, t0.backups AS backups_20, t0.ports AS ports_21, t0.schedules AS schedules_22, t0.nodes AS nodes_23, t0.nest AS nest_24, t0.eggs AS eggs_25, t0.eggs_configuration AS eggs_configuration_26, t0.allow_change_egg AS allow_change_egg_27, t0.allow_auto_renewal AS allow_auto_renewal_28, t0.allow_user_select_location AS allow_user_select_location_29, t0.setup_fee AS setup_fee_30, t0.category_id AS category_id_31 FROM product t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.value AS value_3,
  t0.unit AS unit_4,
  t0.price AS price_5,
  t0.deleted_at AS deleted_at_6,
  t0.product_id AS product_id_7
FROM
  product_price t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.unit AS unit_4, t0.price AS price_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = 1;

"START TRANSACTION"

"START TRANSACTION";

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_.id = ?
  AND u0_.deleted_at IS NULL FOR
UPDATE

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_.id = 2 AND u0_.deleted_at IS NULL FOR UPDATE;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO server (
  pterodactyl_server_id, pterodactyl_server_identifier,
  name, created_at, deleted_at, expires_at,
  is_suspended, auto_renewal, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO server (pterodactyl_server_id, pterodactyl_server_identifier, name, created_at, deleted_at, expires_at, is_suspended, auto_renewal, user_id) VALUES (6, 'eb19dc76', NULL, '2026-04-21 11:17:33', NULL, '2026-05-21 11:17:33', 0, 0, 2);

UPDATE
  product_price
SET
  price = ?
WHERE
  id = ?

UPDATE product_price SET price = 9.99 WHERE id = 1;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO server_product (
  selected_node_id, name, disk_space,
  memory, io, cpu, threads, db_count,
  swap, backups, ports, schedules, nodes,
  nest, eggs, eggs_configuration, allow_change_egg,
  allow_auto_renewal, allow_user_select_location,
  setup_fee, server_id, original_product_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO server_product (selected_node_id, name, disk_space, memory, io, cpu, threads, db_count, swap, backups, ports, schedules, nodes, nest, eggs, eggs_configuration, allow_change_egg, allow_auto_renewal, allow_user_select_location, setup_fee, server_id, original_product_id) VALUES (NULL, 'Minecraft 2 GB / 30 dni', 10000, 2048, 500, 200, NULL, 0, 0, 0, 0, 10, '[1]', 1, '[4]', '{\"4\":{\"options\":{\"startup\":{\"value\":\"java -Xms128M -XX:MaxRAMPercentage=95.0 -Dterminal.jline=false -Dterminal.ansi=true -jar {{SERVER_JARFILE}}\"},\"docker_image\":{\"value\":\"ghcr.io\\/pterodactyl\\/yolks:java_21\"}},\"variables\":{\"9\":{\"value\":\"latest\",\"env_variable\":\"MINECRAFT_VERSION\",\"name\":\"Minecraft Version\",\"description\":\"The version of minecraft to download. \\r\\n\\r\\nLeave at latest to always get the latest version. Invalid versions will default to latest.\",\"rules\":\"nullable|string|max:20\",\"user_viewable\":\"on\",\"user_editable\":\"on\"},\"10\":{\"value\":\"server.jar\",\"env_variable\":\"SERVER_JARFILE\",\"name\":\"Server Jar File\",\"description\":\"The name of the server jarfile to run the server with.\",\"rules\":\"required|regex:\\/^([\\\\w\\\\d._-]+)(\\\\.jar)$\\/\",\"user_viewable\":\"on\",\"user_editable\":\"on\"},\"11\":{\"value\":\"\",\"env_variable\":\"DL_PATH\",\"name\":\"Download Path\",\"description\":\"A URL to use to download a server.jar rather than the ones in the install script. This is not user viewable.\",\"rules\":\"nullable|string\"},\"12\":{\"value\":\"latest\",\"env_variable\":\"BUILD_NUMBER\",\"name\":\"Build Number\",\"description\":\"The build number for the paper release.\\r\\n\\r\\nLeave at latest to always get the latest version. Invalid versions will default to latest.\",\"rules\":\"required|string|max:20\",\"user_viewable\":\"on\",\"user_editable\":\"on\"}}}}', 0, 0, 0, NULL, 3, 1);

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO server_product_price (
  is_selected, type, value, unit, price,
  deleted_at, server_product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO server_product_price (is_selected, type, value, unit, price, deleted_at, server_product_id) VALUES (1, 'static', 30, 'days', 9.99, NULL, 3);

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

UPDATE
  user
SET
  balance = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET balance = 99991.02, updated_at = '2026-04-21 11:17:33' WHERE id = 2;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

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

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 = 'pterodactyl_use_as_client_panel' LIMIT 1;

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

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 = 'site_url' LIMIT 1;

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

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 = 'site_email_logo' LIMIT 1;