Symfony Profiler

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

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

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

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

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;

DELETE FROM
  live.autologin_token
WHERE
  expired_at < ?

DELETE FROM live.autologin_token WHERE expired_at < '2026-08-07 00:12:44';

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

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

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

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 = 'fefd635b-1416-45a3-8df4-cfab6333f0b8' LIMIT 1;

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

SELECT
  count(p0_.id) AS sclr_0
FROM
  live.permission_group p0_
WHERE
  p0_.client_id = ?

SELECT count(p0_.id) AS sclr_0 FROM live.permission_group p0_ WHERE p0_.client_id = 29;

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 = ?

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 = 29 AND s0_.scene_state_id IN (1, 2, 3) AND s0_.for_guest_users = 1;

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

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

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

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

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

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

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

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

"START TRANSACTION"

"START TRANSACTION";

SELECT
  count(id)
FROM
  live.user
WHERE
  uuid = :uuid

SELECT count(id) FROM live.user WHERE uuid = :uuid;

SELECT
  NEXTVAL('live.user_id_seq')

SELECT NEXTVAL('live.user_id_seq');

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

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

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 = ?