Symfony Profiler

Query Metrics

17 Database Queries

13 Different statements

9.09 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.43 ms
(15.71%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.provider AS provider_2, s0_.ips AS ips_3 FROM server s0_ WHERE s0_.id IN (?)

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.provider AS provider_2,
  s0_.ips AS ips_3
FROM
  server s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.provider AS provider_2, s0_.ips AS ips_3 FROM server s0_ WHERE s0_.id IN ('3');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 150)
11	Symfony\Component\Form\Extension\Core\Type\ChoiceType::Symfony\Component\Form\Extension\Core\Type\{closure} (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 30)
14	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 482)
15	Symfony\Component\Form\Form->submit (line 499)
16	Symfony\Component\Form\Form->submit (line 109)
17	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
18	Symfony\Component\Form\Form->handleRequest (line 202)
19	App\Controller\DropController->new (line 166)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.04 ms
(11.44%)

SELECT s0_.id AS id_0, s0_.hostname AS hostname_1, s0_.port AS port_2, s0_.login AS login_3, s0_.password AS password_4, s0_.name AS name_5, s0_.email AS email_6, s0_.auth AS auth_7 FROM smtp s0_ WHERE s0_.id IN (?)

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.hostname AS hostname_1,
  s0_.port AS port_2,
  s0_.login AS login_3,
  s0_.password AS password_4,
  s0_.name AS name_5,
  s0_.email AS email_6,
  s0_.auth AS auth_7
FROM
  smtp s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.hostname AS hostname_1, s0_.port AS port_2, s0_.login AS login_3, s0_.password AS password_4, s0_.name AS name_5, s0_.email AS email_6, s0_.auth AS auth_7 FROM smtp s0_ WHERE s0_.id IN ('6');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 150)
11	Symfony\Component\Form\Extension\Core\Type\ChoiceType::Symfony\Component\Form\Extension\Core\Type\{closure} (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 30)
14	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 482)
15	Symfony\Component\Form\Form->submit (line 499)
16	Symfony\Component\Form\Form->submit (line 109)
17	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
18	Symfony\Component\Form\Form->handleRequest (line 202)
19	App\Controller\DropController->new (line 166)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.93 ms
(10.19%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.provider AS provider_2, s0_.ips AS ips_3 FROM server s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.provider AS provider_2,
  s0_.ips AS ips_3
FROM
  server s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.provider AS provider_2, s0_.ips AS ips_3 FROM server s0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
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 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 203)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
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 345)
21	App\Controller\DropController->new (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.85 ms
(9.40%)

SELECT t0_.id AS id_0, t0_.url AS url_1 FROM tracking_url t0_ WHERE t0_.id IN (?)

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.url AS url_1
FROM
  tracking_url t0_
WHERE
  t0_.id IN (?)

SELECT t0_.id AS id_0, t0_.url AS url_1 FROM tracking_url t0_ WHERE t0_.id IN ('1');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 150)
11	Symfony\Component\Form\Extension\Core\Type\ChoiceType::Symfony\Component\Form\Extension\Core\Type\{closure} (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 30)
14	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 482)
15	Symfony\Component\Form\Form->submit (line 499)
16	Symfony\Component\Form\Form->submit (line 109)
17	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
18	Symfony\Component\Form\Form->handleRequest (line 202)
19	App\Controller\DropController->new (line 166)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.74 ms
(8.14%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.isp AS isp_2, d0_.country AS country_3 FROM data_list d0_ WHERE d0_.id IN (?)

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.isp AS isp_2,
  d0_.country AS country_3
FROM
  data_list d0_
WHERE
  d0_.id IN (?)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.isp AS isp_2, d0_.country AS country_3 FROM data_list d0_ WHERE d0_.id IN ('2');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 150)
11	Symfony\Component\Form\Extension\Core\Type\ChoiceType::Symfony\Component\Form\Extension\Core\Type\{closure} (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 30)
14	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 482)
15	Symfony\Component\Form\Form->submit (line 499)
16	Symfony\Component\Form\Form->submit (line 109)
17	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
18	Symfony\Component\Form\Form->handleRequest (line 202)
19	App\Controller\DropController->new (line 166)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.70 ms
(7.72%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.isp AS isp_2, d0_.country AS country_3 FROM data_list d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.isp AS isp_2,
  d0_.country AS country_3
FROM
  data_list d0_

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.isp AS isp_2, d0_.country AS country_3 FROM data_list d0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
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 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 203)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
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 345)
21	App\Controller\DropController->new (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.68 ms
(7.53%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 73)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.63 ms
(6.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.provider AS provider_3, t0.ips AS ips_4 FROM server t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.provider AS provider_3,
  t0.ips AS ips_4
FROM
  server t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.provider AS provider_3, t0.ips AS ips_4 FROM server t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 129)
5	App\Controller\DropController->new (line 166)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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)

0.48 ms
(5.32%)

SELECT s0_.id AS id_0, s0_.hostname AS hostname_1, s0_.port AS port_2, s0_.login AS login_3, s0_.password AS password_4, s0_.name AS name_5, s0_.email AS email_6, s0_.auth AS auth_7 FROM smtp s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.hostname AS hostname_1,
  s0_.port AS port_2,
  s0_.login AS login_3,
  s0_.password AS password_4,
  s0_.name AS name_5,
  s0_.email AS email_6,
  s0_.auth AS auth_7
FROM
  smtp s0_

SELECT s0_.id AS id_0, s0_.hostname AS hostname_1, s0_.port AS port_2, s0_.login AS login_3, s0_.password AS password_4, s0_.name AS name_5, s0_.email AS email_6, s0_.auth AS auth_7 FROM smtp s0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
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 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 203)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
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 345)
21	App\Controller\DropController->new (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.42 ms
(4.60%)

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.sponsor AS sponsor_2, o0_.id_sponsor AS id_sponsor_3, o0_.url AS url_4, o0_.unsub AS unsub_5 FROM offer o0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.sponsor AS sponsor_2,
  o0_.id_sponsor AS id_sponsor_3,
  o0_.url AS url_4,
  o0_.unsub AS unsub_5
FROM
  offer o0_

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.sponsor AS sponsor_2, o0_.id_sponsor AS id_sponsor_3, o0_.url AS url_4, o0_.unsub AS unsub_5 FROM offer o0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
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 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 203)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
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 345)
21	App\Controller\DropController->new (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.42 ms
(4.57%)

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.sponsor AS sponsor_2, o0_.id_sponsor AS id_sponsor_3, o0_.url AS url_4, o0_.unsub AS unsub_5 FROM offer o0_ WHERE o0_.id IN (?)

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.sponsor AS sponsor_2,
  o0_.id_sponsor AS id_sponsor_3,
  o0_.url AS url_4,
  o0_.unsub AS unsub_5
FROM
  offer o0_
WHERE
  o0_.id IN (?)

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.sponsor AS sponsor_2, o0_.id_sponsor AS id_sponsor_3, o0_.url AS url_4, o0_.unsub AS unsub_5 FROM offer o0_ WHERE o0_.id IN ('1');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 43)
11	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 1014)
12	Symfony\Component\Form\Form->viewToNorm (line 558)
13	Symfony\Component\Form\Form->submit (line 499)
14	Symfony\Component\Form\Form->submit (line 109)
15	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
16	Symfony\Component\Form\Form->handleRequest (line 202)
17	App\Controller\DropController->new (line 166)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.41 ms
(4.53%)

SELECT i0_.id AS id_0, i0_.url AS url_1 FROM image_url i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.url AS url_1
FROM
  image_url i0_

SELECT i0_.id AS id_0, i0_.url AS url_1 FROM image_url i0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
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 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 203)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
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 345)
21	App\Controller\DropController->new (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.36 ms
(3.92%)

SELECT t0_.id AS id_0, t0_.url AS url_1 FROM tracking_url t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.url AS url_1
FROM
  tracking_url t0_

SELECT t0_.id AS id_0, t0_.url AS url_1 FROM tracking_url t0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
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 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 203)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
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 345)
21	App\Controller\DropController->new (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Server	No errors.
App\Entity\Drop	No errors.
App\Entity\Smtp	No errors.
App\Entity\Offer	No errors.
App\Entity\TrackingUrl	No errors.
App\Entity\ImageUrl	No errors.
App\Entity\DataList	No errors.
App\Entity\Send	No errors.
App\Entity\Suppression	No errors.
App\Entity\Clicker	No errors.
App\Entity\Openers	No errors.
App\Entity\Unsub	No errors.
App\Entity\OfferBody	No errors.
App\Entity\OfferSubject	No errors.
App\Entity\OfferFrom	No errors.
App\Entity\Customer	No errors.

Symfony Profiler

POST https://promail.7ap.tech/drop/new?p=drop%2Fnew

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping