Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

61.49 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

29.29 ms
(47.64%)

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, EXTRACT(YEAR FROM a1_.created_at) AS sclr_1, EXTRACT(MONTH FROM a1_.created_at) AS sclr_2 FROM app_lead a1_ LEFT JOIN app_user a0_ ON a1_.user_id = a0_.id LEFT JOIN app_tool a2_ ON a1_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a1_.created_at >= ? AND a1_.is_enabled = ? AND a1_.deleted_at IS NULL AND a1_.archived_at IS NULL GROUP BY sclr_1, sclr_2

Parameters:

[
  "2025-04-01"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT (a0_.id)
  ) AS sclr_0,
  EXTRACT(
    YEAR
    FROM
      a1_.created_at
  ) AS sclr_1,
  EXTRACT(
    MONTH
    FROM
      a1_.created_at
  ) AS sclr_2
FROM
  app_lead a1_
  LEFT JOIN app_user a0_ ON a1_.user_id = a0_.id
  LEFT JOIN app_tool a2_ ON a1_.tool_id = a2_.id
  LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id
WHERE
  a1_.created_at >= ?
  AND a1_.is_enabled = ?
  AND a1_.deleted_at IS NULL
  AND a1_.archived_at IS NULL
GROUP BY
  sclr_1,
  sclr_2

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, EXTRACT(YEAR FROM a1_.created_at) AS sclr_1, EXTRACT(MONTH FROM a1_.created_at) AS sclr_2 FROM app_lead a1_ LEFT JOIN app_user a0_ ON a1_.user_id = a0_.id LEFT JOIN app_tool a2_ ON a1_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a1_.created_at >= '2025-04-01' AND a1_.is_enabled = 1 AND a1_.deleted_at IS NULL AND a1_.archived_at IS NULL GROUP BY sclr_1, sclr_2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\LeadRepository->getCustomersAggregatedStats (line 316)
7	App\Service\ReportingService->getAggregatedStatsByDate (line 67)
8	App\Controller\Admin\ReportingController->_monthlyChart (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

28.30 ms
(46.02%)

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, EXTRACT(YEAR FROM a0_.created_at) AS sclr_1, EXTRACT(MONTH FROM a0_.created_at) AS sclr_2 FROM app_lead a0_ LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a0_.created_at >= ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL AND a0_.archived_at IS NULL GROUP BY sclr_1, sclr_2

Parameters:

[
  "2025-04-01"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT (a0_.id)
  ) AS sclr_0,
  EXTRACT(
    YEAR
    FROM
      a0_.created_at
  ) AS sclr_1,
  EXTRACT(
    MONTH
    FROM
      a0_.created_at
  ) AS sclr_2
FROM
  app_lead a0_
  LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id
  LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id
  LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id
WHERE
  a0_.created_at >= ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
  AND a0_.archived_at IS NULL
GROUP BY
  sclr_1,
  sclr_2

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, EXTRACT(YEAR FROM a0_.created_at) AS sclr_1, EXTRACT(MONTH FROM a0_.created_at) AS sclr_2 FROM app_lead a0_ LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a0_.created_at >= '2025-04-01' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL AND a0_.archived_at IS NULL GROUP BY sclr_1, sclr_2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\LeadRepository->getAggregatedStats (line 281)
7	App\Service\ReportingService->getAggregatedStatsByDate (line 29)
8	App\Controller\Admin\ReportingController->_monthlyChart (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

2.10 ms
(3.41%)

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, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_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,
  t0.phone_number AS phone_number_7,
  t0.street AS street_8,
  t0.postcode AS postcode_9,
  t0.city AS city_10,
  t0.referrer AS referrer_11,
  t0.external_reference AS external_reference_12,
  t0.is_enabled AS is_enabled_13,
  t0.import_reference AS import_reference_14,
  t0.ip AS ip_15,
  t0.last_activity_at AS last_activity_at_16,
  t0.birthday AS birthday_17,
  t0.archived_at AS archived_at_18,
  t0.session_token AS session_token_19,
  t0.compliance AS compliance_20,
  t0.is_valid_email AS is_valid_email_21,
  t0.deleted_at AS deleted_at_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.uuid AS uuid_25,
  t0.civility_id AS civility_id_26,
  t0.avatar_id AS avatar_id_27,
  t0.company_id AS company_id_28
FROM
  app_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, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.08 ms
(1.76%)

SELECT SUM(a0_.amount) AS sclr_0, EXTRACT(YEAR FROM a0_.date) AS sclr_1, EXTRACT(MONTH FROM a0_.date) AS sclr_2 FROM app_spend a0_ LEFT JOIN app_partner a1_ ON a0_.advertiser_id = a1_.id WHERE a0_.date >= ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL GROUP BY sclr_1, sclr_2

Parameters:

[
  "2025-04-01"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(a0_.amount) AS sclr_0,
  EXTRACT(
    YEAR
    FROM
      a0_.date
  ) AS sclr_1,
  EXTRACT(
    MONTH
    FROM
      a0_.date
  ) AS sclr_2
FROM
  app_spend a0_
  LEFT JOIN app_partner a1_ ON a0_.advertiser_id = a1_.id
WHERE
  a0_.date >= ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
GROUP BY
  sclr_1,
  sclr_2

SELECT SUM(a0_.amount) AS sclr_0, EXTRACT(YEAR FROM a0_.date) AS sclr_1, EXTRACT(MONTH FROM a0_.date) AS sclr_2 FROM app_spend a0_ LEFT JOIN app_partner a1_ ON a0_.advertiser_id = a1_.id WHERE a0_.date >= '2025-04-01' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL GROUP BY sclr_1, sclr_2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\SpendRepository->getAggregatedStats (line 154)
7	App\Service\ReportingService->getAggregatedStatsByDate (line 48)
8	App\Controller\Admin\ReportingController->_monthlyChart (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.72 ms
(1.18%)

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, EXTRACT(YEAR FROM a0_.created_at) AS sclr_1, EXTRACT(MONTH FROM a0_.created_at) AS sclr_2 FROM app_conversion a0_ WHERE a0_.is_enabled = ? AND a0_.deleted_at IS NULL GROUP BY sclr_1, sclr_2

Parameters:

[
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT (a0_.id)
  ) AS sclr_0,
  EXTRACT(
    YEAR
    FROM
      a0_.created_at
  ) AS sclr_1,
  EXTRACT(
    MONTH
    FROM
      a0_.created_at
  ) AS sclr_2
FROM
  app_conversion a0_
WHERE
  a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
GROUP BY
  sclr_1,
  sclr_2

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, EXTRACT(YEAR FROM a0_.created_at) AS sclr_1, EXTRACT(MONTH FROM a0_.created_at) AS sclr_2 FROM app_conversion a0_ WHERE a0_.is_enabled = 1 AND a0_.deleted_at IS NULL GROUP BY sclr_1, sclr_2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\ConversionRepository->getAggregatedStats (line 165)
7	App\Service\ReportingService->getAggregatedStatsByDate (line 86)
8	App\Controller\Admin\ReportingController->_monthlyChart (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\User	1
App\Entity\Term	1
App\Entity\Media	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Term	No errors.
App\Entity\Media	No errors.
App\Entity\Company	No errors.
App\Entity\Event	No errors.
App\Entity\Lead	No errors.
App\Entity\Tool	No errors.
App\Entity\Campaign	No errors.
App\Entity\Spend	No errors.
App\Entity\Partner	No errors.
App\Entity\Conversion	No errors.

Symfony Profiler

GET https://d.app.woptimizer.com/admin/reporting/_monthlyChart

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping