KPiR w paktyce - część I

central-default-default-default

No	Time	Returned	Affected	Query
1	0.00023	0	0	SET sql_auto_is_null = 0
2	0.00037		1	SELECT id FROM database_versions WHERE `status` = "completed" ORDER BY id DESC LIMIT 1
3	0.00042		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
9	0.00113		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
10	0.00034		1	SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`user_id` = '-1') AND (`right` IN ('leader','helper','payroll_specialist'))
15	0.0003		1	SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-21') AND (`PackAddon`.`name` = 'reliable_contractor')
16	0.00027		1	SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`UserCompany`.`company_id` = '-1') AND (`UserCompany`.`right` = 'client') AND (`UserCompany`.`user_id` = '-1')
19	0.00098		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')
20	0.00045		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'))
21	0.00045		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'))
22	0.00104		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`
23	0.00068		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`
24	0.00034		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'))
25	0.00089		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`, `CompanyPartMigration`.`status`, `CompanyPartMigration`.`active_after` FROM `companies` AS `Company` LEFT JOIN `company_part_migrations` AS `CompanyPartMigration` ON `CompanyPartMigration`.`company_id` = -1 AND `CompanyPartMigration`.`company_id` = `Company`.`id` AND (CompanyPartMigration.status NOT IN ("completed", "error")) WHERE (`Company`.`company_id` = '-1') LIMIT 1
26	0.0008		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-21 04:11:00') AND (`Promotion`.`date_since` <= '2025-06-21 04:11:00') AND (`Promotion`.`active` = '1') AND (`Promotion`.`type` = 'presale') LIMIT 1
27	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
30	0.00029		1	SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-21') AND (`PackAddon`.`name` = 'warehouse')
31	0.00025		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
0.00956

default-default-default-default

No	Time	Returned	Affected	Query
4	0.00025	0	0	SET sql_auto_is_null = 0
5	0.00036		1	SELECT id FROM database_versions WHERE `status` = "completed" ORDER BY id DESC LIMIT 1
6	0.00036		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
7	0.00042		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
8	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`.`company_id` = '0') AND (`CommonSharedMemory`.`key` = 'companyBackupLoadLockProgressKey::-1') LIMIT 1
11	0.0003		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
12	0.00025		0	SELECT `Taxregister`.`id` FROM `taxregisters` AS `Taxregister` WHERE (`Taxregister`.`company_id` = '-1') LIMIT 1
13	0.00025		0	SELECT `Lumpregister`.`id` FROM `lumpregisters` AS `Lumpregister` WHERE (`Lumpregister`.`company_id` = '-1') LIMIT 1
14	0.00042		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
17	0.00032		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
18	0.00028		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
28	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
29	0.00028		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.00434

No	File	Message
1	/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
2	/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
3	/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
4	/var/www/wfirma.pl/framework/model/my_sql_db.php:59	Creation of dynamic property MySqlDb::$connectionid is deprecated
5	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property User::$CommonFile 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/app/libs/MainMenu.php:170	Creation of dynamic property App\Libs\MainMenu::$sidebarCollapse is deprecated
8	/var/www/wfirma.pl/app/libs/MainMenu.php:171	Creation of dynamic property App\Libs\MainMenu::$shortcutsCollapse is deprecated
9	/var/www/wfirma.pl/app/libs/MainMenu.php:172	Creation of dynamic property App\Libs\MainMenu::$UserRemoveRight is deprecated
10	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property UserCompany::$Company is deprecated
11	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property TaxregisterExpenseCorrection::$Vatregister is deprecated
12	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property DashboardStartModule::$PackAddonInfo is deprecated
13	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackAddonInfo::$PackAddon is deprecated
14	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property DashboardStartModule::$UserCompany is deprecated
15	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property DashboardStartModule::$Shortcut is deprecated
16	/var/www/wfirma.pl/framework/controller.php:248	Method ReflectionParameter::getClass() is deprecated
17	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackDef::$PackPrice is deprecated
18	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackDef::$PackDefVariant is deprecated
19	/var/www/wfirma.pl/framework/model.php:2212	Creation of dynamic property PackAddonInfo::$PackAddon is deprecated
20	/var/www/wfirma.pl/framework/libs/services/loaders/service_loader.php:50	Method ReflectionParameter::getClass() is deprecated
21	/var/www/wfirma.pl/framework/libs/services/loaders/service_loader.php:50	Method ReflectionParameter::getClass() is deprecated
22	/var/www/wfirma.pl/framework/libs/services/loaders/service_loader.php:50	Method ReflectionParameter::getClass() is deprecated
23	/var/www/wfirma.pl/framework/controller.php:458	Creation of dynamic property App\View::$data is deprecated
24	/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
8	/var/www/wfirma.pl/framework/model.php:1623	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 "/kpir-w-paktyce-czesc-i"
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/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
7	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
8	/var/www/wfirma.pl/framework/model.php:1501	Undefined array key "joinType"
9	/var/www/wfirma.pl/framework/model.php:1501	Undefined array key "joinType"
10	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
11	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
12	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
13	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
14	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
15	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
16	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
17	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
18	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
19	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
20	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
21	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
22	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
23	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
24	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
25	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
26	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
27	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
28	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
29	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
30	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
31	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
32	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
33	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
34	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
35	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
36	/var/www/wfirma.pl/framework/model.php:1501	Undefined array key "joinType"
37	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
38	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
39	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
40	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
41	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
42	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
43	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
44	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
45	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
46	/var/www/wfirma.pl/app/Model/DTO/PackPriceDTO.php:36	Undefined array key "account_type"
47	/var/www/wfirma.pl/framework/model.php:1668	Undefined array key "joinType"
48	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
49	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
50	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
51	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
52	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
53	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
54	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
55	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
56	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
57	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
58	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
59	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
60	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
61	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
62	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
63	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
64	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
65	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
66	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
67	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
68	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
69	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
70	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
71	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
72	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
73	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
74	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
75	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
76	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
77	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
78	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
79	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
80	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
81	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
82	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
83	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
84	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
85	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
86	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
87	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
88	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
89	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
90	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
91	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
92	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
93	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
94	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Undefined array key "Company"
95	/var/www/wfirma.pl/_core/models/pack/pack_price.php:148	Trying to access array offset on value of type null
96	/var/www/wfirma.pl/_core/controllers/pages_controller.php:156	Undefined array key "referrerPromotionId"
97	/var/www/wfirma.pl/_core/controllers/pages_controller.php:158	Undefined array key "isClient"
98	/var/www/wfirma.pl/_core/libs/services/start/start_services_loader.php:49	Undefined array key "id"
99	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:99	Undefined variable $defaultPageKeywords
100	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:105	Undefined variable $_author
101	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:148	Undefined variable $userId
102	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:150	Undefined variable $_company
103	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:151	Undefined variable $headerTheme
104	/var/www/wfirma.pl/app/views/pages/landing_page_checker.phtml:159	Undefined variable $addonType
105	/var/www/wfirma.pl/app/views/pages/elements/footer.phtml:19	Undefined variable $factoringUrl
106	/var/www/wfirma.pl/app/views/pages/elements/footer.phtml:22	Undefined variable $factoringUrl
107	/var/www/wfirma.pl/framework/view/helpers/html_helper.php:240	Undefined array key "class"