| 1 |
0.61 ms |
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.type AS type_6, t0.company_id AS company_id_7, t0.pg_id AS pg_id_8, t0.group_code AS group_code_9, t0.hs_code AS hs_code_10, t0.start_hs_code AS start_hs_code_11, t0.end_hs_code AS end_hs_code_12, t0.dr_accounts_head_id AS dr_accounts_head_id_13, t0.cr_accounts_head_id AS cr_accounts_head_id_14, t0.ledger_hit_as AS ledger_hit_as_15, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_16, t0.default_expense_id AS default_expense_id_17, t0.vat_as_expense_flag AS vat_as_expense_flag_18, t0.sellable AS sellable_19, t0.abstract AS abstract_20, t0.icon_path AS icon_path_21, t0.banner_image AS banner_image_22, t0.default_image AS default_image_23, t0.data_sheets AS data_sheets_24, t0.tax_config_ids AS tax_config_ids_25, t0.default_tax_config_id AS default_tax_config_id_26, t0.purchase_tax_config_ids AS purchase_tax_config_ids_27, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_28, t0.images AS images_29, t0.expiry_days AS expiry_days_30, t0.description AS description_31, t0.categorization_data AS categorization_data_32, t0.specification_types AS specification_types_33, t0.allowed_unit_types AS allowed_unit_types_34, t0.include_in_product_name AS include_in_product_name_35, t0.status AS status_36, t0.unit_type_id AS unit_type_id_37, t0.created_login_id AS created_login_id_38, t0.edited_login_id AS edited_login_id_39, t0.created_user_id AS created_user_id_40, t0.edited_user_id AS edited_user_id_41, t0.created_sig_id AS created_sig_id_42, t0.edited_sig_id AS edited_sig_id_43, t0.doc_booked_flag AS doc_booked_flag_44, t0.time_stamp_of_form AS time_stamp_of_form_45 FROM inv_item_group t0 WHERE t0.name = ? AND t0.type = ? LIMIT 1
Parameters: [
"Mounting Accessories"
1
]
SELECT
t0.id AS id_1,
t0.global_id AS global_id_2,
t0.sync_flag AS sync_flag_3,
t0.class_suffix AS class_suffix_4,
t0.name AS name_5,
t0.type AS type_6,
t0.company_id AS company_id_7,
t0.pg_id AS pg_id_8,
t0.group_code AS group_code_9,
t0.hs_code AS hs_code_10,
t0.start_hs_code AS start_hs_code_11,
t0.end_hs_code AS end_hs_code_12,
t0.dr_accounts_head_id AS dr_accounts_head_id_13,
t0.cr_accounts_head_id AS cr_accounts_head_id_14,
t0.ledger_hit_as AS ledger_hit_as_15,
t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_16,
t0.default_expense_id AS default_expense_id_17,
t0.vat_as_expense_flag AS vat_as_expense_flag_18,
t0.sellable AS sellable_19,
t0.abstract AS abstract_20,
t0.icon_path AS icon_path_21,
t0.banner_image AS banner_image_22,
t0.default_image AS default_image_23,
t0.data_sheets AS data_sheets_24,
t0.tax_config_ids AS tax_config_ids_25,
t0.default_tax_config_id AS default_tax_config_id_26,
t0.purchase_tax_config_ids AS purchase_tax_config_ids_27,
t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_28,
t0.images AS images_29,
t0.expiry_days AS expiry_days_30,
t0.description AS description_31,
t0.categorization_data AS categorization_data_32,
t0.specification_types AS specification_types_33,
t0.allowed_unit_types AS allowed_unit_types_34,
t0.include_in_product_name AS include_in_product_name_35,
t0.status AS status_36,
t0.unit_type_id AS unit_type_id_37,
t0.created_login_id AS created_login_id_38,
t0.edited_login_id AS edited_login_id_39,
t0.created_user_id AS created_user_id_40,
t0.edited_user_id AS edited_user_id_41,
t0.created_sig_id AS created_sig_id_42,
t0.edited_sig_id AS edited_sig_id_43,
t0.doc_booked_flag AS doc_booked_flag_44,
t0.time_stamp_of_form AS time_stamp_of_form_45
FROM
inv_item_group t0
WHERE
t0.name = ?
AND t0.type = ?
LIMIT
1
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.type AS type_6, t0.company_id AS company_id_7, t0.pg_id AS pg_id_8, t0.group_code AS group_code_9, t0.hs_code AS hs_code_10, t0.start_hs_code AS start_hs_code_11, t0.end_hs_code AS end_hs_code_12, t0.dr_accounts_head_id AS dr_accounts_head_id_13, t0.cr_accounts_head_id AS cr_accounts_head_id_14, t0.ledger_hit_as AS ledger_hit_as_15, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_16, t0.default_expense_id AS default_expense_id_17, t0.vat_as_expense_flag AS vat_as_expense_flag_18, t0.sellable AS sellable_19, t0.abstract AS abstract_20, t0.icon_path AS icon_path_21, t0.banner_image AS banner_image_22, t0.default_image AS default_image_23, t0.data_sheets AS data_sheets_24, t0.tax_config_ids AS tax_config_ids_25, t0.default_tax_config_id AS default_tax_config_id_26, t0.purchase_tax_config_ids AS purchase_tax_config_ids_27, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_28, t0.images AS images_29, t0.expiry_days AS expiry_days_30, t0.description AS description_31, t0.categorization_data AS categorization_data_32, t0.specification_types AS specification_types_33, t0.allowed_unit_types AS allowed_unit_types_34, t0.include_in_product_name AS include_in_product_name_35, t0.status AS status_36, t0.unit_type_id AS unit_type_id_37, t0.created_login_id AS created_login_id_38, t0.edited_login_id AS edited_login_id_39, t0.created_user_id AS created_user_id_40, t0.edited_user_id AS edited_user_id_41, t0.created_sig_id AS created_sig_id_42, t0.edited_sig_id AS edited_sig_id_43, t0.doc_booked_flag AS doc_booked_flag_44, t0.time_stamp_of_form AS time_stamp_of_form_45 FROM inv_item_group t0 WHERE t0.name = 'Mounting Accessories' AND t0.type = 1 LIMIT 1;
|
| 2 |
6.58 ms |
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.product_name_fdm AS product_name_fdm_6, t0.model_no AS model_no_7, t0.product_fdm AS product_fdm_8, t0.categorization_pending AS categorization_pending_9, t0.global_fdm AS global_fdm_10, t0.part_id AS part_id_11, t0.auto_generate_serial AS auto_generate_serial_12, t0.sku_code AS sku_code_13, t0.default_color_id AS default_color_id_14, t0.default_size AS default_size_15, t0.colors AS colors_16, t0.colors_data AS colors_data_17, t0.sizes AS sizes_18, t0.sizes_data AS sizes_data_19, t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_20, t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_21, t0.tax_config_ids AS tax_config_ids_22, t0.default_tax_config_id AS default_tax_config_id_23, t0.purchase_tax_config_ids AS purchase_tax_config_ids_24, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_25, t0.inco_terms AS inco_terms_26, t0.default_inco_term AS default_inco_term_27, t0.tac AS tac_28, t0.weight AS weight_29, t0.weight_unit_type_id AS weight_unit_type_id_30, t0.weight_variance_value AS weight_variance_value_31, t0.weight_variance_type AS weight_variance_type_32, t0.single_weight AS single_weight_33, t0.single_weight_unit_type_id AS single_weight_unit_type_id_34, t0.single_weight_variance_value AS single_weight_variance_value_35, t0.single_weight_variance_type AS single_weight_variance_type_36, t0.carton_capacity_count AS carton_capacity_count_37, t0.default_label_format_id AS default_label_format_id_38, t0.label_format_ids_by_type AS label_format_ids_by_type_39, t0.dimension AS dimension_40, t0.dimension_unit_type_id AS dimension_unit_type_id_41, t0.crate_data AS crate_data_42, t0.type AS type_43, t0.product_type AS product_type_44, t0.product_code AS product_code_45, t0.specification_types AS specification_types_46, t0.spec_data AS spec_data_47, t0.hs_code AS hs_code_48, t0.mushak_description AS mushak_description_49, t0.epc_category_code AS epc_category_code_50, t0.specification_id AS specification_id_51, t0.sub_category_id AS sub_category_id_52, t0.specification_ids AS specification_ids_53, t0.category_id AS category_id_54, t0.ig_id AS ig_id_55, t0.has_serial AS has_serial_56, t0.dr_accounts_head_id AS dr_accounts_head_id_57, t0.cr_accounts_head_id AS cr_accounts_head_id_58, t0.brand_company AS brand_company_59, t0.company_id AS company_id_60, t0.specification AS specification_61, t0.ingredient AS ingredient_62, t0.nutrition AS nutrition_63, t0.tags AS tags_64, t0.marker_flags AS marker_flags_65, t0.yearly_depreciation AS yearly_depreciation_66, t0.purchase_warranty_months AS purchase_warranty_months_67, t0.sales_warranty_months AS sales_warranty_months_68, t0.starting_balance_unit AS starting_balance_unit_69, t0.qty AS qty_70, t0.booking_qty AS booking_qty_71, t0.non_invoiced_qty AS non_invoiced_qty_72, t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_73, t0.non_sales_return_received_qty AS non_sales_return_received_qty_74, t0.physical_qty AS physical_qty_75, t0.warehouse_id AS warehouse_id_76, t0.ledger_hit_as AS ledger_hit_as_77, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_78, t0.default_expense_id AS default_expense_id_79, t0.vat_as_expense_flag AS vat_as_expense_flag_80, t0.sellable AS sellable_81, t0.abstract AS abstract_82, t0.default_image AS default_image_83, t0.data_sheets AS data_sheets_84, t0.images AS images_85, t0.expiry_days AS expiry_days_86, t0.unit_type_id AS unit_type_id_87, t0.curr_purchase_price AS curr_purchase_price_88, t0.purchase_price_wo_expense AS purchase_price_wo_expense_89, t0.curr_sales_price AS curr_sales_price_90, t0.price_for_servicing_need AS price_for_servicing_need_91, t0.min_margin_percent AS min_margin_percent_92, t0.reorder_level AS reorder_level_93, t0.expense_id AS expense_id_94, t0.expense_cost AS expense_cost_95, t0.note AS note_96, t0.alias AS alias_97, t0.status AS status_98, t0.created_login_id AS created_login_id_99, t0.edited_login_id AS edited_login_id_100, t0.created_user_id AS created_user_id_101, t0.edited_user_id AS edited_user_id_102, t0.created_sig_id AS created_sig_id_103, t0.edited_sig_id AS edited_sig_id_104, t0.doc_booked_flag AS doc_booked_flag_105, t0.time_stamp_of_form AS time_stamp_of_form_106, t0.pending_data AS pending_data_107, t0.local_overrides AS local_overrides_108, t0.disposition_method AS disposition_method_109 FROM inv_products t0 WHERE t0.ig_id = ? AND t0.model_no = ? LIMIT 1
Parameters: [
"110"
"2010mm Reinforcing angle-Mounting Accessories"
]
SELECT
t0.id AS id_1,
t0.global_id AS global_id_2,
t0.sync_flag AS sync_flag_3,
t0.class_suffix AS class_suffix_4,
t0.name AS name_5,
t0.product_name_fdm AS product_name_fdm_6,
t0.model_no AS model_no_7,
t0.product_fdm AS product_fdm_8,
t0.categorization_pending AS categorization_pending_9,
t0.global_fdm AS global_fdm_10,
t0.part_id AS part_id_11,
t0.auto_generate_serial AS auto_generate_serial_12,
t0.sku_code AS sku_code_13,
t0.default_color_id AS default_color_id_14,
t0.default_size AS default_size_15,
t0.colors AS colors_16,
t0.colors_data AS colors_data_17,
t0.sizes AS sizes_18,
t0.sizes_data AS sizes_data_19,
t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_20,
t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_21,
t0.tax_config_ids AS tax_config_ids_22,
t0.default_tax_config_id AS default_tax_config_id_23,
t0.purchase_tax_config_ids AS purchase_tax_config_ids_24,
t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_25,
t0.inco_terms AS inco_terms_26,
t0.default_inco_term AS default_inco_term_27,
t0.tac AS tac_28,
t0.weight AS weight_29,
t0.weight_unit_type_id AS weight_unit_type_id_30,
t0.weight_variance_value AS weight_variance_value_31,
t0.weight_variance_type AS weight_variance_type_32,
t0.single_weight AS single_weight_33,
t0.single_weight_unit_type_id AS single_weight_unit_type_id_34,
t0.single_weight_variance_value AS single_weight_variance_value_35,
t0.single_weight_variance_type AS single_weight_variance_type_36,
t0.carton_capacity_count AS carton_capacity_count_37,
t0.default_label_format_id AS default_label_format_id_38,
t0.label_format_ids_by_type AS label_format_ids_by_type_39,
t0.dimension AS dimension_40,
t0.dimension_unit_type_id AS dimension_unit_type_id_41,
t0.crate_data AS crate_data_42,
t0.type AS type_43,
t0.product_type AS product_type_44,
t0.product_code AS product_code_45,
t0.specification_types AS specification_types_46,
t0.spec_data AS spec_data_47,
t0.hs_code AS hs_code_48,
t0.mushak_description AS mushak_description_49,
t0.epc_category_code AS epc_category_code_50,
t0.specification_id AS specification_id_51,
t0.sub_category_id AS sub_category_id_52,
t0.specification_ids AS specification_ids_53,
t0.category_id AS category_id_54,
t0.ig_id AS ig_id_55,
t0.has_serial AS has_serial_56,
t0.dr_accounts_head_id AS dr_accounts_head_id_57,
t0.cr_accounts_head_id AS cr_accounts_head_id_58,
t0.brand_company AS brand_company_59,
t0.company_id AS company_id_60,
t0.specification AS specification_61,
t0.ingredient AS ingredient_62,
t0.nutrition AS nutrition_63,
t0.tags AS tags_64,
t0.marker_flags AS marker_flags_65,
t0.yearly_depreciation AS yearly_depreciation_66,
t0.purchase_warranty_months AS purchase_warranty_months_67,
t0.sales_warranty_months AS sales_warranty_months_68,
t0.starting_balance_unit AS starting_balance_unit_69,
t0.qty AS qty_70,
t0.booking_qty AS booking_qty_71,
t0.non_invoiced_qty AS non_invoiced_qty_72,
t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_73,
t0.non_sales_return_received_qty AS non_sales_return_received_qty_74,
t0.physical_qty AS physical_qty_75,
t0.warehouse_id AS warehouse_id_76,
t0.ledger_hit_as AS ledger_hit_as_77,
t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_78,
t0.default_expense_id AS default_expense_id_79,
t0.vat_as_expense_flag AS vat_as_expense_flag_80,
t0.sellable AS sellable_81,
t0.abstract AS abstract_82,
t0.default_image AS default_image_83,
t0.data_sheets AS data_sheets_84,
t0.images AS images_85,
t0.expiry_days AS expiry_days_86,
t0.unit_type_id AS unit_type_id_87,
t0.curr_purchase_price AS curr_purchase_price_88,
t0.purchase_price_wo_expense AS purchase_price_wo_expense_89,
t0.curr_sales_price AS curr_sales_price_90,
t0.price_for_servicing_need AS price_for_servicing_need_91,
t0.min_margin_percent AS min_margin_percent_92,
t0.reorder_level AS reorder_level_93,
t0.expense_id AS expense_id_94,
t0.expense_cost AS expense_cost_95,
t0.note AS note_96,
t0.alias AS alias_97,
t0.status AS status_98,
t0.created_login_id AS created_login_id_99,
t0.edited_login_id AS edited_login_id_100,
t0.created_user_id AS created_user_id_101,
t0.edited_user_id AS edited_user_id_102,
t0.created_sig_id AS created_sig_id_103,
t0.edited_sig_id AS edited_sig_id_104,
t0.doc_booked_flag AS doc_booked_flag_105,
t0.time_stamp_of_form AS time_stamp_of_form_106,
t0.pending_data AS pending_data_107,
t0.local_overrides AS local_overrides_108,
t0.disposition_method AS disposition_method_109
FROM
inv_products t0
WHERE
t0.ig_id = ?
AND t0.model_no = ?
LIMIT
1
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.product_name_fdm AS product_name_fdm_6, t0.model_no AS model_no_7, t0.product_fdm AS product_fdm_8, t0.categorization_pending AS categorization_pending_9, t0.global_fdm AS global_fdm_10, t0.part_id AS part_id_11, t0.auto_generate_serial AS auto_generate_serial_12, t0.sku_code AS sku_code_13, t0.default_color_id AS default_color_id_14, t0.default_size AS default_size_15, t0.colors AS colors_16, t0.colors_data AS colors_data_17, t0.sizes AS sizes_18, t0.sizes_data AS sizes_data_19, t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_20, t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_21, t0.tax_config_ids AS tax_config_ids_22, t0.default_tax_config_id AS default_tax_config_id_23, t0.purchase_tax_config_ids AS purchase_tax_config_ids_24, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_25, t0.inco_terms AS inco_terms_26, t0.default_inco_term AS default_inco_term_27, t0.tac AS tac_28, t0.weight AS weight_29, t0.weight_unit_type_id AS weight_unit_type_id_30, t0.weight_variance_value AS weight_variance_value_31, t0.weight_variance_type AS weight_variance_type_32, t0.single_weight AS single_weight_33, t0.single_weight_unit_type_id AS single_weight_unit_type_id_34, t0.single_weight_variance_value AS single_weight_variance_value_35, t0.single_weight_variance_type AS single_weight_variance_type_36, t0.carton_capacity_count AS carton_capacity_count_37, t0.default_label_format_id AS default_label_format_id_38, t0.label_format_ids_by_type AS label_format_ids_by_type_39, t0.dimension AS dimension_40, t0.dimension_unit_type_id AS dimension_unit_type_id_41, t0.crate_data AS crate_data_42, t0.type AS type_43, t0.product_type AS product_type_44, t0.product_code AS product_code_45, t0.specification_types AS specification_types_46, t0.spec_data AS spec_data_47, t0.hs_code AS hs_code_48, t0.mushak_description AS mushak_description_49, t0.epc_category_code AS epc_category_code_50, t0.specification_id AS specification_id_51, t0.sub_category_id AS sub_category_id_52, t0.specification_ids AS specification_ids_53, t0.category_id AS category_id_54, t0.ig_id AS ig_id_55, t0.has_serial AS has_serial_56, t0.dr_accounts_head_id AS dr_accounts_head_id_57, t0.cr_accounts_head_id AS cr_accounts_head_id_58, t0.brand_company AS brand_company_59, t0.company_id AS company_id_60, t0.specification AS specification_61, t0.ingredient AS ingredient_62, t0.nutrition AS nutrition_63, t0.tags AS tags_64, t0.marker_flags AS marker_flags_65, t0.yearly_depreciation AS yearly_depreciation_66, t0.purchase_warranty_months AS purchase_warranty_months_67, t0.sales_warranty_months AS sales_warranty_months_68, t0.starting_balance_unit AS starting_balance_unit_69, t0.qty AS qty_70, t0.booking_qty AS booking_qty_71, t0.non_invoiced_qty AS non_invoiced_qty_72, t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_73, t0.non_sales_return_received_qty AS non_sales_return_received_qty_74, t0.physical_qty AS physical_qty_75, t0.warehouse_id AS warehouse_id_76, t0.ledger_hit_as AS ledger_hit_as_77, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_78, t0.default_expense_id AS default_expense_id_79, t0.vat_as_expense_flag AS vat_as_expense_flag_80, t0.sellable AS sellable_81, t0.abstract AS abstract_82, t0.default_image AS default_image_83, t0.data_sheets AS data_sheets_84, t0.images AS images_85, t0.expiry_days AS expiry_days_86, t0.unit_type_id AS unit_type_id_87, t0.curr_purchase_price AS curr_purchase_price_88, t0.purchase_price_wo_expense AS purchase_price_wo_expense_89, t0.curr_sales_price AS curr_sales_price_90, t0.price_for_servicing_need AS price_for_servicing_need_91, t0.min_margin_percent AS min_margin_percent_92, t0.reorder_level AS reorder_level_93, t0.expense_id AS expense_id_94, t0.expense_cost AS expense_cost_95, t0.note AS note_96, t0.alias AS alias_97, t0.status AS status_98, t0.created_login_id AS created_login_id_99, t0.edited_login_id AS edited_login_id_100, t0.created_user_id AS created_user_id_101, t0.edited_user_id AS edited_user_id_102, t0.created_sig_id AS created_sig_id_103, t0.edited_sig_id AS edited_sig_id_104, t0.doc_booked_flag AS doc_booked_flag_105, t0.time_stamp_of_form AS time_stamp_of_form_106, t0.pending_data AS pending_data_107, t0.local_overrides AS local_overrides_108, t0.disposition_method AS disposition_method_109 FROM inv_products t0 WHERE t0.ig_id = '110' AND t0.model_no = '2010mm Reinforcing angle-Mounting Accessories' LIMIT 1;
|
| 3 |
5.78 ms |
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.product_name_fdm AS product_name_fdm_6, t0.model_no AS model_no_7, t0.product_fdm AS product_fdm_8, t0.categorization_pending AS categorization_pending_9, t0.global_fdm AS global_fdm_10, t0.part_id AS part_id_11, t0.auto_generate_serial AS auto_generate_serial_12, t0.sku_code AS sku_code_13, t0.default_color_id AS default_color_id_14, t0.default_size AS default_size_15, t0.colors AS colors_16, t0.colors_data AS colors_data_17, t0.sizes AS sizes_18, t0.sizes_data AS sizes_data_19, t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_20, t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_21, t0.tax_config_ids AS tax_config_ids_22, t0.default_tax_config_id AS default_tax_config_id_23, t0.purchase_tax_config_ids AS purchase_tax_config_ids_24, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_25, t0.inco_terms AS inco_terms_26, t0.default_inco_term AS default_inco_term_27, t0.tac AS tac_28, t0.weight AS weight_29, t0.weight_unit_type_id AS weight_unit_type_id_30, t0.weight_variance_value AS weight_variance_value_31, t0.weight_variance_type AS weight_variance_type_32, t0.single_weight AS single_weight_33, t0.single_weight_unit_type_id AS single_weight_unit_type_id_34, t0.single_weight_variance_value AS single_weight_variance_value_35, t0.single_weight_variance_type AS single_weight_variance_type_36, t0.carton_capacity_count AS carton_capacity_count_37, t0.default_label_format_id AS default_label_format_id_38, t0.label_format_ids_by_type AS label_format_ids_by_type_39, t0.dimension AS dimension_40, t0.dimension_unit_type_id AS dimension_unit_type_id_41, t0.crate_data AS crate_data_42, t0.type AS type_43, t0.product_type AS product_type_44, t0.product_code AS product_code_45, t0.specification_types AS specification_types_46, t0.spec_data AS spec_data_47, t0.hs_code AS hs_code_48, t0.mushak_description AS mushak_description_49, t0.epc_category_code AS epc_category_code_50, t0.specification_id AS specification_id_51, t0.sub_category_id AS sub_category_id_52, t0.specification_ids AS specification_ids_53, t0.category_id AS category_id_54, t0.ig_id AS ig_id_55, t0.has_serial AS has_serial_56, t0.dr_accounts_head_id AS dr_accounts_head_id_57, t0.cr_accounts_head_id AS cr_accounts_head_id_58, t0.brand_company AS brand_company_59, t0.company_id AS company_id_60, t0.specification AS specification_61, t0.ingredient AS ingredient_62, t0.nutrition AS nutrition_63, t0.tags AS tags_64, t0.marker_flags AS marker_flags_65, t0.yearly_depreciation AS yearly_depreciation_66, t0.purchase_warranty_months AS purchase_warranty_months_67, t0.sales_warranty_months AS sales_warranty_months_68, t0.starting_balance_unit AS starting_balance_unit_69, t0.qty AS qty_70, t0.booking_qty AS booking_qty_71, t0.non_invoiced_qty AS non_invoiced_qty_72, t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_73, t0.non_sales_return_received_qty AS non_sales_return_received_qty_74, t0.physical_qty AS physical_qty_75, t0.warehouse_id AS warehouse_id_76, t0.ledger_hit_as AS ledger_hit_as_77, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_78, t0.default_expense_id AS default_expense_id_79, t0.vat_as_expense_flag AS vat_as_expense_flag_80, t0.sellable AS sellable_81, t0.abstract AS abstract_82, t0.default_image AS default_image_83, t0.data_sheets AS data_sheets_84, t0.images AS images_85, t0.expiry_days AS expiry_days_86, t0.unit_type_id AS unit_type_id_87, t0.curr_purchase_price AS curr_purchase_price_88, t0.purchase_price_wo_expense AS purchase_price_wo_expense_89, t0.curr_sales_price AS curr_sales_price_90, t0.price_for_servicing_need AS price_for_servicing_need_91, t0.min_margin_percent AS min_margin_percent_92, t0.reorder_level AS reorder_level_93, t0.expense_id AS expense_id_94, t0.expense_cost AS expense_cost_95, t0.note AS note_96, t0.alias AS alias_97, t0.status AS status_98, t0.created_login_id AS created_login_id_99, t0.edited_login_id AS edited_login_id_100, t0.created_user_id AS created_user_id_101, t0.edited_user_id AS edited_user_id_102, t0.created_sig_id AS created_sig_id_103, t0.edited_sig_id AS edited_sig_id_104, t0.doc_booked_flag AS doc_booked_flag_105, t0.time_stamp_of_form AS time_stamp_of_form_106, t0.pending_data AS pending_data_107, t0.local_overrides AS local_overrides_108, t0.disposition_method AS disposition_method_109 FROM inv_products t0 WHERE t0.ig_id = ? AND t0.name = ? LIMIT 1
Parameters: [
"110"
"2010mm Reinforcing angle-Mounting Accessories"
]
SELECT
t0.id AS id_1,
t0.global_id AS global_id_2,
t0.sync_flag AS sync_flag_3,
t0.class_suffix AS class_suffix_4,
t0.name AS name_5,
t0.product_name_fdm AS product_name_fdm_6,
t0.model_no AS model_no_7,
t0.product_fdm AS product_fdm_8,
t0.categorization_pending AS categorization_pending_9,
t0.global_fdm AS global_fdm_10,
t0.part_id AS part_id_11,
t0.auto_generate_serial AS auto_generate_serial_12,
t0.sku_code AS sku_code_13,
t0.default_color_id AS default_color_id_14,
t0.default_size AS default_size_15,
t0.colors AS colors_16,
t0.colors_data AS colors_data_17,
t0.sizes AS sizes_18,
t0.sizes_data AS sizes_data_19,
t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_20,
t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_21,
t0.tax_config_ids AS tax_config_ids_22,
t0.default_tax_config_id AS default_tax_config_id_23,
t0.purchase_tax_config_ids AS purchase_tax_config_ids_24,
t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_25,
t0.inco_terms AS inco_terms_26,
t0.default_inco_term AS default_inco_term_27,
t0.tac AS tac_28,
t0.weight AS weight_29,
t0.weight_unit_type_id AS weight_unit_type_id_30,
t0.weight_variance_value AS weight_variance_value_31,
t0.weight_variance_type AS weight_variance_type_32,
t0.single_weight AS single_weight_33,
t0.single_weight_unit_type_id AS single_weight_unit_type_id_34,
t0.single_weight_variance_value AS single_weight_variance_value_35,
t0.single_weight_variance_type AS single_weight_variance_type_36,
t0.carton_capacity_count AS carton_capacity_count_37,
t0.default_label_format_id AS default_label_format_id_38,
t0.label_format_ids_by_type AS label_format_ids_by_type_39,
t0.dimension AS dimension_40,
t0.dimension_unit_type_id AS dimension_unit_type_id_41,
t0.crate_data AS crate_data_42,
t0.type AS type_43,
t0.product_type AS product_type_44,
t0.product_code AS product_code_45,
t0.specification_types AS specification_types_46,
t0.spec_data AS spec_data_47,
t0.hs_code AS hs_code_48,
t0.mushak_description AS mushak_description_49,
t0.epc_category_code AS epc_category_code_50,
t0.specification_id AS specification_id_51,
t0.sub_category_id AS sub_category_id_52,
t0.specification_ids AS specification_ids_53,
t0.category_id AS category_id_54,
t0.ig_id AS ig_id_55,
t0.has_serial AS has_serial_56,
t0.dr_accounts_head_id AS dr_accounts_head_id_57,
t0.cr_accounts_head_id AS cr_accounts_head_id_58,
t0.brand_company AS brand_company_59,
t0.company_id AS company_id_60,
t0.specification AS specification_61,
t0.ingredient AS ingredient_62,
t0.nutrition AS nutrition_63,
t0.tags AS tags_64,
t0.marker_flags AS marker_flags_65,
t0.yearly_depreciation AS yearly_depreciation_66,
t0.purchase_warranty_months AS purchase_warranty_months_67,
t0.sales_warranty_months AS sales_warranty_months_68,
t0.starting_balance_unit AS starting_balance_unit_69,
t0.qty AS qty_70,
t0.booking_qty AS booking_qty_71,
t0.non_invoiced_qty AS non_invoiced_qty_72,
t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_73,
t0.non_sales_return_received_qty AS non_sales_return_received_qty_74,
t0.physical_qty AS physical_qty_75,
t0.warehouse_id AS warehouse_id_76,
t0.ledger_hit_as AS ledger_hit_as_77,
t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_78,
t0.default_expense_id AS default_expense_id_79,
t0.vat_as_expense_flag AS vat_as_expense_flag_80,
t0.sellable AS sellable_81,
t0.abstract AS abstract_82,
t0.default_image AS default_image_83,
t0.data_sheets AS data_sheets_84,
t0.images AS images_85,
t0.expiry_days AS expiry_days_86,
t0.unit_type_id AS unit_type_id_87,
t0.curr_purchase_price AS curr_purchase_price_88,
t0.purchase_price_wo_expense AS purchase_price_wo_expense_89,
t0.curr_sales_price AS curr_sales_price_90,
t0.price_for_servicing_need AS price_for_servicing_need_91,
t0.min_margin_percent AS min_margin_percent_92,
t0.reorder_level AS reorder_level_93,
t0.expense_id AS expense_id_94,
t0.expense_cost AS expense_cost_95,
t0.note AS note_96,
t0.alias AS alias_97,
t0.status AS status_98,
t0.created_login_id AS created_login_id_99,
t0.edited_login_id AS edited_login_id_100,
t0.created_user_id AS created_user_id_101,
t0.edited_user_id AS edited_user_id_102,
t0.created_sig_id AS created_sig_id_103,
t0.edited_sig_id AS edited_sig_id_104,
t0.doc_booked_flag AS doc_booked_flag_105,
t0.time_stamp_of_form AS time_stamp_of_form_106,
t0.pending_data AS pending_data_107,
t0.local_overrides AS local_overrides_108,
t0.disposition_method AS disposition_method_109
FROM
inv_products t0
WHERE
t0.ig_id = ?
AND t0.name = ?
LIMIT
1
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.product_name_fdm AS product_name_fdm_6, t0.model_no AS model_no_7, t0.product_fdm AS product_fdm_8, t0.categorization_pending AS categorization_pending_9, t0.global_fdm AS global_fdm_10, t0.part_id AS part_id_11, t0.auto_generate_serial AS auto_generate_serial_12, t0.sku_code AS sku_code_13, t0.default_color_id AS default_color_id_14, t0.default_size AS default_size_15, t0.colors AS colors_16, t0.colors_data AS colors_data_17, t0.sizes AS sizes_18, t0.sizes_data AS sizes_data_19, t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_20, t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_21, t0.tax_config_ids AS tax_config_ids_22, t0.default_tax_config_id AS default_tax_config_id_23, t0.purchase_tax_config_ids AS purchase_tax_config_ids_24, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_25, t0.inco_terms AS inco_terms_26, t0.default_inco_term AS default_inco_term_27, t0.tac AS tac_28, t0.weight AS weight_29, t0.weight_unit_type_id AS weight_unit_type_id_30, t0.weight_variance_value AS weight_variance_value_31, t0.weight_variance_type AS weight_variance_type_32, t0.single_weight AS single_weight_33, t0.single_weight_unit_type_id AS single_weight_unit_type_id_34, t0.single_weight_variance_value AS single_weight_variance_value_35, t0.single_weight_variance_type AS single_weight_variance_type_36, t0.carton_capacity_count AS carton_capacity_count_37, t0.default_label_format_id AS default_label_format_id_38, t0.label_format_ids_by_type AS label_format_ids_by_type_39, t0.dimension AS dimension_40, t0.dimension_unit_type_id AS dimension_unit_type_id_41, t0.crate_data AS crate_data_42, t0.type AS type_43, t0.product_type AS product_type_44, t0.product_code AS product_code_45, t0.specification_types AS specification_types_46, t0.spec_data AS spec_data_47, t0.hs_code AS hs_code_48, t0.mushak_description AS mushak_description_49, t0.epc_category_code AS epc_category_code_50, t0.specification_id AS specification_id_51, t0.sub_category_id AS sub_category_id_52, t0.specification_ids AS specification_ids_53, t0.category_id AS category_id_54, t0.ig_id AS ig_id_55, t0.has_serial AS has_serial_56, t0.dr_accounts_head_id AS dr_accounts_head_id_57, t0.cr_accounts_head_id AS cr_accounts_head_id_58, t0.brand_company AS brand_company_59, t0.company_id AS company_id_60, t0.specification AS specification_61, t0.ingredient AS ingredient_62, t0.nutrition AS nutrition_63, t0.tags AS tags_64, t0.marker_flags AS marker_flags_65, t0.yearly_depreciation AS yearly_depreciation_66, t0.purchase_warranty_months AS purchase_warranty_months_67, t0.sales_warranty_months AS sales_warranty_months_68, t0.starting_balance_unit AS starting_balance_unit_69, t0.qty AS qty_70, t0.booking_qty AS booking_qty_71, t0.non_invoiced_qty AS non_invoiced_qty_72, t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_73, t0.non_sales_return_received_qty AS non_sales_return_received_qty_74, t0.physical_qty AS physical_qty_75, t0.warehouse_id AS warehouse_id_76, t0.ledger_hit_as AS ledger_hit_as_77, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_78, t0.default_expense_id AS default_expense_id_79, t0.vat_as_expense_flag AS vat_as_expense_flag_80, t0.sellable AS sellable_81, t0.abstract AS abstract_82, t0.default_image AS default_image_83, t0.data_sheets AS data_sheets_84, t0.images AS images_85, t0.expiry_days AS expiry_days_86, t0.unit_type_id AS unit_type_id_87, t0.curr_purchase_price AS curr_purchase_price_88, t0.purchase_price_wo_expense AS purchase_price_wo_expense_89, t0.curr_sales_price AS curr_sales_price_90, t0.price_for_servicing_need AS price_for_servicing_need_91, t0.min_margin_percent AS min_margin_percent_92, t0.reorder_level AS reorder_level_93, t0.expense_id AS expense_id_94, t0.expense_cost AS expense_cost_95, t0.note AS note_96, t0.alias AS alias_97, t0.status AS status_98, t0.created_login_id AS created_login_id_99, t0.edited_login_id AS edited_login_id_100, t0.created_user_id AS created_user_id_101, t0.edited_user_id AS edited_user_id_102, t0.created_sig_id AS created_sig_id_103, t0.edited_sig_id AS edited_sig_id_104, t0.doc_booked_flag AS doc_booked_flag_105, t0.time_stamp_of_form AS time_stamp_of_form_106, t0.pending_data AS pending_data_107, t0.local_overrides AS local_overrides_108, t0.disposition_method AS disposition_method_109 FROM inv_products t0 WHERE t0.ig_id = '110' AND t0.name = '2010mm Reinforcing angle-Mounting Accessories' LIMIT 1;
|