| 1 |
0.00021 |
0 |
0 |
SET sql_auto_is_null = 0 |
| 2 |
0.00032 |
|
1 |
SELECT id FROM database_versions WHERE `status` = "completed" ORDER BY id DESC LIMIT 1 |
| 3 |
0.00033 |
|
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.00074 |
|
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.00027 |
|
1 |
SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`user_id` = '-1') AND (`right` IN ('leader','helper','payroll_specialist')) |
| 15 |
0.00028 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-13') AND (`PackAddon`.`name` = 'reliable_contractor') |
| 16 |
0.00023 |
|
1 |
SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`UserCompany`.`company_id` = '-1') AND (`UserCompany`.`right` = 'client') AND (`UserCompany`.`user_id` = '-1') |
| 19 |
0.00045 |
|
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.00028 |
|
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.00029 |
|
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.00052 |
|
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.00035 |
|
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.00025 |
|
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.00057 |
|
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-13 00:15:47') AND (`Promotion`.`date_since` <= '2025-06-13 00:15:47') AND (`Promotion`.`active` = '1') AND (`Promotion`.`type` = 'presale') LIMIT 1 |
| 26 |
0.00026 |
|
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 |
| 29 |
0.00029 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-13') AND (`PackAddon`.`name` = 'warehouse') |
| 30 |
0.00023 |
|
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 |
| 31 |
0.0003 |
|
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 |
| 33 |
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 |
| 36 |
0.00026 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-13') AND (`PackAddon`.`name` = 'warehouse') |
Wsparcie, gdy tego potrzebujesz 
