| 1 |
1.89 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nick AS nick_6, t0.is_active AS is_active_7, t0.is_guest AS is_guest_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.say_hello_email_enabled AS say_hello_email_enabled_11, t0.last_password_update AS last_password_update_12, t0.agree_registration_clause AS agree_registration_clause_13, t0.token AS token_14, t0.email_validated AS email_validated_15, t0.email_validation_token AS email_validation_token_16, t0.subtitle AS subtitle_17, t0.allow_change_password AS allow_change_password_18, t0.allow_edit_profile AS allow_edit_profile_19, t0.rpm_avatar_url AS rpm_avatar_url_20, t0.external_id AS external_id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.registration_origin_id AS registration_origin_id_24 FROM live.user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nick AS nick_6, t0.is_active AS is_active_7, t0.is_guest AS is_guest_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.say_hello_email_enabled AS say_hello_email_enabled_11, t0.last_password_update AS last_password_update_12, t0.agree_registration_clause AS agree_registration_clause_13, t0.token AS token_14, t0.email_validated AS email_validated_15, t0.email_validation_token AS email_validation_token_16, t0.subtitle AS subtitle_17, t0.allow_change_password AS allow_change_password_18, t0.allow_edit_profile AS allow_edit_profile_19, t0.rpm_avatar_url AS rpm_avatar_url_20, t0.external_id AS external_id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.registration_origin_id AS registration_origin_id_24 FROM live.user t0 WHERE t0.id = 1;
|
| 2 |
2.78 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 |
9.25 ms |
SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3 FROM live.client_configuration c0_ INNER JOIN live.configuration c1_ ON (c0_.key = c1_.key) WHERE c1_.is_active = true ORDER BY c1_."order" ASC
SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3 FROM live.client_configuration c0_ INNER JOIN live.configuration c1_ ON (c0_.key = c1_.key) WHERE c1_.is_active = true ORDER BY c1_."order" ASC;
|
| 4 |
2.80 ms |
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.type AS type_4, t0.is_crypted AS is_crypted_5, t0."order" AS order_6, t0.title AS title_7, t0.text AS text_8, t0.only_for_superadmin AS only_for_superadmin_9, t0.is_active AS is_active_10, t0.extradata AS extradata_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM live.configuration t0 ORDER BY t0."order" ASC
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.type AS type_4, t0.is_crypted AS is_crypted_5, t0."order" AS order_6, t0.title AS title_7, t0.text AS text_8, t0.only_for_superadmin AS only_for_superadmin_9, t0.is_active AS is_active_10, t0.extradata AS extradata_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM live.configuration t0 ORDER BY t0."order" ASC;
|
| 5 |
5.15 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.client_id AS client_id_5, t0.client_configuration_id AS client_configuration_id_6 FROM live.client_configuration_client t0 WHERE t0.client_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.client_id AS client_id_5, t0.client_configuration_id AS client_configuration_id_6 FROM live.client_configuration_client t0 WHERE t0.client_id = 20;
|
| 6 |
4.05 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 = 20
;
|
| 7 |
3.34 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 ORDER BY t0.name ASC
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 ORDER BY t0.name ASC;
|
| 8 |
2.07 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 = 24;
|
| 9 |
1.89 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 = 15;
|
| 10 |
5.29 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 = 1;
|
| 11 |
1.78 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 = 28;
|
| 12 |
1.62 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 = 17;
|
| 13 |
1.57 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 = 36;
|
| 14 |
1.81 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 = 21;
|
| 15 |
1.71 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 = 26;
|
| 16 |
1.63 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 = 20;
|
| 17 |
1.47 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 = 19;
|
| 18 |
1.32 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 = 16;
|
| 19 |
1.88 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 = 29;
|
| 20 |
2.27 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 = 67;
|
| 21 |
1.66 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 = 35;
|
| 22 |
1.42 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 = 31;
|
| 23 |
1.38 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 = 34;
|
| 24 |
1.65 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;
|
| 25 |
1.75 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 = 14;
|
| 26 |
1.72 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 = 6;
|
| 27 |
1.58 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 = 30;
|
| 28 |
1.47 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 = 33;
|