Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.85 ms Query time

0 Invalid entities

50 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.96 ms
(33.89%)

SELECT i0_.id AS id_0, i0_.month AS month_1, i0_.status AS status_2, i0_.total_amount AS total_amount_3, i0_.description AS description_4, i0_.notes AS notes_5, i0_.exact_reference AS exact_reference_6, i0_.exact_error AS exact_error_7, i0_.exact_error_at AS exact_error_at_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.finalized_at AS finalized_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.website_url AS website_url_14, c1_.exact_id AS exact_id_15, c1_.exact_account_guid AS exact_account_guid_16, c1_.reserved_support_hours AS reserved_support_hours_17, c1_.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_18, c1_.hourly_rate AS hourly_rate_19, c1_.default_month AS default_month_20, c1_.yearly_maintenance_remaining AS yearly_maintenance_remaining_21, c1_.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_22, c1_.initial_support_carry_over AS initial_support_carry_over_23, c1_.use_initial_support_carry_over AS use_initial_support_carry_over_24, c1_.email_locale AS email_locale_25, c1_.default_invoice_description AS default_invoice_description_26, i0_.company_id AS company_id_27 FROM invoice i0_ INNER JOIN company c1_ ON i0_.company_id = c1_.id WHERE i0_.month = ? ORDER BY c1_.name ASC

Parameters:

[
  "2026-05-01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.month AS month_1,
  i0_.status AS status_2,
  i0_.total_amount AS total_amount_3,
  i0_.description AS description_4,
  i0_.notes AS notes_5,
  i0_.exact_reference AS exact_reference_6,
  i0_.exact_error AS exact_error_7,
  i0_.exact_error_at AS exact_error_at_8,
  i0_.created_at AS created_at_9,
  i0_.updated_at AS updated_at_10,
  i0_.finalized_at AS finalized_at_11,
  c1_.id AS id_12,
  c1_.name AS name_13,
  c1_.website_url AS website_url_14,
  c1_.exact_id AS exact_id_15,
  c1_.exact_account_guid AS exact_account_guid_16,
  c1_.reserved_support_hours AS reserved_support_hours_17,
  c1_.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_18,
  c1_.hourly_rate AS hourly_rate_19,
  c1_.default_month AS default_month_20,
  c1_.yearly_maintenance_remaining AS yearly_maintenance_remaining_21,
  c1_.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_22,
  c1_.initial_support_carry_over AS initial_support_carry_over_23,
  c1_.use_initial_support_carry_over AS use_initial_support_carry_over_24,
  c1_.email_locale AS email_locale_25,
  c1_.default_invoice_description AS default_invoice_description_26,
  i0_.company_id AS company_id_27
FROM
  invoice i0_
  INNER JOIN company c1_ ON i0_.company_id = c1_.id
WHERE
  i0_.month = ?
ORDER BY
  c1_.name ASC

SELECT i0_.id AS id_0, i0_.month AS month_1, i0_.status AS status_2, i0_.total_amount AS total_amount_3, i0_.description AS description_4, i0_.notes AS notes_5, i0_.exact_reference AS exact_reference_6, i0_.exact_error AS exact_error_7, i0_.exact_error_at AS exact_error_at_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.finalized_at AS finalized_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.website_url AS website_url_14, c1_.exact_id AS exact_id_15, c1_.exact_account_guid AS exact_account_guid_16, c1_.reserved_support_hours AS reserved_support_hours_17, c1_.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_18, c1_.hourly_rate AS hourly_rate_19, c1_.default_month AS default_month_20, c1_.yearly_maintenance_remaining AS yearly_maintenance_remaining_21, c1_.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_22, c1_.initial_support_carry_over AS initial_support_carry_over_23, c1_.use_initial_support_carry_over AS use_initial_support_carry_over_24, c1_.email_locale AS email_locale_25, c1_.default_invoice_description AS default_invoice_description_26, i0_.company_id AS company_id_27 FROM invoice i0_ INNER JOIN company c1_ ON i0_.company_id = c1_.id WHERE i0_.month = '2026-05-01' ORDER BY c1_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\InvoiceRepository->findAllForMonth (line 53)
7	App\Controller\Frontend\InvoiceController->index (line 60)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.57 ms
(19.99%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.is_active AS is_active_6, t0.email_greeting AS email_greeting_7, t0.email_signature AS email_signature_8, t0.email_greeting_en AS email_greeting_en_9, t0.email_signature_en AS email_signature_en_10, t0.last_login_at AS last_login_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 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.full_name AS full_name_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.is_active AS is_active_6,
  t0.email_greeting AS email_greeting_7,
  t0.email_signature AS email_signature_8,
  t0.email_greeting_en AS email_greeting_en_9,
  t0.email_signature_en AS email_signature_en_10,
  t0.last_login_at AS last_login_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.is_active AS is_active_6, t0.email_greeting AS email_greeting_7, t0.email_signature AS email_signature_8, t0.email_greeting_en AS email_greeting_en_9, t0.email_signature_en AS email_signature_en_10, t0.last_login_at AS last_login_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.49 ms
(17.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.website_url AS website_url_3, t0.exact_id AS exact_id_4, t0.exact_account_guid AS exact_account_guid_5, t0.reserved_support_hours AS reserved_support_hours_6, t0.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_7, t0.hourly_rate AS hourly_rate_8, t0.default_month AS default_month_9, t0.yearly_maintenance_remaining AS yearly_maintenance_remaining_10, t0.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_11, t0.initial_support_carry_over AS initial_support_carry_over_12, t0.use_initial_support_carry_over AS use_initial_support_carry_over_13, t0.email_locale AS email_locale_14, t0.default_invoice_description AS default_invoice_description_15 FROM company t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.website_url AS website_url_3,
  t0.exact_id AS exact_id_4,
  t0.exact_account_guid AS exact_account_guid_5,
  t0.reserved_support_hours AS reserved_support_hours_6,
  t0.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.default_month AS default_month_9,
  t0.yearly_maintenance_remaining AS yearly_maintenance_remaining_10,
  t0.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_11,
  t0.initial_support_carry_over AS initial_support_carry_over_12,
  t0.use_initial_support_carry_over AS use_initial_support_carry_over_13,
  t0.email_locale AS email_locale_14,
  t0.default_invoice_description AS default_invoice_description_15
FROM
  company t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.website_url AS website_url_3, t0.exact_id AS exact_id_4, t0.exact_account_guid AS exact_account_guid_5, t0.reserved_support_hours AS reserved_support_hours_6, t0.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_7, t0.hourly_rate AS hourly_rate_8, t0.default_month AS default_month_9, t0.yearly_maintenance_remaining AS yearly_maintenance_remaining_10, t0.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_11, t0.initial_support_carry_over AS initial_support_carry_over_12, t0.use_initial_support_carry_over AS use_initial_support_carry_over_13, t0.email_locale AS email_locale_14, t0.default_invoice_description AS default_invoice_description_15 FROM company t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Frontend\InvoiceController->index (line 56)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.43 ms
(15.00%)

SELECT i0_.status AS status_0, COUNT(i0_.id) AS sclr_1, SUM(i0_.total_amount) AS sclr_2 FROM invoice i0_ WHERE i0_.month = ? GROUP BY i0_.status

Parameters:

[
  "2026-05-01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.status AS status_0,
  COUNT(i0_.id) AS sclr_1,
  SUM(i0_.total_amount) AS sclr_2
FROM
  invoice i0_
WHERE
  i0_.month = ?
GROUP BY
  i0_.status

SELECT i0_.status AS status_0, COUNT(i0_.id) AS sclr_1, SUM(i0_.total_amount) AS sclr_2 FROM invoice i0_ WHERE i0_.month = '2026-05-01' GROUP BY i0_.status;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\InvoiceRepository->summarizeMonth (line 72)
7	App\Controller\Frontend\InvoiceController->index (line 65)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.39 ms
(13.73%)

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = 0

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  n0_.user_id = ?
  AND n0_.is_read = 0

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = 1 AND n0_.is_read = 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\NotificationRepository->countUnreadByUser (line 69)
8	App\Service\Notification\NotificationService->getUnreadCount (line 137)
9	App\Twig\NotificationTwigExtension->getGlobals (line 31)
10	Twig\ExtensionSet->getGlobals (line 365)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 406)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	App\Controller\Frontend\InvoiceController->index (line 69)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Company	39
App\Entity\Invoice	10
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Contact	No errors.
App\Entity\Project	No errors.
App\Entity\Service	No errors.
App\Entity\Invoice	No errors.
App\Entity\InvoiceLine	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET https://nexus.staging.ecomwise.dev/invoices

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping