Query Metrics
4
Database Queries
4
Different statements
4.22 ms
Query time
0
Invalid entities
42
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.04 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.street AS street_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.country AS country_10, t0.job_title AS job_title_11, t0.active AS active_12, t0.terms_accepted_at AS terms_accepted_at_13, t0.terms_version AS terms_version_14, t0.privacy_accepted_at AS privacy_accepted_at_15, t0.privacy_version AS privacy_version_16, t0.smtp_host AS smtp_host_17, t0.smtp_port AS smtp_port_18, t0.smtp_encryption AS smtp_encryption_19, t0.smtp_username AS smtp_username_20, t0.smtp_password_encrypted AS smtp_password_encrypted_21, t0.smtp_from_email AS smtp_from_email_22, t0.smtp_from_name AS smtp_from_name_23, t0.smtp_signature_html AS smtp_signature_html_24, t0.ics_feed_token AS ics_feed_token_25, t0.caldav_password_hash AS caldav_password_hash_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.company_id AS company_id_29, t0.avatar_id AS avatar_id_30 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"service@it-onkel.com"
]
|
| 2 | 0.89 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_id AS company_id_6 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
1314
]
|
| 3 | 1.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_form AS legal_form_3, t0.owner_name AS owner_name_4, t0.street AS street_5, t0.postal_code AS postal_code_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.email AS email_10, t0.website AS website_11, t0.tax_number AS tax_number_12, t0.vat_id AS vat_id_13, t0.small_business_enabled AS small_business_enabled_14, t0.small_business_notice AS small_business_notice_15, t0.bank_account_holder AS bank_account_holder_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.bank_name AS bank_name_19, t0.default_payment_term_days AS default_payment_term_days_20, t0.default_payment_notice AS default_payment_notice_21, t0.contact_person_name AS contact_person_name_22, t0.contact_person_email AS contact_person_email_23, t0.contact_person_phone AS contact_person_phone_24, t0.invoice_footer_text AS invoice_footer_text_25, t0.offer_intro_text AS offer_intro_text_26, t0.offer_closing_text AS offer_closing_text_27, t0.invoice_intro_text AS invoice_intro_text_28, t0.invoice_closing_text AS invoice_closing_text_29, t0.billing_mode AS billing_mode_30, t0.subscription_status AS subscription_status_31, t0.trial_ends_at AS trial_ends_at_32, t0.stripe_customer_id AS stripe_customer_id_33, t0.stripe_subscription_id AS stripe_subscription_id_34, t0.stripe_product_id AS stripe_product_id_35, t0.stripe_price_id AS stripe_price_id_36, t0.subscription_current_period_end AS subscription_current_period_end_37, t0.subscription_cancel_at_period_end AS subscription_cancel_at_period_end_38, t0.default_sender_name AS default_sender_name_39, t0.default_reply_to_email AS default_reply_to_email_40, t0.dunning_reminder_threshold_days AS dunning_reminder_threshold_days_41, t0.dunning_first_notice_threshold_days AS dunning_first_notice_threshold_days_42, t0.dunning_second_notice_threshold_days AS dunning_second_notice_threshold_days_43, t0.dunning_reminder_text AS dunning_reminder_text_44, t0.dunning_first_notice_text AS dunning_first_notice_text_45, t0.dunning_second_notice_text AS dunning_second_notice_text_46, t0.dunning_reminder_fee_enabled AS dunning_reminder_fee_enabled_47, t0.dunning_reminder_fee_amount AS dunning_reminder_fee_amount_48, t0.dunning_first_notice_fee_enabled AS dunning_first_notice_fee_enabled_49, t0.dunning_first_notice_fee_amount AS dunning_first_notice_fee_amount_50, t0.dunning_second_notice_fee_enabled AS dunning_second_notice_fee_enabled_51, t0.dunning_second_notice_fee_amount AS dunning_second_notice_fee_amount_52, t0.dunning_automation_enabled AS dunning_automation_enabled_53, t0.ics_feed_token AS ics_feed_token_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.logo_id AS logo_id_57, t0.automatic_dunning_mail_sender_id AS automatic_dunning_mail_sender_id_58 FROM company t0 WHERE t0.id = ?
Parameters:
[
1777
]
|
| 4 | 1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = ?
Parameters:
[
747
]
|
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\Permission | 37 |
| App\Entity\FileAttachment | 2 |
| App\Entity\User | 1 |
| App\Entity\Company | 1 |
| App\Entity\Role | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\FileAttachment | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Permission | No errors. |