Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.17 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.17 ms (100.00%)	1	SELECT r0_.id AS id_0, r0_.lang AS lang_1, r0_.time_zone AS time_zone_2, r0_.date_format AS date_format_3, r0_.currency AS currency_4, r0_.decimals AS decimals_5, r0_.decimals_percentage AS decimals_percentage_6, r0_.decimal_separator AS decimal_separator_7, r0_.thousands_separator AS thousands_separator_8, r0_.enable_use_product_barcode AS enable_use_product_barcode_9, r0_.enable_use_product_reference AS enable_use_product_reference_10, r0_.enable_exercise AS enable_exercise_11, r0_.enable_sales_margin AS enable_sales_margin_12, r0_.enable_focus_reference AS enable_focus_reference_13, r0_.enable_out_of_stock_product_warning AS enable_out_of_stock_product_warning_14, r0_.enable_stock_capital_calculation_by_selling_price AS enable_stock_capital_calculation_by_selling_price_15, r0_.enable_strict_mode_entry_stock AS enable_strict_mode_entry_stock_16, r0_.enable_update_prices_from_entry_stock AS enable_update_prices_from_entry_stock_17, r0_.entry_stock_default_payment_mode AS entry_stock_default_payment_mode_18, r0_.return_stock_default_payment_mode AS return_stock_default_payment_mode_19, r0_.out_stock_default_payment_mode AS out_stock_default_payment_mode_20, r0_.entre_material_default_payment_mode AS entre_material_default_payment_mode_21, r0_.enable_update_quantity_from_product_form AS enable_update_quantity_from_product_form_22, r0_.start_ref_entry_stock AS start_ref_entry_stock_23, r0_.start_ref_vente AS start_ref_vente_24, r0_.start_ref_facture AS start_ref_facture_25, r0_.start_ref_devis AS start_ref_devis_26, r0_.start_ref_avoir AS start_ref_avoir_27, r0_.start_ref_avoir_fournisseur AS start_ref_avoir_fournisseur_28, r0_.start_ref_bon_command AS start_ref_bon_command_29, r0_.start_ref_entre_material AS start_ref_entre_material_30, r0_.start_ref_sorti_material AS start_ref_sorti_material_31, r0_.reference_mode AS reference_mode_32, r0_.reference_length AS reference_length_33, r0_.enable_discount_global AS enable_discount_global_34, r0_.enable_tvaglobal AS enable_tvaglobal_35, r0_.enable_system_sntl AS enable_system_sntl_36, r0_.enable_ticket AS enable_ticket_37, r0_.enable_tva AS enable_tva_38, r0_.enable_discount AS enable_discount_39, r0_.enable_create_facture_from_multi_ventes AS enable_create_facture_from_multi_ventes_40 FROM reglage r0_ Parameters: [] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.lang AS lang_1, r0_.time_zone AS time_zone_2, r0_.date_format AS date_format_3, r0_.currency AS currency_4, r0_.decimals AS decimals_5, r0_.decimals_percentage AS decimals_percentage_6, r0_.decimal_separator AS decimal_separator_7, r0_.thousands_separator AS thousands_separator_8, r0_.enable_use_product_barcode AS enable_use_product_barcode_9, r0_.enable_use_product_reference AS enable_use_product_reference_10, r0_.enable_exercise AS enable_exercise_11, r0_.enable_sales_margin AS enable_sales_margin_12, r0_.enable_focus_reference AS enable_focus_reference_13, r0_.enable_out_of_stock_product_warning AS enable_out_of_stock_product_warning_14, r0_.enable_stock_capital_calculation_by_selling_price AS enable_stock_capital_calculation_by_selling_price_15, r0_.enable_strict_mode_entry_stock AS enable_strict_mode_entry_stock_16, r0_.enable_update_prices_from_entry_stock AS enable_update_prices_from_entry_stock_17, r0_.entry_stock_default_payment_mode AS entry_stock_default_payment_mode_18, r0_.return_stock_default_payment_mode AS return_stock_default_payment_mode_19, r0_.out_stock_default_payment_mode AS out_stock_default_payment_mode_20, r0_.entre_material_default_payment_mode AS entre_material_default_payment_mode_21, r0_.enable_update_quantity_from_product_form AS enable_update_quantity_from_product_form_22, r0_.start_ref_entry_stock AS start_ref_entry_stock_23, r0_.start_ref_vente AS start_ref_vente_24, r0_.start_ref_facture AS start_ref_facture_25, r0_.start_ref_devis AS start_ref_devis_26, r0_.start_ref_avoir AS start_ref_avoir_27, r0_.start_ref_avoir_fournisseur AS start_ref_avoir_fournisseur_28, r0_.start_ref_bon_command AS start_ref_bon_command_29, r0_.start_ref_entre_material AS start_ref_entre_material_30, r0_.start_ref_sorti_material AS start_ref_sorti_material_31, r0_.reference_mode AS reference_mode_32, r0_.reference_length AS reference_length_33, r0_.enable_discount_global AS enable_discount_global_34, r0_.enable_tvaglobal AS enable_tvaglobal_35, r0_.enable_system_sntl AS enable_system_sntl_36, r0_.enable_ticket AS enable_ticket_37, r0_.enable_tva AS enable_tva_38, r0_.enable_discount AS enable_discount_39, r0_.enable_create_facture_from_multi_ventes AS enable_create_facture_from_multi_ventes_40 FROM reglage r0_ SELECT r0_.id AS id_0, r0_.lang AS lang_1, r0_.time_zone AS time_zone_2, r0_.date_format AS date_format_3, r0_.currency AS currency_4, r0_.decimals AS decimals_5, r0_.decimals_percentage AS decimals_percentage_6, r0_.decimal_separator AS decimal_separator_7, r0_.thousands_separator AS thousands_separator_8, r0_.enable_use_product_barcode AS enable_use_product_barcode_9, r0_.enable_use_product_reference AS enable_use_product_reference_10, r0_.enable_exercise AS enable_exercise_11, r0_.enable_sales_margin AS enable_sales_margin_12, r0_.enable_focus_reference AS enable_focus_reference_13, r0_.enable_out_of_stock_product_warning AS enable_out_of_stock_product_warning_14, r0_.enable_stock_capital_calculation_by_selling_price AS enable_stock_capital_calculation_by_selling_price_15, r0_.enable_strict_mode_entry_stock AS enable_strict_mode_entry_stock_16, r0_.enable_update_prices_from_entry_stock AS enable_update_prices_from_entry_stock_17, r0_.entry_stock_default_payment_mode AS entry_stock_default_payment_mode_18, r0_.return_stock_default_payment_mode AS return_stock_default_payment_mode_19, r0_.out_stock_default_payment_mode AS out_stock_default_payment_mode_20, r0_.entre_material_default_payment_mode AS entre_material_default_payment_mode_21, r0_.enable_update_quantity_from_product_form AS enable_update_quantity_from_product_form_22, r0_.start_ref_entry_stock AS start_ref_entry_stock_23, r0_.start_ref_vente AS start_ref_vente_24, r0_.start_ref_facture AS start_ref_facture_25, r0_.start_ref_devis AS start_ref_devis_26, r0_.start_ref_avoir AS start_ref_avoir_27, r0_.start_ref_avoir_fournisseur AS start_ref_avoir_fournisseur_28, r0_.start_ref_bon_command AS start_ref_bon_command_29, r0_.start_ref_entre_material AS start_ref_entre_material_30, r0_.start_ref_sorti_material AS start_ref_sorti_material_31, r0_.reference_mode AS reference_mode_32, r0_.reference_length AS reference_length_33, r0_.enable_discount_global AS enable_discount_global_34, r0_.enable_tvaglobal AS enable_tvaglobal_35, r0_.enable_system_sntl AS enable_system_sntl_36, r0_.enable_ticket AS enable_ticket_37, r0_.enable_tva AS enable_tva_38, r0_.enable_discount AS enable_discount_39, r0_.enable_create_facture_from_multi_ventes AS enable_create_facture_from_multi_ventes_40 FROM reglage r0_;

Time▼

Count

Info

1.17 ms
(100.00%)

SELECT r0_.id AS id_0, r0_.lang AS lang_1, r0_.time_zone AS time_zone_2, r0_.date_format AS date_format_3, r0_.currency AS currency_4, r0_.decimals AS decimals_5, r0_.decimals_percentage AS decimals_percentage_6, r0_.decimal_separator AS decimal_separator_7, r0_.thousands_separator AS thousands_separator_8, r0_.enable_use_product_barcode AS enable_use_product_barcode_9, r0_.enable_use_product_reference AS enable_use_product_reference_10, r0_.enable_exercise AS enable_exercise_11, r0_.enable_sales_margin AS enable_sales_margin_12, r0_.enable_focus_reference AS enable_focus_reference_13, r0_.enable_out_of_stock_product_warning AS enable_out_of_stock_product_warning_14, r0_.enable_stock_capital_calculation_by_selling_price AS enable_stock_capital_calculation_by_selling_price_15, r0_.enable_strict_mode_entry_stock AS enable_strict_mode_entry_stock_16, r0_.enable_update_prices_from_entry_stock AS enable_update_prices_from_entry_stock_17, r0_.entry_stock_default_payment_mode AS entry_stock_default_payment_mode_18, r0_.return_stock_default_payment_mode AS return_stock_default_payment_mode_19, r0_.out_stock_default_payment_mode AS out_stock_default_payment_mode_20, r0_.entre_material_default_payment_mode AS entre_material_default_payment_mode_21, r0_.enable_update_quantity_from_product_form AS enable_update_quantity_from_product_form_22, r0_.start_ref_entry_stock AS start_ref_entry_stock_23, r0_.start_ref_vente AS start_ref_vente_24, r0_.start_ref_facture AS start_ref_facture_25, r0_.start_ref_devis AS start_ref_devis_26, r0_.start_ref_avoir AS start_ref_avoir_27, r0_.start_ref_avoir_fournisseur AS start_ref_avoir_fournisseur_28, r0_.start_ref_bon_command AS start_ref_bon_command_29, r0_.start_ref_entre_material AS start_ref_entre_material_30, r0_.start_ref_sorti_material AS start_ref_sorti_material_31, r0_.reference_mode AS reference_mode_32, r0_.reference_length AS reference_length_33, r0_.enable_discount_global AS enable_discount_global_34, r0_.enable_tvaglobal AS enable_tvaglobal_35, r0_.enable_system_sntl AS enable_system_sntl_36, r0_.enable_ticket AS enable_ticket_37, r0_.enable_tva AS enable_tva_38, r0_.enable_discount AS enable_discount_39, r0_.enable_create_facture_from_multi_ventes AS enable_create_facture_from_multi_ventes_40 FROM reglage r0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  r0_.id AS id_0,
  r0_.lang AS lang_1,
  r0_.time_zone AS time_zone_2,
  r0_.date_format AS date_format_3,
  r0_.currency AS currency_4,
  r0_.decimals AS decimals_5,
  r0_.decimals_percentage AS decimals_percentage_6,
  r0_.decimal_separator AS decimal_separator_7,
  r0_.thousands_separator AS thousands_separator_8,
  r0_.enable_use_product_barcode AS enable_use_product_barcode_9,
  r0_.enable_use_product_reference AS enable_use_product_reference_10,
  r0_.enable_exercise AS enable_exercise_11,
  r0_.enable_sales_margin AS enable_sales_margin_12,
  r0_.enable_focus_reference AS enable_focus_reference_13,
  r0_.enable_out_of_stock_product_warning AS enable_out_of_stock_product_warning_14,
  r0_.enable_stock_capital_calculation_by_selling_price AS enable_stock_capital_calculation_by_selling_price_15,
  r0_.enable_strict_mode_entry_stock AS enable_strict_mode_entry_stock_16,
  r0_.enable_update_prices_from_entry_stock AS enable_update_prices_from_entry_stock_17,
  r0_.entry_stock_default_payment_mode AS entry_stock_default_payment_mode_18,
  r0_.return_stock_default_payment_mode AS return_stock_default_payment_mode_19,
  r0_.out_stock_default_payment_mode AS out_stock_default_payment_mode_20,
  r0_.entre_material_default_payment_mode AS entre_material_default_payment_mode_21,
  r0_.enable_update_quantity_from_product_form AS enable_update_quantity_from_product_form_22,
  r0_.start_ref_entry_stock AS start_ref_entry_stock_23,
  r0_.start_ref_vente AS start_ref_vente_24,
  r0_.start_ref_facture AS start_ref_facture_25,
  r0_.start_ref_devis AS start_ref_devis_26,
  r0_.start_ref_avoir AS start_ref_avoir_27,
  r0_.start_ref_avoir_fournisseur AS start_ref_avoir_fournisseur_28,
  r0_.start_ref_bon_command AS start_ref_bon_command_29,
  r0_.start_ref_entre_material AS start_ref_entre_material_30,
  r0_.start_ref_sorti_material AS start_ref_sorti_material_31,
  r0_.reference_mode AS reference_mode_32,
  r0_.reference_length AS reference_length_33,
  r0_.enable_discount_global AS enable_discount_global_34,
  r0_.enable_tvaglobal AS enable_tvaglobal_35,
  r0_.enable_system_sntl AS enable_system_sntl_36,
  r0_.enable_ticket AS enable_ticket_37,
  r0_.enable_tva AS enable_tva_38,
  r0_.enable_discount AS enable_discount_39,
  r0_.enable_create_facture_from_multi_ventes AS enable_create_facture_from_multi_ventes_40
FROM
  reglage r0_

SELECT r0_.id AS id_0, r0_.lang AS lang_1, r0_.time_zone AS time_zone_2, r0_.date_format AS date_format_3, r0_.currency AS currency_4, r0_.decimals AS decimals_5, r0_.decimals_percentage AS decimals_percentage_6, r0_.decimal_separator AS decimal_separator_7, r0_.thousands_separator AS thousands_separator_8, r0_.enable_use_product_barcode AS enable_use_product_barcode_9, r0_.enable_use_product_reference AS enable_use_product_reference_10, r0_.enable_exercise AS enable_exercise_11, r0_.enable_sales_margin AS enable_sales_margin_12, r0_.enable_focus_reference AS enable_focus_reference_13, r0_.enable_out_of_stock_product_warning AS enable_out_of_stock_product_warning_14, r0_.enable_stock_capital_calculation_by_selling_price AS enable_stock_capital_calculation_by_selling_price_15, r0_.enable_strict_mode_entry_stock AS enable_strict_mode_entry_stock_16, r0_.enable_update_prices_from_entry_stock AS enable_update_prices_from_entry_stock_17, r0_.entry_stock_default_payment_mode AS entry_stock_default_payment_mode_18, r0_.return_stock_default_payment_mode AS return_stock_default_payment_mode_19, r0_.out_stock_default_payment_mode AS out_stock_default_payment_mode_20, r0_.entre_material_default_payment_mode AS entre_material_default_payment_mode_21, r0_.enable_update_quantity_from_product_form AS enable_update_quantity_from_product_form_22, r0_.start_ref_entry_stock AS start_ref_entry_stock_23, r0_.start_ref_vente AS start_ref_vente_24, r0_.start_ref_facture AS start_ref_facture_25, r0_.start_ref_devis AS start_ref_devis_26, r0_.start_ref_avoir AS start_ref_avoir_27, r0_.start_ref_avoir_fournisseur AS start_ref_avoir_fournisseur_28, r0_.start_ref_bon_command AS start_ref_bon_command_29, r0_.start_ref_entre_material AS start_ref_entre_material_30, r0_.start_ref_sorti_material AS start_ref_sorti_material_31, r0_.reference_mode AS reference_mode_32, r0_.reference_length AS reference_length_33, r0_.enable_discount_global AS enable_discount_global_34, r0_.enable_tvaglobal AS enable_tvaglobal_35, r0_.enable_system_sntl AS enable_system_sntl_36, r0_.enable_ticket AS enable_ticket_37, r0_.enable_tva AS enable_tva_38, r0_.enable_discount AS enable_discount_39, r0_.enable_create_facture_from_multi_ventes AS enable_create_facture_from_multi_ventes_40 FROM reglage r0_;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Reglage\Reglage	1

Entities Mapping

Class	Mapping errors
App\Entity\Reglage\Reglage	No errors.

Symfony Profiler

GET https://manaimmarrakech.novicore.ma/_profiler

Configuration Settings

Theme

Page Width