Korekty przychodów i kosztów - przewodnik dla biur rachunkowych

central-default-default-default

No	Time	Returned	Affected	Query
1	0.00019	0	0	SET sql_auto_is_null = 0
2	0.00038		1	SELECT id FROM database_versions WHERE `status` = "completed" ORDER BY id DESC LIMIT 1
3	0.00081		8	DESC common_shared_memories
4	0.00031		1	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`key` = 'updateLock') LIMIT 1
12	0.00135		175	DESC companies
13	0.00062		28	DESC user_companies
14	0.00062		0	SELECT `Company`.`id`, `Company`.`company_id`, `Company`.`part_id`, `Company`.`partner_id`, `Company`.`company_activity_classification_id`, `Company`.`accountant_company_id`, `Company`.`pending_accountant_company_id`, `Company`.`is_accountant`, `Company`.`is_verified`, `Company`.`is_active`, `Company`.`is_banned_by_accountant`, `Company`.`name`, `Company`.`altname`, `Company`.`trade_name`, `Company`.`nip`, `Company`.`bdo`, `Company`.`eori`, `Company`.`krs`, `Company`.`able_to_change_nip`, `Company`.`regon`, `Company`.`invoice_send_external`, `Company`.`invoice_send_external_type`, `Company`.`invoice_template`, `Company`.`invoice_series_strict`, `Company`.`invoice_header`, `Company`.`invoice_footer`, `Company`.`invoice_signature_name_type`, `Company`.`invoice_signature_name`, `Company`.`invoice_force_show_page_type`, `Company`.`invoice_force_document_name_suffix`, `Company`.`invoice_force_document_account_number`, `Company`.`invoice_proforma_force_show_nip`, `Company`.`warehouse_allow_negative`, `Company`.`warehouse_type`, `Company`.`warehouse_print_good_codes`, `Company`.`warehouse_print_wz_prices`, `Company`.`warehouse_print_pz_prices`, `Company`.`warehouse_print_zd_prices`, `Company`.`warehouse_auto_update_good_prices`, `Company`.`warehouse_document_cloud_drive_id`, `Company`.`warehouse_hide_used_photos`, `Company`.`warehouse_expiration_date`, `Company`.`warehouse_expiration_date_reminds`, `Company`.`warehouse_goods_inventories_cron`, `Company`.`invoice_draft`, `Company`.`envelope_template`, `Company`.`vat`, `Company`.`vat_payer`, `Company`.`vat_payer_margin`, `Company`.`vat_payer_rr`, `Company`.`vat_payer_cashbox`, `Company`.`vat_payer_proportion`, `Company`.`vat_payer_moss`, `Company`.`vat_payer_ue`, `Company`.`vat_payer_exempt_reason`, `Company`.`vat_payer_exempt_reason_text`, `Company`.`tax`, `Company`.`tax_expense_method`, `Company`.`schema_jpk_pit`, `Company`.`tax_lump_default_rate`, `Company`.`payment_cashbox`, `Company`.`payment_manual_ledger`, `Company`.`authorized_person_type`, `Company`.`authorized_person_company_owner_id`, `Company`.`taxregister_shift`, `Company`.`taxregister_shift_type`, `Company`.`taxregister_shift_sequence`, `Company`.`taxregister_shift_income_sale`, `Company`.`taxregister_shift_income_odd`, `Company`.`taxregister_shift_expense_purchase`, `Company`.`taxregister_shift_expense_purchase_cost`, `Company`.`taxregister_shift_expense_salaries`, `Company`.`taxregister_shift_expense_odd`, `Company`.`taxregister_sequence_type`, `Company`.`taxregister_exchange_differences`, `Company`.`taxregister_exchange_differences_series_id`, `Company`.`taxregister_company_owner_social`, `Company`.`taxregister_company_owner_health`, `Company`.`ledger_register_company_owner_health`, `Company`.`start_date`, `Company`.`book_start_date`, `Company`.`book_date_validation`, `Company`.`cc`, `Company`.`bcc`, `Company`.`tax_department_code`, `Company`.`tax_department_name`, `Company`.`tax_department_code2`, `Company`.`tax_department_name2`, `Company`.`tax_bank_account`, `Company`.`form`, `Company`.`corporation_type`, `Company`.`corporation_owner_zus`, `Company`.`corporation_gus_code`, `Company`.`corporation_tax_period`, `Company`.`incidental_rate_type`, `Company`.`incidental_rate`, `Company`.`insurance_bank_account`, `Company`.`benefit_payer`, `Company`.`dotpay_on`, `Company`.`przelewy24_on`, `Company`.`przelewy24_email`, `Company`.`dotpay_id`, `Company`.`dotpay_pin`, `Company`.`dotpay_username`, `Company`.`dotpay_password`, `Company`.`dotpay_card`, `Company`.`dotpay_email`, `Company`.`dotpay_send_payment_confirm_sms`, `Company`.`bluemedia_on`, `Company`.`bluemedia_invoices_payment`, `Company`.`bluemedia_taxes_payment`, `Company`.`bluemedia_expenses_payment`, `Company`.`bluemedia_send_payment_confirm_sms`, `Company`.`ppk_on`, `Company`.`ppk_start_month`, `Company`.`ppk_start_year`, `Company`.`ppk_institution`, `Company`.`ppk_default_company_additional_rate_type`, `Company`.`ppk_default_company_additional_rate`, `Company`.`ppk_bank_account`, `Company`.`work_regulations`, `Company`.`sms_api_on`, `Company`.`sms_api_login`, `Company`.`sms_api_password`, `Company`.`sms_api_from`, `Company`.`sms_remove_spec_chars`, `Company`.`dhl_on`, `Company`.`dhl_login`, `Company`.`dhl_password`, `Company`.`dhl_box_size`, `Company`.`dhl_height`, `Company`.`dhl_width`, `Company`.`dhl_length`, `Company`.`dhl_weight`, `Company`.`dhl_content`, `Company`.`dhl_custom_shipment`, `Company`.`dhl_sap_number`, `Company`.`is_registered`, `Company`.`gus_register_correction`, `Company`.`check_debtor`, `Company`.`edeclarations_rules`, `Company`.`edeclarations_docs`, `Company`.`print_blockade`, `Company`.`print_footer_creator`, `Company`.`print_encryption`, `Company`.`company_promotion_code_id`, `Company`.`company_promotion_code_used`, `Company`.`invoice_ksef_force_show_nip`, `Company`.`verification_description`, `Company`.`declaration_signature_name_type`, `Company`.`declaration_signature_firstname`, `Company`.`declaration_signature_lastname`, `Company`.`declaration_signature_phone`, `Company`.`declaration_email_source`, `Company`.`declaration_email_other`, `Company`.`phone`, `Company`.`email`, `Company`.`declaration_form`, `Company`.`crm_next_task_number`, `Company`.`is_crm_event_invoice`, `Company`.`mojo_settings`, `Company`.`payment_method`, `Company`.`jpkv7_settings`, `Company`.`foreign_order_sale`, `Company`.`ksef_active`, `Company`.`ksef_auto_import_expense`, `Company`.`staff_salary_auto_close`, `Company`.`staff_salary_sum_type`, `Company`.`resident_status`, `Company`.`default_invoice_place_of_issue`, `Company`.`shortcuts_enabled`, `Company`.`delete_date`, `Company`.`is_implementation_company`, `Company`.`created`, `Company`.`modified`, `UserCompany`.`id`, `UserCompany`.`user_id`, `UserCompany`.`company_id`, `UserCompany`.`warehouse_id`, `UserCompany`.`staff_employee_id`, `UserCompany`.`right`, `UserCompany`.`accepted`, `UserCompany`.`is_superadmin`, `UserCompany`.`is_main`, `UserCompany`.`ip`, `UserCompany`.`replyto`, `UserCompany`.`smtp_login`, `UserCompany`.`smtp_from`, `UserCompany`.`smtp_from_email`, `UserCompany`.`smtp_password`, `UserCompany`.`smtp_connection_type`, `UserCompany`.`smtp_cipher_suite`, `UserCompany`.`smtp_host`, `UserCompany`.`smtp_port`, `UserCompany`.`smtp_error_behavior`, `UserCompany`.`smtp_status`, `UserCompany`.`tags`, `UserCompany`.`last_login`, `UserCompany`.`is_pinned_by_accountant`, `UserCompany`.`dynamic_menu`, `UserCompany`.`app_mode`, `UserCompany`.`created`, `UserCompany`.`modified` FROM `companies` AS `Company` LEFT JOIN `user_companies` AS `UserCompany` ON `UserCompany`.`company_id` = `Company`.`id` WHERE (`UserCompany`.`user_id` = '-1') AND (`UserCompany`.`right` = 'admin') AND (`Company`.`is_accountant` = '1') LIMIT 1
15	0.00024		1	SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`user_id` = '-1') AND (`right` IN ('leader','helper','payroll_specialist'))
24	0.00058		10	DESC pack_addons
25	0.00026		1	SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-08') AND (`PackAddon`.`name` = 'reliable_contractor')
26	0.00027		1	SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`UserCompany`.`company_id` = '-1') AND (`UserCompany`.`right` = 'client') AND (`UserCompany`.`user_id` = '-1')
31	0.00105		11	DESC pack_defs
32	0.00039		3	SELECT `PackDef`.`id`, `PackDef`.`pack_type`, `PackDef`.`internal_name`, `PackDef`.`name`, `PackDef`.`short_name`, `PackDef`.`description`, `PackDef`.`properties`, `PackDef`.`order`, `PackDef`.`removed`, `PackDef`.`created`, `PackDef`.`modified` FROM `pack_defs` AS `PackDef` WHERE (`PackDef`.`internal_name` IN ('trade','book','staff')) AND (`PackDef`.`pack_type` = 'pack')
33	0.00063		9	DESC pack_def_variants
34	0.00034		0	SELECT `PackDefVariant`.`id`, `PackDefVariant`.`pack_def_id`, `PackDefVariant`.`internal_name`, `PackDefVariant`.`name`, `PackDefVariant`.`description`, `PackDefVariant`.`properties`, `PackDefVariant`.`order`, `PackDefVariant`.`created`, `PackDefVariant`.`modified` FROM `pack_def_variants` AS `PackDefVariant` WHERE (`PackDefVariant`.`pack_def_id` IN ('1','16','19'))
35	0.00063		8	DESC pack_prices
36	0.00036		6	SELECT `PackPrice`.`id`, `PackPrice`.`pack_def_id`, `PackPrice`.`pack_def_variant_id`, `PackPrice`.`type`, `PackPrice`.`price_period`, `PackPrice`.`price`, `PackPrice`.`created`, `PackPrice`.`modified` FROM `pack_prices` AS `PackPrice` WHERE (`PackPrice`.`pack_def_id` IN ('1','16','19'))
37	0.00073		26	SELECT `PackPrice`.`id`, `PackPrice`.`pack_def_id`, `PackPrice`.`pack_def_variant_id`, `PackPrice`.`type`, `PackPrice`.`price_period`, `PackPrice`.`price`, `PackPrice`.`created`, `PackPrice`.`modified`, `PackDef`.`id`, `PackDef`.`pack_type`, `PackDef`.`internal_name`, `PackDef`.`name`, `PackDef`.`short_name`, `PackDef`.`description`, `PackDef`.`properties`, `PackDef`.`order`, `PackDef`.`removed`, `PackDef`.`created`, `PackDef`.`modified`, `PackDefVariant`.`id`, `PackDefVariant`.`pack_def_id`, `PackDefVariant`.`internal_name`, `PackDefVariant`.`name`, `PackDefVariant`.`description`, `PackDefVariant`.`properties`, `PackDefVariant`.`order`, `PackDefVariant`.`created`, `PackDefVariant`.`modified` FROM `pack_prices` AS `PackPrice` LEFT JOIN `pack_defs` AS `PackDef` ON `PackPrice`.`pack_def_id` = `PackDef`.`id` LEFT JOIN `pack_def_variants` AS `PackDefVariant` ON `PackPrice`.`pack_def_variant_id` = `PackDefVariant`.`id`
38	0.00039		6	SELECT `PackDefVariant`.`id`, `PackDefVariant`.`pack_def_id`, `PackDefVariant`.`internal_name`, `PackDefVariant`.`name`, `PackDefVariant`.`description`, `PackDefVariant`.`properties`, `PackDefVariant`.`order`, `PackDefVariant`.`created`, `PackDefVariant`.`modified`, `PackDef`.`id`, `PackDef`.`pack_type`, `PackDef`.`internal_name`, `PackDef`.`name`, `PackDef`.`short_name`, `PackDef`.`description`, `PackDef`.`properties`, `PackDef`.`order`, `PackDef`.`removed`, `PackDef`.`created`, `PackDef`.`modified` FROM `pack_def_variants` AS `PackDefVariant` LEFT JOIN `pack_defs` AS `PackDef` ON `PackDefVariant`.`pack_def_id` = `PackDef`.`id`
39	0.00028		6	SELECT `PackPrice`.`id`, `PackPrice`.`pack_def_id`, `PackPrice`.`pack_def_variant_id`, `PackPrice`.`type`, `PackPrice`.`price_period`, `PackPrice`.`price`, `PackPrice`.`created`, `PackPrice`.`modified` FROM `pack_prices` AS `PackPrice` WHERE (`PackPrice`.`pack_def_variant_id` IN ('7','10','19','22','25','28'))
40	0.00074		34	DESC promotions
41	0.00063		0	SELECT `Promotion`.`id`, `Promotion`.`parent_id`, `Promotion`.`partner_id`, `Promotion`.`name`, `Promotion`.`url`, `Promotion`.`redirect`, `Promotion`.`head_title`, `Promotion`.`meta_description`, `Promotion`.`type`, `Promotion`.`date_since`, `Promotion`.`date_to`, `Promotion`.`days_to_expire`, `Promotion`.`referer`, `Promotion`.`active`, `Promotion`.`is_main`, `Promotion`.`is_cycle`, `Promotion`.`visible`, `Promotion`.`addons`, `Promotion`.`min_days_after_package_expiration`, `Promotion`.`max_days_after_package_expiration`, `Promotion`.`min_days_after_last_login`, `Promotion`.`max_days_after_last_login`, `Promotion`.`discount_type`, `Promotion`.`discount_value`, `Promotion`.`email_subject`, `Promotion`.`email_text`, `Promotion`.`notification_text`, `Promotion`.`notification_button_text`, `Promotion`.`landing_page_text`, `Promotion`.`user_type`, `Promotion`.`is_accountant`, `Promotion`.`landing_page`, `Promotion`.`created`, `Promotion`.`modified` FROM `promotions` AS `Promotion` WHERE (`Promotion`.`is_main` = '1') AND (`Promotion`.`landing_page` LIKE "%prices%") AND (`Promotion`.`date_to` >= '2025-06-08 07:25:42') AND (`Promotion`.`date_since` <= '2025-06-08 07:25:42') AND (`Promotion`.`active` = '1') AND (`Promotion`.`type` = 'presale') LIMIT 1
42	0.00029		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`key` = 'User::-1::appMode') LIMIT 1
45	0.00026		1	SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-08') AND (`PackAddon`.`name` = 'warehouse')
46	0.00057		7	DESC fiskalizator_software_keys
47	0.00027		0	SELECT `FiskalizatorSoftwareKey`.`id`, `FiskalizatorSoftwareKey`.`company_id`, `FiskalizatorSoftwareKey`.`valid`, `FiskalizatorSoftwareKey`.`key`, `FiskalizatorSoftwareKey`.`expiration_date`, `FiskalizatorSoftwareKey`.`created`, `FiskalizatorSoftwareKey`.`modified` FROM `fiskalizator_software_keys` AS `FiskalizatorSoftwareKey` IGNORE INDEX (PRIMARY) WHERE (`FiskalizatorSoftwareKey`.`company_id` = '-1') ORDER BY FiskalizatorSoftwareKey.id DESC LIMIT 1
48	0.00032		1	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`key` = 'updateLock') LIMIT 1
50	0.00039		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`key` = 'User::-1::appMode') LIMIT 1
53	0.00032		1	SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-08') AND (`PackAddon`.`name` = 'warehouse')
54	0.00032		1	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`key` = 'updateLock') LIMIT 1
56	0.00033		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`key` = 'User::-1::appMode') LIMIT 1
59	0.00025		1	SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-08') AND (`PackAddon`.`name` = 'warehouse')
0.01512

default-default-default-default

No	Time	Returned	Affected	Query
5	0.00026	0	0	SET sql_auto_is_null = 0
6	0.00039		1	SELECT id FROM database_versions WHERE `status` = "completed" ORDER BY id DESC LIMIT 1
7	0.00106		16	DESC common_files
8	0.0003		0	SELECT `CommonFile`.`id`, `CommonFile`.`company_id`, `CommonFile`.`object_name`, `CommonFile`.`object_id`, `CommonFile`.`name`, `CommonFile`.`filename`, `CommonFile`.`mime`, `CommonFile`.`size`, `CommonFile`.`virus_scan_status`, `CommonFile`.`virus_scan_error`, `CommonFile`.`compression`, `CommonFile`.`type`, `CommonFile`.`file_location`, `CommonFile`.`accessed`, `CommonFile`.`created`, `CommonFile`.`modified` FROM `common_files` AS `CommonFile` WHERE (`CommonFile`.`object_id` = '-1') AND (`CommonFile`.`object_name` = 'UserAvatar') LIMIT 1
9	0.00066		8	DESC common_shared_memories
10	0.00038		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`company_id` = '0') AND (`CommonSharedMemory`.`key` = 'virtualMachineSnapshotLock::-1') LIMIT 1
11	0.00029		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`company_id` = '0') AND (`CommonSharedMemory`.`key` = 'companyBackupLoadLockProgressKey::-1') LIMIT 1
16	0.00076		8	DESC taxregister_expense_corrections
17	0.00031		0	SELECT `TaxregisterExpenseCorrection`.`id`, `TaxregisterExpenseCorrection`.`company_id`, `TaxregisterExpenseCorrection`.`year`, `TaxregisterExpenseCorrection`.`month`, `TaxregisterExpenseCorrection`.`income`, `TaxregisterExpenseCorrection`.`expense`, `TaxregisterExpenseCorrection`.`created`, `TaxregisterExpenseCorrection`.`modified` FROM `taxregister_expense_corrections` AS `TaxregisterExpenseCorrection` WHERE (`TaxregisterExpenseCorrection`.`company_id` = '-1') LIMIT 1
18	0.0008		37	DESC taxregisters
19	0.00027		0	SELECT `Taxregister`.`id` FROM `taxregisters` AS `Taxregister` WHERE (`Taxregister`.`company_id` = '-1') LIMIT 1
20	0.00077		25	DESC lumpregisters
21	0.00027		0	SELECT `Lumpregister`.`id` FROM `lumpregisters` AS `Lumpregister` WHERE (`Lumpregister`.`company_id` = '-1') LIMIT 1
22	0.00103		53	DESC vatregisters
23	0.00038		0	SELECT `Vatregister`.`id`, `Vatregister`.`company_id`, `Vatregister`.`user`, `Vatregister`.`invoice_id`, `Vatregister`.`expense_id`, `Vatregister`.`vehicle_id`, `Vatregister`.`vatregister_proportion_correction_id`, `Vatregister`.`contractor_id`, `Vatregister`.`contractor_detail_id`, `Vatregister`.`type`, `Vatregister`.`date`, `Vatregister`.`purchase_date`, `Vatregister`.`payment_date`, `Vatregister`.`payment_term_date`, `Vatregister`.`name`, `Vatregister`.`description`, `Vatregister`.`netto`, `Vatregister`.`tax`, `Vatregister`.`total`, `Vatregister`.`currency`, `Vatregister`.`manual`, `Vatregister`.`wnt`, `Vatregister`.`service_import`, `Vatregister`.`service_import2`, `Vatregister`.`cargo_import`, `Vatregister`.`cargo_import2`, `Vatregister`.`ift_2r`, `Vatregister`.`vat_buyer`, `Vatregister`.`fixed_asset`, `Vatregister`.`bad_debts_deduction`, `Vatregister`.`internal_document`, `Vatregister`.`trade_goods`, `Vatregister`.`liquidation_inventory`, `Vatregister`.`fiscal_printer_deduction_return`, `Vatregister`.`wnt_vehicle`, `Vatregister`.`vatregister_proportion_mixed`, `Vatregister`.`vatregister_proportion_correction_years`, `Vatregister`.`vatregister_proportion_manual`, `Vatregister`.`vatregister_proportion_correction_fixed_asset`, `Vatregister`.`vatregister_proportion_correction_other`, `Vatregister`.`expense_correction`, `Vatregister`.`split_payment`, `Vatregister`.`sw`, `Vatregister`.`vat_buyer_sale_type`, `Vatregister`.`type_of_sale`, `Vatregister`.`gtu`, `Vatregister`.`affiliated_entity`, `Vatregister`.`buyer_tax`, `Vatregister`.`import_jpk_vat`, `Vatregister`.`tags`, `Vatregister`.`documents`, `Vatregister`.`created`, `Vatregister`.`modified` FROM `vatregisters` AS `Vatregister` WHERE (`Vatregister`.`company_id` = '-1') AND (`Vatregister`.`type` = 'invoice_to_receipt') LIMIT 1
27	0.00066		10	DESC shortcuts
28	0.0003		0	SELECT `Shortcut`.`id`, `Shortcut`.`company_id`, `Shortcut`.`user`, `Shortcut`.`label`, `Shortcut`.`url`, `Shortcut`.`icon`, `Shortcut`.`type`, `Shortcut`.`order`, `Shortcut`.`created`, `Shortcut`.`modified` FROM `shortcuts` AS `Shortcut` IGNORE INDEX (PRIMARY) WHERE (`Shortcut`.`company_id` = '-1') AND (`Shortcut`.`user` = '-1') ORDER BY Shortcut.order
29	0.0006		8	DESC company_remember_fields
30	0.00029		0	SELECT `CompanyRememberField`.`id`, `CompanyRememberField`.`company_id`, `CompanyRememberField`.`model`, `CompanyRememberField`.`field`, `CompanyRememberField`.`type`, `CompanyRememberField`.`value`, `CompanyRememberField`.`created`, `CompanyRememberField`.`modified` FROM `company_remember_fields` AS `CompanyRememberField` WHERE (`CompanyRememberField`.`field` = 'progressKey') AND (`CompanyRememberField`.`model` = 'WarehouseGood') AND (`CompanyRememberField`.`company_id` = '-1') LIMIT 1
43	0.00075		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`company_id` = '0') AND (`CommonSharedMemory`.`key` = 'User::-1::shortcutsEnabled') LIMIT 1
44	0.00045		0	SELECT `CompanyRememberField`.`id`, `CompanyRememberField`.`company_id`, `CompanyRememberField`.`model`, `CompanyRememberField`.`field`, `CompanyRememberField`.`type`, `CompanyRememberField`.`value`, `CompanyRememberField`.`created`, `CompanyRememberField`.`modified` FROM `company_remember_fields` AS `CompanyRememberField` WHERE (`CompanyRememberField`.`field` = 'need_buy_pack') AND (`CompanyRememberField`.`model` = 'Mojo') AND (`CompanyRememberField`.`company_id` = '-1') LIMIT 1
49	0.00035		0	SELECT `CompanyRememberField`.`id`, `CompanyRememberField`.`company_id`, `CompanyRememberField`.`model`, `CompanyRememberField`.`field`, `CompanyRememberField`.`type`, `CompanyRememberField`.`value`, `CompanyRememberField`.`created`, `CompanyRememberField`.`modified` FROM `company_remember_fields` AS `CompanyRememberField` WHERE (`CompanyRememberField`.`field` = 'progressKey') AND (`CompanyRememberField`.`model` = 'WarehouseGood') AND (`CompanyRememberField`.`company_id` = '-1') LIMIT 1
51	0.00052		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`company_id` = '0') AND (`CommonSharedMemory`.`key` = 'User::-1::shortcutsEnabled') LIMIT 1
52	0.00035		0	SELECT `CompanyRememberField`.`id`, `CompanyRememberField`.`company_id`, `CompanyRememberField`.`model`, `CompanyRememberField`.`field`, `CompanyRememberField`.`type`, `CompanyRememberField`.`value`, `CompanyRememberField`.`created`, `CompanyRememberField`.`modified` FROM `company_remember_fields` AS `CompanyRememberField` WHERE (`CompanyRememberField`.`field` = 'need_buy_pack') AND (`CompanyRememberField`.`model` = 'Mojo') AND (`CompanyRememberField`.`company_id` = '-1') LIMIT 1
55	0.00029		0	SELECT `CompanyRememberField`.`id`, `CompanyRememberField`.`company_id`, `CompanyRememberField`.`model`, `CompanyRememberField`.`field`, `CompanyRememberField`.`type`, `CompanyRememberField`.`value`, `CompanyRememberField`.`created`, `CompanyRememberField`.`modified` FROM `company_remember_fields` AS `CompanyRememberField` WHERE (`CompanyRememberField`.`field` = 'progressKey') AND (`CompanyRememberField`.`model` = 'WarehouseGood') AND (`CompanyRememberField`.`company_id` = '-1') LIMIT 1
57	0.00055		0	SELECT `CommonSharedMemory`.`id`, `CommonSharedMemory`.`company_id`, `CommonSharedMemory`.`key`, `CommonSharedMemory`.`value`, `CommonSharedMemory`.`type`, `CommonSharedMemory`.`expiration_date`, `CommonSharedMemory`.`created`, `CommonSharedMemory`.`modified` FROM `common_shared_memories` AS `CommonSharedMemory` WHERE (`CommonSharedMemory`.`company_id` = '0') AND (`CommonSharedMemory`.`key` = 'User::-1::shortcutsEnabled') LIMIT 1
58	0.00026		0	SELECT `CompanyRememberField`.`id`, `CompanyRememberField`.`company_id`, `CompanyRememberField`.`model`, `CompanyRememberField`.`field`, `CompanyRememberField`.`type`, `CompanyRememberField`.`value`, `CompanyRememberField`.`created`, `CompanyRememberField`.`modified` FROM `company_remember_fields` AS `CompanyRememberField` WHERE (`CompanyRememberField`.`field` = 'need_buy_pack') AND (`CompanyRememberField`.`model` = 'Mojo') AND (`CompanyRememberField`.`company_id` = '-1') LIMIT 1
0.0133

No	File	Message
1	/var/www/wfirma.pl/framework/controller.php:125	Function libxml_disable_entity_loader() is deprecated
2	/var/www/wfirma.pl/framework/model/fields_object.php:61	Return type of Framework\Model\FieldsObject::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
3	/var/www/wfirma.pl/framework/model/fields_object.php:97	Return type of Framework\Model\FieldsObject::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
4	/var/www/wfirma.pl/framework/model/fields_object.php:105	Return type of Framework\Model\FieldsObject::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
5	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CommonSharedMemory is deprecated
6	/var/www/wfirma.pl/framework/model/my_sql_db.php:59	Creation of dynamic property MySqlDb::$connectionid is deprecated
7	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Company is deprecated
8	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$User is deprecated
9	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property User::$CommonFile is deprecated
10	/var/www/wfirma.pl/framework/model/my_sql_db.php:59	Creation of dynamic property MySqlDb::$connectionid is deprecated
11	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserRememberField is deprecated
12	/var/www/wfirma.pl/app/libs/MainMenu.php:170	Creation of dynamic property App\Libs\MainMenu::$sidebarCollapse is deprecated
13	/var/www/wfirma.pl/app/libs/MainMenu.php:171	Creation of dynamic property App\Libs\MainMenu::$shortcutsCollapse is deprecated
14	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserRemoveRight is deprecated
15	/var/www/wfirma.pl/app/libs/MainMenu.php:172	Creation of dynamic property App\Libs\MainMenu::$UserRemoveRight is deprecated
16	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserCompany is deprecated
17	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property UserCompany::$Company is deprecated
18	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$TaxregisterExpenseCorrection is deprecated
19	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Taxregister is deprecated
20	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Lumpregister is deprecated
21	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property TaxregisterExpenseCorrection::$Vatregister is deprecated
22	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property DashboardStartModule::$PackAddonInfo is deprecated
23	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackAddonInfo::$PackAddon is deprecated
24	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property DashboardStartModule::$UserCompany is deprecated
25	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$DashboardStartModule is deprecated
26	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property DashboardStartModule::$Shortcut is deprecated
27	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CompanyRememberField is deprecated
28	/var/www/wfirma.pl/framework/controller.php:185	Method ReflectionParameter::getClass() is deprecated
29	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$PackDef is deprecated
30	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CompanyPromotionCode is deprecated
31	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackDef::$PackPrice is deprecated
32	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackDef::$PackDefVariant is deprecated
33	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Promotion is deprecated
34	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$PackAddonInfo is deprecated
35	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackAddonInfo::$PackAddon is deprecated
36	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$FiskalizatorSoftwareKey is deprecated
37	/var/www/wfirma.pl/framework/libs/services/loaders/service_loader.php:50	Method ReflectionParameter::getClass() is deprecated
38	/var/www/wfirma.pl/framework/libs/services/loaders/service_loader.php:50	Method ReflectionParameter::getClass() is deprecated
39	/var/www/wfirma.pl/framework/libs/services/loaders/service_loader.php:50	Method ReflectionParameter::getClass() is deprecated
40	/var/www/wfirma.pl/framework/controller.php:724	Creation of dynamic property PagesController::$rabbitmqTokenGeneratorService is deprecated
41	/var/www/wfirma.pl/framework/controller.php:395	Creation of dynamic property App\View::$data is deprecated
42	/var/www/wfirma.pl/framework/controller.php:125	Function libxml_disable_entity_loader() is deprecated
43	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CommonSharedMemory is deprecated
44	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Company is deprecated
45	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$User is deprecated
46	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserRememberField is deprecated
47	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CompanyRememberField is deprecated
48	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Article is deprecated
49	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserRemoveRight is deprecated
50	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$PackAddonInfo is deprecated
51	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackAddonInfo::$PackAddon is deprecated
52	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$FiskalizatorSoftwareKey is deprecated
53	/var/www/wfirma.pl/framework/controller.php:724	Creation of dynamic property PagesController::$rabbitmqTokenGeneratorService is deprecated
54	/var/www/wfirma.pl/framework/controller.php:395	Creation of dynamic property App\View::$data is deprecated
55	/var/www/wfirma.pl/framework/controller.php:125	Function libxml_disable_entity_loader() is deprecated
56	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CommonSharedMemory is deprecated
57	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$Company is deprecated
58	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$User is deprecated
59	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserRememberField is deprecated
60	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$CompanyRememberField is deprecated
61	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$UserRemoveRight is deprecated
62	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$PackAddonInfo is deprecated
63	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackAddonInfo::$PackAddon is deprecated
64	/var/www/wfirma.pl/framework/controller.php:494	Creation of dynamic property PagesController::$FiskalizatorSoftwareKey is deprecated
65	/var/www/wfirma.pl/framework/controller.php:724	Creation of dynamic property PagesController::$rabbitmqTokenGeneratorService is deprecated
66	/var/www/wfirma.pl/framework/controller.php:395	Creation of dynamic property App\View::$data is deprecated
67	/var/www/wfirma.pl/framework/view/helpers/html_helper.php:761	Creation of dynamic property HtmlHelper::$position is deprecated

No	File	Message
1	/var/www/wfirma.pl/framework/model.php:1623	Only variables should be passed by reference
2	/var/www/wfirma.pl/framework/model.php:1536	Only variables should be passed by reference
3	/var/www/wfirma.pl/framework/model.php:1536	Only variables should be passed by reference
4	/var/www/wfirma.pl/framework/model.php:1460	Only variables should be passed by reference
5	/var/www/wfirma.pl/framework/model.php:1460	Only variables should be passed by reference
6	/var/www/wfirma.pl/framework/model.php:1460	Only variables should be passed by reference
7	/var/www/wfirma.pl/framework/model.php:1536	Only variables should be passed by reference

No	File	Message
1	/var/www/wfirma.pl/framework/model.php:1668	Undefined array key "joinType"
2	/var/www/wfirma.pl/app/libs/MainMenu/OfficeTrait.php:227	Trying to access array offset on value of type null
3	/var/www/wfirma.pl/_core/controllers/pages_controller.php:61	Undefined array key "/korekty-przychodow-i-kosztow-przewodnik-dla-biur-rachunkowych"
4	/var/www/wfirma.pl/_core/controllers/pages_controller.php:125	Undefined variable $crop
5	/var/www/wfirma.pl/_core/controllers/pages_controller.php:129	Undefined array key "visited"
6	/var/www/wfirma.pl/framework/model.php:1501	Undefined array key "joinType"
7	/var/www/wfirma.pl/framework/model.php:1501	Undefined array key "joinType"
8	/var/www/wfirma.pl/framework/model.php:1501	Undefined array key "joinType"
9	/var/www/wfirma.pl/_core/controllers/pages_controller.php:155	Undefined array key "referrerPromotionId"
10	/var/www/wfirma.pl/_core/controllers/pages_controller.php:157	Undefined array key "isClient"
11	/var/www/wfirma.pl/_core/libs/services/start/start_services_loader.php:49	Undefined array key "id"
12	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:99	Undefined variable $defaultPageKeywords
13	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:105	Undefined variable $_author
14	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:148	Undefined variable $userId
15	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:150	Undefined variable $_company
16	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:151	Undefined variable $headerTheme
17	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:159	Undefined variable $addonType
18	/var/www/wfirma.pl/app/views/pages/elements/footer.phtml:19	Undefined variable $factoringUrl
19	/var/www/wfirma.pl/app/views/pages/elements/footer.phtml:22	Undefined variable $factoringUrl
20	/var/www/wfirma.pl/framework/view/helpers/html_helper.php:240	Undefined array key "class"