Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

29.83 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.37 ms
(51.53%)

SELECT SUM(b0_.balance) AS sclr_0 FROM bookmaker_balance b0_ INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id WHERE b1_.name = ?

Parameters:

[
  "Retrait"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(b0_.balance) AS sclr_0
FROM
  bookmaker_balance b0_
  INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id
WHERE
  b1_.name = ?

SELECT SUM(b0_.balance) AS sclr_0 FROM bookmaker_balance b0_ INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id WHERE b1_.name = 'Retrait';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 75)
7	App\Repository\BookmakerBalanceRepository->findTotalRetrait (line 36)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

5.27 ms
(17.65%)

SELECT b0_.date AS date_0, b1_.name AS name_1, u2_.name AS name_2, SUM(b0_.balance) AS sclr_3, SUM(b0_.freebet) AS sclr_4 FROM bookmaker_balance b0_ INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id INNER JOIN user u2_ ON b0_.user_id = u2_.id GROUP BY b0_.date, b1_.name, u2_.name ORDER BY b0_.date ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.date AS date_0,
  b1_.name AS name_1,
  u2_.name AS name_2,
  SUM(b0_.balance) AS sclr_3,
  SUM(b0_.freebet) AS sclr_4
FROM
  bookmaker_balance b0_
  INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id
  INNER JOIN user u2_ ON b0_.user_id = u2_.id
GROUP BY
  b0_.date,
  b1_.name,
  u2_.name
ORDER BY
  b0_.date ASC

SELECT b0_.date AS date_0, b1_.name AS name_1, u2_.name AS name_2, SUM(b0_.balance) AS sclr_3, SUM(b0_.freebet) AS sclr_4 FROM bookmaker_balance b0_ INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id INNER JOIN user u2_ ON b0_.user_id = u2_.id GROUP BY b0_.date, b1_.name, u2_.name ORDER BY b0_.date ASC;

#	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 64)
7	App\Repository\BookmakerBalanceRepository->findBalancesByDateWithRetrait (line 47)
8	App\Controller\HomeController->getBalanceChartData (line 33)
9	App\Controller\HomeController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

4.61 ms
(15.44%)

SELECT b0_.date AS date_0, b1_.name AS name_1, u2_.name AS name_2, SUM(b0_.balance) AS sclr_3, SUM(b0_.freebet) AS sclr_4 FROM bookmaker_balance b0_ INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id INNER JOIN user u2_ ON b0_.user_id = u2_.id WHERE b1_.name <> ? GROUP BY b0_.date, b1_.name, u2_.name ORDER BY b0_.date ASC

Parameters:

[
  "Retrait"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.date AS date_0,
  b1_.name AS name_1,
  u2_.name AS name_2,
  SUM(b0_.balance) AS sclr_3,
  SUM(b0_.freebet) AS sclr_4
FROM
  bookmaker_balance b0_
  INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id
  INNER JOIN user u2_ ON b0_.user_id = u2_.id
WHERE
  b1_.name <> ?
GROUP BY
  b0_.date,
  b1_.name,
  u2_.name
ORDER BY
  b0_.date ASC

SELECT b0_.date AS date_0, b1_.name AS name_1, u2_.name AS name_2, SUM(b0_.balance) AS sclr_3, SUM(b0_.freebet) AS sclr_4 FROM bookmaker_balance b0_ INNER JOIN bookmaker b1_ ON b0_.bookmaker_id = b1_.id INNER JOIN user u2_ ON b0_.user_id = u2_.id WHERE b1_.name <> 'Retrait' GROUP BY b0_.date, b1_.name, u2_.name ORDER BY b0_.date ASC;

#	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 52)
7	App\Repository\BookmakerBalanceRepository->findBalancesByDate (line 116)
8	App\Controller\HomeController->getFreebetChartData (line 34)
9	App\Controller\HomeController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

4.59 ms
(15.38%)

SELECT 
                d.date,
                COALESCE(SUM(CASE WHEN b.name = 'Retrait' THEN r.balance ELSE 0 END), 0) AS total_balance,
                COALESCE(SUM(CASE WHEN b.name = 'Retrait' THEN r.freebet ELSE 0 END), 0) AS total_freebet
            FROM (
                SELECT DISTINCT date FROM bookmaker_balance
            ) d
            LEFT JOIN bookmaker_balance r ON r.date = d.date
            LEFT JOIN bookmaker b ON b.id = r.bookmaker_id
            GROUP BY d.date
            ORDER BY d.date ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d.date,
  COALESCE(
    SUM(
      CASE WHEN b.name = 'Retrait' THEN
        r.balance
      ELSE
        0
      END
    ),
    0
  ) AS total_balance,
  COALESCE(
    SUM(
      CASE WHEN b.name = 'Retrait' THEN
        r.freebet
      ELSE
        0
      END
    ),
    0
  ) AS total_freebet
FROM
  (
    SELECT
      DISTINCT date
    FROM
      bookmaker_balance
  ) d
  LEFT JOIN bookmaker_balance r ON r.date = d.date
  LEFT JOIN bookmaker b ON b.id = r.bookmaker_id
GROUP BY
  d.date
ORDER BY
  d.date ASC

SELECT 
                d.date,
                COALESCE(SUM(CASE WHEN b.name = 'Retrait' THEN r.balance ELSE 0 END), 0) AS total_balance,
                COALESCE(SUM(CASE WHEN b.name = 'Retrait' THEN r.freebet ELSE 0 END), 0) AS total_freebet
            FROM (
                SELECT DISTINCT date FROM bookmaker_balance
            ) d
            LEFT JOIN bookmaker_balance r ON r.date = d.date
            LEFT JOIN bookmaker b ON b.id = r.bookmaker_id
            GROUP BY d.date
            ORDER BY d.date ASC
        ;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 112)
3	App\Repository\BookmakerBalanceRepository->findRetraitByDateRaw (line 86)
4	App\Controller\HomeController->getRetraitChartData (line 35)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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

Entities Mapping

Class	Mapping errors
App\Entity\BookmakerBalance	No errors.
App\Entity\Bookmaker	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://osd2.orbix.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping