Symfony Profiler

Query Metrics

19 Database Queries

18 Different statements

396.41 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

63.34 ms
(15.98%)

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = ?
              AND DATE_FORMAT(order_date, '%m-%d') <= ?

Parameters:

[
  2026
  "07-13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?
  AND DATE_FORMAT(order_date, '%m-%d') <= ?

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = 2026
              AND DATE_FORMAT(order_date, '%m-%d') <= '07-13'
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 91)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

56.29 ms
(14.20%)

SELECT
                DATE_FORMAT(DATE_ADD(order_date, INTERVAL 12 MONTH), '%Y-%m') AS month,
                SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE order_date >= DATE_SUB(NOW(), INTERVAL 24 MONTH)
              AND order_date < DATE_SUB(NOW(), INTERVAL 12 MONTH)
            GROUP BY DATE_FORMAT(DATE_ADD(order_date, INTERVAL 12 MONTH), '%Y-%m')
            ORDER BY month ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATE_FORMAT(
    DATE_ADD(order_date, INTERVAL 12 MONTH),
    '%Y-%m'
  ) AS month,
  SUM(quantity * unit_price) AS revenue
FROM
  order_item
WHERE
  order_date >= DATE_SUB(
    NOW(),
    INTERVAL 24 MONTH
  )
  AND order_date < DATE_SUB(
    NOW(),
    INTERVAL 12 MONTH
  )
GROUP BY
  DATE_FORMAT(
    DATE_ADD(order_date, INTERVAL 12 MONTH),
    '%Y-%m'
  )
ORDER BY
  month ASC

SELECT
                DATE_FORMAT(DATE_ADD(order_date, INTERVAL 12 MONTH), '%Y-%m') AS month,
                SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE order_date >= DATE_SUB(NOW(), INTERVAL 24 MONTH)
              AND order_date < DATE_SUB(NOW(), INTERVAL 12 MONTH)
            GROUP BY DATE_FORMAT(DATE_ADD(order_date, INTERVAL 12 MONTH), '%Y-%m')
            ORDER BY month ASC
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Controller\DashboardController->index (line 45)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

53.06 ms
(13.38%)

SELECT
                DATE_FORMAT(order_date, '%Y-%m') AS month,
                SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE order_date >= DATE_SUB(NOW(), INTERVAL 12 MONTH)
            GROUP BY month
            ORDER BY month ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATE_FORMAT(order_date, '%Y-%m') AS month,
  SUM(quantity * unit_price) AS revenue
FROM
  order_item
WHERE
  order_date >= DATE_SUB(
    NOW(),
    INTERVAL 12 MONTH
  )
GROUP BY
  month
ORDER BY
  month ASC

SELECT
                DATE_FORMAT(order_date, '%Y-%m') AS month,
                SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE order_date >= DATE_SUB(NOW(), INTERVAL 12 MONTH)
            GROUP BY month
            ORDER BY month ASC
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Controller\DashboardController->index (line 34)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

40.77 ms
(10.29%)

SELECT
                oi.prestashop_product_id,
                oi.prestashop_combination_id,
                SUM(oi.quantity) AS total_qty,
                SUM(oi.quantity * oi.unit_price) AS total_revenue,
                REGEXP_REPLACE(MAX(p.name), '[0-9]+\s*$', '') AS name,
                MAX(p.img_url) AS img_url,
                MAX(p.id) AS product_id
            FROM order_item oi
            LEFT JOIN product p ON p.prestashop_id = oi.prestashop_product_id
                AND (
                    (oi.prestashop_combination_id IS NULL AND p.prestashop_combination_id IS NULL)
                    OR p.prestashop_combination_id = oi.prestashop_combination_id
                )
            WHERE oi.order_date >= DATE_SUB(NOW(), INTERVAL 30 DAY)
            GROUP BY oi.prestashop_product_id, oi.prestashop_combination_id
            ORDER BY total_qty DESC
            LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  oi.prestashop_product_id,
  oi.prestashop_combination_id,
  SUM(oi.quantity) AS total_qty,
  SUM(oi.quantity * oi.unit_price) AS total_revenue,
  REGEXP_REPLACE(
    MAX(p.name),
    '[0-9]+\s*$',
    ''
  ) AS name,
  MAX(p.img_url) AS img_url,
  MAX(p.id) AS product_id
FROM
  order_item oi
  LEFT JOIN product p ON p.prestashop_id = oi.prestashop_product_id
  AND (
    (
      oi.prestashop_combination_id IS NULL
      AND p.prestashop_combination_id IS NULL
    )
    OR p.prestashop_combination_id = oi.prestashop_combination_id
  )
WHERE
  oi.order_date >= DATE_SUB(
    NOW(),
    INTERVAL 30 DAY
  )
GROUP BY
  oi.prestashop_product_id,
  oi.prestashop_combination_id
ORDER BY
  total_qty DESC
LIMIT
  20

SELECT
                oi.prestashop_product_id,
                oi.prestashop_combination_id,
                SUM(oi.quantity) AS total_qty,
                SUM(oi.quantity * oi.unit_price) AS total_revenue,
                REGEXP_REPLACE(MAX(p.name), '[0-9]+\s*$', '') AS name,
                MAX(p.img_url) AS img_url,
                MAX(p.id) AS product_id
            FROM order_item oi
            LEFT JOIN product p ON p.prestashop_id = oi.prestashop_product_id
                AND (
                    (oi.prestashop_combination_id IS NULL AND p.prestashop_combination_id IS NULL)
                    OR p.prestashop_combination_id = oi.prestashop_combination_id
                )
            WHERE oi.order_date >= DATE_SUB(NOW(), INTERVAL 30 DAY)
            GROUP BY oi.prestashop_product_id, oi.prestashop_combination_id
            ORDER BY total_qty DESC
            LIMIT 20
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Controller\DashboardController->index (line 58)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

40.13 ms
(10.12%)

SELECT MONTH(order_date) AS month_num, SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE YEAR(order_date) = ?
            GROUP BY MONTH(order_date)

Parameters:

[
  2025
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MONTH(order_date) AS month_num,
  SUM(quantity * unit_price) AS revenue
FROM
  order_item
WHERE
  YEAR(order_date) = ?
GROUP BY
  MONTH(order_date)

SELECT MONTH(order_date) AS month_num, SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE YEAR(order_date) = 2025
            GROUP BY MONTH(order_date)
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Controller\DashboardController->index (line 113)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

30.13 ms
(7.60%)

SELECT SUM(quantity * unit_price) FROM order_item WHERE YEAR(order_date) = ?

Parameters:

[
  2025
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?

SELECT SUM(quantity * unit_price) FROM order_item WHERE YEAR(order_date) = 2025
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 145)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

28.10 ms
(7.09%)

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = ?
              AND MONTH(order_date) < ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?
  AND MONTH(order_date) < ?

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = 2026
              AND MONTH(order_date) < 7
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 135)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

19.75 ms
(4.98%)

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 7 DAY)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)
  AND order_date <= DATE_SUB(
    NOW(),
    INTERVAL 7 DAY
  )

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 7 DAY);

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 157)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

19.74 ms
(4.98%)

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 3 DAY)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)
  AND order_date <= DATE_SUB(
    NOW(),
    INTERVAL 3 DAY
  )

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 3 DAY);

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 158)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

19.64 ms
(4.95%)

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 15 DAY)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)
  AND order_date <= DATE_SUB(
    NOW(),
    INTERVAL 15 DAY
  )

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 15 DAY);

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 156)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

19.59 ms
(4.94%)

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9);

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 155)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

1.16 ms
(0.29%)

SELECT s.id, s.name, COUNT(p.id) AS product_count
            FROM supplier s
            LEFT JOIN product p ON p.supplier_id = s.id AND p.active = 1
            GROUP BY s.id, s.name
            ORDER BY s.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s.id,
  s.name,
  COUNT(p.id) AS product_count
FROM
  supplier s
  LEFT JOIN product p ON p.supplier_id = s.id
  AND p.active = 1
GROUP BY
  s.id,
  s.name
ORDER BY
  s.name ASC

SELECT s.id, s.name, COUNT(p.id) AS product_count
            FROM supplier s
            LEFT JOIN product p ON p.supplier_id = s.id AND p.active = 1
            GROUP BY s.id, s.name
            ORDER BY s.name ASC
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Controller\DashboardController->index (line 161)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

1.06 ms
(0.27%)

SELECT COUNT(*) FROM product WHERE active = 1 AND supplier_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  product
WHERE
  active = 1
  AND supplier_id IS NULL

SELECT COUNT(*) FROM product WHERE active = 1 AND supplier_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 31)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

0.97 ms
(0.25%)

SELECT
                SUM(stock * price) AS purchase_value,
                SUM(stock * (selling_price - price)) AS gross_margin,
                AVG(margin_rate_stored) AS avg_margin,
                COUNT(*) AS total_products
            FROM product
            WHERE active = 1 AND stock > 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(stock * price) AS purchase_value,
  SUM(
    stock * (selling_price - price)
  ) AS gross_margin,
  AVG(margin_rate_stored) AS avg_margin,
  COUNT(*) AS total_products
FROM
  product
WHERE
  active = 1
  AND stock > 0

SELECT
                SUM(stock * price) AS purchase_value,
                SUM(stock * (selling_price - price)) AS gross_margin,
                AVG(margin_rate_stored) AS avg_margin,
                COUNT(*) AS total_products
            FROM product
            WHERE active = 1 AND stock > 0
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 300)
2	App\Controller\DashboardController->index (line 18)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

0.80 ms
(0.20%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "contact@maluttebio.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.email = 'contact@maluttebio.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 60)
6	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 64)
7	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->{closure:Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator::authenticate():105} (line 105)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.71 ms
(0.18%)

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ WHERE t0_.status <> ?

Parameters:

[
  "closed"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  ticket t0_
WHERE
  t0_.status <> ?

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ WHERE t0_.status <> 'closed';

#	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\Twig\AppExtension->getOpenTicketCount (line 57)
8	__TwigTemplate_54ff3d4458c71252e0bfd059e48903be->doDisplay (line 174)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_394ae5cbb80e4d50df306240260110fc->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
19	App\Controller\DashboardController->index (line 169)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

0.60 ms
(0.15%)

SELECT COUNT(*) FROM product WHERE active = 1 AND stock <= 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  product
WHERE
  active = 1
  AND stock <= 0

SELECT COUNT(*) FROM product WHERE active = 1 AND stock <= 0;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 29)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

0.56 ms
(0.14%)

SELECT COUNT(*) FROM product WHERE active = 1 AND remaining_days IS NOT NULL AND remaining_days < 30 AND remaining_days > 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  product
WHERE
  active = 1
  AND remaining_days IS NOT NULL
  AND remaining_days < 30
  AND remaining_days > 0

SELECT COUNT(*) FROM product WHERE active = 1 AND remaining_days IS NOT NULL AND remaining_days < 30 AND remaining_days > 0;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\DashboardController->index (line 30)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	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.
App\Entity\Ticket	No errors.

Symfony Profiler

GET https://skyflow.maluttebio.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping