Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.created_date AS created_date_3,
  t0.din AS din_4,
  t0.company_name AS company_name_5,
  t0.atc_number AS atc_number_6,
  t0.atc_description AS atc_description_7,
  t0.hc_updated_date AS hc_updated_date_8,
  t0.remaining_supply_date AS remaining_supply_date_9,
  t0.discontinuation_date AS discontinuation_date_10,
  t0.anticipated_discontinuation_date AS anticipated_discontinuation_date_11,
  t0.anticipated_start_date AS anticipated_start_date_12,
  t0.estimated_end_date AS estimated_end_date_13,
  t0.actual_start_date AS actual_start_date_14,
  t0.actual_end_date AS actual_end_date_15,
  t0.en_info_on_alternative AS en_info_on_alternative_16,
  t0.fr_info_on_alternative AS fr_info_on_alternative_17,
  t0.decision_reversal AS decision_reversal_18,
  t0.en_supply_disruption_mitigation AS en_supply_disruption_mitigation_19,
  t0.fr_supply_disruption_mitigation AS fr_supply_disruption_mitigation_20,
  t0.en_discontinuation_comments AS en_discontinuation_comments_21,
  t0.fr_discontinuation_comments AS fr_discontinuation_comments_22,
  t0.updated_date AS updated_date_23,
  t0.last_updated_operation AS last_updated_operation_24,
  t0.last_updated_ip AS last_updated_ip_25,
  t0.en_product_alternative AS en_product_alternative_26,
  t0.fr_product_alternative AS fr_product_alternative_27,
  t0.status AS status_28,
  t0.en_info_for_care_provider AS en_info_for_care_provider_29,
  t0.fr_info_for_care_provider AS fr_info_for_care_provider_30,
  t0.en_mitigation_efforts AS en_mitigation_efforts_31,
  t0.fr_mitigation_efforts AS fr_mitigation_efforts_32,
  t0.en_comments AS en_comments_33,
  t0.fr_comments AS fr_comments_34,
  t0.hc_en_product_alternative AS hc_en_product_alternative_35,
  t0.hc_fr_product_alternative AS hc_fr_product_alternative_36,
  t0.hc_en_shortage_info AS hc_en_shortage_info_37,
  t0.hc_fr_shortage_info AS hc_fr_shortage_info_38,
  t0.hc_en_mitigation_efforts AS hc_en_mitigation_efforts_39,
  t0.hc_fr_mitigation_efforts AS hc_fr_mitigation_efforts_40,
  t0.hc_en_comments AS hc_en_comments_41,
  t0.hc_fr_comments AS hc_fr_comments_42,
  t0.en_drug_brand_name AS en_drug_brand_name_43,
  t0.en_drug_proper_name AS en_drug_proper_name_44,
  t0.en_drug_common_name AS en_drug_common_name_45,
  t0.fr_drug_brand_name AS fr_drug_brand_name_46,
  t0.fr_drug_proper_name AS fr_drug_proper_name_47,
  t0.fr_drug_common_name AS fr_drug_common_name_48,
  t0.en_ingredients AS en_ingredients_49,
  t0.fr_ingredients AS fr_ingredients_50,
  t0.drug_strength AS drug_strength_51,
  t0.drug_dosage_form AS drug_dosage_form_52,
  t0.drug_dosage_form_fr AS drug_dosage_form_fr_53,
  t0.drug_route AS drug_route_54,
  t0.drug_route_fr AS drug_route_fr_55,
  t0.drug_package_quantity AS drug_package_quantity_56,
  t0.resolved AS resolved_57,
  t0.avoided AS avoided_58,
  t0.advance AS advance_59,
  t0.late_submission AS late_submission_60,
  t0.shortage_duplicated AS shortage_duplicated_61,
  t0.discontinuance_duplicated AS discontinuance_duplicated_62,
  t0.draft AS draft_63,
  t0.deleted_ip_address AS deleted_ip_address_64,
  t0.deleted_date AS deleted_date_65,
  t0.current_form_lang AS current_form_lang_66,
  t0.discontinuation_duplication AS discontinuation_duplication_67,
  t0.shortage_duplication AS shortage_duplication_68,
  t0.unknown_estimated_end_date AS unknown_estimated_end_date_69,
  t0.marker_a1 AS marker_a1_70,
  t0.marker_a2 AS marker_a2_71,
  t0.marker_a3 AS marker_a3_72,
  t0.marker_b1 AS marker_b1_73,
  t0.marker_b2 AS marker_b2_74,
  t0.marker_b3 AS marker_b3_75,
  t0.late_marker_disabled AS late_marker_disabled_76,
  t0.tier_3 AS tier_3_77,
  t0.drug_id AS drug_id_78,
  t0.type_id AS type_id_79,
  t0.discontinuance_reason_id AS discontinuance_reason_id_80,
  t0.shortage_reason_id AS shortage_reason_id_81,
  t0.parent_object_id AS parent_object_id_82,
  t0.last_updated_user_id AS last_updated_user_id_83,
  t0.deleted_by_user_id AS deleted_by_user_id_84
FROM
  reports t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.created_date AS created_date_3, t0.din AS din_4, t0.company_name AS company_name_5, t0.atc_number AS atc_number_6, t0.atc_description AS atc_description_7, t0.hc_updated_date AS hc_updated_date_8, t0.remaining_supply_date AS remaining_supply_date_9, t0.discontinuation_date AS discontinuation_date_10, t0.anticipated_discontinuation_date AS anticipated_discontinuation_date_11, t0.anticipated_start_date AS anticipated_start_date_12, t0.estimated_end_date AS estimated_end_date_13, t0.actual_start_date AS actual_start_date_14, t0.actual_end_date AS actual_end_date_15, t0.en_info_on_alternative AS en_info_on_alternative_16, t0.fr_info_on_alternative AS fr_info_on_alternative_17, t0.decision_reversal AS decision_reversal_18, t0.en_supply_disruption_mitigation AS en_supply_disruption_mitigation_19, t0.fr_supply_disruption_mitigation AS fr_supply_disruption_mitigation_20, t0.en_discontinuation_comments AS en_discontinuation_comments_21, t0.fr_discontinuation_comments AS fr_discontinuation_comments_22, t0.updated_date AS updated_date_23, t0.last_updated_operation AS last_updated_operation_24, t0.last_updated_ip AS last_updated_ip_25, t0.en_product_alternative AS en_product_alternative_26, t0.fr_product_alternative AS fr_product_alternative_27, t0.status AS status_28, t0.en_info_for_care_provider AS en_info_for_care_provider_29, t0.fr_info_for_care_provider AS fr_info_for_care_provider_30, t0.en_mitigation_efforts AS en_mitigation_efforts_31, t0.fr_mitigation_efforts AS fr_mitigation_efforts_32, t0.en_comments AS en_comments_33, t0.fr_comments AS fr_comments_34, t0.hc_en_product_alternative AS hc_en_product_alternative_35, t0.hc_fr_product_alternative AS hc_fr_product_alternative_36, t0.hc_en_shortage_info AS hc_en_shortage_info_37, t0.hc_fr_shortage_info AS hc_fr_shortage_info_38, t0.hc_en_mitigation_efforts AS hc_en_mitigation_efforts_39, t0.hc_fr_mitigation_efforts AS hc_fr_mitigation_efforts_40, t0.hc_en_comments AS hc_en_comments_41, t0.hc_fr_comments AS hc_fr_comments_42, t0.en_drug_brand_name AS en_drug_brand_name_43, t0.en_drug_proper_name AS en_drug_proper_name_44, t0.en_drug_common_name AS en_drug_common_name_45, t0.fr_drug_brand_name AS fr_drug_brand_name_46, t0.fr_drug_proper_name AS fr_drug_proper_name_47, t0.fr_drug_common_name AS fr_drug_common_name_48, t0.en_ingredients AS en_ingredients_49, t0.fr_ingredients AS fr_ingredients_50, t0.drug_strength AS drug_strength_51, t0.drug_dosage_form AS drug_dosage_form_52, t0.drug_dosage_form_fr AS drug_dosage_form_fr_53, t0.drug_route AS drug_route_54, t0.drug_route_fr AS drug_route_fr_55, t0.drug_package_quantity AS drug_package_quantity_56, t0.resolved AS resolved_57, t0.avoided AS avoided_58, t0.advance AS advance_59, t0.late_submission AS late_submission_60, t0.shortage_duplicated AS shortage_duplicated_61, t0.discontinuance_duplicated AS discontinuance_duplicated_62, t0.draft AS draft_63, t0.deleted_ip_address AS deleted_ip_address_64, t0.deleted_date AS deleted_date_65, t0.current_form_lang AS current_form_lang_66, t0.discontinuation_duplication AS discontinuation_duplication_67, t0.shortage_duplication AS shortage_duplication_68, t0.unknown_estimated_end_date AS unknown_estimated_end_date_69, t0.marker_a1 AS marker_a1_70, t0.marker_a2 AS marker_a2_71, t0.marker_a3 AS marker_a3_72, t0.marker_b1 AS marker_b1_73, t0.marker_b2 AS marker_b2_74, t0.marker_b3 AS marker_b3_75, t0.late_marker_disabled AS late_marker_disabled_76, t0.tier_3 AS tier_3_77, t0.drug_id AS drug_id_78, t0.type_id AS type_id_79, t0.discontinuance_reason_id AS discontinuance_reason_id_80, t0.shortage_reason_id AS shortage_reason_id_81, t0.parent_object_id AS parent_object_id_82, t0.last_updated_user_id AS last_updated_user_id_83, t0.deleted_by_user_id AS deleted_by_user_id_84 FROM reports t0 WHERE t0.id = '83435';

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.created_date AS created_date_3,
  t0.din AS din_4,
  t0.company_name AS company_name_5,
  t0.atc_number AS atc_number_6,
  t0.atc_description AS atc_description_7,
  t0.hc_updated_date AS hc_updated_date_8,
  t0.remaining_supply_date AS remaining_supply_date_9,
  t0.discontinuation_date AS discontinuation_date_10,
  t0.anticipated_discontinuation_date AS anticipated_discontinuation_date_11,
  t0.anticipated_start_date AS anticipated_start_date_12,
  t0.estimated_end_date AS estimated_end_date_13,
  t0.actual_start_date AS actual_start_date_14,
  t0.actual_end_date AS actual_end_date_15,
  t0.en_info_on_alternative AS en_info_on_alternative_16,
  t0.fr_info_on_alternative AS fr_info_on_alternative_17,
  t0.decision_reversal AS decision_reversal_18,
  t0.en_supply_disruption_mitigation AS en_supply_disruption_mitigation_19,
  t0.fr_supply_disruption_mitigation AS fr_supply_disruption_mitigation_20,
  t0.en_discontinuation_comments AS en_discontinuation_comments_21,
  t0.fr_discontinuation_comments AS fr_discontinuation_comments_22,
  t0.updated_date AS updated_date_23,
  t0.last_updated_operation AS last_updated_operation_24,
  t0.last_updated_ip AS last_updated_ip_25,
  t0.en_product_alternative AS en_product_alternative_26,
  t0.fr_product_alternative AS fr_product_alternative_27,
  t0.status AS status_28,
  t0.en_info_for_care_provider AS en_info_for_care_provider_29,
  t0.fr_info_for_care_provider AS fr_info_for_care_provider_30,
  t0.en_mitigation_efforts AS en_mitigation_efforts_31,
  t0.fr_mitigation_efforts AS fr_mitigation_efforts_32,
  t0.en_comments AS en_comments_33,
  t0.fr_comments AS fr_comments_34,
  t0.hc_en_product_alternative AS hc_en_product_alternative_35,
  t0.hc_fr_product_alternative AS hc_fr_product_alternative_36,
  t0.hc_en_shortage_info AS hc_en_shortage_info_37,
  t0.hc_fr_shortage_info AS hc_fr_shortage_info_38,
  t0.hc_en_mitigation_efforts AS hc_en_mitigation_efforts_39,
  t0.hc_fr_mitigation_efforts AS hc_fr_mitigation_efforts_40,
  t0.hc_en_comments AS hc_en_comments_41,
  t0.hc_fr_comments AS hc_fr_comments_42,
  t0.en_drug_brand_name AS en_drug_brand_name_43,
  t0.en_drug_proper_name AS en_drug_proper_name_44,
  t0.en_drug_common_name AS en_drug_common_name_45,
  t0.fr_drug_brand_name AS fr_drug_brand_name_46,
  t0.fr_drug_proper_name AS fr_drug_proper_name_47,
  t0.fr_drug_common_name AS fr_drug_common_name_48,
  t0.en_ingredients AS en_ingredients_49,
  t0.fr_ingredients AS fr_ingredients_50,
  t0.drug_strength AS drug_strength_51,
  t0.drug_dosage_form AS drug_dosage_form_52,
  t0.drug_dosage_form_fr AS drug_dosage_form_fr_53,
  t0.drug_route AS drug_route_54,
  t0.drug_route_fr AS drug_route_fr_55,
  t0.drug_package_quantity AS drug_package_quantity_56,
  t0.resolved AS resolved_57,
  t0.avoided AS avoided_58,
  t0.advance AS advance_59,
  t0.late_submission AS late_submission_60,
  t0.shortage_duplicated AS shortage_duplicated_61,
  t0.discontinuance_duplicated AS discontinuance_duplicated_62,
  t0.draft AS draft_63,
  t0.deleted_ip_address AS deleted_ip_address_64,
  t0.deleted_date AS deleted_date_65,
  t0.current_form_lang AS current_form_lang_66,
  t0.discontinuation_duplication AS discontinuation_duplication_67,
  t0.shortage_duplication AS shortage_duplication_68,
  t0.unknown_estimated_end_date AS unknown_estimated_end_date_69,
  t0.marker_a1 AS marker_a1_70,
  t0.marker_a2 AS marker_a2_71,
  t0.marker_a3 AS marker_a3_72,
  t0.marker_b1 AS marker_b1_73,
  t0.marker_b2 AS marker_b2_74,
  t0.marker_b3 AS marker_b3_75,
  t0.late_marker_disabled AS late_marker_disabled_76,
  t0.tier_3 AS tier_3_77,
  t0.drug_id AS drug_id_78,
  t0.type_id AS type_id_79,
  t0.discontinuance_reason_id AS discontinuance_reason_id_80,
  t0.shortage_reason_id AS shortage_reason_id_81,
  t0.parent_object_id AS parent_object_id_82,
  t0.last_updated_user_id AS last_updated_user_id_83,
  t0.deleted_by_user_id AS deleted_by_user_id_84
FROM
  reports t0
WHERE
  t0.parent_object_id = ?
ORDER BY
  t0.updated_date DESC,
  t0.id DESC

SELECT t0.id AS id_1, t0.number AS number_2, t0.created_date AS created_date_3, t0.din AS din_4, t0.company_name AS company_name_5, t0.atc_number AS atc_number_6, t0.atc_description AS atc_description_7, t0.hc_updated_date AS hc_updated_date_8, t0.remaining_supply_date AS remaining_supply_date_9, t0.discontinuation_date AS discontinuation_date_10, t0.anticipated_discontinuation_date AS anticipated_discontinuation_date_11, t0.anticipated_start_date AS anticipated_start_date_12, t0.estimated_end_date AS estimated_end_date_13, t0.actual_start_date AS actual_start_date_14, t0.actual_end_date AS actual_end_date_15, t0.en_info_on_alternative AS en_info_on_alternative_16, t0.fr_info_on_alternative AS fr_info_on_alternative_17, t0.decision_reversal AS decision_reversal_18, t0.en_supply_disruption_mitigation AS en_supply_disruption_mitigation_19, t0.fr_supply_disruption_mitigation AS fr_supply_disruption_mitigation_20, t0.en_discontinuation_comments AS en_discontinuation_comments_21, t0.fr_discontinuation_comments AS fr_discontinuation_comments_22, t0.updated_date AS updated_date_23, t0.last_updated_operation AS last_updated_operation_24, t0.last_updated_ip AS last_updated_ip_25, t0.en_product_alternative AS en_product_alternative_26, t0.fr_product_alternative AS fr_product_alternative_27, t0.status AS status_28, t0.en_info_for_care_provider AS en_info_for_care_provider_29, t0.fr_info_for_care_provider AS fr_info_for_care_provider_30, t0.en_mitigation_efforts AS en_mitigation_efforts_31, t0.fr_mitigation_efforts AS fr_mitigation_efforts_32, t0.en_comments AS en_comments_33, t0.fr_comments AS fr_comments_34, t0.hc_en_product_alternative AS hc_en_product_alternative_35, t0.hc_fr_product_alternative AS hc_fr_product_alternative_36, t0.hc_en_shortage_info AS hc_en_shortage_info_37, t0.hc_fr_shortage_info AS hc_fr_shortage_info_38, t0.hc_en_mitigation_efforts AS hc_en_mitigation_efforts_39, t0.hc_fr_mitigation_efforts AS hc_fr_mitigation_efforts_40, t0.hc_en_comments AS hc_en_comments_41, t0.hc_fr_comments AS hc_fr_comments_42, t0.en_drug_brand_name AS en_drug_brand_name_43, t0.en_drug_proper_name AS en_drug_proper_name_44, t0.en_drug_common_name AS en_drug_common_name_45, t0.fr_drug_brand_name AS fr_drug_brand_name_46, t0.fr_drug_proper_name AS fr_drug_proper_name_47, t0.fr_drug_common_name AS fr_drug_common_name_48, t0.en_ingredients AS en_ingredients_49, t0.fr_ingredients AS fr_ingredients_50, t0.drug_strength AS drug_strength_51, t0.drug_dosage_form AS drug_dosage_form_52, t0.drug_dosage_form_fr AS drug_dosage_form_fr_53, t0.drug_route AS drug_route_54, t0.drug_route_fr AS drug_route_fr_55, t0.drug_package_quantity AS drug_package_quantity_56, t0.resolved AS resolved_57, t0.avoided AS avoided_58, t0.advance AS advance_59, t0.late_submission AS late_submission_60, t0.shortage_duplicated AS shortage_duplicated_61, t0.discontinuance_duplicated AS discontinuance_duplicated_62, t0.draft AS draft_63, t0.deleted_ip_address AS deleted_ip_address_64, t0.deleted_date AS deleted_date_65, t0.current_form_lang AS current_form_lang_66, t0.discontinuation_duplication AS discontinuation_duplication_67, t0.shortage_duplication AS shortage_duplication_68, t0.unknown_estimated_end_date AS unknown_estimated_end_date_69, t0.marker_a1 AS marker_a1_70, t0.marker_a2 AS marker_a2_71, t0.marker_a3 AS marker_a3_72, t0.marker_b1 AS marker_b1_73, t0.marker_b2 AS marker_b2_74, t0.marker_b3 AS marker_b3_75, t0.late_marker_disabled AS late_marker_disabled_76, t0.tier_3 AS tier_3_77, t0.drug_id AS drug_id_78, t0.type_id AS type_id_79, t0.discontinuance_reason_id AS discontinuance_reason_id_80, t0.shortage_reason_id AS shortage_reason_id_81, t0.parent_object_id AS parent_object_id_82, t0.last_updated_user_id AS last_updated_user_id_83, t0.deleted_by_user_id AS deleted_by_user_id_84 FROM reports t0 WHERE t0.parent_object_id = 83435 ORDER BY t0.updated_date DESC, t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.drug_code AS drug_code_2,
  t0.updated_date AS updated_date_3,
  t0.content_update_date AS content_update_date_4,
  t0.last_updated_operation AS last_updated_operation_5,
  t0.last_updated_ip AS last_updated_ip_6,
  t0.product_categorization AS product_categorization_7,
  t0.din AS din_8,
  t0.brand_name AS brand_name_9,
  t0.brand_name_fr AS brand_name_fr_10,
  t0.descriptor AS descriptor_11,
  t0.pediatric_flag AS pediatric_flag_12,
  t0.accession_number AS accession_number_13,
  t0.number_of_ais AS number_of_ais_14,
  t0.ai_group_no AS ai_group_no_15,
  t0.en_proper_name AS en_proper_name_16,
  t0.fr_proper_name AS fr_proper_name_17,
  t0.en_common_name AS en_common_name_18,
  t0.fr_common_name AS fr_common_name_19,
  t0.parent_object_id AS parent_object_id_20,
  t0.last_updated_user_id AS last_updated_user_id_21,
  t0.company_id AS company_id_22,
  t0.class_id AS class_id_23
FROM
  drugs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.drug_code AS drug_code_2, t0.updated_date AS updated_date_3, t0.content_update_date AS content_update_date_4, t0.last_updated_operation AS last_updated_operation_5, t0.last_updated_ip AS last_updated_ip_6, t0.product_categorization AS product_categorization_7, t0.din AS din_8, t0.brand_name AS brand_name_9, t0.brand_name_fr AS brand_name_fr_10, t0.descriptor AS descriptor_11, t0.pediatric_flag AS pediatric_flag_12, t0.accession_number AS accession_number_13, t0.number_of_ais AS number_of_ais_14, t0.ai_group_no AS ai_group_no_15, t0.en_proper_name AS en_proper_name_16, t0.fr_proper_name AS fr_proper_name_17, t0.en_common_name AS en_common_name_18, t0.fr_common_name AS fr_common_name_19, t0.parent_object_id AS parent_object_id_20, t0.last_updated_user_id AS last_updated_user_id_21, t0.company_id AS company_id_22, t0.class_id AS class_id_23 FROM drugs t0 WHERE t0.id = 21970;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.updated_date AS updated_date_3,
  t0.last_updated_operation AS last_updated_operation_4,
  t0.last_updated_ip AS last_updated_ip_5,
  t0.company_code AS company_code_6,
  t0.mfr_code AS mfr_code_7,
  t0.name AS name_8,
  t0.company_type AS company_type_9,
  t0.address_mailing_flag AS address_mailing_flag_10,
  t0.address_billing_flag AS address_billing_flag_11,
  t0.address_notification_flag AS address_notification_flag_12,
  t0.address_other AS address_other_13,
  t0.address_report_display AS address_report_display_14,
  t0.suite_number AS suite_number_15,
  t0.street_name AS street_name_16,
  t0.province AS province_17,
  t0.country AS country_18,
  t0.city AS city_19,
  t0.postal_code AS postal_code_20,
  t0.post_office_box AS post_office_box_21,
  t0.contact_information AS contact_information_22,
  t0.senior_official_user_id AS senior_official_user_id_23,
  t0.parent_object_id AS parent_object_id_24,
  t0.last_updated_user_id AS last_updated_user_id_25
FROM
  companies t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.last_updated_operation AS last_updated_operation_4, t0.last_updated_ip AS last_updated_ip_5, t0.company_code AS company_code_6, t0.mfr_code AS mfr_code_7, t0.name AS name_8, t0.company_type AS company_type_9, t0.address_mailing_flag AS address_mailing_flag_10, t0.address_billing_flag AS address_billing_flag_11, t0.address_notification_flag AS address_notification_flag_12, t0.address_other AS address_other_13, t0.address_report_display AS address_report_display_14, t0.suite_number AS suite_number_15, t0.street_name AS street_name_16, t0.province AS province_17, t0.country AS country_18, t0.city AS city_19, t0.postal_code AS postal_code_20, t0.post_office_box AS post_office_box_21, t0.contact_information AS contact_information_22, t0.senior_official_user_id AS senior_official_user_id_23, t0.parent_object_id AS parent_object_id_24, t0.last_updated_user_id AS last_updated_user_id_25 FROM companies t0 WHERE t0.id = 80;

SELECT
  t0.id AS id_1,
  t0.current_status_flag AS current_status_flag_2,
  t0.status AS status_3,
  t0.history_date AS history_date_4,
  t0.created_date AS created_date_5,
  t0.deleted_date AS deleted_date_6,
  t0.drug_id AS drug_id_7
FROM
  statuses t0
WHERE
  (
    t0.current_status_flag = ?
    AND t0.drug_id = ?
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.current_status_flag AS current_status_flag_2, t0.status AS status_3, t0.history_date AS history_date_4, t0.created_date AS created_date_5, t0.deleted_date AS deleted_date_6, t0.drug_id AS drug_id_7 FROM statuses t0 WHERE (t0.current_status_flag = 1 AND t0.drug_id = 21970) ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.gtin AS gtin_2,
  t0.package_info AS package_info_3,
  t0.created_date AS created_date_4,
  t0.updated_date AS updated_date_5,
  t0.drug_id AS drug_id_6
FROM
  drug_gtins t0
  INNER JOIN drug_report_drug_gtin ON t0.id = drug_report_drug_gtin.drug_gtin_id
WHERE
  drug_report_drug_gtin.drug_report_id = ?

SELECT t0.id AS id_1, t0.gtin AS gtin_2, t0.package_info AS package_info_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.drug_id AS drug_id_6 FROM drug_gtins t0 INNER JOIN drug_report_drug_gtin ON t0.id = drug_report_drug_gtin.drug_gtin_id WHERE drug_report_drug_gtin.drug_report_id = 108306;

SELECT
  t0.id AS id_1,
  t0.en_reason AS en_reason_2,
  t0.fr_reason AS fr_reason_3,
  t0.active AS active_4,
  t0.updated_date AS updated_date_5
FROM
  shortagereasons t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.en_reason AS en_reason_2, t0.fr_reason AS fr_reason_3, t0.active AS active_4, t0.updated_date AS updated_date_5 FROM shortagereasons t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.current_status_flag AS current_status_flag_2,
  t0.status AS status_3,
  t0.history_date AS history_date_4,
  t0.created_date AS created_date_5,
  t0.deleted_date AS deleted_date_6,
  t0.drug_id AS drug_id_7
FROM
  statuses t0
WHERE
  (
    t0.current_status_flag = ?
    AND t0.drug_id = ?
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.current_status_flag AS current_status_flag_2, t0.status AS status_3, t0.history_date AS history_date_4, t0.created_date AS created_date_5, t0.deleted_date AS deleted_date_6, t0.drug_id AS drug_id_7 FROM statuses t0 WHERE (t0.current_status_flag = 1 AND t0.drug_id = 21970) ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.gtin AS gtin_2,
  t0.package_info AS package_info_3,
  t0.created_date AS created_date_4,
  t0.updated_date AS updated_date_5,
  t0.drug_id AS drug_id_6
FROM
  drug_gtins t0
  INNER JOIN drug_report_drug_gtin ON t0.id = drug_report_drug_gtin.drug_gtin_id
WHERE
  drug_report_drug_gtin.drug_report_id = ?

SELECT t0.id AS id_1, t0.gtin AS gtin_2, t0.package_info AS package_info_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.drug_id AS drug_id_6 FROM drug_gtins t0 INNER JOIN drug_report_drug_gtin ON t0.id = drug_report_drug_gtin.drug_gtin_id WHERE drug_report_drug_gtin.drug_report_id = 108239;