Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.yellow_alarm AS yellow_alarm_1,
  t0_.red_alarm AS red_alarm_2,
  t0_.num_of_buy_dates AS num_of_buy_dates_3,
  t0_.avg_sell_cadence AS avg_sell_cadence_4,
  t0_.datetime_last_order AS datetime_last_order_5,
  t0_.notes AS notes_6,
  t0_.is_disabled AS is_disabled_7,
  t0_.facility_id AS facility_id_8,
  t0_.product_id AS product_id_9
FROM
  til_join_table_facility_product t0_
  LEFT JOIN til_hospital_facility t1_ ON t0_.facility_id = t1_.id
ORDER BY
  t1_.name ASC

SELECT t0_.id AS id_0, t0_.yellow_alarm AS yellow_alarm_1, t0_.red_alarm AS red_alarm_2, t0_.num_of_buy_dates AS num_of_buy_dates_3, t0_.avg_sell_cadence AS avg_sell_cadence_4, t0_.datetime_last_order AS datetime_last_order_5, t0_.notes AS notes_6, t0_.is_disabled AS is_disabled_7, t0_.facility_id AS facility_id_8, t0_.product_id AS product_id_9 FROM til_join_table_facility_product t0_ LEFT JOIN til_hospital_facility t1_ ON t0_.facility_id = t1_.id ORDER BY t1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.type AS type_3,
  t0.value AS value_4,
  t0.description AS description_5
FROM
  til_settings t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = 'sells_last_import_date' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.type AS type_3,
  t0.value AS value_4,
  t0.description AS description_5
FROM
  til_settings t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = 'sells_old_last_import_date' LIMIT 1;

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_.datetime_issue AS datetime_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
FROM
  til_sell t0_
WHERE
  t0_.datetime_import > ?
  AND t0_.datetime_import <= ?

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_.datetime_issue AS datetime_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 FROM til_sell t0_ WHERE t0_.datetime_import > '2023-02-28' AND t0_.datetime_import <= '2024-01-31';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.type AS type_3,
  t0.value AS value_4,
  t0.description AS description_5
FROM
  til_settings t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = 'sells_last_import_date' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.vat AS vat_2,
  t0_.address AS address_3,
  t0_.zip AS zip_4,
  t0_.lat AS lat_5,
  t0_.lng AS lng_6,
  t0_.email AS email_7,
  t0_.pec AS pec_8,
  t0_.sdi AS sdi_9,
  t0_.phone AS phone_10,
  t0_.fax AS fax_11,
  t0_.minister_code AS minister_code_12,
  t0_.is_head_group AS is_head_group_13,
  t0_.is_public AS is_public_14,
  t0_.city_id AS city_id_15,
  t0_.hospital_group_id AS hospital_group_id_16
FROM
  til_hospital t0_
WHERE
  t0_.is_public IS NULL

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.vat AS vat_2, t0_.address AS address_3, t0_.zip AS zip_4, t0_.lat AS lat_5, t0_.lng AS lng_6, t0_.email AS email_7, t0_.pec AS pec_8, t0_.sdi AS sdi_9, t0_.phone AS phone_10, t0_.fax AS fax_11, t0_.minister_code AS minister_code_12, t0_.is_head_group AS is_head_group_13, t0_.is_public AS is_public_14, t0_.city_id AS city_id_15, t0_.hospital_group_id AS hospital_group_id_16 FROM til_hospital t0_ WHERE t0_.is_public IS NULL;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.address AS address_2,
  t0_.zip AS zip_3,
  t0_.lat AS lat_4,
  t0_.lng AS lng_5,
  t0_.minister_code AS minister_code_6,
  t0_.is_public AS is_public_7,
  t0_.is_abbandoned_ignored AS is_abbandoned_ignored_8,
  t0_.city_id AS city_id_9,
  t0_.hospital_id AS hospital_id_10,
  t0_.employee_id AS employee_id_11
FROM
  til_hospital_facility t0_
WHERE
  t0_.hospital_id IS NULL
ORDER BY
  t0_.name ASC
LIMIT
  50

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.address AS address_2, t0_.zip AS zip_3, t0_.lat AS lat_4, t0_.lng AS lng_5, t0_.minister_code AS minister_code_6, t0_.is_public AS is_public_7, t0_.is_abbandoned_ignored AS is_abbandoned_ignored_8, t0_.city_id AS city_id_9, t0_.hospital_id AS hospital_id_10, t0_.employee_id AS employee_id_11 FROM til_hospital_facility t0_ WHERE t0_.hospital_id IS NULL ORDER BY t0_.name ASC LIMIT 50;

SELECT
  t0_.id AS id_0,
  t0_.motivation AS motivation_1,
  t0_.response AS response_2,
  t0_.status AS status_3,
  t0_.datetime AS datetime_4,
  t0_.is_notified AS is_notified_5,
  t0_.employee_id AS employee_id_6
FROM
  til_employee_holiday_request t0_
WHERE
  t0_.status = ?
ORDER BY
  t0_.datetime DESC

SELECT t0_.id AS id_0, t0_.motivation AS motivation_1, t0_.response AS response_2, t0_.status AS status_3, t0_.datetime AS datetime_4, t0_.is_notified AS is_notified_5, t0_.employee_id AS employee_id_6 FROM til_employee_holiday_request t0_ WHERE t0_.status = 'insert' ORDER BY t0_.datetime DESC;