Query Metrics
8
Database Queries
8
Different statements
5.46 ms
Query time
0
Invalid entities
24
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.08 ms |
SELECT text_value FROM oro_config_value WHERE name = ? AND section = ?
Parameters:
[ "is_installed" "oro_distribution" ] |
| 2 | 0.16 ms |
SET application_name TO '7f8c55e9d88514510d281f85fb0d276d'
Parameters:
[] |
| 3 | 0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8, t0.guest_role_id AS guest_role_id_9, t0.default_role_id AS default_role_id_10 FROM oro_website t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
1
]
|
| 4 | 0.52 ms |
SELECT o0_.role AS role_0 FROM oro_customer_user_role o0_ WHERE o0_.id = ?
Parameters:
[
3
]
|
| 5 | 0.58 ms |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.formatting_code AS formatting_code_2, o0_.rtl_mode AS rtl_mode_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.serialized_data AS serialized_data_6, o0_.language_id AS language_id_7, o0_.parent_id AS parent_id_8 FROM oro_localization o0_ ORDER BY o0_.name ASC
Parameters:
[] |
| 6 | 0.33 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.installed_build_date AS installed_build_date_4, t0.local_files_language AS local_files_language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.organization_id AS organization_id_8 FROM oro_language t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.29 ms |
SELECT o0_.theme AS theme_0 FROM oro_theme_configuration o0_ WHERE o0_.id = ?
Parameters:
[
1
]
|
| 8 | 1.93 ms |
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.sku_uppercase AS sku_uppercase_3, t0.status AS status_4, t0.variant_fields AS variant_fields_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type AS type_8, t0.is_featured AS is_featured_9, t0.is_new_arrival AS is_new_arrival_10, t0.name AS name_11, t0.name_uppercase AS name_uppercase_12, t0.kit_shipping_calculation_method AS kit_shipping_calculation_method_13, t0.category_sort_order AS category_sort_order_14, t0.availability_date AS availability_date_15, t0.serialized_data AS serialized_data_16, t0.business_unit_owner_id AS business_unit_owner_id_17, t0.organization_id AS organization_id_18, t0.primary_unit_precision_id AS primary_unit_precision_id_19, t0.default_variant_id AS default_variant_id_20, t0.attribute_family_id AS attribute_family_id_21, t0.brand_id AS brand_id_22, t0.category_id AS category_id_23, t0.taxCode_id AS taxcode_id_24, t0.pageTemplate_id AS pagetemplate_id_25, t0.manageInventory_id AS manageinventory_id_26, t0.highlightLowInventory_id AS highlightlowinventory_id_27, t0.inventoryThreshold_id AS inventorythreshold_id_28, t0.lowInventoryThreshold_id AS lowinventorythreshold_id_29, t0.minimumQuantityToOrder_id AS minimumquantitytoorder_id_30, t0.maximumQuantityToOrder_id AS maximumquantitytoorder_id_31, t0.decrementQuantity_id AS decrementquantity_id_32, t0.backOrder_id AS backorder_id_33, t0.isUpcoming_id AS isupcoming_id_34 FROM oro_product t0 WHERE t0.id = ?
Parameters:
[
"38"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| session | doctrine.dbal.session_connection |
| config | doctrine.dbal.config_connection |
| message_queue | doctrine.dbal.message_queue_connection |
| sql_validator | doctrine.dbal.sql_validator_connection |
| search | doctrine.dbal.search_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| config | doctrine.orm.config_entity_manager |
| message_queue | doctrine.orm.message_queue_entity_manager |
| batch | doctrine.orm.batch_entity_manager |
| search | doctrine.orm.search_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Oro\Bundle\LocaleBundle\Entity\Localization | 8 |
| Oro\Bundle\TranslationBundle\Entity\Language | 8 |
| Oro\Bundle\CustomerBundle\Entity\CustomerUserRole | 2 |
| Oro\Bundle\WebsiteBundle\Entity\Website | 1 |
| Oro\Bundle\OrganizationBundle\Entity\BusinessUnit | 1 |
| Oro\Bundle\OrganizationBundle\Entity\Organization | 1 |
| Oro\Bundle\ProductBundle\Entity\Product | 1 |
| Oro\Bundle\ProductBundle\Entity\ProductUnitPrecision | 1 |
| Oro\Bundle\EntityConfigBundle\Attribute\Entity\AttributeFamily | 1 |
config entity manager
| Class | Amount of managed objects |
|---|
message_queue entity manager
| Class | Amount of managed objects |
|---|
batch entity manager
| Class | Amount of managed objects |
|---|
search entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
config entity manager
No loaded entities.
message_queue entity manager
No loaded entities.
batch entity manager
No loaded entities.
search entity manager
No loaded entities.