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.ait_certificate_no AS ait_certificate_no_34,
  t0.uen AS uen_35,
  t0.ssic_code AS ssic_code_36,
  t0.incorporation_date AS incorporation_date_37,
  t0.financial_year_end AS financial_year_end_38,
  t0.user_allowed AS user_allowed_39,
  t0.user_allocated AS user_allocated_40,
  t0.user_remaining AS user_remaining_41,
  t0.admin_user_allowed AS admin_user_allowed_42,
  t0.admin_user_allocated AS admin_user_allocated_43,
  t0.admin_user_remaining AS admin_user_remaining_44,
  t0.me_str AS me_str_45,
  t0.cash AS cash_46,
  t0.bank AS bank_47,
  t0.sales AS sales_48,
  t0.asset AS asset_49,
  t0.liability AS liability_50,
  t0.expense AS expense_51,
  t0.revenue AS revenue_52,
  t0.payable AS payable_53,
  t0.receivable AS receivable_54,
  t0.net_worth AS net_worth_55,
  t0.monthly_growth AS monthly_growth_56,
  t0.wacc AS wacc_57,
  t0.active AS active_58,
  t0.company_status AS company_status_59,
  t0.package_type AS package_type_60,
  t0.subscription_expiry AS subscription_expiry_61,
  t0.last_activity_at AS last_activity_at_62,
  t0.company_description AS company_description_63,
  t0.created_at AS created_at_64,
  t0.updated_at AS updated_at_65,
  t0.doc_booked_flag AS doc_booked_flag_66,
  t0.time_stamp_of_form AS time_stamp_of_form_67
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.ait_certificate_no AS ait_certificate_no_34, t0.uen AS uen_35, t0.ssic_code AS ssic_code_36, t0.incorporation_date AS incorporation_date_37, t0.financial_year_end AS financial_year_end_38, t0.user_allowed AS user_allowed_39, t0.user_allocated AS user_allocated_40, t0.user_remaining AS user_remaining_41, t0.admin_user_allowed AS admin_user_allowed_42, t0.admin_user_allocated AS admin_user_allocated_43, t0.admin_user_remaining AS admin_user_remaining_44, t0.me_str AS me_str_45, t0.cash AS cash_46, t0.bank AS bank_47, t0.sales AS sales_48, t0.asset AS asset_49, t0.liability AS liability_50, t0.expense AS expense_51, t0.revenue AS revenue_52, t0.payable AS payable_53, t0.receivable AS receivable_54, t0.net_worth AS net_worth_55, t0.monthly_growth AS monthly_growth_56, t0.wacc AS wacc_57, t0.active AS active_58, t0.company_status AS company_status_59, t0.package_type AS package_type_60, t0.subscription_expiry AS subscription_expiry_61, t0.last_activity_at AS last_activity_at_62, t0.company_description AS company_description_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.doc_booked_flag AS doc_booked_flag_66, t0.time_stamp_of_form AS time_stamp_of_form_67 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.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.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.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.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;

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;