Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.48 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.48 ms

SELECT o0_.id AS id_0, o0_.primary_order_id AS sclr_1 FROM order_entity o0_ WHERE o0_.primary_order_id <> ? ORDER BY o0_.id DESC

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.primary_order_id AS sclr_1
FROM
  order_entity o0_
WHERE
  o0_.primary_order_id <> ?
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.primary_order_id AS sclr_1 FROM order_entity o0_ WHERE o0_.primary_order_id <> '' ORDER BY o0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 1257)
7	App\Repository\OrderEntityRepository->getOnlySubOrders (line 417)
8	App\Manager\Order\Order\OrderManager->getOnlySubOrders (line 20)
9	App\Service\Order\SubOrder\SubOrderGetService->getAllSubOrders (line 15)
10	App\Service\Order\SubOrder\SubOrderGetService->__construct (line 29)
11	Container5xSJvSs\getSubOrderGetServiceService::do (line 654)
12	Container5xSJvSs\App_KernelDevDebugContainer->load (line 26)
13	Container5xSJvSs\getOrderGetServiceService::do (line 654)
14	Container5xSJvSs\App_KernelDevDebugContainer->load (line 38)
15	Container5xSJvSs\getExternallyDeliveredOrderHandleServiceService::do (line 654)
16	Container5xSJvSs\App_KernelDevDebugContainer->load (line 36)
17	Container5xSJvSs\getOrderServiceService::do (line 654)
18	Container5xSJvSs\App_KernelDevDebugContainer->load (line 24)
19	Container5xSJvSs\getOrderCreateByWhatsappHandleServiceService::do (line 654)
20	Container5xSJvSs\App_KernelDevDebugContainer->load (line 24)
21	Container5xSJvSs\getWhatsappOrderDetailsServiceService::do (line 654)
22	Container5xSJvSs\App_KernelDevDebugContainer->load (line 85)
23	Container5xSJvSs\getWhatsappChatControllerService::do (line 654)
24	Container5xSJvSs\App_KernelDevDebugContainer->load (line 220)
25	Symfony\Component\DependencyInjection\Container::make (line 202)
26	Symfony\Component\DependencyInjection\Container->get (line 38)
27	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
28	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
29	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
30	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
31	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	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.

Entities Mapping

Class	Mapping errors
App\Entity\OrderEntity	The mappings App\Entity\OrderEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#orderId are inconsistent with each other.

Symfony Profiler

POST https://prod-api.callme4d.com/v1/whatsapp/chat/c4drobotbot

Configuration Settings

Theme