Query Metrics
3
Database Queries
3
Different statements
1.90 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.64 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.salutation AS salutation_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.street AS street_9, t0.zip_code AS zip_code_10, t0.phone AS phone_11, t0.cellphone AS cellphone_12, t0.city AS city_13, t0.profession AS profession_14, t0.dob AS dob_15, t0.insured_by AS insured_by_16, t0.insured_since AS insured_since_17, t0.is_married AS is_married_18, t0.partner_insured_by AS partner_insured_by_19, t0.has_children_insured AS has_children_insured_20, t0.reg_by AS reg_by_21, t0.reg_datetime AS reg_datetime_22, t0.account_locked AS account_locked_23, t0.is_active AS is_active_24, t0.insurance_number AS insurance_number_25, t0.insurance_amount AS insurance_amount_26, t0.partner_insurance_number AS partner_insurance_number_27, t0.partner_insurance_amount AS partner_insurance_amount_28, t0.update_datetime AS update_datetime_29, t0.street_additional AS street_additional_30, t0.address_pool_id AS address_pool_id_31, t0.address_number AS address_number_32, t0.address_invoice_number AS address_invoice_number_33, t0.business_phone AS business_phone_34, t0.notes AS notes_35, t0.address_date AS address_date_36, t0.title AS title_37, t0.fax AS fax_38, t0.has_accepted_data_protection AS has_accepted_data_protection_39, t0.has_accepted_conditions AS has_accepted_conditions_40, t0.due_date AS due_date_41, t0.due_date_sales AS due_date_sales_42, t0.company AS company_43, t0.is_privileged AS is_privileged_44, t0.has_interest_life_insurance_reversal AS has_interest_life_insurance_reversal_45, t0.has_interest_investment AS has_interest_investment_46, t0.processing_section AS processing_section_47, t0.super_admin AS super_admin_48, t0.is_shared_mailbox AS is_shared_mailbox_49, t0.completed_by_user AS completed_by_user_50, t0.completed_by_admin AS completed_by_admin_51, t0.mail_state AS mail_state_52, t0.general_state AS general_state_53, t0.salesmen_id AS salesmen_id_54, t0.event_id AS event_id_55, t0.is_processed AS is_processed_56, t0.availability AS availability_57, t0.phone_availability AS phone_availability_58, t0.address_purchaser_id AS address_purchaser_id_59, t0.address_marketing_id AS address_marketing_id_60, t0.address_state_id AS address_state_id_61, t0.address_provider_id AS address_provider_id_62, t0.salesman_id AS salesman_id_63, t0.calendar_state_id AS calendar_state_id_64 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.67 ms |
SELECT t0.id AS id_1, t0.is_checked AS is_checked_2, t0.check_datetime AS check_datetime_3, t0.note_id AS note_id_4, t0.member_id AS member_id_5 FROM note_member t0 WHERE t0.is_checked = ? AND t0.member_id = ?
Parameters:
[ 0 1 ] |
| 3 | 0.59 ms |
SELECT s0_.id AS id_0, s0_.company_name AS company_name_1, s0_.vat AS vat_2, s0_.company_email AS company_email_3, s0_.company_phone AS company_phone_4, s0_.company_fax AS company_fax_5, s0_.app_tenant_id AS app_tenant_id_6, s0_.app_client_id AS app_client_id_7, s0_.app_client_secret AS app_client_secret_8, s0_.reg_by AS reg_by_9, s0_.reg_datetime AS reg_datetime_10, s0_.vat_id AS vat_id_11, s0_.company AS company_12, s0_.cumas_user AS cumas_user_13, s0_.cumas_password AS cumas_password_14, s0_.cumas_address AS cumas_address_15, s0_.refresh_token AS refresh_token_16, s0_.refresh_expires AS refresh_expires_17, s0_.refresh_expires_datetime AS refresh_expires_datetime_18, s0_.api_token AS api_token_19 FROM settings s0_ WHERE s0_.company = ? ORDER BY s0_.id DESC
Parameters:
[
"kompass"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\AddressPurchaser | No errors. |
| App\Entity\AddressMarketing | No errors. |
| App\Entity\AddressState | No errors. |
| App\Entity\AddressProvider | No errors. |
| App\Entity\CalendarState | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\AddressPool | No errors. |
| App\Entity\InsuranceInfo | No errors. |
| App\Entity\NoteMember | No errors. |
| App\Entity\LogLoginSuccess | No errors. |
| App\Entity\LogDocumentAccess | No errors. |
| App\Entity\Calendar | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\CalendarBusinessPlace | No errors. |
| App\Entity\Signature | No errors. |
| App\Entity\EmailOffer | No errors. |
| App\Entity\CalendarClient | No errors. |
| App\Entity\Note | No errors. |
| App\Entity\Settings | No errors. |