| 1 |
7.36 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 = ?
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 = 2
;
|
| 2 |
9.80 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
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;
|
| 3 |
6.02 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: [
"a79da417c3c7db8c182cbc7e54be2e09a2f6cc08989e0da2477738993ec63511e99b6f59a56dfdc61e0267b853b06e883e09df4ce5f2d3c5ef1e6a5b4bdb2f0b"
]
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 = 'a79da417c3c7db8c182cbc7e54be2e09a2f6cc08989e0da2477738993ec63511e99b6f59a56dfdc61e0267b853b06e883e09df4ce5f2d3c5ef1e6a5b4bdb2f0b' LIMIT 1;
|
| 4 |
6.45 ms |
UPDATE live.session SET updated_at=:updated_at WHERE id=:id
Parameters: [
":updated_at" => "2026-08-06 18:02:01"
":id" => 699617
]
UPDATE live.session SET updated_at=:updated_at WHERE id=:id;
|
| 5 |
5.51 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 s0_.uuid = ? AND c1_.code = ?
Parameters: [
"a74f8be1-d5d9-4260-bc64-70ef43a022a9"
"VIRTWAY"
]
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 s0_.uuid = 'a74f8be1-d5d9-4260-bc64-70ef43a022a9' AND c1_.code = 'VIRTWAY';
|
| 6 |
18.85 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 = ?
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 = 263;
|
| 7 |
14.50 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.id = ?
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.id = 2;
|
| 8 |
4.43 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 = ?
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 = 2;
|
| 9 |
4.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.version AS version_3, t0.definition AS definition_4, t0.is_active AS is_active_5, t0.template AS template_6, t0.email_template AS email_template_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10 FROM live.professional_profile_client t0 WHERE t0.client_id = ? AND t0.is_active = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.version AS version_3, t0.definition AS definition_4, t0.is_active AS is_active_5, t0.template AS template_6, t0.email_template AS email_template_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10 FROM live.professional_profile_client t0 WHERE t0.client_id = 2 AND t0.is_active = 1 LIMIT 1;
|
| 10 |
18.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.version AS version_3, t0.definition AS definition_4, t0.is_active AS is_active_5, t0.template AS template_6, t0.email_template AS email_template_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10 FROM live.professional_profile_client t0 WHERE t0.client_id = ? AND t0.is_active = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.version AS version_3, t0.definition AS definition_4, t0.is_active AS is_active_5, t0.template AS template_6, t0.email_template AS email_template_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10 FROM live.professional_profile_client t0 WHERE t0.client_id = 2 AND t0.is_active = 1 LIMIT 1;
|