https://freund.easytransfer24.de/mmm/accounting/billing/303/pdf?0=0

Query Metrics

4 Database Queries
4 Different statements
2.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.26 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.hidden AS hidden_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.mail_action_hash AS mail_action_hash_10, t0.mail_action_mode AS mail_action_mode_11, t0.locale AS locale_12, t0.last_password_change AS last_password_change_13, t0.sys_user AS sys_user_14, t0.mail_cc AS mail_cc_15, t0.auto_fill_orderer_details_in_new_order AS auto_fill_orderer_details_in_new_order_16, t0.fcm_tokens AS fcm_tokens_17, t0.telegram_id AS telegram_id_18, t0.shared_key AS shared_key_19, t0.enable_time_tracking AS enable_time_tracking_20, t0.short_code AS short_code_21, t0.dashboards AS dashboards_22, t0.be_created AS be_created_23, t0.be_edited AS be_edited_24, t0.be_deleted AS be_deleted_25, t0.be_comment AS be_comment_26, t0.customer_id AS customer_id_27, t0.current_substitute_user_id AS current_substitute_user_id_28, t0.member_id AS member_id_29, t0.profile_image_id AS profile_image_id_30, t0.home_address_id AS home_address_id_31, t0.be_owner AS be_owner_32 FROM users t0 WHERE t0.id = ? AND ((t0.be_deleted = 0))
Parameters:
[
  5
]
2 0.54 ms
SELECT t0.id AS id_1, t0.platform AS platform_2, t0.token_type AS token_type_3, t0.token AS token_4, t0.first_seen AS first_seen_5, t0.last_seen AS last_seen_6, t0.be_created AS be_created_7, t0.be_edited AS be_edited_8, t0.be_deleted AS be_deleted_9, t0.be_comment AS be_comment_10, t0.user_id AS user_id_11, t0.be_owner AS be_owner_12 FROM user_device_tokens t0 WHERE t0.user_id IN (?) AND ((t0.be_deleted = 0))
Parameters:
[
  5
]
3 0.65 ms
SELECT t0.id AS id_1, t0.document_type AS document_type_2, t0.document_number AS document_number_3, t0.document_date AS document_date_4, t0.receiver_address AS receiver_address_5, t0.status AS status_6, t0.total_net AS total_net_7, t0.accounting_month AS accounting_month_8, t0.accounting_year AS accounting_year_9, t0.sent_to_receiver AS sent_to_receiver_10, t0.header_text AS header_text_11, t0.footer_text AS footer_text_12, t0.reminder_sent_to_receiver AS reminder_sent_to_receiver_13, t0.monition1sent_to_receiver AS monition1sent_to_receiver_14, t0.monition2sent_to_receiver AS monition2sent_to_receiver_15, t0.extra_calculation_items AS extra_calculation_items_16, t0.stand_by_dispo_data AS stand_by_dispo_data_17, t0.be_created AS be_created_18, t0.be_edited AS be_edited_19, t0.be_deleted AS be_deleted_20, t0.be_comment AS be_comment_21, t0.customer_id AS customer_id_22, t0.member_id AS member_id_23, t0.pdf_file_id AS pdf_file_id_24, t25.id AS id_26, t25.file_name AS file_name_27, t25.physical_file_name AS physical_file_name_28, t25.path AS path_29, t25.type AS type_30, t25.file_size AS file_size_31, t25.be_created AS be_created_32, t25.be_edited AS be_edited_33, t25.be_deleted AS be_deleted_34, t25.be_comment AS be_comment_35, t25.be_owner AS be_owner_36, t0.billing_id AS billing_id_37, t0.treated_by_id AS treated_by_id_38, t0.reminder_pdf_id AS reminder_pdf_id_39, t40.id AS id_41, t40.file_name AS file_name_42, t40.physical_file_name AS physical_file_name_43, t40.path AS path_44, t40.type AS type_45, t40.file_size AS file_size_46, t40.be_created AS be_created_47, t40.be_edited AS be_edited_48, t40.be_deleted AS be_deleted_49, t40.be_comment AS be_comment_50, t40.be_owner AS be_owner_51, t0.monition1pdf_id AS monition1pdf_id_52, t53.id AS id_54, t53.file_name AS file_name_55, t53.physical_file_name AS physical_file_name_56, t53.path AS path_57, t53.type AS type_58, t53.file_size AS file_size_59, t53.be_created AS be_created_60, t53.be_edited AS be_edited_61, t53.be_deleted AS be_deleted_62, t53.be_comment AS be_comment_63, t53.be_owner AS be_owner_64, t0.monition2pdf_id AS monition2pdf_id_65, t66.id AS id_67, t66.file_name AS file_name_68, t66.physical_file_name AS physical_file_name_69, t66.path AS path_70, t66.type AS type_71, t66.file_size AS file_size_72, t66.be_created AS be_created_73, t66.be_edited AS be_edited_74, t66.be_deleted AS be_deleted_75, t66.be_comment AS be_comment_76, t66.be_owner AS be_owner_77, t0.extra_pdf_id AS extra_pdf_id_78, t79.id AS id_80, t79.file_name AS file_name_81, t79.physical_file_name AS physical_file_name_82, t79.path AS path_83, t79.type AS type_84, t79.file_size AS file_size_85, t79.be_created AS be_created_86, t79.be_edited AS be_edited_87, t79.be_deleted AS be_deleted_88, t79.be_comment AS be_comment_89, t79.be_owner AS be_owner_90, t0.be_owner AS be_owner_91 FROM acc_documents t0 LEFT JOIN files t25 ON t0.pdf_file_id = t25.id AND ((t25.be_deleted = 0)) LEFT JOIN files t40 ON t0.reminder_pdf_id = t40.id AND ((t40.be_deleted = 0)) LEFT JOIN files t53 ON t0.monition1pdf_id = t53.id AND ((t53.be_deleted = 0)) LEFT JOIN files t66 ON t0.monition2pdf_id = t66.id AND ((t66.be_deleted = 0)) LEFT JOIN files t79 ON t0.extra_pdf_id = t79.id AND ((t79.be_deleted = 0)) WHERE t0.id = ? AND ((t0.be_deleted = 0)) LIMIT 1
Parameters:
[
  "303"
]
4 0.38 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.physical_file_name AS physical_file_name_3, t0.path AS path_4, t0.type AS type_5, t0.file_size AS file_size_6, t0.be_created AS be_created_7, t0.be_edited AS be_edited_8, t0.be_deleted AS be_deleted_9, t0.be_comment AS be_comment_10, t0.be_owner AS be_owner_11 FROM files t0 WHERE t0.id = ? AND ((t0.be_deleted = 0)) LIMIT 1
Parameters:
[
  311
]

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.