Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

9.40 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.39 ms
(25.40%)

SELECT
            COALESCE(SUM(s.net_amount), 0) AS revenue,
            COALESCE(SUM(s.vat_amount), 0) AS vat,
            COALESCE(SUM(s.gross_amount), 0) AS gross,
            COALESCE(SUM(CASE WHEN s.gross_amount < 0 THEN ABS(s.net_amount) ELSE 0 END), 0) AS credits,
            COUNT(CASE WHEN s.gross_amount < 0 THEN 1 END) AS credit_documents,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS documents,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 THEN s.customer_id END) AS buyers,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 AND firsts.first_purchase >= ? THEN s.customer_id END) AS new_buyers,
            COALESCE(ROUND(AVG(CASE WHEN s.gross_amount > 0 THEN s.net_amount END), 2), 0) AS average
            FROM sale s LEFT JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN ? AND ?

Parameters:

[
  "2026-10-01"
  "2026-10-01"
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COALESCE(
    SUM(s.net_amount),
    0
  ) AS revenue,
  COALESCE(
    SUM(s.vat_amount),
    0
  ) AS vat,
  COALESCE(
    SUM(s.gross_amount),
    0
  ) AS gross,
  COALESCE(
    SUM(
      CASE WHEN s.gross_amount < 0 THEN
        ABS(s.net_amount)
      ELSE
        0
      END
    ),
    0
  ) AS credits,
  COUNT(
    CASE WHEN s.gross_amount < 0 THEN
      1
    END
  ) AS credit_documents,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS documents,
  COUNT(
    DISTINCT CASE WHEN s.gross_amount > 0 THEN
      s.customer_id
    END
  ) AS buyers,
  COUNT(
    DISTINCT CASE WHEN s.gross_amount > 0
    AND firsts.first_purchase >= ? THEN
      s.customer_id
    END
  ) AS new_buyers,
  COALESCE(
    ROUND(
      AVG(
        CASE WHEN s.gross_amount > 0 THEN
          s.net_amount
        END
      ),
      2
    ),
    0
  ) AS average
FROM
  sale s
  LEFT JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.date BETWEEN ?
  AND ?

SELECT
            COALESCE(SUM(s.net_amount), 0) AS revenue,
            COALESCE(SUM(s.vat_amount), 0) AS vat,
            COALESCE(SUM(s.gross_amount), 0) AS gross,
            COALESCE(SUM(CASE WHEN s.gross_amount < 0 THEN ABS(s.net_amount) ELSE 0 END), 0) AS credits,
            COUNT(CASE WHEN s.gross_amount < 0 THEN 1 END) AS credit_documents,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS documents,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 THEN s.customer_id END) AS buyers,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 AND firsts.first_purchase >= '2026-10-01' THEN s.customer_id END) AS new_buyers,
            COALESCE(ROUND(AVG(CASE WHEN s.gross_amount > 0 THEN s.net_amount END), 2), 0) AS average
            FROM sale s LEFT JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN '2026-10-01' AND '2026-10-26';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 298)
2	App\Repository\DashboardRepository->metrics (line 19)
3	App\Service\DashboardAnalytics->build (line 19)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

2.08 ms
(22.08%)

SELECT c.id, c.name, c.softone_code,
            MAX(CASE WHEN s.gross_amount > 0 THEN s.date END) AS last_purchase,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS purchases,
            COALESCE(SUM(s.net_amount), 0) AS revenue
            FROM customer c LEFT JOIN sale s ON s.customer_id = c.id AND s.cancelled = 0 AND s.date <= ?
            WHERE c.active = 1 GROUP BY c.id, c.name, c.softone_code

Parameters:

[
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.id,
  c.name,
  c.softone_code,
  MAX(
    CASE WHEN s.gross_amount > 0 THEN
      s.date
    END
  ) AS last_purchase,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS purchases,
  COALESCE(
    SUM(s.net_amount),
    0
  ) AS revenue
FROM
  customer c
  LEFT JOIN sale s ON s.customer_id = c.id
  AND s.cancelled = 0
  AND s.date <= ?
WHERE
  c.active = 1
GROUP BY
  c.id,
  c.name,
  c.softone_code

SELECT c.id, c.name, c.softone_code,
            MAX(CASE WHEN s.gross_amount > 0 THEN s.date END) AS last_purchase,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS purchases,
            COALESCE(SUM(s.net_amount), 0) AS revenue
            FROM customer c LEFT JOIN sale s ON s.customer_id = c.id AND s.cancelled = 0 AND s.date <= '2026-10-26'
            WHERE c.active = 1 GROUP BY c.id, c.name, c.softone_code;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 620)
2	App\Repository\DashboardRepository->activity (line 67)
3	App\Service\DashboardAnalytics->build (line 102)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

1.80 ms
(19.15%)

SELECT DISTINCT DATE_FORMAT(s.date, '%Y-%m') AS month, s.customer_id, firsts.first_purchase
            FROM sale s JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.gross_amount > 0 AND s.date BETWEEN ? AND ? ORDER BY month

Parameters:

[
  "2025-11-01"
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT DATE_FORMAT(s.date, '%Y-%m') AS month,
  s.customer_id,
  firsts.first_purchase
FROM
  sale s
  JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.gross_amount > 0
  AND s.date BETWEEN ?
  AND ?
ORDER BY
  month

SELECT DISTINCT DATE_FORMAT(s.date, '%Y-%m') AS month, s.customer_id, firsts.first_purchase
            FROM sale s JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.gross_amount > 0 AND s.date BETWEEN '2025-11-01' AND '2026-10-26' ORDER BY month;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 620)
2	App\Repository\DashboardRepository->monthlyBuyers (line 59)
3	App\Service\DashboardAnalytics->build (line 64)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.88 ms
(9.37%)

SELECT c.id, c.name, c.softone_code,
            SUM(s.net_amount) AS revenue, COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS purchases
            FROM sale s JOIN customer c ON c.id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN ? AND ?
            GROUP BY c.id, c.name, c.softone_code HAVING purchases > 0
            ORDER BY revenue DESC, c.name ASC, c.id ASC LIMIT 5

Parameters:

[
  "2026-10-01"
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.id,
  c.name,
  c.softone_code,
  SUM(s.net_amount) AS revenue,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS purchases
FROM
  sale s
  JOIN customer c ON c.id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.date BETWEEN ?
  AND ?
GROUP BY
  c.id,
  c.name,
  c.softone_code
HAVING
  purchases > 0
ORDER BY
  revenue DESC,
  c.name ASC,
  c.id ASC
LIMIT
  5

SELECT c.id, c.name, c.softone_code,
            SUM(s.net_amount) AS revenue, COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS purchases
            FROM sale s JOIN customer c ON c.id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN '2026-10-01' AND '2026-10-26'
            GROUP BY c.id, c.name, c.softone_code HAVING purchases > 0
            ORDER BY revenue DESC, c.name ASC, c.id ASC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 620)
2	App\Repository\DashboardRepository->topCustomers (line 77)
3	App\Service\DashboardAnalytics->build (line 126)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.81 ms
(8.58%)

SELECT date, SUM(net_amount) AS revenue,
            SUM(vat_amount) AS vat, SUM(gross_amount) AS gross,
            SUM(CASE WHEN gross_amount < 0 THEN ABS(net_amount) ELSE 0 END) AS credits
            FROM sale WHERE cancelled = 0 AND date BETWEEN ? AND ? GROUP BY date ORDER BY date

Parameters:

[
  "2026-10-01"
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  date,
  SUM(net_amount) AS revenue,
  SUM(vat_amount) AS vat,
  SUM(gross_amount) AS gross,
  SUM(
    CASE WHEN gross_amount < 0 THEN
      ABS(net_amount)
    ELSE
      0
    END
  ) AS credits
FROM
  sale
WHERE
  cancelled = 0
  AND date BETWEEN ?
  AND ?
GROUP BY
  date
ORDER BY
  date

SELECT date, SUM(net_amount) AS revenue,
            SUM(vat_amount) AS vat, SUM(gross_amount) AS gross,
            SUM(CASE WHEN gross_amount < 0 THEN ABS(net_amount) ELSE 0 END) AS credits
            FROM sale WHERE cancelled = 0 AND date BETWEEN '2026-10-01' AND '2026-10-26' GROUP BY date ORDER BY date;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 620)
2	App\Repository\DashboardRepository->dailyTotals (line 35)
3	App\Service\DashboardAnalytics->build (line 41)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.75 ms
(7.98%)

SELECT s.date AS bucket,
            COUNT(DISTINCT CASE WHEN firsts.first_purchase >= s.date THEN s.customer_id END) AS new_buyers,
            COUNT(DISTINCT CASE WHEN firsts.first_purchase < s.date THEN s.customer_id END) AS returning_buyers
            FROM sale s JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.gross_amount > 0 AND s.date BETWEEN ? AND ?
            GROUP BY bucket ORDER BY bucket

Parameters:

[
  "2026-10-01"
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s.date AS bucket,
  COUNT(
    DISTINCT CASE WHEN firsts.first_purchase >= s.date THEN
      s.customer_id
    END
  ) AS new_buyers,
  COUNT(
    DISTINCT CASE WHEN firsts.first_purchase < s.date THEN
      s.customer_id
    END
  ) AS returning_buyers
FROM
  sale s
  JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.gross_amount > 0
  AND s.date BETWEEN ?
  AND ?
GROUP BY
  bucket
ORDER BY
  bucket

SELECT s.date AS bucket,
            COUNT(DISTINCT CASE WHEN firsts.first_purchase >= s.date THEN s.customer_id END) AS new_buyers,
            COUNT(DISTINCT CASE WHEN firsts.first_purchase < s.date THEN s.customer_id END) AS returning_buyers
            FROM sale s JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.gross_amount > 0 AND s.date BETWEEN '2026-10-01' AND '2026-10-26'
            GROUP BY bucket ORDER BY bucket;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 620)
2	App\Repository\DashboardRepository->buyerTimeline (line 49)
3	App\Service\DashboardAnalytics->build (line 43)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.36 ms
(3.85%)

SELECT MIN(date) AS first_date, MAX(date) AS last_date, COUNT(*) AS documents
            FROM sale WHERE cancelled = 0 AND date <= ?

Parameters:

[
  "2026-10-26"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(date) AS first_date,
  MAX(date) AS last_date,
  COUNT(*) AS documents
FROM
  sale
WHERE
  cancelled = 0
  AND date <= ?

SELECT MIN(date) AS first_date, MAX(date) AS last_date, COUNT(*) AS documents
            FROM sale WHERE cancelled = 0 AND date <= '2026-10-26';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 298)
2	App\Repository\DashboardRepository->coverage (line 87)
3	App\Service\DashboardAnalytics->build (line 127)
4	App\Controller\AdminController->index (line 22)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.34 ms
(3.59%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
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 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	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

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.

GET https://babl.apto.gr/admin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping