Symfony Profiler

Query Metrics

57 Database Queries

12 Different statements

56.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.18 ms
(19.85%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = ? AND t0.status = ?

Parameters:

[
  6
  "sent"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.open_track AS open_track_3,
  t0.click_track AS click_track_4,
  t0.unsub_track AS unsub_track_5,
  t0.status AS status_6,
  t0.error_message AS error_message_7,
  t0.tracking_url AS tracking_url_8,
  t0.image_server AS image_server_9,
  t0.drop_id_id AS drop_id_id_10,
  t0.smtp_id AS smtp_id_11,
  t0.customer_id AS customer_id_12
FROM
  send t0
WHERE
  t0.drop_id_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = 6 AND t0.status = 'sent';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 61)
4	App\Controller\DropController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

5.84 ms
(10.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:

[
  6
]

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

#	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 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 164)
8	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->block_body (line 171)
9	Twig\Template->displayBlock (line 129)
10	__TwigTemplate_23349055d50eeaf334010099e3418fb3->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 49)
13	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 86)
21	App\Controller\DropController->index (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)

5.58 ms
(9.91%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date AS date_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM clicker t0 WHERE t0.drop_id_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.date AS date_3,
  t0.offer_id AS offer_id_4,
  t0.data_list_id AS data_list_id_5,
  t0.customer_id AS customer_id_6,
  t0.drop_id_id AS drop_id_id_7
FROM
  clicker t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date AS date_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM clicker t0 WHERE t0.drop_id_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 78)
4	App\Controller\DropController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

5.37 ms
(9.53%)

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:

[
  6
]

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

#	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 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 143)
8	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->block_body (line 171)
9	Twig\Template->displayBlock (line 129)
10	__TwigTemplate_23349055d50eeaf334010099e3418fb3->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 49)
13	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 86)
21	App\Controller\DropController->index (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)

5.04 ms
(8.95%)

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:

[
  6
]

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

#	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 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 198)
8	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->block_body (line 171)
9	Twig\Template->displayBlock (line 129)
10	__TwigTemplate_23349055d50eeaf334010099e3418fb3->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 49)
13	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 86)
21	App\Controller\DropController->index (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)

4.72 ms
(8.38%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date_open AS date_open_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM openers t0 WHERE t0.drop_id_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.date_open AS date_open_3,
  t0.offer_id AS offer_id_4,
  t0.data_list_id AS data_list_id_5,
  t0.customer_id AS customer_id_6,
  t0.drop_id_id AS drop_id_id_7
FROM
  openers t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date_open AS date_open_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM openers t0 WHERE t0.drop_id_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 67)
4	App\Controller\DropController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

4.18 ms
(7.42%)

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)

3.63 ms
(6.45%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = ? AND t0.status = ? AND t0.error_message IS NULL

Parameters:

[
  6
  "sent"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.open_track AS open_track_3,
  t0.click_track AS click_track_4,
  t0.unsub_track AS unsub_track_5,
  t0.status AS status_6,
  t0.error_message AS error_message_7,
  t0.tracking_url AS tracking_url_8,
  t0.image_server AS image_server_9,
  t0.drop_id_id AS drop_id_id_10,
  t0.smtp_id AS smtp_id_11,
  t0.customer_id AS customer_id_12
FROM
  send t0
WHERE
  t0.drop_id_id = ?
  AND t0.status = ?
  AND t0.error_message IS NULL

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = 6 AND t0.status = 'sent' AND t0.error_message IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 64)
4	App\Controller\DropController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.60 ms
(6.39%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date_unsub AS date_unsub_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM unsub t0 WHERE t0.drop_id_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.date_unsub AS date_unsub_3,
  t0.offer_id AS offer_id_4,
  t0.data_list_id AS data_list_id_5,
  t0.customer_id AS customer_id_6,
  t0.drop_id_id AS drop_id_id_7
FROM
  unsub t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date_unsub AS date_unsub_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM unsub t0 WHERE t0.drop_id_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 81)
4	App\Controller\DropController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.13 ms
(5.56%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.open_track AS open_track_3,
  t0.click_track AS click_track_4,
  t0.unsub_track AS unsub_track_5,
  t0.status AS status_6,
  t0.error_message AS error_message_7,
  t0.tracking_url AS tracking_url_8,
  t0.image_server AS image_server_9,
  t0.drop_id_id AS drop_id_id_10,
  t0.smtp_id AS smtp_id_11,
  t0.customer_id AS customer_id_12
FROM
  send t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3131)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1131)
9	twig_length_filter (line 216)
10	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->block_body (line 171)
11	Twig\Template->displayBlock (line 129)
12	__TwigTemplate_23349055d50eeaf334010099e3418fb3->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 86)
23	App\Controller\DropController->index (line 166)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

2.11 ms
(3.75%)

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 176)
7	Proxies\__CG__\App\Entity\Offer->__get (line 77)
8	App\Entity\Offer->getName (line 1637)
9	twig_get_attribute (line 128)
10	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->block_body (line 171)
11	Twig\Template->displayBlock (line 129)
12	__TwigTemplate_23349055d50eeaf334010099e3418fb3->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_7a90e661ee72e0f7e776dab5489801b5->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 86)
23	App\Controller\DropController->index (line 166)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.94 ms
(3.45%)

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 ORDER BY t0.id DESC LIMIT 10

Parameters:

[]

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
ORDER BY
  t0.id DESC
LIMIT
  10

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 ORDER BY t0.id DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 51)
4	App\Controller\DropController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Customer	No errors.
App\Entity\Suppression	No errors.
App\Entity\OfferBody	No errors.
App\Entity\OfferSubject	No errors.
App\Entity\OfferFrom	No errors.

Symfony Profiler

GET https://promail.7ap.tech/drops/1?p=drops%2F1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping