Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.54 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.78 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.db_host AS db_host_3, t0.db_port AS db_port_4, t0.db_name AS db_name_5, t0.db_user AS db_user_6, t0.db_password AS db_password_7, t0.db_charset AS db_charset_8, t0.company_id AS company_id_9 FROM tenant t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "vguimaraes"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.db_host AS db_host_3,
  t0.db_port AS db_port_4,
  t0.db_name AS db_name_5,
  t0.db_user AS db_user_6,
  t0.db_password AS db_password_7,
  t0.db_charset AS db_charset_8,
  t0.company_id AS company_id_9
FROM
  tenant t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.db_host AS db_host_3, t0.db_port AS db_port_4, t0.db_name AS db_name_5, t0.db_user AS db_user_6, t0.db_password AS db_password_7, t0.db_charset AS db_charset_8, t0.company_id AS company_id_9 FROM tenant t0 WHERE t0.code = 'vguimaraes' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 15)
4	App\MultiTenant\TenantDirectory->find (line 302)
5	App\Controller\Cron\CronController->runNewsletters (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 7)

1.21 ms

SELECT n0_.id AS id_0, n0_.nome AS nome_1, n0_.data_envio AS data_envio_2, n0_.estado AS estado_3, n0_.conteudo AS conteudo_4, n0_.assunto AS assunto_5, n0_.config AS config_6, n0_.created_by AS created_by_7, n0_.created_at AS created_at_8, n0_.updated_by AS updated_by_9, n0_.updated_at AS updated_at_10, n0_.id_audiencia AS id_audiencia_11 FROM newsletter_campaign n0_ WHERE n0_.estado = ? AND (n0_.data_envio IS NOT NULL AND n0_.data_envio <= ?)

Parameters:

[
  "agendado"
  "2026-01-13 02:10:14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.nome AS nome_1,
  n0_.data_envio AS data_envio_2,
  n0_.estado AS estado_3,
  n0_.conteudo AS conteudo_4,
  n0_.assunto AS assunto_5,
  n0_.config AS config_6,
  n0_.created_by AS created_by_7,
  n0_.created_at AS created_at_8,
  n0_.updated_by AS updated_by_9,
  n0_.updated_at AS updated_at_10,
  n0_.id_audiencia AS id_audiencia_11
FROM
  newsletter_campaign n0_
WHERE
  n0_.estado = ?
  AND (
    n0_.data_envio IS NOT NULL
    AND n0_.data_envio <= ?
  )

SELECT n0_.id AS id_0, n0_.nome AS nome_1, n0_.data_envio AS data_envio_2, n0_.estado AS estado_3, n0_.conteudo AS conteudo_4, n0_.assunto AS assunto_5, n0_.config AS config_6, n0_.created_by AS created_by_7, n0_.created_at AS created_at_8, n0_.updated_by AS updated_by_9, n0_.updated_at AS updated_at_10, n0_.id_audiencia AS id_audiencia_11 FROM newsletter_campaign n0_ WHERE n0_.estado = 'agendado' AND (n0_.data_envio IS NOT NULL AND n0_.data_envio <= '2026-01-13 02:10:14');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 331)
7	App\Controller\Cron\CronController->runNewsletters (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 7)

0.89 ms

SELECT n0_.id AS id_0, n0_.nome AS nome_1, n0_.data_envio AS data_envio_2, n0_.estado AS estado_3, n0_.conteudo AS conteudo_4, n0_.assunto AS assunto_5, n0_.config AS config_6, n0_.created_by AS created_by_7, n0_.created_at AS created_at_8, n0_.updated_by AS updated_by_9, n0_.updated_at AS updated_at_10, n0_.id_audiencia AS id_audiencia_11 FROM newsletter_campaign n0_ WHERE n0_.estado IN (?, ?) AND (n0_.data_envio IS NOT NULL AND n0_.data_envio <= ?)

Parameters:

[
  "a_enviar"
  "a enviar"
  "2026-01-13 02:10:14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.nome AS nome_1,
  n0_.data_envio AS data_envio_2,
  n0_.estado AS estado_3,
  n0_.conteudo AS conteudo_4,
  n0_.assunto AS assunto_5,
  n0_.config AS config_6,
  n0_.created_by AS created_by_7,
  n0_.created_at AS created_at_8,
  n0_.updated_by AS updated_by_9,
  n0_.updated_at AS updated_at_10,
  n0_.id_audiencia AS id_audiencia_11
FROM
  newsletter_campaign n0_
WHERE
  n0_.estado IN (?, ?)
  AND (
    n0_.data_envio IS NOT NULL
    AND n0_.data_envio <= ?
  )

SELECT n0_.id AS id_0, n0_.nome AS nome_1, n0_.data_envio AS data_envio_2, n0_.estado AS estado_3, n0_.conteudo AS conteudo_4, n0_.assunto AS assunto_5, n0_.config AS config_6, n0_.created_by AS created_by_7, n0_.created_at AS created_at_8, n0_.updated_by AS updated_by_9, n0_.updated_at AS updated_at_10, n0_.id_audiencia AS id_audiencia_11 FROM newsletter_campaign n0_ WHERE n0_.estado IN ('a_enviar', 'a enviar') AND (n0_.data_envio IS NOT NULL AND n0_.data_envio <= '2026-01-13 02:10:14');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 76)
7	App\Service\NewsletterSender->send (line 348)
8	App\Controller\Cron\CronController->runNewsletters (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.66 ms

SELECT id FROM newsletter_campaign WHERE estado IN ('a_enviar', 'a enviar')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  newsletter_campaign
WHERE
  estado IN ('a_enviar', 'a enviar')

SELECT id FROM newsletter_campaign WHERE estado IN ('a_enviar', 'a enviar');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 357)
3	App\Controller\Cron\CronController->runNewsletters (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 7)

Database Connections

Name	Service
system	doctrine.dbal.system_connection

Entity Managers

Name	Service
system	doctrine.orm.system_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

system entity manager

Class	Amount of managed objects
App\Entity\Tenant	1

Entities Mapping

Class	Mapping errors
App\Entity\Tenant	No errors.

Symfony Profiler

GET http://dev.sosadvanced.pt/cron/newsletters/run/vguimaraes?limit=200

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

system entity manager

Entities Mapping