Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

275.00 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

267.00 ms
(97.09%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 477)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 55)
5	Rawafed\AdsBundle\Repository\ImpressionRepository->setImpressionValue (line 21)
6	Rawafed\AdsBundle\Repository\ImpressionRepository->makeClick (line 25)
7	Rawafed\AdsBundle\Controller\FrontController->openLinkAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.71 ms
(0.62%)

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.65 ms
(0.60%)

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_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' 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_
WHERE
  c0_.lvl IN (0, 1)
  AND c0_.role NOT LIKE 'ROLE_ADMIN_%'
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_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' 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)

1.02 ms
(0.37%)

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)

0.91 ms
(0.33%)

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.clicks AS clicks_3, t0.imps AS imps_4, t0.bannerstate_id AS bannerstate_id_5 FROM ads_impression t0 WHERE t0.bannerstate_id = ? AND t0.start_date = ? LIMIT 1

Parameters:

[
  5
  "2025-06-28 08:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.clicks AS clicks_3,
  t0.imps AS imps_4,
  t0.bannerstate_id AS bannerstate_id_5
FROM
  ads_impression t0
WHERE
  t0.bannerstate_id = ?
  AND t0.start_date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.clicks AS clicks_3, t0.imps AS imps_4, t0.bannerstate_id AS bannerstate_id_5 FROM ads_impression t0 WHERE t0.bannerstate_id = 5 AND t0.start_date = '2025-06-28 08:00:00' 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 39)
4	Rawafed\AdsBundle\Repository\ImpressionRepository->setImpressionValue (line 21)
5	Rawafed\AdsBundle\Repository\ImpressionRepository->makeClick (line 25)
6	Rawafed\AdsBundle\Controller\FrontController->openLinkAction (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)

0.81 ms
(0.29%)

SELECT t0.id AS id_1, t0.date_time AS date_time_2, t0.banner_id AS banner_id_3, t0.zone_id AS zone_id_4, t0.campaign_id AS campaign_id_5 FROM ads_banner_state t0 WHERE t0.banner_id = ? ORDER BY t0.id ASC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_time AS date_time_2,
  t0.banner_id AS banner_id_3,
  t0.zone_id AS zone_id_4,
  t0.campaign_id AS campaign_id_5
FROM
  ads_banner_state t0
WHERE
  t0.banner_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.date_time AS date_time_2, t0.banner_id AS banner_id_3, t0.zone_id AS zone_id_4, t0.campaign_id AS campaign_id_5 FROM ads_banner_state t0 WHERE t0.banner_id = 5 ORDER BY t0.id ASC;

#	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 177)
7	Doctrine\Common\Collections\AbstractLazyCollection->last (line 268)
8	Rawafed\AdsBundle\Entity\Banner->tempCurrentActiveState (line 83)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 66)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 3987)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 55)
12	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 274)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 797)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
16	Doctrine\ORM\EntityManager->find (line 196)
17	Doctrine\ORM\EntityRepository->find (line 24)
18	Rawafed\AdsBundle\Controller\FrontController->openLinkAction (line 181)
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)

0.79 ms
(0.29%)

UPDATE ads_impression SET clicks = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ads_impression
SET
  clicks = ?
WHERE
  id = ?

UPDATE ads_impression SET clicks = 1 WHERE id = 8884;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 546)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 432)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1278)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 453)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 55)
7	Rawafed\AdsBundle\Repository\ImpressionRepository->setImpressionValue (line 21)
8	Rawafed\AdsBundle\Repository\ImpressionRepository->makeClick (line 25)
9	Rawafed\AdsBundle\Controller\FrontController->openLinkAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.63 ms
(0.23%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_name AS banner_name_7 FROM ads_banner t0 WHERE t0.id = ?

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.banner_name AS banner_name_7
FROM
  ads_banner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.banner_name AS banner_name_7 FROM ads_banner t0 WHERE t0.id = '5';

#	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 24)
6	Rawafed\AdsBundle\Controller\FrontController->openLinkAction (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)

0.47 ms
(0.17%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 55)
4	Rawafed\AdsBundle\Repository\ImpressionRepository->setImpressionValue (line 21)
5	Rawafed\AdsBundle\Repository\ImpressionRepository->makeClick (line 25)
6	Rawafed\AdsBundle\Controller\FrontController->openLinkAction (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)

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

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\AdsBundle\Entity\Banner	No errors.
Rawafed\AdsBundle\Entity\BannerState	No errors.
Rawafed\AdsBundle\Entity\Zone	No errors.
Rawafed\AdsBundle\Entity\Campaign	No errors.
Rawafed\AdsBundle\Entity\Impression	No errors.

tq entity manager

No loaded entities.

Symfony Profiler

GET http://akhawat.local.rawafedtech.info/openlink/5

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