1 |
0.00028 |
0 |
0 |
SET sql_auto_is_null = 0 |
2 |
0.00044 |
|
1 |
SELECT id FROM database_versions WHERE `status` = "completed" ORDER BY id DESC LIMIT 1 |
3 |
0.00044 |
|
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 |
4 |
0.00079 |
|
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`.`referer` IS NOT NULL) AND (`Promotion`.`active` = '1') |
5 |
0.00037 |
|
8 |
SELECT `LandingPage`.`name`, `LandingPage`.`url` FROM `landing_pages` AS `LandingPage` WHERE (`LandingPage`.`show_in_footer` = '1') |
11 |
0.00052 |
|
1 |
SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`user_id` = '0') AND (`right` IN ('leader','helper','payroll_specialist')) |
16 |
0.0004 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-14') AND (`PackAddon`.`name` = 'reliable_contractor') |
17 |
0.00031 |
|
1 |
SELECT COUNT(*) FROM `user_companies` AS `UserCompany` WHERE (`UserCompany`.`company_id` = '-1') AND (`UserCompany`.`right` = 'client') AND (`UserCompany`.`user_id` = '0') |
20 |
0.00164 |
|
1 |
SELECT `AccountancyDetail`.`id`, `AccountancyDetail`.`company_id`, `AccountancyDetail`.`name`, `AccountancyDetail`.`url`, `AccountancyDetail`.`text`, `AccountancyDetail`.`short_text`, `AccountancyDetail`.`street`, `AccountancyDetail`.`zip`, `AccountancyDetail`.`city`, `AccountancyDetail`.`city_slug`, `AccountancyDetail`.`state`, `AccountancyDetail`.`phone`, `AccountancyDetail`.`email`, `AccountancyDetail`.`www`, `AccountancyDetail`.`lat`, `AccountancyDetail`.`lng`, `AccountancyDetail`.`offer`, `AccountancyDetail`.`promoted`, `AccountancyDetail`.`warranty`, `AccountancyDetail`.`super`, `AccountancyDetail`.`top`, `AccountancyDetail`.`attachment`, `AccountancyDetail`.`is_verified`, `AccountancyDetail`.`discount`, `AccountancyDetail`.`discount_value`, `AccountancyDetail`.`accountant_detail`, `AccountancyDetail`.`score`, `AccountancyDetail`.`online`, `AccountancyDetail`.`specialization_accounting_offices`, `AccountancyDetail`.`specialization_companies`, `AccountancyDetail`.`service_book`, `AccountancyDetail`.`service_staff`, `AccountancyDetail`.`service_trade`, `AccountancyDetail`.`service_analysis`, `AccountancyDetail`.`service_crm`, `AccountancyDetail`.`service_warehouse`, `AccountancyDetail`.`service_ecommerce_integration`, `AccountancyDetail`.`service_fiscal_printers`, `AccountancyDetail`.`cert_book`, `AccountancyDetail`.`cert_tax`, `AccountancyDetail`.`cert_book_number`, `AccountancyDetail`.`cert_tax_number`, `AccountancyDetail`.`insurance`, `AccountancyDetail`.`insurance_number`, `AccountancyDetail`.`contact_online`, `AccountancyDetail`.`contact_headquarter`, `AccountancyDetail`.`open_days`, `AccountancyDetail`.`open_hour`, `AccountancyDetail`.`close_hour`, `AccountancyDetail`.`implementation_company`, `AccountancyDetail`.`implementation_respondo_subdomain`, `AccountancyDetail`.`implementer`, `AccountancyDetail`.`created`, `AccountancyDetail`.`modified`, `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` FROM `accountancy_details` AS `AccountancyDetail` LEFT JOIN `companies` AS `Company` ON `AccountancyDetail`.`company_id` = `Company`.`id` WHERE (`AccountancyDetail`.`offer` = '1') AND (`AccountancyDetail`.`url` = 'mercury') LIMIT 1 |
23 |
0.00252 |
|
2 |
SELECT `AccountancyDetail`.`id`, `AccountancyDetail`.`company_id`, `AccountancyDetail`.`name`, `AccountancyDetail`.`url`, `AccountancyDetail`.`text`, `AccountancyDetail`.`short_text`, `AccountancyDetail`.`street`, `AccountancyDetail`.`zip`, `AccountancyDetail`.`city`, `AccountancyDetail`.`city_slug`, `AccountancyDetail`.`state`, `AccountancyDetail`.`phone`, `AccountancyDetail`.`email`, `AccountancyDetail`.`www`, `AccountancyDetail`.`lat`, `AccountancyDetail`.`lng`, `AccountancyDetail`.`offer`, `AccountancyDetail`.`promoted`, `AccountancyDetail`.`warranty`, `AccountancyDetail`.`super`, `AccountancyDetail`.`top`, `AccountancyDetail`.`attachment`, `AccountancyDetail`.`is_verified`, `AccountancyDetail`.`discount`, `AccountancyDetail`.`discount_value`, `AccountancyDetail`.`accountant_detail`, `AccountancyDetail`.`score`, `AccountancyDetail`.`online`, `AccountancyDetail`.`specialization_accounting_offices`, `AccountancyDetail`.`specialization_companies`, `AccountancyDetail`.`service_book`, `AccountancyDetail`.`service_staff`, `AccountancyDetail`.`service_trade`, `AccountancyDetail`.`service_analysis`, `AccountancyDetail`.`service_crm`, `AccountancyDetail`.`service_warehouse`, `AccountancyDetail`.`service_ecommerce_integration`, `AccountancyDetail`.`service_fiscal_printers`, `AccountancyDetail`.`cert_book`, `AccountancyDetail`.`cert_tax`, `AccountancyDetail`.`cert_book_number`, `AccountancyDetail`.`cert_tax_number`, `AccountancyDetail`.`insurance`, `AccountancyDetail`.`insurance_number`, `AccountancyDetail`.`contact_online`, `AccountancyDetail`.`contact_headquarter`, `AccountancyDetail`.`open_days`, `AccountancyDetail`.`open_hour`, `AccountancyDetail`.`close_hour`, `AccountancyDetail`.`implementation_company`, `AccountancyDetail`.`implementation_respondo_subdomain`, `AccountancyDetail`.`implementer`, `AccountancyDetail`.`created`, `AccountancyDetail`.`modified`, `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` FROM `accountancy_details` AS `AccountancyDetail` LEFT JOIN `companies` AS `Company` ON `AccountancyDetail`.`company_id` = `Company`.`id` WHERE (COALESCE(`AccountancyDetail`.`short_text`, '') != '') AND (`promoted` = '1') AND (`offer` = '1') ORDER BY RAND() LIMIT 2 |
26 |
0.0004 |
|
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::0::appMode') LIMIT 1 |
29 |
0.00031 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-14') AND (`PackAddon`.`name` = 'warehouse') |
30 |
0.00034 |
|
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.00046 |
|
1 |
SELECT `Setting`.`id`, `Setting`.`meta_title`, `Setting`.`meta_description`, `Setting`.`meta_keywords`, `Setting`.`meta_publisher`, `Setting`.`support_text`, `Setting`.`dotpay_id`, `Setting`.`dotpay_pin`, `Setting`.`dotpay_username`, `Setting`.`dotpay_password`, `Setting`.`dotpay_channels`, `Setting`.`paybynet_password`, `Setting`.`paybynet_channels`, `Setting`.`bluemedia_on`, `Setting`.`bluemedia_invoices_service_id`, `Setting`.`bluemedia_invoices_key`, `Setting`.`autopay_common_order_service_id`, `Setting`.`autopay_common_order_key`, `Setting`.`autopay_common_order_url`, `Setting`.`allegro_carrier_modified_date`, `Setting`.`bluemedia_invoices_gateway_url`, `Setting`.`bluemedia_expenses_service_id`, `Setting`.`bluemedia_expenses_key`, `Setting`.`bluemedia_expenses_gateway_url`, `Setting`.`bluemedia_expenses_card_service_id`, `Setting`.`bluemedia_expenses_card_key`, `Setting`.`bluemedia_expenses_card_gateway_url`, `Setting`.`bluemedia_taxes_service_id`, `Setting`.`bluemedia_taxes_key`, `Setting`.`bluemedia_taxes_gateway_url`, `Setting`.`bluemedia_taxes_card_service_id`, `Setting`.`bluemedia_taxes_card_key`, `Setting`.`bluemedia_taxes_card_gateway_url`, `Setting`.`bluemedia_zus_service_id`, `Setting`.`bluemedia_zus_key`, `Setting`.`bluemedia_zus_gateway_url`, `Setting`.`bluemedia_zus_card_service_id`, `Setting`.`bluemedia_zus_card_key`, `Setting`.`bluemedia_zus_card_gateway_url`, `Setting`.`bluemedia_verification_service_id`, `Setting`.`bluemedia_verification_key`, `Setting`.`bluemedia_verification_gateway_url`, `Setting`.`bluemedia_verification_payway_list`, `Setting`.`bluemedia_verification_corporation_service_id`, `Setting`.`bluemedia_verification_corporation_key`, `Setting`.`bluemedia_verification_corporation_gateway_url`, `Setting`.`bluemedia_verification_corporation_payway_list`, `Setting`.`bluemedia_packs_service_id`, `Setting`.`bluemedia_packs_key`, `Setting`.`bluemedia_packs_gateway_url`, `Setting`.`bluemedia_packs_payway_list`, `Setting`.`auto_send_invoices` FROM `settings` AS `Setting` LIMIT 1 |
33 |
0.00151 |
|
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 |
34 |
0.00066 |
|
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`.`referer` IS NOT NULL) AND (`Promotion`.`active` = '1') |
35 |
0.00037 |
|
8 |
SELECT `LandingPage`.`name`, `LandingPage`.`url` FROM `landing_pages` AS `LandingPage` WHERE (`LandingPage`.`show_in_footer` = '1') |
37 |
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::0::appMode') LIMIT 1 |
40 |
0.00033 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-14') AND (`PackAddon`.`name` = 'warehouse') |
41 |
0.00038 |
|
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 |
43 |
0.00044 |
|
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 |
46 |
0.0004 |
|
1 |
SELECT COUNT(*) FROM `pack_addons` AS `PackAddon` WHERE (`PackAddon`.`company_id` = '-1') AND (`PackAddon`.`expiration_date` >= '2025-06-14') AND (`PackAddon`.`name` = 'warehouse') |