GET https://devwebgl.virtway.com/virtway/a91b2a36-f57c-4b04-a67f-95103a21b086

Query Metrics

57 Database Queries
21 Different statements
239.00 ms Query time
0 Invalid entities
240 Managed entities

Queries

Group similar statements

# Time Info
1 4.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.uuid AS uuid_4, t0.is_active AS is_active_5, t0.is_free AS is_free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.start_datetime AS start_datetime_11, t9.end_datetime AS end_datetime_12, t9.accumulated_agora_consumption AS accumulated_agora_consumption_13, t9.send_weekly_notification AS send_weekly_notification_14, t9.created_at AS created_at_15, t9.updated_at AS updated_at_16, t9.client_id AS client_id_17, t18.id AS id_19, t18.email AS email_20, t18.token AS token_21, t18.is_free AS is_free_22, t18.registered_at AS registered_at_23, t18.company_website AS company_website_24, t18.created_at AS created_at_25, t18.updated_at AS updated_at_26, t18.client_id AS client_id_27, t18.scene_inheritance_pack_id AS scene_inheritance_pack_id_28, t18.partner_client_id AS partner_client_id_29, t0.customer_id AS customer_id_30 FROM live.client t0 LEFT JOIN live.client_billing_period t9 ON t9.client_id = t0.id LEFT JOIN live.client_wizard_invitation t18 ON t18.client_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VIRTWAY"
]
2 3.69 ms
SELECT t0.id AS id_1, t0.gdpr_text AS gdpr_text_2, t0.gdpr_agree_terms AS gdpr_agree_terms_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.client_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
3 4.30 ms
SELECT c.type, c.key, c.is_crypted, ccc.value 
            FROM live.client_configuration_client ccc 
            INNER JOIN live.client_configuration cc ON cc.id = ccc.client_configuration_id 
            INNER JOIN live."configuration" c ON c."key" = cc."key" 
            WHERE ccc.client_id = ?
Parameters:
[
  2
]
4 4.53 ms
SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.value AS value_2, c0_.type AS type_3, c0_.is_crypted AS is_crypted_4, c0_."order" AS order_5, c0_.title AS title_6, c0_.text AS text_7, c0_.only_for_superadmin AS only_for_superadmin_8, c0_.is_active AS is_active_9, c0_.extradata AS extradata_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12 FROM live.configuration c0_ ORDER BY c0_.id ASC
Parameters:
[]
5 3.34 ms
DELETE FROM live.autologin_token WHERE expired_at < ?
Parameters:
[
  "2026-08-06 18:01:37"
]
6 4.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.uuid AS uuid_4, t0.is_active AS is_active_5, t0.is_free AS is_free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.start_datetime AS start_datetime_11, t9.end_datetime AS end_datetime_12, t9.accumulated_agora_consumption AS accumulated_agora_consumption_13, t9.send_weekly_notification AS send_weekly_notification_14, t9.created_at AS created_at_15, t9.updated_at AS updated_at_16, t9.client_id AS client_id_17, t18.id AS id_19, t18.email AS email_20, t18.token AS token_21, t18.is_free AS is_free_22, t18.registered_at AS registered_at_23, t18.company_website AS company_website_24, t18.created_at AS created_at_25, t18.updated_at AS updated_at_26, t18.client_id AS client_id_27, t18.scene_inheritance_pack_id AS scene_inheritance_pack_id_28, t18.partner_client_id AS partner_client_id_29, t0.customer_id AS customer_id_30 FROM live.client t0 LEFT JOIN live.client_billing_period t9 ON t9.client_id = t0.id LEFT JOIN live.client_wizard_invitation t18 ON t18.client_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VIRTWAY"
]
7 3.55 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.internal_name AS internal_name_3, t0.thumbnail_path AS thumbnail_path_4, t0."order" AS order_5, t0.for_registered_users AS for_registered_users_6, t0.for_guest_users AS for_guest_users_7, t0.is_instantiable AS is_instantiable_8, t0.max_users AS max_users_9, t0.has_own_geometry AS has_own_geometry_10, t0.communication_restricted AS communication_restricted_11, t0.ai_context_description AS ai_context_description_12, t0.automatic_sitting AS automatic_sitting_13, t0.browser_cache_hash AS browser_cache_hash_14, t0.initial_positionx AS initial_positionx_15, t0.initial_positiony AS initial_positiony_16, t0.initial_positionz AS initial_positionz_17, t0.initial_rotationx AS initial_rotationx_18, t0.initial_rotationy AS initial_rotationy_19, t0.initial_rotationz AS initial_rotationz_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.client_id AS client_id_23, t0.scene_state_id AS scene_state_id_24 FROM live.scene t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "a91b2a36-f57c-4b04-a67f-95103a21b086"
]
8 3.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
9 3.81 ms
SELECT count(p0_.id) AS sclr_0 FROM live.permission_group p0_ WHERE p0_.client_id = ?
Parameters:
[
  2
]
10 4.12 ms
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.internal_name AS internal_name_2, s0_.thumbnail_path AS thumbnail_path_3, s0_."order" AS order_4, s0_.for_registered_users AS for_registered_users_5, s0_.for_guest_users AS for_guest_users_6, s0_.is_instantiable AS is_instantiable_7, s0_.max_users AS max_users_8, s0_.has_own_geometry AS has_own_geometry_9, s0_.communication_restricted AS communication_restricted_10, s0_.ai_context_description AS ai_context_description_11, s0_.automatic_sitting AS automatic_sitting_12, s0_.browser_cache_hash AS browser_cache_hash_13, s0_.initial_positionx AS initial_positionx_14, s0_.initial_positiony AS initial_positiony_15, s0_.initial_positionz AS initial_positionz_16, s0_.initial_rotationx AS initial_rotationx_17, s0_.initial_rotationy AS initial_rotationy_18, s0_.initial_rotationz AS initial_rotationz_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21, s0_.client_id AS client_id_22, s0_.scene_state_id AS scene_state_id_23 FROM live.scene s0_ INNER JOIN live.client c1_ ON s0_.client_id = c1_.id WHERE c1_.id = ? AND s0_.scene_state_id IN (?, ?, ?) AND s0_.for_guest_users = ?
Parameters:
[
  2
  1
  2
  3
  1
]
11 9.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  203
]
12 20.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
13 3.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  177
]
14 5.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  172
]
15 3.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  180
]
16 3.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
17 3.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
18 3.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  242
]
19 3.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
20 3.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
21 3.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  24
]
22 3.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
23 3.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
24 3.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  23
]
25 3.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  224
]
26 3.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  118
]
27 3.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
28 3.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  263
]
29 3.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  26
]
30 3.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  197
]
31 3.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  258
]
32 3.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  264
]
33 3.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  243
]
34 3.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  25
]
35 3.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
36 3.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  412
]
37 3.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  510
]
38 3.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  642
]
39 3.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  783
]
40 3.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  788
]
41 3.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  741
]
42 3.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  644
]
43 3.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  719
]
44 3.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM live.scene_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  608
]
45 2.96 ms
"START TRANSACTION"
Parameters:
[]
46 4.86 ms
SELECT count(id) FROM live.user WHERE uuid = :uuid
Parameters:
[
  ":uuid" => "27e8c98b-fb33-477e-9eb3-91ca07fa05da"
]
47 3.43 ms
SELECT NEXTVAL('live.user_id_seq')
Parameters:
[]
48 3.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.uuid AS uuid_4, t0.is_active AS is_active_5, t0.is_free AS is_free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.start_datetime AS start_datetime_11, t9.end_datetime AS end_datetime_12, t9.accumulated_agora_consumption AS accumulated_agora_consumption_13, t9.send_weekly_notification AS send_weekly_notification_14, t9.created_at AS created_at_15, t9.updated_at AS updated_at_16, t9.client_id AS client_id_17, t18.id AS id_19, t18.email AS email_20, t18.token AS token_21, t18.is_free AS is_free_22, t18.registered_at AS registered_at_23, t18.company_website AS company_website_24, t18.created_at AS created_at_25, t18.updated_at AS updated_at_26, t18.client_id AS client_id_27, t18.scene_inheritance_pack_id AS scene_inheritance_pack_id_28, t18.partner_client_id AS partner_client_id_29, t0.customer_id AS customer_id_30 FROM live.client t0 LEFT JOIN live.client_billing_period t9 ON t9.client_id = t0.id LEFT JOIN live.client_wizard_invitation t18 ON t18.client_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VIRTWAY"
]
49 3.64 ms
SELECT NEXTVAL('live.user_client_id_seq')
Parameters:
[]
50 4.08 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.closed AS closed_3, t0.locked AS locked_4, t0.browser AS browser_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t0.platform_id AS platform_id_9 FROM live.session t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "6cf7963c4434a9afbef4af6c357e03303e4c55567418d1b476eecced6656e5b26a47ddf2209070a30691438f126e1fe2d637727eb8c2d5193ff05ad471dd9f05"
]
51 3.59 ms
SELECT NEXTVAL('live.session_id_seq')
Parameters:
[]
52 3.68 ms
SAVEPOINT DOCTRINE_2
Parameters:
[]
53 4.32 ms
INSERT INTO live.user (id, uuid, email, roles, password, nick, is_active, is_guest, first_name, last_name, say_hello_email_enabled, last_password_update, agree_registration_clause, token, email_validated, email_validation_token, subtitle, allow_change_password, allow_edit_profile, rpm_avatar_url, external_id, created_at, updated_at, registration_origin_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  695775
  "27e8c98b-fb33-477e-9eb3-91ca07fa05da"
  "nomail_695775@mail.com"
  "[]"
  "no_password"
  null
  1
  1
  null
  null
  1
  null
  0
  null
  0
  null
  null
  1
  1
  null
  null
  "2026-08-06 18:01:37"
  "2026-08-06 18:01:37"
  1
]
54 4.30 ms
INSERT INTO live.user_client (id, say_hello_email_enabled, created_at, updated_at, user_id, client_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  12848
  1
  "2026-08-06 18:01:37"
  "2026-08-06 18:01:37"
  695775
  2
]
55 3.86 ms
INSERT INTO live.session (id, token, closed, locked, browser, created_at, updated_at, user_id, platform_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  699615
  "6cf7963c4434a9afbef4af6c357e03303e4c55567418d1b476eecced6656e5b26a47ddf2209070a30691438f126e1fe2d637727eb8c2d5193ff05ad471dd9f05"
  0
  0
  "unknown"
  "2026-08-06 18:01:37"
  "2026-08-06 18:01:37"
  695775
  1
]
56 3.14 ms
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
57 10.84 ms
"COMMIT"
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\Entity\Configuration 124
App\Entity\SceneTranslation 70
App\Entity\Scene 35
App\Entity\SceneState 2
App\Entity\Client 1
App\Entity\Customer 1
App\Entity\ClientTranslation 1
App\Entity\ClientBillingPeriod 1
App\Entity\UserRegistrationOrigin 1
App\Entity\User 1
App\Entity\UserClient 1
App\Entity\Platform 1
App\Entity\PlayerSession 1