Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.app_id AS app_id_4,
  t0.country_id AS country_id_5,
  t0.locale AS locale_6,
  t0.company_hash AS company_hash_7,
  t0.company_unique_code AS company_unique_code_8,
  t0.contact_number AS contact_number_9,
  t0.email AS email_10,
  t0.enabled_module_id_list AS enabled_module_id_list_11,
  t0.company_type AS company_type_12,
  t0.usage_valid_upto_date AS usage_valid_upto_date_13,
  t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_14,
  t0.post_dated_job_active AS post_dated_job_active_15,
  t0.address AS address_16,
  t0.shipping_address AS shipping_address_17,
  t0.sms_notification_enabled AS sms_notification_enabled_18,
  t0.sms_settings AS sms_settings_19,
  t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_20,
  t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_21,
  t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_22,
  t0.dark_vibrant AS dark_vibrant_23,
  t0.light_vibrant AS light_vibrant_24,
  t0.vibrant AS vibrant_25,
  t0.billing_address AS billing_address_26,
  t0.motto AS motto_27,
  t0.invoice_footer AS invoice_footer_28,
  t0.general_footer AS general_footer_29,
  t0.company_bin AS company_bin_30,
  t0.company_tin AS company_tin_31,
  t0.company_reg AS company_reg_32,
  t0.company_tl AS company_tl_33,
  t0.user_allowed AS user_allowed_34,
  t0.user_allocated AS user_allocated_35,
  t0.user_remaining AS user_remaining_36,
  t0.admin_user_allowed AS admin_user_allowed_37,
  t0.admin_user_allocated AS admin_user_allocated_38,
  t0.admin_user_remaining AS admin_user_remaining_39,
  t0.me_str AS me_str_40,
  t0.cash AS cash_41,
  t0.bank AS bank_42,
  t0.sales AS sales_43,
  t0.asset AS asset_44,
  t0.liability AS liability_45,
  t0.expense AS expense_46,
  t0.revenue AS revenue_47,
  t0.payable AS payable_48,
  t0.receivable AS receivable_49,
  t0.net_worth AS net_worth_50,
  t0.monthly_growth AS monthly_growth_51,
  t0.wacc AS wacc_52,
  t0.active AS active_53,
  t0.company_status AS company_status_54,
  t0.package_type AS package_type_55,
  t0.subscription_expiry AS subscription_expiry_56,
  t0.last_activity_at AS last_activity_at_57,
  t0.company_description AS company_description_58,
  t0.created_at AS created_at_59,
  t0.updated_at AS updated_at_60,
  t0.doc_booked_flag AS doc_booked_flag_61,
  t0.time_stamp_of_form AS time_stamp_of_form_62
FROM
  company t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.app_id AS app_id_4, t0.country_id AS country_id_5, t0.locale AS locale_6, t0.company_hash AS company_hash_7, t0.company_unique_code AS company_unique_code_8, t0.contact_number AS contact_number_9, t0.email AS email_10, t0.enabled_module_id_list AS enabled_module_id_list_11, t0.company_type AS company_type_12, t0.usage_valid_upto_date AS usage_valid_upto_date_13, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_14, t0.post_dated_job_active AS post_dated_job_active_15, t0.address AS address_16, t0.shipping_address AS shipping_address_17, t0.sms_notification_enabled AS sms_notification_enabled_18, t0.sms_settings AS sms_settings_19, t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_20, t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_21, t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_22, t0.dark_vibrant AS dark_vibrant_23, t0.light_vibrant AS light_vibrant_24, t0.vibrant AS vibrant_25, t0.billing_address AS billing_address_26, t0.motto AS motto_27, t0.invoice_footer AS invoice_footer_28, t0.general_footer AS general_footer_29, t0.company_bin AS company_bin_30, t0.company_tin AS company_tin_31, t0.company_reg AS company_reg_32, t0.company_tl AS company_tl_33, t0.user_allowed AS user_allowed_34, t0.user_allocated AS user_allocated_35, t0.user_remaining AS user_remaining_36, t0.admin_user_allowed AS admin_user_allowed_37, t0.admin_user_allocated AS admin_user_allocated_38, t0.admin_user_remaining AS admin_user_remaining_39, t0.me_str AS me_str_40, t0.cash AS cash_41, t0.bank AS bank_42, t0.sales AS sales_43, t0.asset AS asset_44, t0.liability AS liability_45, t0.expense AS expense_46, t0.revenue AS revenue_47, t0.payable AS payable_48, t0.receivable AS receivable_49, t0.net_worth AS net_worth_50, t0.monthly_growth AS monthly_growth_51, t0.wacc AS wacc_52, t0.active AS active_53, t0.company_status AS company_status_54, t0.package_type AS package_type_55, t0.subscription_expiry AS subscription_expiry_56, t0.last_activity_at AS last_activity_at_57, t0.company_description AS company_description_58, t0.created_at AS created_at_59, t0.updated_at AS updated_at_60, t0.doc_booked_flag AS doc_booked_flag_61, t0.time_stamp_of_form AS time_stamp_of_form_62 FROM company t0 ORDER BY t0.id ASC 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.global_fdm AS global_fdm_9,
  t0.part_id AS part_id_10,
  t0.auto_generate_serial AS auto_generate_serial_11,
  t0.sku_code AS sku_code_12,
  t0.default_color_id AS default_color_id_13,
  t0.default_size AS default_size_14,
  t0.colors AS colors_15,
  t0.colors_data AS colors_data_16,
  t0.sizes AS sizes_17,
  t0.sizes_data AS sizes_data_18,
  t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_19,
  t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_20,
  t0.tax_config_ids AS tax_config_ids_21,
  t0.default_tax_config_id AS default_tax_config_id_22,
  t0.purchase_tax_config_ids AS purchase_tax_config_ids_23,
  t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_24,
  t0.inco_terms AS inco_terms_25,
  t0.default_inco_term AS default_inco_term_26,
  t0.tac AS tac_27,
  t0.weight AS weight_28,
  t0.weight_unit_type_id AS weight_unit_type_id_29,
  t0.weight_variance_value AS weight_variance_value_30,
  t0.weight_variance_type AS weight_variance_type_31,
  t0.single_weight AS single_weight_32,
  t0.single_weight_unit_type_id AS single_weight_unit_type_id_33,
  t0.single_weight_variance_value AS single_weight_variance_value_34,
  t0.single_weight_variance_type AS single_weight_variance_type_35,
  t0.carton_capacity_count AS carton_capacity_count_36,
  t0.default_label_format_id AS default_label_format_id_37,
  t0.label_format_ids_by_type AS label_format_ids_by_type_38,
  t0.dimension AS dimension_39,
  t0.dimension_unit_type_id AS dimension_unit_type_id_40,
  t0.crate_data AS crate_data_41,
  t0.type AS type_42,
  t0.product_type AS product_type_43,
  t0.product_code AS product_code_44,
  t0.specification_types AS specification_types_45,
  t0.spec_data AS spec_data_46,
  t0.hs_code AS hs_code_47,
  t0.epc_category_code AS epc_category_code_48,
  t0.specification_id AS specification_id_49,
  t0.sub_category_id AS sub_category_id_50,
  t0.specification_ids AS specification_ids_51,
  t0.category_id AS category_id_52,
  t0.ig_id AS ig_id_53,
  t0.has_serial AS has_serial_54,
  t0.dr_accounts_head_id AS dr_accounts_head_id_55,
  t0.cr_accounts_head_id AS cr_accounts_head_id_56,
  t0.brand_company AS brand_company_57,
  t0.company_id AS company_id_58,
  t0.specification AS specification_59,
  t0.ingredient AS ingredient_60,
  t0.nutrition AS nutrition_61,
  t0.tags AS tags_62,
  t0.marker_flags AS marker_flags_63,
  t0.yearly_depreciation AS yearly_depreciation_64,
  t0.purchase_warranty_months AS purchase_warranty_months_65,
  t0.sales_warranty_months AS sales_warranty_months_66,
  t0.starting_balance_unit AS starting_balance_unit_67,
  t0.qty AS qty_68,
  t0.booking_qty AS booking_qty_69,
  t0.non_invoiced_qty AS non_invoiced_qty_70,
  t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_71,
  t0.non_sales_return_received_qty AS non_sales_return_received_qty_72,
  t0.physical_qty AS physical_qty_73,
  t0.warehouse_id AS warehouse_id_74,
  t0.ledger_hit_as AS ledger_hit_as_75,
  t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_76,
  t0.default_expense_id AS default_expense_id_77,
  t0.vat_as_expense_flag AS vat_as_expense_flag_78,
  t0.sellable AS sellable_79,
  t0.abstract AS abstract_80,
  t0.default_image AS default_image_81,
  t0.data_sheets AS data_sheets_82,
  t0.images AS images_83,
  t0.expiry_days AS expiry_days_84,
  t0.unit_type_id AS unit_type_id_85,
  t0.curr_purchase_price AS curr_purchase_price_86,
  t0.purchase_price_wo_expense AS purchase_price_wo_expense_87,
  t0.curr_sales_price AS curr_sales_price_88,
  t0.price_for_servicing_need AS price_for_servicing_need_89,
  t0.min_margin_percent AS min_margin_percent_90,
  t0.reorder_level AS reorder_level_91,
  t0.expense_id AS expense_id_92,
  t0.expense_cost AS expense_cost_93,
  t0.note AS note_94,
  t0.alias AS alias_95,
  t0.status AS status_96,
  t0.created_login_id AS created_login_id_97,
  t0.edited_login_id AS edited_login_id_98,
  t0.created_user_id AS created_user_id_99,
  t0.edited_user_id AS edited_user_id_100,
  t0.created_sig_id AS created_sig_id_101,
  t0.edited_sig_id AS edited_sig_id_102,
  t0.doc_booked_flag AS doc_booked_flag_103,
  t0.time_stamp_of_form AS time_stamp_of_form_104,
  t0.pending_data AS pending_data_105,
  t0.disposition_method AS disposition_method_106
FROM
  inv_products t0
WHERE
  t0.id = ?
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.global_fdm AS global_fdm_9, t0.part_id AS part_id_10, t0.auto_generate_serial AS auto_generate_serial_11, t0.sku_code AS sku_code_12, t0.default_color_id AS default_color_id_13, t0.default_size AS default_size_14, t0.colors AS colors_15, t0.colors_data AS colors_data_16, t0.sizes AS sizes_17, t0.sizes_data AS sizes_data_18, t0.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_19, t0.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_20, t0.tax_config_ids AS tax_config_ids_21, t0.default_tax_config_id AS default_tax_config_id_22, t0.purchase_tax_config_ids AS purchase_tax_config_ids_23, t0.default_purchase_tax_config_id AS default_purchase_tax_config_id_24, t0.inco_terms AS inco_terms_25, t0.default_inco_term AS default_inco_term_26, t0.tac AS tac_27, t0.weight AS weight_28, t0.weight_unit_type_id AS weight_unit_type_id_29, t0.weight_variance_value AS weight_variance_value_30, t0.weight_variance_type AS weight_variance_type_31, t0.single_weight AS single_weight_32, t0.single_weight_unit_type_id AS single_weight_unit_type_id_33, t0.single_weight_variance_value AS single_weight_variance_value_34, t0.single_weight_variance_type AS single_weight_variance_type_35, t0.carton_capacity_count AS carton_capacity_count_36, t0.default_label_format_id AS default_label_format_id_37, t0.label_format_ids_by_type AS label_format_ids_by_type_38, t0.dimension AS dimension_39, t0.dimension_unit_type_id AS dimension_unit_type_id_40, t0.crate_data AS crate_data_41, t0.type AS type_42, t0.product_type AS product_type_43, t0.product_code AS product_code_44, t0.specification_types AS specification_types_45, t0.spec_data AS spec_data_46, t0.hs_code AS hs_code_47, t0.epc_category_code AS epc_category_code_48, t0.specification_id AS specification_id_49, t0.sub_category_id AS sub_category_id_50, t0.specification_ids AS specification_ids_51, t0.category_id AS category_id_52, t0.ig_id AS ig_id_53, t0.has_serial AS has_serial_54, t0.dr_accounts_head_id AS dr_accounts_head_id_55, t0.cr_accounts_head_id AS cr_accounts_head_id_56, t0.brand_company AS brand_company_57, t0.company_id AS company_id_58, t0.specification AS specification_59, t0.ingredient AS ingredient_60, t0.nutrition AS nutrition_61, t0.tags AS tags_62, t0.marker_flags AS marker_flags_63, t0.yearly_depreciation AS yearly_depreciation_64, t0.purchase_warranty_months AS purchase_warranty_months_65, t0.sales_warranty_months AS sales_warranty_months_66, t0.starting_balance_unit AS starting_balance_unit_67, t0.qty AS qty_68, t0.booking_qty AS booking_qty_69, t0.non_invoiced_qty AS non_invoiced_qty_70, t0.non_sales_invoiced_qty AS non_sales_invoiced_qty_71, t0.non_sales_return_received_qty AS non_sales_return_received_qty_72, t0.physical_qty AS physical_qty_73, t0.warehouse_id AS warehouse_id_74, t0.ledger_hit_as AS ledger_hit_as_75, t0.default_purchase_action_tag_id AS default_purchase_action_tag_id_76, t0.default_expense_id AS default_expense_id_77, t0.vat_as_expense_flag AS vat_as_expense_flag_78, t0.sellable AS sellable_79, t0.abstract AS abstract_80, t0.default_image AS default_image_81, t0.data_sheets AS data_sheets_82, t0.images AS images_83, t0.expiry_days AS expiry_days_84, t0.unit_type_id AS unit_type_id_85, t0.curr_purchase_price AS curr_purchase_price_86, t0.purchase_price_wo_expense AS purchase_price_wo_expense_87, t0.curr_sales_price AS curr_sales_price_88, t0.price_for_servicing_need AS price_for_servicing_need_89, t0.min_margin_percent AS min_margin_percent_90, t0.reorder_level AS reorder_level_91, t0.expense_id AS expense_id_92, t0.expense_cost AS expense_cost_93, t0.note AS note_94, t0.alias AS alias_95, t0.status AS status_96, t0.created_login_id AS created_login_id_97, t0.edited_login_id AS edited_login_id_98, t0.created_user_id AS created_user_id_99, t0.edited_user_id AS edited_user_id_100, t0.created_sig_id AS created_sig_id_101, t0.edited_sig_id AS edited_sig_id_102, t0.doc_booked_flag AS doc_booked_flag_103, t0.time_stamp_of_form AS time_stamp_of_form_104, t0.pending_data AS pending_data_105, t0.disposition_method AS disposition_method_106 FROM inv_products t0 WHERE t0.id = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.global_id AS global_id_2,
  t0.image AS image_3,
  t0.sync_flag AS sync_flag_4,
  t0.class_suffix AS class_suffix_5,
  t0.name AS name_6,
  t0.supplier_id AS supplier_id_7,
  t0.supplier_short_code AS supplier_short_code_8,
  t0.company_id AS company_id_9,
  t0.status AS status_10,
  t0.created_login_id AS created_login_id_11,
  t0.edited_login_id AS edited_login_id_12,
  t0.created_user_id AS created_user_id_13,
  t0.edited_user_id AS edited_user_id_14,
  t0.created_sig_id AS created_sig_id_15,
  t0.edited_sig_id AS edited_sig_id_16,
  t0.doc_booked_flag AS doc_booked_flag_17,
  t0.time_stamp_of_form AS time_stamp_of_form_18
FROM
  brand_company t0
WHERE
  t0.status = ?
  AND t0.company_id IS NULL

SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.image AS image_3, t0.sync_flag AS sync_flag_4, t0.class_suffix AS class_suffix_5, t0.name AS name_6, t0.supplier_id AS supplier_id_7, t0.supplier_short_code AS supplier_short_code_8, t0.company_id AS company_id_9, t0.status AS status_10, t0.created_login_id AS created_login_id_11, t0.edited_login_id AS edited_login_id_12, t0.created_user_id AS created_user_id_13, t0.edited_user_id AS edited_user_id_14, t0.created_sig_id AS created_sig_id_15, t0.edited_sig_id AS edited_sig_id_16, t0.doc_booked_flag AS doc_booked_flag_17, t0.time_stamp_of_form AS time_stamp_of_form_18 FROM brand_company t0 WHERE t0.status = 1 AND t0.company_id IS NULL;

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.status = ?

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.status = 1;