Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

4.80 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.28 ms
(26.75%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = ? ORDER BY r0_.created_at DESC) dctrn_result) dctrn_table

Parameters:

[
  "pending"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.last_name AS last_name_1,
          r0_.first_name AS first_name_2,
          r0_.email AS email_3,
          r0_.order_number AS order_number_4,
          r0_.order_number_normalized AS order_number_normalized_5,
          r0_.screenshot_path AS screenshot_path_6,
          r0_.status AS status_7,
          r0_.rejection_reason AS rejection_reason_8,
          r0_.order_verified AS order_verified_9,
          r0_.prestashop_order_id AS prestashop_order_id_10,
          r0_.prestashop_order_ref AS prestashop_order_ref_11,
          r0_.created_at AS created_at_12,
          r0_.updated_at AS updated_at_13
        FROM
          review_submission r0_
        WHERE
          r0_.status = ?
        ORDER BY
          r0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = 'pending' ORDER BY r0_.created_at DESC) dctrn_result) dctrn_table;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 44)
8	App\Controller\ReviewController::index (line 44)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.05 ms
(21.87%)

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = ?

Parameters:

[
  "pending"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  review_submission r0_
WHERE
  r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = 'pending';

#	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\Controller\ReviewController->index (line 52)
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 32)
13	require_once (line 5)

0.83 ms
(17.40%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = ?) dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 50

Parameters:

[
  "pending"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_12
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.last_name AS last_name_1,
          r0_.first_name AS first_name_2,
          r0_.email AS email_3,
          r0_.order_number AS order_number_4,
          r0_.order_number_normalized AS order_number_normalized_5,
          r0_.screenshot_path AS screenshot_path_6,
          r0_.status AS status_7,
          r0_.rejection_reason AS rejection_reason_8,
          r0_.order_verified AS order_verified_9,
          r0_.prestashop_order_id AS prestashop_order_id_10,
          r0_.prestashop_order_ref AS prestashop_order_ref_11,
          r0_.created_at AS created_at_12,
          r0_.updated_at AS updated_at_13
        FROM
          review_submission r0_
        WHERE
          r0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_12 DESC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = 'pending') dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 50;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_b126eec304ac421d4f71d2e6bf7ba25d->block_content (line 257)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_54ff3d4458c71252e0bfd059e48903be->doDisplay (line 356)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b126eec304ac421d4f71d2e6bf7ba25d->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\ReviewController->index (line 55)
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 32)
26	require_once (line 5)

0.64 ms
(13.31%)

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_b126eec304ac421d4f71d2e6bf7ba25d->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\ReviewController->index (line 55)
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.58 ms
(12.17%)

SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = ? AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.last_name AS last_name_1,
  r0_.first_name AS first_name_2,
  r0_.email AS email_3,
  r0_.order_number AS order_number_4,
  r0_.order_number_normalized AS order_number_normalized_5,
  r0_.screenshot_path AS screenshot_path_6,
  r0_.status AS status_7,
  r0_.rejection_reason AS rejection_reason_8,
  r0_.order_verified AS order_verified_9,
  r0_.prestashop_order_id AS prestashop_order_id_10,
  r0_.prestashop_order_ref AS prestashop_order_ref_11,
  r0_.created_at AS created_at_12,
  r0_.updated_at AS updated_at_13
FROM
  review_submission r0_
WHERE
  r0_.status = ?
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = 'pending' AND r0_.id IN (13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3) ORDER BY r0_.created_at DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	__TwigTemplate_b126eec304ac421d4f71d2e6bf7ba25d->block_content (line 257)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_54ff3d4458c71252e0bfd059e48903be->doDisplay (line 356)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b126eec304ac421d4f71d2e6bf7ba25d->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\ReviewController->index (line 55)
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 32)
26	require_once (line 5)

0.41 ms
(8.50%)

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.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.name AS name_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  `user` t0
WHERE
  t0.id = ?

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.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\ServiceEntityRepository->find (line 66)
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->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Bridge\Twig\AppVariable->getUser (line 92)
14	Twig\Extension\CoreExtension->getAttribute (line 1919)
15	__TwigTemplate_54ff3d4458c71252e0bfd059e48903be::doDisplay (line 335)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_b126eec304ac421d4f71d2e6bf7ba25d->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\ReviewController->index (line 55)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	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\ReviewSubmission	11
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\ReviewSubmission	No errors.
App\Entity\Ticket	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://skyflow.maluttebio.com/avis-clients?status=pending

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping