Symfony Profiler

Query Metrics

15 Database Queries

15 Different statements

20.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.35 ms
(11.37%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.provider AS provider_3, t0.ips AS ips_4 FROM server t0 INNER JOIN drop_server ON t0.id = drop_server.server_id WHERE drop_server.drop_id = ?

Parameters:

[
  11
]

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
  INNER JOIN drop_server ON t0.id = drop_server.server_id
WHERE
  drop_server.drop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.provider AS provider_3, t0.ips AS ips_4 FROM server t0 INNER JOIN drop_server ON t0.id = drop_server.server_id WHERE drop_server.drop_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3135)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
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 52)
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 200)
15	App\Controller\DropController->new (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.28 ms
(11.01%)

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)

2.08 ms
(10.05%)

SELECT t0.id AS id_1, t0.url AS url_2 FROM image_url t0 INNER JOIN drop_image_url ON t0.id = drop_image_url.image_url_id WHERE drop_image_url.drop_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2
FROM
  image_url t0
  INNER JOIN drop_image_url ON t0.id = drop_image_url.image_url_id
WHERE
  drop_image_url.drop_id = ?

SELECT t0.id AS id_1, t0.url AS url_2 FROM image_url t0 INNER JOIN drop_image_url ON t0.id = drop_image_url.image_url_id WHERE drop_image_url.drop_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3135)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
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 52)
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 200)
15	App\Controller\DropController->new (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.91 ms
(9.25%)

SELECT t0.id AS id_1, t0.url AS url_2 FROM tracking_url t0 INNER JOIN drop_tracking_url ON t0.id = drop_tracking_url.tracking_url_id WHERE drop_tracking_url.drop_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2
FROM
  tracking_url t0
  INNER JOIN drop_tracking_url ON t0.id = drop_tracking_url.tracking_url_id
WHERE
  drop_tracking_url.drop_id = ?

SELECT t0.id AS id_1, t0.url AS url_2 FROM tracking_url t0 INNER JOIN drop_tracking_url ON t0.id = drop_tracking_url.tracking_url_id WHERE drop_tracking_url.drop_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3135)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
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 52)
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 200)
15	App\Controller\DropController->new (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.81 ms
(8.78%)

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)

1.77 ms
(8.57%)

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 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 73)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.60 ms
(7.76%)

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)

1.47 ms
(7.10%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sponsor AS sponsor_3, t0.id_sponsor AS id_sponsor_4, t0.url AS url_5, t0.unsub AS unsub_6 FROM offer t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sponsor AS sponsor_3,
  t0.id_sponsor AS id_sponsor_4,
  t0.url AS url_5,
  t0.unsub AS unsub_6
FROM
  offer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sponsor AS sponsor_3, t0.id_sponsor AS id_sponsor_4, t0.url AS url_5, t0.unsub AS unsub_6 FROM offer 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 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 111)
7	Proxies\__CG__\App\Entity\Offer->__load (line 3503)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 953)
9	Doctrine\ORM\EntityManager->initializeObject (line 87)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
12	array_map (line 49)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
15	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
16	Symfony\Component\Form\Form->normToView (line 301)
17	Symfony\Component\Form\Form->setData (line 52)
18	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
19	Symfony\Component\Form\Form->setData (line 412)
20	Symfony\Component\Form\Form->initialize (line 176)
21	Symfony\Component\Form\FormBuilder->getForm (line 200)
22	App\Controller\DropController->new (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.41 ms
(6.81%)

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.89 ms
(4.31%)

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.83 ms
(4.00%)

SELECT t0.id AS id_1, t0.from_name AS from_name_2, t0.subject AS subject_3, t0.body AS body_4, t0.additional_headers AS additional_headers_5, t0.email_per_seconde AS email_per_seconde_6, t0.ips AS ips_7, t0.type_data AS type_data_8, t0.status AS status_9, t0.drop_start AS drop_start_10, t0.drop_stop AS drop_stop_11, t0.test_after AS test_after_12, t0.test_email AS test_email_13, t0.offer_id AS offer_id_14 FROM `drop` t0 WHERE t0.id = ?

Parameters:

[
  "11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.from_name AS from_name_2,
  t0.subject AS subject_3,
  t0.body AS body_4,
  t0.additional_headers AS additional_headers_5,
  t0.email_per_seconde AS email_per_seconde_6,
  t0.ips AS ips_7,
  t0.type_data AS type_data_8,
  t0.status AS status_9,
  t0.drop_start AS drop_start_10,
  t0.drop_stop AS drop_stop_11,
  t0.test_after AS test_after_12,
  t0.test_email AS test_email_13,
  t0.offer_id AS offer_id_14
FROM
  `drop` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.from_name AS from_name_2, t0.subject AS subject_3, t0.body AS body_4, t0.additional_headers AS additional_headers_5, t0.email_per_seconde AS email_per_seconde_6, t0.ips AS ips_7, t0.type_data AS type_data_8, t0.status AS status_9, t0.drop_start AS drop_start_10, t0.drop_stop AS drop_stop_11, t0.test_after AS test_after_12, t0.test_email AS test_email_13, t0.offer_id AS offer_id_14 FROM `drop` t0 WHERE t0.id = '11';

#	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 124)
6	App\Controller\DropController->new (line 166)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.82 ms
(3.98%)

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.port AS port_3, t0.login AS login_4, t0.password AS password_5, t0.name AS name_6, t0.email AS email_7, t0.auth AS auth_8 FROM smtp t0 INNER JOIN drop_smtp ON t0.id = drop_smtp.smtp_id WHERE drop_smtp.drop_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hostname AS hostname_2,
  t0.port AS port_3,
  t0.login AS login_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.email AS email_7,
  t0.auth AS auth_8
FROM
  smtp t0
  INNER JOIN drop_smtp ON t0.id = drop_smtp.smtp_id
WHERE
  drop_smtp.drop_id = ?

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.port AS port_3, t0.login AS login_4, t0.password AS password_5, t0.name AS name_6, t0.email AS email_7, t0.auth AS auth_8 FROM smtp t0 INNER JOIN drop_smtp ON t0.id = drop_smtp.smtp_id WHERE drop_smtp.drop_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3135)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
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 52)
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 200)
15	App\Controller\DropController->new (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.54 ms
(2.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.isp AS isp_3, t0.country AS country_4 FROM data_list t0 INNER JOIN drop_data_list ON t0.id = drop_data_list.data_list_id WHERE drop_data_list.drop_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.isp AS isp_3,
  t0.country AS country_4
FROM
  data_list t0
  INNER JOIN drop_data_list ON t0.id = drop_data_list.data_list_id
WHERE
  drop_data_list.drop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.isp AS isp_3, t0.country AS country_4 FROM data_list t0 INNER JOIN drop_data_list ON t0.id = drop_data_list.data_list_id WHERE drop_data_list.drop_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3135)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
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 52)
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 200)
15	App\Controller\DropController->new (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.49 ms
(2.37%)

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)

0.42 ms
(2.03%)

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)

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\Drop	No errors.
App\Entity\Offer	No errors.
App\Entity\DataList	No errors.
App\Entity\Smtp	No errors.
App\Entity\Server	No errors.
App\Entity\Send	No errors.
App\Entity\Openers	No errors.
App\Entity\Clicker	No errors.
App\Entity\Unsub	No errors.
App\Entity\TrackingUrl	No errors.
App\Entity\ImageUrl	No errors.
App\Entity\Suppression	No errors.
App\Entity\OfferBody	No errors.
App\Entity\OfferSubject	No errors.
App\Entity\OfferFrom	No errors.
App\Entity\Customer	No errors.

Symfony Profiler

GET 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