Query Metrics

7 Database Queries
6 Different statements
12.33 ms Query time
0 Invalid entities
926 Managed entities

Queries

Group similar statements

# Time Info
1 1.77 ms
SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ ORDER BY c0_.root ASC, c0_.lft ASC
Parameters:
[]
2 1.45 ms
SELECT t0.id AS id_1, t0.package AS package_2, t0.name AS name_3, t0.description AS description_4, t0.display_name AS display_name_5, t0.list_name AS list_name_6, t0.is_internal AS is_internal_7, t0.is_categorizable AS is_categorizable_8, t0.is_fileable AS is_fileable_9, t0.is_printable AS is_printable_10, t0.is_embeddable AS is_embeddable_11, t0.is_searchable AS is_searchable_12, t0.is_queryable AS is_queryable_13, t0.accepts_comments AS accepts_comments_14, t0.has_authors AS has_authors_15, t0.has_attachments AS has_attachments_16, t0.has_source AS has_source_17, t0.has_tags AS has_tags_18, t0.has_summary AS has_summary_19, t0.has_aggregates AS has_aggregates_20 FROM content_type t0
Parameters:
[]
3 1.15 ms
SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_
Parameters:
[]
4 1.17 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.real_name AS real_name_13, t0.updated_at AS updated_at_14, t0.created_at AS created_at_15, t0.image_name AS image_name_16, t0.reporting_reference_id AS reporting_reference_id_17, t0.reporting_banned AS reporting_banned_18, t0.reporting_immuned AS reporting_immuned_19, t0.is_system AS is_system_20, t0.public_id AS public_id_21 FROM cms_users t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
5 4.78 ms
SELECT c0_.id AS id_0, c0_.alpha3_code AS alpha3_code_1, c0_.numeric_code AS numeric_code_2, c0_.calling_code AS calling_code_3, c0_.default_locale AS default_locale_4, c1_.name AS name_5, c1_.locale AS locale_6, c1_.id AS id_7 FROM country c0_ INNER JOIN country_translation c1_ ON c0_.id = c1_.id AND (c1_.locale = 'ar') ORDER BY c1_.name ASC
Parameters:
[]
6 0.88 ms
SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_
Parameters:
[]
7 1.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.params AS params_4, t0.icon AS icon_5, t0.user_id AS user_id_6 FROM admin_favorite t0 WHERE t0.user_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
tq doctrine.orm.tq_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Rawafed\SecurityBundle\Entity\Role 423
Rawafed\CommonsBundle\Entity\Country 236
Rawafed\CommonsBundle\Entity\CountryTranslation 236
Rawafed\ContentManagementBundle\Entity\ContentType 29
Rawafed\UserBundle\Entity\User 1
Rawafed\AdminBundle\Entity\Favorite 1

tq entity manager

Class Amount of managed objects