GET http://tafsir.rawafedtech.info/admin/authors/app/bestauthoradmin/new

Query Metrics

9 Database Queries
7 Different statements
90.10 ms Query time
0 Invalid entities
4765 Managed entities

Queries

Group similar statements

# Time Info
1 2.10 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.25 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.22 ms
SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_
Parameters:
[]
4 1.15 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 0.76 ms
SELECT a0_.id AS id_0, a0_.author_id AS author_id_1 FROM author_best a0_
Parameters:
[]
6 80.68 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.website AS website_2, a0_.email AS email_3, a0_.phone AS phone_4, a0_.fax AS fax_5, a0_.photo AS photo_6, a0_.is_enabled AS is_enabled_7, a0_.is_active AS is_active_8, a0_.popularity AS popularity_9, a0_.views_count AS views_count_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.deleted_at AS deleted_at_13, a0_.extra_fields AS extra_fields_14, a1_.name AS name_15, a1_.brief_biography AS brief_biography_16, a1_.full_biography AS full_biography_17, a1_.deleted_at AS deleted_at_18, a1_.locale AS locale_19, a0_.country_id AS country_id_20, a0_.user_id AS user_id_21, a0_.created_by AS created_by_22, a0_.updated_by AS updated_by_23, a1_.id AS id_24 FROM author a0_ INNER JOIN author_translation a1_ ON a0_.id = a1_.id AND (a1_.locale = 'ar') AND (a1_.deleted_at IS NULL) AND (a1_.deleted_at IS NULL) WHERE (a1_.locale = ? AND a0_.id NOT IN (108, 164, 242, 2388, 3341)) AND (a0_.deleted_at IS NULL) AND (a0_.deleted_at IS NULL) ORDER BY a1_.name ASC
Parameters:
[
  "ar"
]
7 0.82 ms
SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_
Parameters:
[]
8 0.98 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
]
9 1.13 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\AuthorsBundle\Entity\Author 2129
Rawafed\AuthorsBundle\Entity\AuthorTranslation 2124
Rawafed\SecurityBundle\Entity\Role 423
Rawafed\CommonsBundle\Entity\Country 45
Rawafed\ContentManagementBundle\Entity\ContentType 29
Rawafed\UserBundle\Entity\User 9
App\Entity\BestAuthor 5
Rawafed\AdminBundle\Entity\Favorite 1

tq entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
Rawafed\SecurityBundle\Entity\Role No errors.
Rawafed\SecurityBundle\Entity\RoleRoute No errors.
Rawafed\UserBundle\Entity\Group No errors.
Rawafed\ContentManagementBundle\Entity\ContentType No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsMessage No errors.
FOS\UserBundle\Model\User No errors.
Rawafed\UserBundle\Entity\User No errors.
Rawafed\CommentsBundle\Entity\Comment No errors.
Rawafed\RuntimeConfigBundle\Entity\Parameter No errors.
Rawafed\ContentOrganizationBundle\Entity\Collection No errors.
Rawafed\HWIFOSUserBundle\Entity\HWIUserExtraFields No errors.
Rawafed\AuthorsBundle\Entity\Author No errors.
App\Entity\BestAuthor No errors.
Rawafed\AuthorsBundle\Entity\AuthorTranslation No errors.
Rawafed\CommonsBundle\Entity\Country No errors.
Rawafed\AdminBundle\Entity\Favorite No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsMessageReply No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsCategory No errors.
Rawafed\CommentsBundle\Entity\CommentsThread No errors.
Rawafed\CommentsBundle\Entity\CommentLike No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterGroup No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterTranslation No errors.
Rawafed\ContentOrganizationBundle\Entity\Category No errors.
Rawafed\ContentOrganizationBundle\Entity\Aggregate No errors.
Rawafed\ContentManagementBundle\Entity\Entry No errors.
Rawafed\ContentOrganizationBundle\Entity\CollectionSocialPublisher No errors.
Rawafed\CommonsBundle\Entity\City No errors.
Rawafed\CommonsBundle\Entity\CountryTranslation No errors.
App\Entity\ChosenEntry No errors.
App\Entity\ContentTypeTags No errors.
Rawafed\CommonsBundle\Entity\Timezone No errors.
Rawafed\CommonsBundle\Entity\Group No errors.
Rawafed\CommonsBundle\Entity\HWIUserExtraFields No errors.
Rawafed\CommonsBundle\Entity\ProfileInterestsThread No errors.
Rawafed\CommonsBundle\Entity\User No errors.
Rawafed\CommonsBundle\Entity\UserProfile No errors.
Rawafed\CommonsBundle\Entity\UserTitle No errors.
Rawafed\CommonsBundle\Entity\UserTitleTranslation No errors.
Rawafed\CommonsBundle\Entity\ViewsIntermediate No errors.
Rawafed\AdminBundle\Entity\AdminBundle No errors.
Rawafed\AdminBundle\Entity\AdminSidemenu No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsEmailRecipient No errors.
Rawafed\ReportViewerBundle\Entity\ReportviewerCache No errors.
Rawafed\ContentOrganizationBundle\Entity\CategoryTranslation No errors.
Rawafed\ContentOrganizationBundle\Entity\Tag No errors.
Rawafed\ContentManagementBundle\Entity\ContentSource No errors.
Rawafed\ContentManagementBundle\Entity\EntryProperty No errors.
Rawafed\ContentManagementBundle\Entity\EntryResource No errors.
Rawafed\ContentManagementBundle\Entity\EntryRelationship No errors.
Rawafed\ContentManagementBundle\Entity\RelatedLink No errors.
Rawafed\ContentManagementBundle\Entity\EntrySocialPublisher No errors.
Rawafed\ContentManagementBundle\Entity\EntryCounters No errors.
Rawafed\ContentManagementBundle\Entity\UserFavourite No errors.
Rawafed\ContentManagementBundle\Entity\ContentSourceTranslation No errors.
Rawafed\ContentManagementBundle\Entity\EntryBookmark No errors.
Rawafed\ContentManagementBundle\Entity\EntryRate No errors.
Rawafed\ContentManagementBundle\Entity\ResourceType No errors.
Rawafed\ContentManagementBundle\Entity\TopEntries No errors.
Rawafed\ContentManagementBundle\Entity\EntryResourceUserProperty No errors.
Rawafed\NavigationBundle\Entity\NavigationMenu No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterGroupTranslation No errors.
Rawafed\AdvancedSeoBundle\Entity\TermType No errors.
Rawafed\AdvancedSeoBundle\Entity\Term No errors.
Rawafed\NewsletterBundle\Entity\Newsletter No errors.
Rawafed\NewsletterBundle\Entity\NewsletterEmail No errors.
Rawafed\NewsletterBundle\Entity\NewsletterEmailgroup No errors.
Rawafed\NewsletterBundle\Entity\NewsletterTransaction No errors.
Rawafed\NewsletterBundle\Entity\NewsletterTransactionDetails No errors.
Rawafed\SolrSearchBundle\Entity\LogEntry No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformData No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformField No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformFieldproperty No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformForm No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformSection No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformSubmission No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformVersion No errors.
Rawafed\AdsBundle\Entity\Campaign No errors.
Rawafed\AdsBundle\Entity\Zone No errors.
Rawafed\AdsBundle\Entity\Banner No errors.
Rawafed\AdsBundle\Entity\BannerState No errors.
Rawafed\AdsBundle\Entity\Impression No errors.
Rawafed\PageComposerBundle\Entity\Block No errors.
Rawafed\PageComposerBundle\Entity\Container No errors.
Rawafed\PageComposerBundle\Entity\Page No errors.
Rawafed\PageComposerBundle\Entity\Widget No errors.
Rawafed\PageComposerBundle\Entity\Zone No errors.
Rawafed\MonitoringBundle\Entity\MonitoringMetrics No errors.
Rawafed\MonitoringBundle\Entity\MonitoringWindow No errors.
Rawafed\JobsListBundle\Entity\Job No errors.
Rawafed\JobsListBundle\Entity\JobItem No errors.
Rawafed\JobsListBundle\Entity\JobParameter No errors.
Rawafed\JobsListBundle\Entity\JobStatus No errors.
Rawafed\SocialPublisherBundle\Entity\Post No errors.
Rawafed\VideoBundle\Entity\Channel No errors.
Vich\UploaderBundle\Entity\File No errors.

tq entity manager

Class Mapping errors
Rawafed\TaskQueueBundle\Entity\Task No errors.