Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.import_from AS import_from_1,
  t0_.document_type AS document_type_2,
  t0_.document_number AS document_number_3,
  t0_.product_code AS product_code_4,
  t0_.atc_code AS atc_code_5,
  t0_.aic_code AS aic_code_6,
  t0_.product_description AS product_description_7,
  t0_.lot_number AS lot_number_8,
  t0_.client_category AS client_category_9,
  t0_.client_code AS client_code_10,
  t0_.client_ministerial_code AS client_ministerial_code_11,
  t0_.client_business_name AS client_business_name_12,
  t0_.client_address AS client_address_13,
  t0_.client_province AS client_province_14,
  t0_.client_city AS client_city_15,
  t0_.client_zip AS client_zip_16,
  t0_.client_region AS client_region_17,
  t0_.vat AS vat_18,
  t0_.order_number AS order_number_19,
  t0_.receiver_client_code AS receiver_client_code_20,
  t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21,
  t0_.receiver_client_business_name AS receiver_client_business_name_22,
  t0_.receiver_client_address AS receiver_client_address_23,
  t0_.receiver_client_province AS receiver_client_province_24,
  t0_.receiver_client_city AS receiver_client_city_25,
  t0_.receiver_client_zip AS receiver_client_zip_26,
  t0_.receiver_client_region AS receiver_client_region_27,
  t0_.kam AS kam_28,
  t0_.extra AS extra_29,
  t0_.email AS email_30,
  t0_.vs_vi AS vs_vi_31,
  t0_.invoice_num AS invoice_num_32,
  t0_.division AS division_33,
  t0_.organization AS organization_34,
  t0_.material AS material_35,
  t0_.selling_unit AS selling_unit_36,
  t0_.tax AS tax_37,
  t0_.num_of_docs_control AS num_of_docs_control_38,
  t0_.delivery_num AS delivery_num_39,
  t0_.cig_number AS cig_number_40,
  t0_.invoice_voice AS invoice_voice_41,
  t0_.datetime_import AS datetime_import_42,
  t0_.date_issue AS date_issue_43,
  t0_.datetime_order AS datetime_order_44,
  t0_.datetime_ref AS datetime_ref_45,
  t0_.datetime_lot_expiration AS datetime_lot_expiration_46,
  t0_.datetime_control_docs AS datetime_control_docs_47,
  t0_.datetime_delivery AS datetime_delivery_48,
  t0_.week_number AS week_number_49,
  t0_.month_number AS month_number_50,
  t0_.quantity AS quantity_51,
  t0_.box_quantity AS box_quantity_52,
  t0_.backup_quantity AS backup_quantity_53,
  t0_.backup_net_unit_price AS backup_net_unit_price_54,
  t0_.net_unit_price AS net_unit_price_55,
  t0_.net_box_price AS net_box_price_56,
  t0_.net_price AS net_price_57,
  t0_.charged_price AS charged_price_58,
  t0_.cost AS cost_59,
  t0_.is_cold AS is_cold_60,
  t0_.notes AS notes_61,
  t0_.product_id AS product_id_62,
  t0_.hospital_id AS hospital_id_63,
  t0_.facility_id AS facility_id_64,
  t0_.employee_id AS employee_id_65,
  t0_.employee_stats_id AS employee_stats_id_66
FROM
  til_sell t0_
WHERE
  YEAR(t0_.date_issue) = ?
  AND MONTH(t0_.date_issue) = ?

SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE YEAR(t0_.date_issue) = '2025' AND MONTH(t0_.date_issue) = '06';

SELECT
  t0_.id AS id_0,
  t0_.import_from AS import_from_1,
  t0_.document_type AS document_type_2,
  t0_.document_number AS document_number_3,
  t0_.product_code AS product_code_4,
  t0_.atc_code AS atc_code_5,
  t0_.aic_code AS aic_code_6,
  t0_.product_description AS product_description_7,
  t0_.lot_number AS lot_number_8,
  t0_.client_category AS client_category_9,
  t0_.client_code AS client_code_10,
  t0_.client_ministerial_code AS client_ministerial_code_11,
  t0_.client_business_name AS client_business_name_12,
  t0_.client_address AS client_address_13,
  t0_.client_province AS client_province_14,
  t0_.client_city AS client_city_15,
  t0_.client_zip AS client_zip_16,
  t0_.client_region AS client_region_17,
  t0_.vat AS vat_18,
  t0_.order_number AS order_number_19,
  t0_.receiver_client_code AS receiver_client_code_20,
  t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21,
  t0_.receiver_client_business_name AS receiver_client_business_name_22,
  t0_.receiver_client_address AS receiver_client_address_23,
  t0_.receiver_client_province AS receiver_client_province_24,
  t0_.receiver_client_city AS receiver_client_city_25,
  t0_.receiver_client_zip AS receiver_client_zip_26,
  t0_.receiver_client_region AS receiver_client_region_27,
  t0_.kam AS kam_28,
  t0_.extra AS extra_29,
  t0_.email AS email_30,
  t0_.vs_vi AS vs_vi_31,
  t0_.invoice_num AS invoice_num_32,
  t0_.division AS division_33,
  t0_.organization AS organization_34,
  t0_.material AS material_35,
  t0_.selling_unit AS selling_unit_36,
  t0_.tax AS tax_37,
  t0_.num_of_docs_control AS num_of_docs_control_38,
  t0_.delivery_num AS delivery_num_39,
  t0_.cig_number AS cig_number_40,
  t0_.invoice_voice AS invoice_voice_41,
  t0_.datetime_import AS datetime_import_42,
  t0_.date_issue AS date_issue_43,
  t0_.datetime_order AS datetime_order_44,
  t0_.datetime_ref AS datetime_ref_45,
  t0_.datetime_lot_expiration AS datetime_lot_expiration_46,
  t0_.datetime_control_docs AS datetime_control_docs_47,
  t0_.datetime_delivery AS datetime_delivery_48,
  t0_.week_number AS week_number_49,
  t0_.month_number AS month_number_50,
  t0_.quantity AS quantity_51,
  t0_.box_quantity AS box_quantity_52,
  t0_.backup_quantity AS backup_quantity_53,
  t0_.backup_net_unit_price AS backup_net_unit_price_54,
  t0_.net_unit_price AS net_unit_price_55,
  t0_.net_box_price AS net_box_price_56,
  t0_.net_price AS net_price_57,
  t0_.charged_price AS charged_price_58,
  t0_.cost AS cost_59,
  t0_.is_cold AS is_cold_60,
  t0_.notes AS notes_61,
  t0_.product_id AS product_id_62,
  t0_.hospital_id AS hospital_id_63,
  t0_.facility_id AS facility_id_64,
  t0_.employee_id AS employee_id_65,
  t0_.employee_stats_id AS employee_stats_id_66
FROM
  til_sell t0_
WHERE
  t0_.date_issue >= ?
  AND t0_.date_issue <= ?

SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE t0_.date_issue >= '2025-04-01' AND t0_.date_issue <= '2026-03-31';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.priority AS priority_5,
  t0.category_id AS category_id_6
FROM
  til_permission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = '1';

SELECT
  t0_.id AS id_0,
  t0_.ihs_code AS ihs_code_1,
  t0_.name AS name_2,
  t0_.vat AS vat_3,
  t0_.address AS address_4,
  t0_.zip AS zip_5,
  t0_.lat AS lat_6,
  t0_.lng AS lng_7,
  t0_.email AS email_8,
  t0_.pec AS pec_9,
  t0_.sdi AS sdi_10,
  t0_.phone AS phone_11,
  t0_.fax AS fax_12,
  t0_.minister_code AS minister_code_13,
  t0_.is_head_group AS is_head_group_14,
  t0_.is_public AS is_public_15,
  t0_.city_id AS city_id_16,
  t0_.hospital_group_id AS hospital_group_id_17
FROM
  til_hospital t0_
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.ihs_code AS ihs_code_1, t0_.name AS name_2, t0_.vat AS vat_3, t0_.address AS address_4, t0_.zip AS zip_5, t0_.lat AS lat_6, t0_.lng AS lng_7, t0_.email AS email_8, t0_.pec AS pec_9, t0_.sdi AS sdi_10, t0_.phone AS phone_11, t0_.fax AS fax_12, t0_.minister_code AS minister_code_13, t0_.is_head_group AS is_head_group_14, t0_.is_public AS is_public_15, t0_.city_id AS city_id_16, t0_.hospital_group_id AS hospital_group_id_17 FROM til_hospital t0_ ORDER BY t0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.january AS january_2,
  t0.february AS february_3,
  t0.march AS march_4,
  t0.april AS april_5,
  t0.may AS may_6,
  t0.june AS june_7,
  t0.july AS july_8,
  t0.august AS august_9,
  t0.september AS september_10,
  t0.october AS october_11,
  t0.november AS november_12,
  t0.december AS december_13,
  t0.january_qty AS january_qty_14,
  t0.february_qty AS february_qty_15,
  t0.march_qty AS march_qty_16,
  t0.april_qty AS april_qty_17,
  t0.may_qty AS may_qty_18,
  t0.june_qty AS june_qty_19,
  t0.july_qty AS july_qty_20,
  t0.august_qty AS august_qty_21,
  t0.september_qty AS september_qty_22,
  t0.october_qty AS october_qty_23,
  t0.november_qty AS november_qty_24,
  t0.december_qty AS december_qty_25,
  t0.product_id AS product_id_26,
  t0.budget_employee_id AS budget_employee_id_27
FROM
  til_budget_employee_product t0
WHERE
  t0.budget_employee_id = ?

SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '2';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.priority AS priority_4
FROM
  til_permission_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.password AS password_5,
  t0.directory_path AS directory_path_6,
  t0.one_time_code AS one_time_code_7,
  t0.role AS role_8,
  t0.expiration_one_time_code AS expiration_one_time_code_9,
  t0.office_hours AS office_hours_10,
  t0.is_active AS is_active_11,
  t0.is_admin_active AS is_admin_active_12,
  t0.is_email_notification_active AS is_email_notification_active_13,
  t0.is_alert_read AS is_alert_read_14,
  t0.is_gdpr_sent AS is_gdpr_sent_15,
  t16.id AS id_17,
  t16.datetime_last_update AS datetime_last_update_18,
  t16.is_terms_accepted AS is_terms_accepted_19,
  t16.is_news_accepted AS is_news_accepted_20,
  t16.user_id AS user_id_21,
  t22.id AS id_23,
  t22.country_code AS country_code_24,
  t22.phone AS phone_25,
  t22.fax AS fax_26,
  t22.mobile AS mobile_27,
  t22.address AS address_28,
  t22.zip AS zip_29,
  t22.other_city AS other_city_30,
  t22.other_province AS other_province_31,
  t22.avatar AS avatar_32,
  t22.user_id AS user_id_33,
  t22.city_id AS city_id_34,
  t22.user_profession_id AS user_profession_id_35,
  t36.id AS id_37,
  t36.residue_rol AS residue_rol_38,
  t36.residue_holiday AS residue_holiday_39,
  t36.datetime_start_work AS datetime_start_work_40,
  t36.datetime_end_work AS datetime_end_work_41,
  t36.show_in_list AS show_in_list_42,
  t36.is_kam AS is_kam_43,
  t36.is_show_in_export_presences AS is_show_in_export_presences_44,
  t36.is_document_product_notify AS is_document_product_notify_45,
  t36.user_id AS user_id_46,
  t36.supervisor_id AS supervisor_id_47,
  t0.account_type_id AS account_type_id_48
FROM
  til_user t0
  LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id
  LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id
  LEFT JOIN til_employee t36 ON t36.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.directory_path AS directory_path_6, t0.one_time_code AS one_time_code_7, t0.role AS role_8, t0.expiration_one_time_code AS expiration_one_time_code_9, t0.office_hours AS office_hours_10, t0.is_active AS is_active_11, t0.is_admin_active AS is_admin_active_12, t0.is_email_notification_active AS is_email_notification_active_13, t0.is_alert_read AS is_alert_read_14, t0.is_gdpr_sent AS is_gdpr_sent_15, t16.id AS id_17, t16.datetime_last_update AS datetime_last_update_18, t16.is_terms_accepted AS is_terms_accepted_19, t16.is_news_accepted AS is_news_accepted_20, t16.user_id AS user_id_21, t22.id AS id_23, t22.country_code AS country_code_24, t22.phone AS phone_25, t22.fax AS fax_26, t22.mobile AS mobile_27, t22.address AS address_28, t22.zip AS zip_29, t22.other_city AS other_city_30, t22.other_province AS other_province_31, t22.avatar AS avatar_32, t22.user_id AS user_id_33, t22.city_id AS city_id_34, t22.user_profession_id AS user_profession_id_35, t36.id AS id_37, t36.residue_rol AS residue_rol_38, t36.residue_holiday AS residue_holiday_39, t36.datetime_start_work AS datetime_start_work_40, t36.datetime_end_work AS datetime_end_work_41, t36.show_in_list AS show_in_list_42, t36.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 FROM til_user t0 LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id LEFT JOIN til_employee t36 ON t36.user_id = t0.id WHERE t0.id = '39';

SELECT
  t0_.id AS id_0,
  t0_.january AS january_1,
  t0_.february AS february_2,
  t0_.march AS march_3,
  t0_.april AS april_4,
  t0_.may AS may_5,
  t0_.june AS june_6,
  t0_.july AS july_7,
  t0_.august AS august_8,
  t0_.september AS september_9,
  t0_.october AS october_10,
  t0_.november AS november_11,
  t0_.december AS december_12,
  t0_.january_qty AS january_qty_13,
  t0_.february_qty AS february_qty_14,
  t0_.march_qty AS march_qty_15,
  t0_.april_qty AS april_qty_16,
  t0_.may_qty AS may_qty_17,
  t0_.june_qty AS june_qty_18,
  t0_.july_qty AS july_qty_19,
  t0_.august_qty AS august_qty_20,
  t0_.september_qty AS september_qty_21,
  t0_.october_qty AS october_qty_22,
  t0_.november_qty AS november_qty_23,
  t0_.december_qty AS december_qty_24,
  t0_.product_id AS product_id_25,
  t0_.budget_employee_id AS budget_employee_id_26
FROM
  til_budget_employee_product t0_
  LEFT JOIN til_product t1_ ON t0_.product_id = t1_.id
  LEFT JOIN til_budget_employee t2_ ON t0_.budget_employee_id = t2_.id
  LEFT JOIN til_employee t3_ ON t2_.employee_id = t3_.id
  LEFT JOIN til_budget_year t4_ ON t2_.budget_year_id = t4_.id
WHERE
  t4_.year = ?
  AND t3_.id IN (?, ?, ?, ?)

SELECT t0_.id AS id_0, t0_.january AS january_1, t0_.february AS february_2, t0_.march AS march_3, t0_.april AS april_4, t0_.may AS may_5, t0_.june AS june_6, t0_.july AS july_7, t0_.august AS august_8, t0_.september AS september_9, t0_.october AS october_10, t0_.november AS november_11, t0_.december AS december_12, t0_.january_qty AS january_qty_13, t0_.february_qty AS february_qty_14, t0_.march_qty AS march_qty_15, t0_.april_qty AS april_qty_16, t0_.may_qty AS may_qty_17, t0_.june_qty AS june_qty_18, t0_.july_qty AS july_qty_19, t0_.august_qty AS august_qty_20, t0_.september_qty AS september_qty_21, t0_.october_qty AS october_qty_22, t0_.november_qty AS november_qty_23, t0_.december_qty AS december_qty_24, t0_.product_id AS product_id_25, t0_.budget_employee_id AS budget_employee_id_26 FROM til_budget_employee_product t0_ LEFT JOIN til_product t1_ ON t0_.product_id = t1_.id LEFT JOIN til_budget_employee t2_ ON t0_.budget_employee_id = t2_.id LEFT JOIN til_employee t3_ ON t2_.employee_id = t3_.id LEFT JOIN til_budget_year t4_ ON t2_.budget_year_id = t4_.id WHERE t4_.year = '2025' AND t3_.id IN ('11', '26', '36', '25');

SELECT
  t0_.id AS id_0,
  t0_.residue_rol AS residue_rol_1,
  t0_.residue_holiday AS residue_holiday_2,
  t0_.datetime_start_work AS datetime_start_work_3,
  t0_.datetime_end_work AS datetime_end_work_4,
  t0_.show_in_list AS show_in_list_5,
  t0_.is_kam AS is_kam_6,
  t0_.is_show_in_export_presences AS is_show_in_export_presences_7,
  t0_.is_document_product_notify AS is_document_product_notify_8,
  t0_.user_id AS user_id_9,
  t0_.supervisor_id AS supervisor_id_10
FROM
  til_employee t0_
  LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id
WHERE
  t0_.is_kam = 1
ORDER BY
  t1_.surname ASC

SELECT t0_.id AS id_0, t0_.residue_rol AS residue_rol_1, t0_.residue_holiday AS residue_holiday_2, t0_.datetime_start_work AS datetime_start_work_3, t0_.datetime_end_work AS datetime_end_work_4, t0_.show_in_list AS show_in_list_5, t0_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC;

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.name AS name_2,
  t0_.dosage AS dosage_3,
  t0_.short_dosage AS short_dosage_4,
  t0_.dosage_int AS dosage_int_5,
  t0_.class AS class_6,
  t0_.aic_code AS aic_code_7,
  t0_.atc_code AS atc_code_8,
  t0_.unit_for_box AS unit_for_box_9,
  t0_.max_unit_price AS max_unit_price_10,
  t0_.image_path AS image_path_11,
  t0_.datetime_start AS datetime_start_12,
  t0_.datetime_budget_start AS datetime_budget_start_13,
  t0_.is_visible AS is_visible_14,
  t0_.is_archived AS is_archived_15,
  t0_.is_retail AS is_retail_16,
  t0_.product_category_id AS product_category_id_17,
  t0_.product_group_id AS product_group_id_18
FROM
  til_product t0_
ORDER BY
  t0_.name ASC,
  t0_.short_dosage ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ ORDER BY t0_.name ASC, t0_.short_dosage ASC;

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.name AS name_2,
  t0_.dosage AS dosage_3,
  t0_.short_dosage AS short_dosage_4,
  t0_.dosage_int AS dosage_int_5,
  t0_.class AS class_6,
  t0_.aic_code AS aic_code_7,
  t0_.atc_code AS atc_code_8,
  t0_.unit_for_box AS unit_for_box_9,
  t0_.max_unit_price AS max_unit_price_10,
  t0_.image_path AS image_path_11,
  t0_.datetime_start AS datetime_start_12,
  t0_.datetime_budget_start AS datetime_budget_start_13,
  t0_.is_visible AS is_visible_14,
  t0_.is_archived AS is_archived_15,
  t0_.is_retail AS is_retail_16,
  t0_.product_category_id AS product_category_id_17,
  t0_.product_group_id AS product_group_id_18
FROM
  til_product t0_
WHERE
  t0_.product_group_id IS NULL
  OR t0_.product_category_id IS NULL
  OR t0_.atc_code IS NULL
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ WHERE t0_.product_group_id IS NULL OR t0_.product_category_id IS NULL OR t0_.atc_code IS NULL ORDER BY t0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.year AS year_2
FROM
  til_budget_year t0
WHERE
  t0.year = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = '2025' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.user_id AS user_id_3,
  t0.permission_id AS permission_id_4
FROM
  til_join_table_user_permission t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM til_join_table_user_permission t0 WHERE t0.user_id = '39';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3
FROM
  til_product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM til_product_category t0 WHERE t0.id = '2';

SELECT
  t0.id AS id_1,
  t0.employee_id AS employee_id_2,
  t0.budget_year_id AS budget_year_id_3
FROM
  til_budget_employee t0
WHERE
  t0.budget_year_id = ?

SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = '2';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.level AS level_4
FROM
  til_user_account_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.level AS level_4 FROM til_user_account_type t0 WHERE t0.id = '3';

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.product_category_id AS product_category_id_3
FROM
  til_product_group t0_
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.product_category_id AS product_category_id_3 FROM til_product_group t0_ ORDER BY t0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.content AS content_3,
  t0.datetime AS datetime_4,
  t0.is_read AS is_read_5,
  t0.is_hidden AS is_hidden_6,
  t0.is_personal AS is_personal_7,
  t0.is_for_admin AS is_for_admin_8,
  t0.type_id AS type_id_9,
  t0.user_id AS user_id_10
FROM
  til_notification t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.level AS level_2, t0.content AS content_3, t0.datetime AS datetime_4, t0.is_read AS is_read_5, t0.is_hidden AS is_hidden_6, t0.is_personal AS is_personal_7, t0.is_for_admin AS is_for_admin_8, t0.type_id AS type_id_9, t0.user_id AS user_id_10 FROM til_notification t0 WHERE t0.user_id = '39';

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1
FROM
  til_region t0_
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1 FROM til_region t0_ ORDER BY t0_.name ASC;