Query Metrics

8 Database Queries
8 Different statements
4.83 ms Query time
0 Invalid entities
25 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.24 ms
(25.61%)
1
SELECT text_value FROM oro_config_value WHERE name = ? AND section = ?
Parameters:
[
  "is_installed"
  "oro_distribution"
]
0.78 ms
(16.09%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.filename AS filename_3, t0.extension AS extension_4, t0.mime_type AS mime_type_5, t0.original_filename AS original_filename_6, t0.file_size AS file_size_7, t0.parent_entity_class AS parent_entity_class_8, t0.parent_entity_id AS parent_entity_id_9, t0.parent_entity_field_name AS parent_entity_field_name_10, t0.external_url AS external_url_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.serialized_data AS serialized_data_14, t0.owner_user_id AS owner_user_id_15, t0.digitalAsset_id AS digitalasset_id_16 FROM oro_attachment_file t0 WHERE t0.id = ?
Parameters:
[
  152
]
0.75 ms
(15.46%)
1
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
]
0.61 ms
(12.57%)
1
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:
[]
0.57 ms
(11.72%)
1
SELECT o0_.role AS role_0 FROM oro_customer_user_role o0_ WHERE o0_.id = ?
Parameters:
[
  3
]
0.40 ms
(8.21%)
1
SELECT o0_.theme AS theme_0 FROM oro_theme_configuration o0_ WHERE o0_.id = ?
Parameters:
[
  1
]
0.36 ms
(7.40%)
1
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
]
0.14 ms
(2.94%)
1
SET application_name TO 'bc0a32ccb168e9cb087676014c38d094'
Parameters:
[]

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\CustomerBundle\Entity\CustomerGroup 1
Oro\Bundle\AttachmentBundle\Entity\File 1
Oro\Bundle\UserBundle\Entity\User 1
Oro\Bundle\DigitalAssetBundle\Entity\DigitalAsset 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