Symfony Profiler

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 = 'Earthing Accessories' AND t0.type = 1 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 = ?
  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 = '50' AND t0.model_no = '8 mm Metal Royal Bolt' 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 = ?
  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 = '50' AND t0.name = '8 mm Metal Royal Bolt' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO inv_products (
  global_id, sync_flag, class_suffix,
  name, product_name_fdm, model_no,
  product_fdm, categorization_pending,
  global_fdm, part_id, auto_generate_serial,
  sku_code, default_color_id, default_size,
  colors, colors_data, sizes, sizes_data,
  segregate_price_by_sizes_flag,
  segregate_price_by_colors_flag,
  tax_config_ids, default_tax_config_id,
  purchase_tax_config_ids, default_purchase_tax_config_id,
  inco_terms, default_inco_term, tac,
  weight, weight_unit_type_id, weight_variance_value,
  weight_variance_type, single_weight,
  single_weight_unit_type_id, single_weight_variance_value,
  single_weight_variance_type, carton_capacity_count,
  default_label_format_id, label_format_ids_by_type,
  dimension, dimension_unit_type_id,
  crate_data, TYPE, product_type, product_code,
  specification_types, spec_data,
  hs_code, mushak_description, epc_category_code,
  specification_id, sub_category_id,
  specification_ids, category_id,
  ig_id, has_serial, dr_accounts_head_id,
  cr_accounts_head_id, brand_company,
  company_id, specification, ingredient,
  nutrition, tags, marker_flags, yearly_depreciation,
  purchase_warranty_months, sales_warranty_months,
  starting_balance_unit, qty, booking_qty,
  non_invoiced_qty, non_sales_invoiced_qty,
  non_sales_return_received_qty,
  physical_qty, warehouse_id, ledger_hit_as,
  default_purchase_action_tag_id,
  default_expense_id, vat_as_expense_flag,
  sellable, abstract, default_image,
  data_sheets, images, expiry_days,
  unit_type_id, curr_purchase_price,
  purchase_price_wo_expense, curr_sales_price,
  price_for_servicing_need, min_margin_percent,
  reorder_level, expense_id, expense_cost,
  note, alias, STATUS, created_login_id,
  edited_login_id, created_user_id,
  edited_user_id, created_sig_id,
  edited_sig_id, doc_booked_flag,
  time_stamp_of_form, pending_data,
  local_overrides, disposition_method
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO inv_products (global_id, sync_flag, class_suffix, name, product_name_fdm, model_no, product_fdm, categorization_pending, global_fdm, part_id, auto_generate_serial, sku_code, default_color_id, default_size, colors, colors_data, sizes, sizes_data, segregate_price_by_sizes_flag, segregate_price_by_colors_flag, tax_config_ids, default_tax_config_id, purchase_tax_config_ids, default_purchase_tax_config_id, inco_terms, default_inco_term, tac, weight, weight_unit_type_id, weight_variance_value, weight_variance_type, single_weight, single_weight_unit_type_id, single_weight_variance_value, single_weight_variance_type, carton_capacity_count, default_label_format_id, label_format_ids_by_type, dimension, dimension_unit_type_id, crate_data, TYPE, product_type, product_code, specification_types, spec_data, hs_code, mushak_description, epc_category_code, specification_id, sub_category_id, specification_ids, category_id, ig_id, has_serial, dr_accounts_head_id, cr_accounts_head_id, brand_company, company_id, specification, ingredient, nutrition, tags, marker_flags, yearly_depreciation, purchase_warranty_months, sales_warranty_months, starting_balance_unit, qty, booking_qty, non_invoiced_qty, non_sales_invoiced_qty, non_sales_return_received_qty, physical_qty, warehouse_id, ledger_hit_as, default_purchase_action_tag_id, default_expense_id, vat_as_expense_flag, sellable, abstract, default_image, data_sheets, images, expiry_days, unit_type_id, curr_purchase_price, purchase_price_wo_expense, curr_sales_price, price_for_servicing_need, min_margin_percent, reorder_level, expense_id, expense_cost, note, alias, STATUS, created_login_id, edited_login_id, created_user_id, edited_user_id, created_sig_id, edited_sig_id, doc_booked_flag, time_stamp_of_form, pending_data, local_overrides, disposition_method) VALUES (NULL, 2, NULL, '8 mm Metal Royal Bolt', NULL, '8 mm Metal Royal Bolt', 'I25_C234_SZ1108_SO1109_B1_P776_', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  inv_products
SET
  global_id = ?
WHERE
  id = ?

UPDATE inv_products SET global_id = '5566' WHERE id = '5566';

"COMMIT"

"COMMIT";