Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.import_from AS import_from_1,
  t0_.import_date AS import_date_2,
  t0_.document_type AS document_type_3,
  t0_.issue_date AS issue_date_4,
  t0_.week_number AS week_number_5,
  t0_.month_number AS month_number_6,
  t0_.document_number AS document_number_7,
  t0_.product_code AS product_code_8,
  t0_.atc_code AS atc_code_9,
  t0_.aic_code AS aic_code_10,
  t0_.product_description AS product_description_11,
  t0_.lot_number AS lot_number_12,
  t0_.quantity AS quantity_13,
  t0_.net_unit_price AS net_unit_price_14,
  t0_.box_quantity AS box_quantity_15,
  t0_.net_box_price AS net_box_price_16,
  t0_.net_price AS net_price_17,
  t0_.charged_price AS charged_price_18,
  t0_.client_category AS client_category_19,
  t0_.client_code AS client_code_20,
  t0_.client_ministerial_code AS client_ministerial_code_21,
  t0_.client_business_name AS client_business_name_22,
  t0_.client_address AS client_address_23,
  t0_.client_province AS client_province_24,
  t0_.client_city AS client_city_25,
  t0_.client_zip AS client_zip_26,
  t0_.client_region AS client_region_27,
  t0_.vat AS vat_28,
  t0_.order_number AS order_number_29,
  t0_.order_date AS order_date_30,
  t0_.ref_date AS ref_date_31,
  t0_.receiver_client_code AS receiver_client_code_32,
  t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_33,
  t0_.receiver_client_business_name AS receiver_client_business_name_34,
  t0_.receiver_client_address AS receiver_client_address_35,
  t0_.receiver_client_province AS receiver_client_province_36,
  t0_.receiver_client_city AS receiver_client_city_37,
  t0_.receiver_client_zip AS receiver_client_zip_38,
  t0_.receiver_client_region AS receiver_client_region_39,
  t0_.kam AS kam_40,
  t0_.extra AS extra_41,
  t0_.notes AS notes_42,
  t0_.email AS email_43,
  t0_.lot_expiration_date AS lot_expiration_date_44,
  t0_.vs_vi AS vs_vi_45,
  t0_.invoice_num AS invoice_num_46,
  t0_.division AS division_47,
  t0_.organization AS organization_48,
  t0_.material AS material_49,
  t0_.selling_unit AS selling_unit_50,
  t0_.tax AS tax_51,
  t0_.backup_quantity AS backup_quantity_52,
  t0_.backup_net_unit_price AS backup_net_unit_price_53,
  t0_.num_of_docs_control AS num_of_docs_control_54,
  t0_.control_docs_date AS control_docs_date_55,
  t0_.delivery_num AS delivery_num_56,
  t0_.delivery_date AS delivery_date_57,
  t0_.cost AS cost_58,
  t0_.cold AS cold_59,
  t0_.cig_number AS cig_number_60,
  t0_.invoice_voice AS invoice_voice_61,
  t0_.product_id AS product_id_62,
  t0_.hospital_id AS hospital_id_63,
  t0_.facility_id AS facility_id_64,
  t0_.user_id AS user_id_65
FROM
  til_sell t0_
WHERE
  t0_.import_date > ?
  AND t0_.import_date <= ?

SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.import_date AS import_date_2, t0_.document_type AS document_type_3, t0_.issue_date AS issue_date_4, t0_.week_number AS week_number_5, t0_.month_number AS month_number_6, t0_.document_number AS document_number_7, t0_.product_code AS product_code_8, t0_.atc_code AS atc_code_9, t0_.aic_code AS aic_code_10, t0_.product_description AS product_description_11, t0_.lot_number AS lot_number_12, t0_.quantity AS quantity_13, t0_.net_unit_price AS net_unit_price_14, t0_.box_quantity AS box_quantity_15, t0_.net_box_price AS net_box_price_16, t0_.net_price AS net_price_17, t0_.charged_price AS charged_price_18, t0_.client_category AS client_category_19, t0_.client_code AS client_code_20, t0_.client_ministerial_code AS client_ministerial_code_21, t0_.client_business_name AS client_business_name_22, t0_.client_address AS client_address_23, t0_.client_province AS client_province_24, t0_.client_city AS client_city_25, t0_.client_zip AS client_zip_26, t0_.client_region AS client_region_27, t0_.vat AS vat_28, t0_.order_number AS order_number_29, t0_.order_date AS order_date_30, t0_.ref_date AS ref_date_31, t0_.receiver_client_code AS receiver_client_code_32, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_33, t0_.receiver_client_business_name AS receiver_client_business_name_34, t0_.receiver_client_address AS receiver_client_address_35, t0_.receiver_client_province AS receiver_client_province_36, t0_.receiver_client_city AS receiver_client_city_37, t0_.receiver_client_zip AS receiver_client_zip_38, t0_.receiver_client_region AS receiver_client_region_39, t0_.kam AS kam_40, t0_.extra AS extra_41, t0_.notes AS notes_42, t0_.email AS email_43, t0_.lot_expiration_date AS lot_expiration_date_44, t0_.vs_vi AS vs_vi_45, t0_.invoice_num AS invoice_num_46, t0_.division AS division_47, t0_.organization AS organization_48, t0_.material AS material_49, t0_.selling_unit AS selling_unit_50, t0_.tax AS tax_51, t0_.backup_quantity AS backup_quantity_52, t0_.backup_net_unit_price AS backup_net_unit_price_53, t0_.num_of_docs_control AS num_of_docs_control_54, t0_.control_docs_date AS control_docs_date_55, t0_.delivery_num AS delivery_num_56, t0_.delivery_date AS delivery_date_57, t0_.cost AS cost_58, t0_.cold AS cold_59, t0_.cig_number AS cig_number_60, t0_.invoice_voice AS invoice_voice_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.user_id AS user_id_65 FROM til_sell t0_ WHERE t0_.import_date > '2023-04-28' AND t0_.import_date <= '2023-04-30';

SELECT
  t0_.id AS id_0,
  t0_.yellow_alarm AS yellow_alarm_1,
  t0_.red_alarm AS red_alarm_2,
  t0_.avg_sell_cadence AS avg_sell_cadence_3,
  t0_.num_of_buy_dates AS num_of_buy_dates_4,
  t0_.last_order_date AS last_order_date_5,
  t0_.notes AS notes_6,
  t0_.disabled AS 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_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_.avg_sell_cadence AS avg_sell_cadence_3, t0_.num_of_buy_dates AS num_of_buy_dates_4, t0_.last_order_date AS last_order_date_5, t0_.notes AS notes_6, t0_.disabled AS 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_facility t1_ ON t0_.facility_id = t1_.id ORDER BY t1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.value AS value_3,
  t0.notes AS notes_4,
  t0.file_path_kam AS file_path_kam_5,
  t0.file_path_supervisor AS file_path_supervisor_6,
  t0.file_path_boss AS file_path_boss_7,
  t0.is_holiday_counter_active AS is_holiday_counter_active_8,
  t0.is_rol_counter_active AS is_rol_counter_active_9,
  t0.presence_year_id AS presence_year_id_10
FROM
  til_presence_month t0
WHERE
  t0.presence_year_id = ?
ORDER BY
  t0.value ASC

SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = '52' ORDER BY t0.value ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.user_id AS user_id_3
FROM
  til_presence_year t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = '1746';

SELECT
  t0.id AS id_1,
  t0.country_code AS country_code_2,
  t0.phone AS phone_3,
  t0.fax AS fax_4,
  t0.mobile AS mobile_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.other_city AS other_city_8,
  t0.other_province AS other_province_9,
  t0.user_id AS user_id_10,
  t0.city_id AS city_id_11,
  t0.profession_id AS profession_id_12,
  t0.department_id AS department_id_13
FROM
  til_profile t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = '1746';

SELECT
  t0.id AS id_1,
  t0.residue_rol AS residue_rol_2,
  t0.residue_holiday AS residue_holiday_3,
  t0.start_work_date AS start_work_date_4,
  t0.end_work_date AS end_work_date_5,
  t0.show_in_list AS show_in_list_6,
  t0.user_id AS user_id_7
FROM
  til_employee_data t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = '1746';

SELECT
  t0.id AS id_1,
  t0.last_update_date_time AS last_update_date_time_2,
  t0.is_terms_accepted AS is_terms_accepted_3,
  t0.is_news_accepted AS is_news_accepted_4,
  t0.user_id AS user_id_5
FROM
  til_privacy t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = '1746';

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_.is_public AS is_public_6,
  t0_.is_abbandoned_ignored AS is_abbandoned_ignored_7,
  t0_.minister_code AS minister_code_8,
  t0_.city_id AS city_id_9,
  t0_.assigned_kam_id AS assigned_kam_id_10,
  t0_.hospital_id AS hospital_id_11
FROM
  til_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_.is_public AS is_public_6, t0_.is_abbandoned_ignored AS is_abbandoned_ignored_7, t0_.minister_code AS minister_code_8, t0_.city_id AS city_id_9, t0_.assigned_kam_id AS assigned_kam_id_10, t0_.hospital_id AS hospital_id_11 FROM til_facility t0_ WHERE t0_.hospital_id IS NULL ORDER BY t0_.name ASC LIMIT 50;

SELECT
  t0_.id AS id_0,
  t0_.email AS email_1,
  t0_.name AS name_2,
  t0_.surname AS surname_3,
  t0_.password AS password_4,
  t0_.is_active AS is_active_5,
  t0_.is_admin_active AS is_admin_active_6,
  t0_.directory_path AS directory_path_7,
  t0_.one_time_code AS one_time_code_8,
  t0_.expiration_one_time_code AS expiration_one_time_code_9,
  t0_.is_email_notification_active AS is_email_notification_active_10,
  t0_.office_hours AS office_hours_11,
  t0_.is_alert_read AS is_alert_read_12,
  t0_.is_gdpr_sent AS is_gdpr_sent_13,
  t0_.role AS role_14,
  t0_.account_type_id AS account_type_id_15,
  t0_.supervisor_id AS supervisor_id_16
FROM
  til_user t0_
  LEFT JOIN til_account_type t1_ ON t0_.account_type_id = t1_.id
WHERE
  (t1_.level < 4)
  AND t0_.is_admin_active = 1
  AND t1_.slug <> ?
  AND t0_.email <> ?
ORDER BY
  t0_.surname ASC,
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.name AS name_2, t0_.surname AS surname_3, t0_.password AS password_4, t0_.is_active AS is_active_5, t0_.is_admin_active AS is_admin_active_6, t0_.directory_path AS directory_path_7, t0_.one_time_code AS one_time_code_8, t0_.expiration_one_time_code AS expiration_one_time_code_9, t0_.is_email_notification_active AS is_email_notification_active_10, t0_.office_hours AS office_hours_11, t0_.is_alert_read AS is_alert_read_12, t0_.is_gdpr_sent AS is_gdpr_sent_13, t0_.role AS role_14, t0_.account_type_id AS account_type_id_15, t0_.supervisor_id AS supervisor_id_16 FROM til_user t0_ LEFT JOIN til_account_type t1_ ON t0_.account_type_id = t1_.id WHERE (t1_.level < 4) AND t0_.is_admin_active = 1 AND t1_.slug <> 'supervisor_mario' AND t0_.email <> 'rporrati@rpgmultimedia.it' ORDER BY t0_.surname ASC, t0_.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_0,
  t0_.name AS name_1,
  t0_.vat AS vat_2,
  t0_.address AS address_3,
  t0_.zip AS zip_4,
  t0_.email AS email_5,
  t0_.pec AS pec_6,
  t0_.sdi AS sdi_7,
  t0_.phone AS phone_8,
  t0_.fax AS fax_9,
  t0_.minister_code AS minister_code_10,
  t0_.head_group AS head_group_11,
  t0_.is_public AS is_public_12,
  t0_.lat AS lat_13,
  t0_.lng AS lng_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_.email AS email_5, t0_.pec AS pec_6, t0_.sdi AS sdi_7, t0_.phone AS phone_8, t0_.fax AS fax_9, t0_.minister_code AS minister_code_10, t0_.head_group AS head_group_11, t0_.is_public AS is_public_12, t0_.lat AS lat_13, t0_.lng AS lng_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_.motivation AS motivation_1,
  t0_.date AS date_2,
  t0_.response AS response_3,
  t0_.status AS status_4,
  t0_.is_notified AS is_notified_5,
  t0_.user_id AS user_id_6
FROM
  til_request_holiday t0_
WHERE
  t0_.status = ?
ORDER BY
  t0_.date DESC

SELECT t0_.id AS id_0, t0_.motivation AS motivation_1, t0_.date AS date_2, t0_.response AS response_3, t0_.status AS status_4, t0_.is_notified AS is_notified_5, t0_.user_id AS user_id_6 FROM til_request_holiday t0_ WHERE t0_.status = 'insert' ORDER BY t0_.date DESC;

SELECT
  t0.id AS id_1,
  t0.object_id AS object_id_2,
  t0.datetime AS datetime_3,
  t0.type AS type_4,
  t0.old_value AS old_value_5,
  t0.new_value AS new_value_6,
  t0.old_notes AS old_notes_7,
  t0.new_notes AS new_notes_8,
  t0.sender_id AS sender_id_9
FROM
  til_edit_request t0

SELECT t0.id AS id_1, t0.object_id AS object_id_2, t0.datetime AS datetime_3, t0.type AS type_4, t0.old_value AS old_value_5, t0.new_value AS new_value_6, t0.old_notes AS old_notes_7, t0.new_notes AS new_notes_8, t0.sender_id AS sender_id_9 FROM til_edit_request t0;