Symfony Profiler

Query Metrics

21 Database Queries

19 Different statements

101.74 ms Query time

1 Invalid entities

4945 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

74.72 ms
(73.43%)

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 (a0_.deleted_at IS NULL) AND (a0_.deleted_at IS NULL) GROUP BY a0_.id ORDER BY a1_.name ASC

Parameters:

[]

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
  (a0_.deleted_at IS NULL)
  AND (a0_.deleted_at IS NULL)
GROUP BY
  a0_.id
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 (a0_.deleted_at IS NULL) AND (a0_.deleted_at IS NULL) GROUP BY a0_.id 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 410)
21	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
22	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (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.79 ms
(2.74%)

SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.rgt AS rgt_2, c0_.level AS level_3, c0_.root_id AS root_id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c1_.name AS name_8, c1_.description AS description_9, c1_.deleted_at AS deleted_at_10, c1_.locale AS locale_11, c0_.parent_id AS parent_id_12, c0_.created_by AS created_by_13, c0_.updated_by AS updated_by_14, c1_.id AS id_15 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.id AND (c1_.locale = 'ar') AND (c1_.deleted_at IS NULL) AND (c1_.deleted_at IS NULL) WHERE (c0_.deleted_at IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.root_id ASC, c0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.lft AS lft_1,
  c0_.rgt AS rgt_2,
  c0_.level AS level_3,
  c0_.root_id AS root_id_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.deleted_at AS deleted_at_7,
  c1_.name AS name_8,
  c1_.description AS description_9,
  c1_.deleted_at AS deleted_at_10,
  c1_.locale AS locale_11,
  c0_.parent_id AS parent_id_12,
  c0_.created_by AS created_by_13,
  c0_.updated_by AS updated_by_14,
  c1_.id AS id_15
FROM
  category c0_
  INNER JOIN category_translation c1_ ON c0_.id = c1_.id
  AND (c1_.locale = 'ar')
  AND (c1_.deleted_at IS NULL)
  AND (c1_.deleted_at IS NULL)
WHERE
  (c0_.deleted_at IS NULL)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.root_id ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.lft AS lft_1, c0_.rgt AS rgt_2, c0_.level AS level_3, c0_.root_id AS root_id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7, c1_.name AS name_8, c1_.description AS description_9, c1_.deleted_at AS deleted_at_10, c1_.locale AS locale_11, c0_.parent_id AS parent_id_12, c0_.created_by AS created_by_13, c0_.updated_by AS updated_by_14, c1_.id AS id_15 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.id AND (c1_.locale = 'ar') AND (c1_.deleted_at IS NULL) AND (c1_.deleted_at IS NULL) WHERE (c0_.deleted_at IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.root_id 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 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 410)
21	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
22	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (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.69 ms
(2.64%)

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 3213)
8	Container1hKuEWu\App_KernelDevDebugContainer::getSecurity_RoleHierarchyService (line 925)
9	Container1hKuEWu\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2144)
10	Container1hKuEWu\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1290)
11	Container1hKuEWu\App_KernelDevDebugContainer::{closure:Container1hKuEWu\App_KernelDevDebugContainer::getEventDispatcherService():1290} (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.64 ms
(2.59%)

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 3467)
10	Container1hKuEWu\App_KernelDevDebugContainer::getTwigService (line 926)
11	Container1hKuEWu\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2144)
12	Container1hKuEWu\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1290)
13	Container1hKuEWu\App_KernelDevDebugContainer::{closure:Container1hKuEWu\App_KernelDevDebugContainer::getEventDispatcherService():1290} (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)

2.31 ms
(2.27%)

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 79)
17	__TwigTemplate_e339e00db8218ef67362d53d7467900f->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 414)
26	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
27	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (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)

1.65 ms
(1.62%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.image AS image_3, a0_.template AS template_4, a0_.views_count AS views_count_5, a0_.lft AS lft_6, a0_.rgt AS rgt_7, a0_.level AS level_8, a0_.root_id AS root_id_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, a0_.locale AS locale_13, a0_.allowed_type_id AS allowed_type_id_14, a0_.parent_id AS parent_id_15, a0_.created_by AS created_by_16, a0_.updated_by AS updated_by_17 FROM aggregate a0_ WHERE (a0_.allowed_type_id = ? OR a0_.allowed_type_id IS NULL) AND (a0_.locale = 'ar') AND (a0_.deleted_at IS NULL) AND (a0_.deleted_at IS NULL) ORDER BY a0_.name ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.image AS image_3,
  a0_.template AS template_4,
  a0_.views_count AS views_count_5,
  a0_.lft AS lft_6,
  a0_.rgt AS rgt_7,
  a0_.level AS level_8,
  a0_.root_id AS root_id_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.deleted_at AS deleted_at_12,
  a0_.locale AS locale_13,
  a0_.allowed_type_id AS allowed_type_id_14,
  a0_.parent_id AS parent_id_15,
  a0_.created_by AS created_by_16,
  a0_.updated_by AS updated_by_17
FROM
  aggregate a0_
WHERE
  (
    a0_.allowed_type_id = ?
    OR a0_.allowed_type_id IS NULL
  )
  AND (a0_.locale = 'ar')
  AND (a0_.deleted_at IS NULL)
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.image AS image_3, a0_.template AS template_4, a0_.views_count AS views_count_5, a0_.lft AS lft_6, a0_.rgt AS rgt_7, a0_.level AS level_8, a0_.root_id AS root_id_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, a0_.locale AS locale_13, a0_.allowed_type_id AS allowed_type_id_14, a0_.parent_id AS parent_id_15, a0_.created_by AS created_by_16, a0_.updated_by AS updated_by_17 FROM aggregate a0_ WHERE (a0_.allowed_type_id = 7 OR a0_.allowed_type_id IS NULL) AND (a0_.locale = 'ar') AND (a0_.deleted_at IS NULL) AND (a0_.deleted_at IS NULL) ORDER BY a0_.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 208)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 85)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 102)
15	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 100)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 102)
20	Symfony\Component\Form\FormFactory->createBuilderForProperty (line 88)
21	Symfony\Component\Form\FormBuilder->create (line 212)
22	Symfony\Component\Form\FormBuilder->resolveChildren (line 165)
23	Symfony\Component\Form\FormBuilder->getForm (line 28)
24	Symfony\Component\Form\FormFactory->create (line 340)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
26	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
27	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
28	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

1.62 ms
(1.59%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.path AS path_3, t0.size_kb AS size_kb_4, t0.properties AS properties_5, t0.view_order AS view_order_6, t0.is_published AS is_published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.entry_id AS entry_id_10, t0.type_id AS type_id_11, t12.id AS id_13, t12.classification AS classification_14, t12.extension AS extension_15, t12.mime_type AS mime_type_16, t12.embeddable AS embeddable_17, t12.priority AS priority_18, t12.viewer_width AS viewer_width_19, t12.viewer_height AS viewer_height_20 FROM entry_resource t0 INNER JOIN resource_type t12 ON t0.type_id = t12.id WHERE t0.entry_id = ?

Parameters:

[
  36055
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.path AS path_3,
  t0.size_kb AS size_kb_4,
  t0.properties AS properties_5,
  t0.view_order AS view_order_6,
  t0.is_published AS is_published_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.entry_id AS entry_id_10,
  t0.type_id AS type_id_11,
  t12.id AS id_13,
  t12.classification AS classification_14,
  t12.extension AS extension_15,
  t12.mime_type AS mime_type_16,
  t12.embeddable AS embeddable_17,
  t12.priority AS priority_18,
  t12.viewer_width AS viewer_width_19,
  t12.viewer_height AS viewer_height_20
FROM
  entry_resource t0
  INNER JOIN resource_type t12 ON t0.type_id = t12.id
WHERE
  t0.entry_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.path AS path_3, t0.size_kb AS size_kb_4, t0.properties AS properties_5, t0.view_order AS view_order_6, t0.is_published AS is_published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.entry_id AS entry_id_10, t0.type_id AS type_id_11, t12.id AS id_13, t12.classification AS classification_14, t12.extension AS extension_15, t12.mime_type AS mime_type_16, t12.embeddable AS embeddable_17, t12.priority AS priority_18, t12.viewer_width AS viewer_width_19, t12.viewer_height AS viewer_height_20 FROM entry_resource t0 INNER JOIN resource_type t12 ON t0.type_id = t12.id WHERE t0.entry_id = 36055;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 632)
7	Doctrine\ORM\PersistentCollection->__clone (line 276)
8	Symfony\Component\Form\Form->setData (line 50)
9	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
10	Symfony\Component\Form\Form->setData (line 412)
11	Symfony\Component\Form\Form->initialize (line 176)
12	Symfony\Component\Form\FormBuilder->getForm (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
15	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
16	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
17	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
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.46 ms
(1.44%)

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, t22.id AS id_23, t22.user_id AS user_id_24 FROM cms_users t0 LEFT JOIN tm_users_profiles t22 ON t22.user_id = t0.id 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,
  t22.id AS id_23,
  t22.user_id AS user_id_24
FROM
  cms_users t0
  LEFT JOIN tm_users_profiles t22 ON t22.user_id = t0.id
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, t22.id AS id_23, t22.user_id AS user_id_24 FROM cms_users t0 LEFT JOIN tm_users_profiles t22 ON t22.user_id = t0.id 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)

1.37 ms
(1.34%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.website AS website_3, t0.email AS email_4, t0.phone AS phone_5, t0.fax AS fax_6, t0.photo AS photo_7, t0.is_enabled AS is_enabled_8, t0.is_active AS is_active_9, t0.popularity AS popularity_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.extra_fields AS extra_fields_15, t0.country_id AS country_id_16, t0.user_id AS user_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM author t0 INNER JOIN entry_author ON t0.id = entry_author.author_id WHERE entry_author.entry_id = ? AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL))

Parameters:

[
  36055
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.website AS website_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.fax AS fax_6,
  t0.photo AS photo_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_active AS is_active_9,
  t0.popularity AS popularity_10,
  t0.views_count AS views_count_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.extra_fields AS extra_fields_15,
  t0.country_id AS country_id_16,
  t0.user_id AS user_id_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  author t0
  INNER JOIN entry_author ON t0.id = entry_author.author_id
WHERE
  entry_author.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.website AS website_3, t0.email AS email_4, t0.phone AS phone_5, t0.fax AS fax_6, t0.photo AS photo_7, t0.is_enabled AS is_enabled_8, t0.is_active AS is_active_9, t0.popularity AS popularity_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.extra_fields AS extra_fields_15, t0.country_id AS country_id_16, t0.user_id AS user_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM author t0 INNER JOIN entry_author ON t0.id = entry_author.author_id WHERE entry_author.entry_id = 36055 AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 47)
8	Symfony\Bridge\Doctrine\Form\DataTransformer\CollectionToArrayTransformer->transform (line 992)
9	Symfony\Component\Form\Form->normToView (line 301)
10	Symfony\Component\Form\Form->setData (line 50)
11	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
12	Symfony\Component\Form\Form->setData (line 412)
13	Symfony\Component\Form\Form->initialize (line 176)
14	Symfony\Component\Form\FormBuilder->getForm (line 28)
15	Symfony\Component\Form\FormFactory->create (line 340)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
17	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
18	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
19	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

1.22 ms
(1.20%)

SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.item_class AS item_class_3, t0.item_handler AS item_handler_4 FROM job_item t0 WHERE t0.item_class = ? AND t0.item_id = ? AND t0.item_handler = ? LIMIT 1

Parameters:

[
  "Rawafed\ContentManagementBundle\Entity\Entry"
  36055
  "rawafed.content.consultations.job_handler"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.item_id AS item_id_2,
  t0.item_class AS item_class_3,
  t0.item_handler AS item_handler_4
FROM
  job_item t0
WHERE
  t0.item_class = ?
  AND t0.item_id = ?
  AND t0.item_handler = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.item_class AS item_class_3, t0.item_handler AS item_handler_4 FROM job_item t0 WHERE t0.item_class = 'Rawafed\\ContentManagementBundle\\Entity\\Entry' AND t0.item_id = 36055 AND t0.item_handler = 'rawafed.content.consultations.job_handler' 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 77)
4	Rawafed\JobsListBundle\Doctrine\JobListManager->findJobItem (line 437)
5	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.18 ms
(1.16%)

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 1923)
9	Container1hKuEWu\App_KernelDevDebugContainer::getContentTypeManagerService (line 1701)
10	Container1hKuEWu\App_KernelDevDebugContainer::getMenuManagerService (line 3467)
11	Container1hKuEWu\App_KernelDevDebugContainer::getTwigService (line 926)
12	Container1hKuEWu\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2144)
13	Container1hKuEWu\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1290)
14	Container1hKuEWu\App_KernelDevDebugContainer::{closure:Container1hKuEWu\App_KernelDevDebugContainer::getEventDispatcherService():1290} (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.18 ms
(1.16%)

SELECT t0.id AS id_1, t0.local_id AS local_id_2, t0.title AS title_3, t0.summary AS summary_4, t0.content AS content_5, t0.is_comments_enabled AS is_comments_enabled_6, t0.is_exclusive AS is_exclusive_7, t0.show_in_homepage AS show_in_homepage_8, t0.is_draft AS is_draft_9, t0.is_published AS is_published_10, t0.published_at AS published_at_11, t0.views_count AS views_count_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.shares AS shares_15, t0.popularity AS popularity_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.view_order AS view_order_20, t0.reporting_reference_id AS reporting_reference_id_21, t0.is_banned AS is_banned_22, t0.is_immune AS is_immune_23, t0.locale AS locale_24, t0.type_id AS type_id_25, t0.source_id AS source_id_26, t0.collection_id AS collection_id_27, t0.comments_thread_id AS comments_thread_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30 FROM entry t0 WHERE t0.id = ? AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL))

Parameters:

[
  "36055"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.local_id AS local_id_2,
  t0.title AS title_3,
  t0.summary AS summary_4,
  t0.content AS content_5,
  t0.is_comments_enabled AS is_comments_enabled_6,
  t0.is_exclusive AS is_exclusive_7,
  t0.show_in_homepage AS show_in_homepage_8,
  t0.is_draft AS is_draft_9,
  t0.is_published AS is_published_10,
  t0.published_at AS published_at_11,
  t0.views_count AS views_count_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.shares AS shares_15,
  t0.popularity AS popularity_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.view_order AS view_order_20,
  t0.reporting_reference_id AS reporting_reference_id_21,
  t0.is_banned AS is_banned_22,
  t0.is_immune AS is_immune_23,
  t0.locale AS locale_24,
  t0.type_id AS type_id_25,
  t0.source_id AS source_id_26,
  t0.collection_id AS collection_id_27,
  t0.comments_thread_id AS comments_thread_id_28,
  t0.created_by AS created_by_29,
  t0.updated_by AS updated_by_30
FROM
  entry t0
WHERE
  t0.id = ?
  AND (
    (t0.locale = 'ar')
    AND (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.local_id AS local_id_2, t0.title AS title_3, t0.summary AS summary_4, t0.content AS content_5, t0.is_comments_enabled AS is_comments_enabled_6, t0.is_exclusive AS is_exclusive_7, t0.show_in_homepage AS show_in_homepage_8, t0.is_draft AS is_draft_9, t0.is_published AS is_published_10, t0.published_at AS published_at_11, t0.views_count AS views_count_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.shares AS shares_15, t0.popularity AS popularity_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.view_order AS view_order_20, t0.reporting_reference_id AS reporting_reference_id_21, t0.is_banned AS is_banned_22, t0.is_immune AS is_immune_23, t0.locale AS locale_24, t0.type_id AS type_id_25, t0.source_id AS source_id_26, t0.collection_id AS collection_id_27, t0.comments_thread_id AS comments_thread_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30 FROM entry t0 WHERE t0.id = '36055' AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 427)
6	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.13 ms
(1.11%)

SELECT t0.id AS id_1, t0.hwi_oauth_id AS hwi_oauth_id_2, t0.hwi_oauth_type AS hwi_oauth_type_3, t0.hwi_oauth_response AS hwi_oauth_response_4, t0.client_id AS client_id_5, t0.client_secret AS client_secret_6, t0.hwi_oauth_access_token AS hwi_oauth_access_token_7, t0.token_secret AS token_secret_8, t0.user_id AS user_id_9 FROM cms_users_hwi_oauth t0 WHERE t0.user_id = ? ORDER BY t0.id DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hwi_oauth_id AS hwi_oauth_id_2,
  t0.hwi_oauth_type AS hwi_oauth_type_3,
  t0.hwi_oauth_response AS hwi_oauth_response_4,
  t0.client_id AS client_id_5,
  t0.client_secret AS client_secret_6,
  t0.hwi_oauth_access_token AS hwi_oauth_access_token_7,
  t0.token_secret AS token_secret_8,
  t0.user_id AS user_id_9
FROM
  cms_users_hwi_oauth t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.hwi_oauth_id AS hwi_oauth_id_2, t0.hwi_oauth_type AS hwi_oauth_type_3, t0.hwi_oauth_response AS hwi_oauth_response_4, t0.client_id AS client_id_5, t0.client_secret AS client_secret_6, t0.hwi_oauth_access_token AS hwi_oauth_access_token_7, t0.token_secret AS token_secret_8, t0.user_id AS user_id_9 FROM cms_users_hwi_oauth t0 WHERE t0.user_id = 1 ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 108)
8	Rawafed\SocialCommonServicesBundle\Service\SocialService->setUser (line 28)
9	Container1hKuEWu\getRawafed_SocialCommonServices_UserPage_GoogleYoutubeService::do (line 875)
10	Container1hKuEWu\App_KernelDevDebugContainer->load (line 229)
11	Symfony\Component\DependencyInjection\Container::make (line 211)
12	Symfony\Component\DependencyInjection\Container->get (line 51)
13	Rawafed\SocialCommonServicesBundle\Service\ServicesManager->addUserService (line 26)
14	Container1hKuEWu\getServicesManagerService::do (line 875)
15	Container1hKuEWu\App_KernelDevDebugContainer->load (line 27)
16	Container1hKuEWu\getEntryAdminControllerService::do (line 875)
17	Container1hKuEWu\App_KernelDevDebugContainer->load (line 229)
18	Symfony\Component\DependencyInjection\Container::make (line 211)
19	Symfony\Component\DependencyInjection\Container->get (line 40)
20	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
21	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
22	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
23	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
24	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.11 ms
(1.09%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.is_group AS is_group_3, c0_.image AS image_4, c0_.podcast_url AS podcast_url_5, c0_.is_published AS is_published_6, c0_.views_count AS views_count_7, c0_.popularity AS popularity_8, c0_.lft AS lft_9, c0_.rgt AS rgt_10, c0_.level AS level_11, c0_.root_id AS root_id_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15, c0_.entries_type_id AS entries_type_id_16, c0_.author_id AS author_id_17, c0_.category_id AS category_id_18, c0_.parent_id AS parent_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21 FROM collection c0_ LEFT JOIN collection c1_ ON c0_.parent_id = c1_.id AND (c1_.deleted_at IS NULL) AND (c1_.deleted_at IS NULL) WHERE (c0_.author_id IS NULL AND c0_.entries_type_id = ?) AND (c0_.deleted_at IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.root_id ASC, c0_.lft ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.is_group AS is_group_3,
  c0_.image AS image_4,
  c0_.podcast_url AS podcast_url_5,
  c0_.is_published AS is_published_6,
  c0_.views_count AS views_count_7,
  c0_.popularity AS popularity_8,
  c0_.lft AS lft_9,
  c0_.rgt AS rgt_10,
  c0_.level AS level_11,
  c0_.root_id AS root_id_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14,
  c0_.deleted_at AS deleted_at_15,
  c0_.entries_type_id AS entries_type_id_16,
  c0_.author_id AS author_id_17,
  c0_.category_id AS category_id_18,
  c0_.parent_id AS parent_id_19,
  c0_.created_by AS created_by_20,
  c0_.updated_by AS updated_by_21
FROM
  collection c0_
  LEFT JOIN collection c1_ ON c0_.parent_id = c1_.id
  AND (c1_.deleted_at IS NULL)
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    c0_.author_id IS NULL
    AND c0_.entries_type_id = ?
  )
  AND (c0_.deleted_at IS NULL)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.root_id ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.is_group AS is_group_3, c0_.image AS image_4, c0_.podcast_url AS podcast_url_5, c0_.is_published AS is_published_6, c0_.views_count AS views_count_7, c0_.popularity AS popularity_8, c0_.lft AS lft_9, c0_.rgt AS rgt_10, c0_.level AS level_11, c0_.root_id AS root_id_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15, c0_.entries_type_id AS entries_type_id_16, c0_.author_id AS author_id_17, c0_.category_id AS category_id_18, c0_.parent_id AS parent_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21 FROM collection c0_ LEFT JOIN collection c1_ ON c0_.parent_id = c1_.id AND (c1_.deleted_at IS NULL) AND (c1_.deleted_at IS NULL) WHERE (c0_.author_id IS NULL AND c0_.entries_type_id = 7) AND (c0_.deleted_at IS NULL) AND (c0_.deleted_at IS NULL) ORDER BY c0_.root_id 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 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 410)
21	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
22	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (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)

1.11 ms
(1.09%)

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 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "consultation"
]

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
WHERE
  t0.name = ?
LIMIT
  1

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 WHERE t0.name = 'consultation' 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 37)
4	Rawafed\ContentManagementBundle\Repository\ContentTypeRepository->getContentType (line 21)
5	Rawafed\ContentManagementBundle\Service\ContentConfigurationResolver->__get (line 177)
6	Rawafed\ContentManagementBundle\Service\ContentTypeManager->getFormOptions (line 861)
7	Rawafed\ContentManagementBundle\Controller\EntryAdminController->getFormOptions (line 433)
8	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.03 ms
(1.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template AS template_5, t0.views_count AS views_count_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.level AS level_9, t0.root_id AS root_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.locale AS locale_14, t0.allowed_type_id AS allowed_type_id_15, t0.parent_id AS parent_id_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM aggregate t0 INNER JOIN aggregate_entries ON t0.id = aggregate_entries.aggregate_id WHERE aggregate_entries.entry_id = ? AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL))

Parameters:

[
  36055
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.template AS template_5,
  t0.views_count AS views_count_6,
  t0.lft AS lft_7,
  t0.rgt AS rgt_8,
  t0.level AS level_9,
  t0.root_id AS root_id_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.locale AS locale_14,
  t0.allowed_type_id AS allowed_type_id_15,
  t0.parent_id AS parent_id_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18
FROM
  aggregate t0
  INNER JOIN aggregate_entries ON t0.id = aggregate_entries.aggregate_id
WHERE
  aggregate_entries.entry_id = ?
  AND (
    (t0.locale = 'ar')
    AND (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template AS template_5, t0.views_count AS views_count_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.level AS level_9, t0.root_id AS root_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.locale AS locale_14, t0.allowed_type_id AS allowed_type_id_15, t0.parent_id AS parent_id_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM aggregate t0 INNER JOIN aggregate_entries ON t0.id = aggregate_entries.aggregate_id WHERE aggregate_entries.entry_id = 36055 AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 47)
8	Symfony\Bridge\Doctrine\Form\DataTransformer\CollectionToArrayTransformer->transform (line 992)
9	Symfony\Component\Form\Form->normToView (line 301)
10	Symfony\Component\Form\Form->setData (line 50)
11	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
12	Symfony\Component\Form\Form->setData (line 412)
13	Symfony\Component\Form\Form->initialize (line 176)
14	Symfony\Component\Form\FormBuilder->getForm (line 28)
15	Symfony\Component\Form\FormFactory->create (line 340)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
17	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
18	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
19	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.90 ms
(0.89%)

SELECT t0.id AS id_1, t0.lft AS lft_2, t0.rgt AS rgt_3, t0.level AS level_4, t0.root_id AS root_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM category t0 INNER JOIN entry_category ON t0.id = entry_category.category_id WHERE entry_category.entry_id = ? AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL))

Parameters:

[
  36055
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lft AS lft_2,
  t0.rgt AS rgt_3,
  t0.level AS level_4,
  t0.root_id AS root_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.parent_id AS parent_id_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  category t0
  INNER JOIN entry_category ON t0.id = entry_category.category_id
WHERE
  entry_category.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.lft AS lft_2, t0.rgt AS rgt_3, t0.level AS level_4, t0.root_id AS root_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM category t0 INNER JOIN entry_category ON t0.id = entry_category.category_id WHERE entry_category.entry_id = 36055 AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 47)
8	Symfony\Bridge\Doctrine\Form\DataTransformer\CollectionToArrayTransformer->transform (line 992)
9	Symfony\Component\Form\Form->normToView (line 301)
10	Symfony\Component\Form\Form->setData (line 50)
11	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
12	Symfony\Component\Form\Form->setData (line 412)
13	Symfony\Component\Form\Form->initialize (line 176)
14	Symfony\Component\Form\FormBuilder->getForm (line 28)
15	Symfony\Component\Form\FormFactory->create (line 340)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
17	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
18	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
19	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.84 ms
(0.83%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 INNER JOIN entry_tag ON t0.id = entry_tag.tag_id WHERE entry_tag.entry_id = ?

Parameters:

[
  36055
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  tag t0
  INNER JOIN entry_tag ON t0.id = entry_tag.tag_id
WHERE
  entry_tag.entry_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 INNER JOIN entry_tag ON t0.id = entry_tag.tag_id WHERE entry_tag.entry_id = 36055;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 632)
7	Doctrine\ORM\PersistentCollection->__clone (line 276)
8	Symfony\Component\Form\Form->setData (line 50)
9	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
10	Symfony\Component\Form\Form->setData (line 412)
11	Symfony\Component\Form\Form->initialize (line 176)
12	Symfony\Component\Form\FormBuilder->getForm (line 28)
13	Symfony\Component\Form\FormFactory->create (line 340)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
15	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
16	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
17	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (line 181)
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)

0.81 ms
(0.80%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.entry_id AS entry_id_4 FROM entry_property t0 WHERE t0.entry_id = ?

Parameters:

[
  36055
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.entry_id AS entry_id_4
FROM
  entry_property t0
WHERE
  t0.entry_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.entry_id AS entry_id_4 FROM entry_property t0 WHERE t0.entry_id = 36055;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 524)
8	Rawafed\ContentManagementBundle\Entity\Entry->getProperties (line 412)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 99)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 92)
11	Symfony\Component\Form\Extension\Core\DataAccessor\PropertyPathAccessor->getPropertyValue (line 47)
12	Symfony\Component\Form\Extension\Core\DataAccessor\PropertyPathAccessor->getValue (line 37)
13	Symfony\Component\Form\Extension\Core\DataAccessor\ChainAccessor->getValue (line 50)
14	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
15	Symfony\Component\Form\Form->setData (line 412)
16	Symfony\Component\Form\Form->initialize (line 176)
17	Symfony\Component\Form\FormBuilder->getForm (line 28)
18	Symfony\Component\Form\FormFactory->create (line 340)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 498)
20	Rawafed\AdminBundle\Classes\AdminCrudController->createEditForm (line 406)
21	Rawafed\AdminBundle\Classes\AdminCrudController->getEditActionResponse (line 441)
22	Rawafed\ContentManagementBundle\Controller\EntryAdminController->editAction (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)

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	2128
Rawafed\AuthorsBundle\Entity\AuthorTranslation	2128
Rawafed\SecurityBundle\Entity\Role	423
Rawafed\ContentOrganizationBundle\Entity\Category	87
Rawafed\ContentOrganizationBundle\Entity\CategoryTranslation	87
Rawafed\CommonsBundle\Entity\Country	45
Rawafed\ContentManagementBundle\Entity\ContentType	29
Rawafed\UserBundle\Entity\User	10
Rawafed\ContentOrganizationBundle\Entity\Aggregate	2
Rawafed\ContentManagementBundle\Entity\EntryProperty	2
Rawafed\ContentManagementBundle\Entity\Entry	1
Rawafed\CommentsBundle\Entity\CommentsThread	1
Rawafed\ContentOrganizationBundle\Entity\Collection	1
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	The field Rawafed\UserBundle\Entity\User#userProfile is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Rawafed\CommonsBundle\Entity\UserProfile#user does not contain the required 'inversedBy="userProfile"' attribute.
Rawafed\CommentsBundle\Entity\Comment	No errors.
Rawafed\RuntimeConfigBundle\Entity\Parameter	No errors.
Rawafed\ContentOrganizationBundle\Entity\Collection	No errors.
Rawafed\CommonsBundle\Entity\UserProfile	No errors.
Rawafed\HWIFOSUserBundle\Entity\HWIUserExtraFields	No errors.
Rawafed\JobsListBundle\Entity\Job	No errors.
Rawafed\ContentManagementBundle\Entity\Entry	No errors.
Rawafed\ContentManagementBundle\Entity\ContentSource	No errors.
Rawafed\CommentsBundle\Entity\CommentsThread	No errors.
Rawafed\ContentManagementBundle\Entity\EntryProperty	No errors.
Rawafed\ContentManagementBundle\Entity\EntryResource	No errors.
Rawafed\AuthorsBundle\Entity\Author	No errors.
Rawafed\ContentOrganizationBundle\Entity\Category	No errors.
Rawafed\ContentOrganizationBundle\Entity\Tag	No errors.
Rawafed\ContentOrganizationBundle\Entity\Aggregate	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\JobsListBundle\Entity\JobItem	No errors.
Rawafed\AuthorsBundle\Entity\AuthorTranslation	No errors.
Rawafed\CommonsBundle\Entity\Country	No errors.
Rawafed\ContentOrganizationBundle\Entity\CategoryTranslation	No errors.
Rawafed\ContentManagementBundle\Entity\ResourceType	No errors.
Rawafed\ContentOrganizationBundle\Entity\CollectionSocialPublisher	No errors.
Rawafed\AdminBundle\Entity\Favorite	No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsMessageReply	No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsCategory	No errors.
Rawafed\CommentsBundle\Entity\CommentLike	No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterGroup	No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterTranslation	No errors.
Rawafed\CommonsBundle\Entity\ProfileInterestsThread	No errors.
Rawafed\JobsListBundle\Entity\JobStatus	No errors.
Rawafed\JobsListBundle\Entity\JobParameter	No errors.
Rawafed\ContentManagementBundle\Entity\ContentSourceTranslation	No errors.
Rawafed\ContentManagementBundle\Entity\EntryResourceUserProperty	No errors.
Rawafed\CommonsBundle\Entity\City	No errors.
Rawafed\CommonsBundle\Entity\CountryTranslation	No errors.
App\Entity\BestAuthor	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\User	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\ContentManagementBundle\Entity\EntryBookmark	No errors.
Rawafed\ContentManagementBundle\Entity\EntryRate	No errors.
Rawafed\ContentManagementBundle\Entity\TopEntries	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\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.

Symfony Profiler

GET http://tafsir.rawafedtech.info/admin/content_management/contentmanagement/consultation/edit/36055

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