Symfony Profiler

SELECT
  i0_.id AS id_0,
  i0_.global_id AS global_id_1,
  i0_.sync_flag AS sync_flag_2,
  i0_.class_suffix AS class_suffix_3,
  i0_.name AS name_4,
  i0_.product_name_fdm AS product_name_fdm_5,
  i0_.model_no AS model_no_6,
  i0_.product_fdm AS product_fdm_7,
  i0_.categorization_pending AS categorization_pending_8,
  i0_.global_fdm AS global_fdm_9,
  i0_.part_id AS part_id_10,
  i0_.auto_generate_serial AS auto_generate_serial_11,
  i0_.sku_code AS sku_code_12,
  i0_.default_color_id AS default_color_id_13,
  i0_.default_size AS default_size_14,
  i0_.colors AS colors_15,
  i0_.colors_data AS colors_data_16,
  i0_.sizes AS sizes_17,
  i0_.sizes_data AS sizes_data_18,
  i0_.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_19,
  i0_.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_20,
  i0_.tax_config_ids AS tax_config_ids_21,
  i0_.default_tax_config_id AS default_tax_config_id_22,
  i0_.purchase_tax_config_ids AS purchase_tax_config_ids_23,
  i0_.default_purchase_tax_config_id AS default_purchase_tax_config_id_24,
  i0_.inco_terms AS inco_terms_25,
  i0_.default_inco_term AS default_inco_term_26,
  i0_.tac AS tac_27,
  i0_.weight AS weight_28,
  i0_.weight_unit_type_id AS weight_unit_type_id_29,
  i0_.weight_variance_value AS weight_variance_value_30,
  i0_.weight_variance_type AS weight_variance_type_31,
  i0_.single_weight AS single_weight_32,
  i0_.single_weight_unit_type_id AS single_weight_unit_type_id_33,
  i0_.single_weight_variance_value AS single_weight_variance_value_34,
  i0_.single_weight_variance_type AS single_weight_variance_type_35,
  i0_.carton_capacity_count AS carton_capacity_count_36,
  i0_.default_label_format_id AS default_label_format_id_37,
  i0_.label_format_ids_by_type AS label_format_ids_by_type_38,
  i0_.dimension AS dimension_39,
  i0_.dimension_unit_type_id AS dimension_unit_type_id_40,
  i0_.crate_data AS crate_data_41,
  i0_.type AS type_42,
  i0_.product_type AS product_type_43,
  i0_.product_code AS product_code_44,
  i0_.specification_types AS specification_types_45,
  i0_.spec_data AS spec_data_46,
  i0_.hs_code AS hs_code_47,
  i0_.mushak_description AS mushak_description_48,
  i0_.epc_category_code AS epc_category_code_49,
  i0_.specification_id AS specification_id_50,
  i0_.sub_category_id AS sub_category_id_51,
  i0_.specification_ids AS specification_ids_52,
  i0_.category_id AS category_id_53,
  i0_.ig_id AS ig_id_54,
  i0_.has_serial AS has_serial_55,
  i0_.dr_accounts_head_id AS dr_accounts_head_id_56,
  i0_.cr_accounts_head_id AS cr_accounts_head_id_57,
  i0_.brand_company AS brand_company_58,
  i0_.company_id AS company_id_59,
  i0_.specification AS specification_60,
  i0_.ingredient AS ingredient_61,
  i0_.nutrition AS nutrition_62,
  i0_.tags AS tags_63,
  i0_.marker_flags AS marker_flags_64,
  i0_.yearly_depreciation AS yearly_depreciation_65,
  i0_.purchase_warranty_months AS purchase_warranty_months_66,
  i0_.sales_warranty_months AS sales_warranty_months_67,
  i0_.starting_balance_unit AS starting_balance_unit_68,
  i0_.qty AS qty_69,
  i0_.booking_qty AS booking_qty_70,
  i0_.non_invoiced_qty AS non_invoiced_qty_71,
  i0_.non_sales_invoiced_qty AS non_sales_invoiced_qty_72,
  i0_.non_sales_return_received_qty AS non_sales_return_received_qty_73,
  i0_.physical_qty AS physical_qty_74,
  i0_.warehouse_id AS warehouse_id_75,
  i0_.ledger_hit_as AS ledger_hit_as_76,
  i0_.default_purchase_action_tag_id AS default_purchase_action_tag_id_77,
  i0_.default_expense_id AS default_expense_id_78,
  i0_.vat_as_expense_flag AS vat_as_expense_flag_79,
  i0_.sellable AS sellable_80,
  i0_.abstract AS abstract_81,
  i0_.default_image AS default_image_82,
  i0_.data_sheets AS data_sheets_83,
  i0_.images AS images_84,
  i0_.expiry_days AS expiry_days_85,
  i0_.unit_type_id AS unit_type_id_86,
  i0_.curr_purchase_price AS curr_purchase_price_87,
  i0_.purchase_price_wo_expense AS purchase_price_wo_expense_88,
  i0_.curr_sales_price AS curr_sales_price_89,
  i0_.price_for_servicing_need AS price_for_servicing_need_90,
  i0_.min_margin_percent AS min_margin_percent_91,
  i0_.reorder_level AS reorder_level_92,
  i0_.expense_id AS expense_id_93,
  i0_.expense_cost AS expense_cost_94,
  i0_.note AS note_95,
  i0_.alias AS alias_96,
  i0_.status AS status_97,
  i0_.created_login_id AS created_login_id_98,
  i0_.edited_login_id AS edited_login_id_99,
  i0_.created_user_id AS created_user_id_100,
  i0_.edited_user_id AS edited_user_id_101,
  i0_.created_sig_id AS created_sig_id_102,
  i0_.edited_sig_id AS edited_sig_id_103,
  i0_.doc_booked_flag AS doc_booked_flag_104,
  i0_.time_stamp_of_form AS time_stamp_of_form_105,
  i0_.pending_data AS pending_data_106,
  i0_.local_overrides AS local_overrides_107,
  i0_.disposition_method AS disposition_method_108
FROM
  inv_products i0_
WHERE
  (i0_.status = 1)
ORDER BY
  i0_.id DESC
LIMIT
  10

SELECT i0_.id AS id_0, i0_.global_id AS global_id_1, i0_.sync_flag AS sync_flag_2, i0_.class_suffix AS class_suffix_3, i0_.name AS name_4, i0_.product_name_fdm AS product_name_fdm_5, i0_.model_no AS model_no_6, i0_.product_fdm AS product_fdm_7, i0_.categorization_pending AS categorization_pending_8, i0_.global_fdm AS global_fdm_9, i0_.part_id AS part_id_10, i0_.auto_generate_serial AS auto_generate_serial_11, i0_.sku_code AS sku_code_12, i0_.default_color_id AS default_color_id_13, i0_.default_size AS default_size_14, i0_.colors AS colors_15, i0_.colors_data AS colors_data_16, i0_.sizes AS sizes_17, i0_.sizes_data AS sizes_data_18, i0_.segregate_price_by_sizes_flag AS segregate_price_by_sizes_flag_19, i0_.segregate_price_by_colors_flag AS segregate_price_by_colors_flag_20, i0_.tax_config_ids AS tax_config_ids_21, i0_.default_tax_config_id AS default_tax_config_id_22, i0_.purchase_tax_config_ids AS purchase_tax_config_ids_23, i0_.default_purchase_tax_config_id AS default_purchase_tax_config_id_24, i0_.inco_terms AS inco_terms_25, i0_.default_inco_term AS default_inco_term_26, i0_.tac AS tac_27, i0_.weight AS weight_28, i0_.weight_unit_type_id AS weight_unit_type_id_29, i0_.weight_variance_value AS weight_variance_value_30, i0_.weight_variance_type AS weight_variance_type_31, i0_.single_weight AS single_weight_32, i0_.single_weight_unit_type_id AS single_weight_unit_type_id_33, i0_.single_weight_variance_value AS single_weight_variance_value_34, i0_.single_weight_variance_type AS single_weight_variance_type_35, i0_.carton_capacity_count AS carton_capacity_count_36, i0_.default_label_format_id AS default_label_format_id_37, i0_.label_format_ids_by_type AS label_format_ids_by_type_38, i0_.dimension AS dimension_39, i0_.dimension_unit_type_id AS dimension_unit_type_id_40, i0_.crate_data AS crate_data_41, i0_.type AS type_42, i0_.product_type AS product_type_43, i0_.product_code AS product_code_44, i0_.specification_types AS specification_types_45, i0_.spec_data AS spec_data_46, i0_.hs_code AS hs_code_47, i0_.mushak_description AS mushak_description_48, i0_.epc_category_code AS epc_category_code_49, i0_.specification_id AS specification_id_50, i0_.sub_category_id AS sub_category_id_51, i0_.specification_ids AS specification_ids_52, i0_.category_id AS category_id_53, i0_.ig_id AS ig_id_54, i0_.has_serial AS has_serial_55, i0_.dr_accounts_head_id AS dr_accounts_head_id_56, i0_.cr_accounts_head_id AS cr_accounts_head_id_57, i0_.brand_company AS brand_company_58, i0_.company_id AS company_id_59, i0_.specification AS specification_60, i0_.ingredient AS ingredient_61, i0_.nutrition AS nutrition_62, i0_.tags AS tags_63, i0_.marker_flags AS marker_flags_64, i0_.yearly_depreciation AS yearly_depreciation_65, i0_.purchase_warranty_months AS purchase_warranty_months_66, i0_.sales_warranty_months AS sales_warranty_months_67, i0_.starting_balance_unit AS starting_balance_unit_68, i0_.qty AS qty_69, i0_.booking_qty AS booking_qty_70, i0_.non_invoiced_qty AS non_invoiced_qty_71, i0_.non_sales_invoiced_qty AS non_sales_invoiced_qty_72, i0_.non_sales_return_received_qty AS non_sales_return_received_qty_73, i0_.physical_qty AS physical_qty_74, i0_.warehouse_id AS warehouse_id_75, i0_.ledger_hit_as AS ledger_hit_as_76, i0_.default_purchase_action_tag_id AS default_purchase_action_tag_id_77, i0_.default_expense_id AS default_expense_id_78, i0_.vat_as_expense_flag AS vat_as_expense_flag_79, i0_.sellable AS sellable_80, i0_.abstract AS abstract_81, i0_.default_image AS default_image_82, i0_.data_sheets AS data_sheets_83, i0_.images AS images_84, i0_.expiry_days AS expiry_days_85, i0_.unit_type_id AS unit_type_id_86, i0_.curr_purchase_price AS curr_purchase_price_87, i0_.purchase_price_wo_expense AS purchase_price_wo_expense_88, i0_.curr_sales_price AS curr_sales_price_89, i0_.price_for_servicing_need AS price_for_servicing_need_90, i0_.min_margin_percent AS min_margin_percent_91, i0_.reorder_level AS reorder_level_92, i0_.expense_id AS expense_id_93, i0_.expense_cost AS expense_cost_94, i0_.note AS note_95, i0_.alias AS alias_96, i0_.status AS status_97, i0_.created_login_id AS created_login_id_98, i0_.edited_login_id AS edited_login_id_99, i0_.created_user_id AS created_user_id_100, i0_.edited_user_id AS edited_user_id_101, i0_.created_sig_id AS created_sig_id_102, i0_.edited_sig_id AS edited_sig_id_103, i0_.doc_booked_flag AS doc_booked_flag_104, i0_.time_stamp_of_form AS time_stamp_of_form_105, i0_.pending_data AS pending_data_106, i0_.local_overrides AS local_overrides_107, i0_.disposition_method AS disposition_method_108 FROM inv_products i0_ WHERE (i0_.status = 1) ORDER BY i0_.id DESC LIMIT 10;

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  inv_products i0_
WHERE
  (i0_.status = 1)

SELECT COUNT(i0_.id) AS sclr_0 FROM inv_products i0_ WHERE (i0_.status = 1);