Query Metrics

28 Database Queries
8 Different statements
68.20 ms Query time
0 Invalid entities
303 Managed entities

Queries

Group similar statements

# Time Info
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 = ?
Parameters:
[
  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
Parameters:
[]
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
Parameters:
[]
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
Parameters:
[]
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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
Parameters:
[]
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  33
]

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\ClientConfiguration 105
App\Entity\Client 21
App\Entity\ClientBillingPeriod 21
App\Entity\ClientWizardInvitation 16
App\Entity\ClientConfigurationClient 7
App\Entity\Customer 3
App\Entity\SceneInheritancePack 2
App\Entity\ClientTranslation 2
App\Entity\User 1
App\Entity\UserRegistrationOrigin 1