Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

88.97 ms Query time

0 Invalid entities

4765 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

80.68 ms
(90.69%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'ar' 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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 314)
21	Rawafed\AdminBundle\Classes\AdminCrudController->getNewActionResponse (line 99)
22	App\Controller\BestAuthorAdminController->newAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

2.10 ms
(2.36%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 96)
6	Rawafed\SecurityBundle\Loader\UserRolesHierarchyLoader->buildRolesTree (line 33)
7	Rawafed\SecurityBundle\Loader\UserRolesHierarchyLoader->__construct (line 3206)
8	ContainerRBvZTkH\App_KernelDevDebugContainer::getSecurity_RoleHierarchyService (line 920)
9	ContainerRBvZTkH\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2139)
10	ContainerRBvZTkH\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1285)
11	ContainerRBvZTkH\App_KernelDevDebugContainer::{closure:ContainerRBvZTkH\App_KernelDevDebugContainer::getEventDispatcherService():1285} (line 235)
12	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
13	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

2.05 ms
(2.30%)

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.name AS name_0,
  r0_.value AS value_1
FROM
  runtime_parameter r0_

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 121)
7	Rawafed\RuntimeConfigBundle\Repository\ParameterRepository->getParametersAsKeyValueHash (line 83)
8	Rawafed\RuntimeConfigBundle\Service\RuntimeParameterBag->initialize (line 49)
9	Rawafed\RuntimeConfigBundle\Service\RuntimeParameterBag->get (line 3460)
10	ContainerRBvZTkH\App_KernelDevDebugContainer::getTwigService (line 921)
11	ContainerRBvZTkH\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2139)
12	ContainerRBvZTkH\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1285)
13	ContainerRBvZTkH\App_KernelDevDebugContainer::{closure:ContainerRBvZTkH\App_KernelDevDebugContainer::getEventDispatcherService():1285} (line 235)
14	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
15	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.25 ms
(1.41%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 42)
5	Rawafed\ContentManagementBundle\Repository\ContentTypeRepository->getContentTypes (line 143)
6	Rawafed\ContentManagementBundle\Service\ContentTypeManager->initialize (line 88)
7	Rawafed\ContentManagementBundle\Service\ContentTypeManager->isContentTypeRegistered (line 43)
8	Rawafed\ContentManagementBundle\Service\ContentTypeManager->registerContentTypes (line 1918)
9	ContainerRBvZTkH\App_KernelDevDebugContainer::getContentTypeManagerService (line 1696)
10	ContainerRBvZTkH\App_KernelDevDebugContainer::getMenuManagerService (line 3460)
11	ContainerRBvZTkH\App_KernelDevDebugContainer::getTwigService (line 921)
12	ContainerRBvZTkH\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2139)
13	ContainerRBvZTkH\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1285)
14	ContainerRBvZTkH\App_KernelDevDebugContainer::{closure:ContainerRBvZTkH\App_KernelDevDebugContainer::getEventDispatcherService():1285} (line 235)
15	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
16	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.15 ms
(1.29%)

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
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 67)
4	FOS\UserBundle\Doctrine\UserManager->findUserBy (line 60)
5	FOS\UserBundle\Security\UserProvider->refreshUser (line 214)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
9	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.98 ms
(1.10%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 123)
4	Rawafed\AdminBundle\Classes\DashboardManager->getFavorites (line 205)
5	Rawafed\AdminBundle\Controller\AdminController->favoritesAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 434)
13	__TwigTemplate_97d3d6912ce86a1ff49b4dfb29c6e8b4->doDisplay (line 402)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_8eb3976c482b429c9d5aaa9856ace00a->doDisplay (line 402)
16	Twig\Template->yield (line 58)
17	__TwigTemplate_d52e81e095f4f46024be672d2310e3c4->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 318)
26	Rawafed\AdminBundle\Classes\AdminCrudController->getNewActionResponse (line 99)
27	App\Controller\BestAuthorAdminController->newAction (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.76 ms
(0.85%)

SELECT a0_.id AS id_0, a0_.author_id AS author_id_1 FROM author_best a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.author_id AS author_id_1
FROM
  author_best a0_

SELECT a0_.id AS id_0, a0_.author_id AS author_id_1 FROM author_best a0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 25)
7	App\Form\BestAuthorType->{closure:App\Form\BestAuthorType::buildForm():23} (line 35)
8	Symfony\Bridge\Doctrine\Form\Type\EntityType->{closure:Symfony\Bridge\Doctrine\Form\Type\EntityType::configureOptions():33} (line 1128)
9	Symfony\Component\OptionsResolver\OptionsResolver->offsetGet (line 126)
10	Symfony\Bridge\Doctrine\Form\Type\DoctrineType->{closure:Symfony\Bridge\Doctrine\Form\Type\DoctrineType::configureOptions():118} (line 1007)
11	Symfony\Component\OptionsResolver\OptionsResolver->offsetGet (line 905)
12	Symfony\Component\OptionsResolver\OptionsResolver->resolve (line 76)
13	Symfony\Component\Form\ResolvedFormType->createBuilder (line 61)
14	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 54)
15	Symfony\Component\Form\FormFactory->createNamedBuilder (line 85)
16	Symfony\Component\Form\FormBuilder->create (line 212)
17	Symfony\Component\Form\FormBuilder->resolveChildren (line 165)
18	Symfony\Component\Form\FormBuilder->getForm (line 28)
19	Symfony\Component\Form\FormFactory->create (line 340)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 398)
21	Rawafed\AdminBundle\Classes\AdminCrudController->createCreateForm (line 310)
22	Rawafed\AdminBundle\Classes\AdminCrudController->getNewActionResponse (line 99)
23	App\Controller\BestAuthorAdminController->newAction (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

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.

tq entity manager

No loaded entities.

Symfony Profiler

GET http://tafsir.rawafedtech.info/_fragment?_path=_format%3Dhtml%26_locale%3Dar%26_controller%3DRawafed%255CAdminBundle%255CController%255CAdminController%253A%253…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

tq entity manager

Entities Mapping

default entity manager

tq entity manager