Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.44 ms Query time

4 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.44 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\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\OrderEntityRepository->getOnlySubOrders (line 1319)
7	App\Manager\Order\Order\OrderManager->getOnlySubOrders (line 395)
8	App\Service\Order\SubOrder\SubOrderGetService->getAllSubOrders (line 20)
9	App\Service\Order\SubOrder\SubOrderGetService->__construct (line 15)
10	ContainerXgzpihI\getSubOrderGetServiceService->do (line 29)
11	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
12	ContainerXgzpihI\getOrderGetServiceService->do (line 26)
13	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
14	ContainerXgzpihI\getExternallyDeliveredOrderHandleServiceService->do (line 38)
15	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
16	ContainerXgzpihI\getOrderServiceService->do (line 34)
17	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
18	ContainerXgzpihI\getOrderCreateByWhatsappHandleServiceService->do (line 25)
19	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
20	ContainerXgzpihI\getWhatsappOrderDetailsServiceService->do (line 25)
21	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
22	ContainerXgzpihI\getMetaWebhookControllerService->do (line 95)
23	ContainerXgzpihI\App_KernelDevDebugContainer::load (line 750)
24	Symfony\Component\DependencyInjection\Container->make (line 220)
25	Symfony\Component\DependencyInjection\Container::get (line 202)
26	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
27	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
28	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
29	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
30	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\OrderEntity	The mappings App\Entity\OrderEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#orderId are inconsistent with each other.
App\Entity\StoreOwnerProfileEntity	The mappings App\Entity\StoreOwnerProfileEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerProfile are inconsistent with each other.
App\Entity\RateEntity	The mappings App\Entity\RateEntity#rated and App\Entity\UserEntity#rateEntities are inconsistent with each other.
App\Entity\OrderTimeLineEntity	The association App\Entity\OrderTimeLineEntity#orderId refers to the inverse side field App\Entity\OrderEntity#OrderTimeLineEntity which does not exist. The association App\Entity\OrderTimeLineEntity#captainProfile refers to the inverse side field App\Entity\CaptainEntity#OrderTimeLineEntity which does not exist. The association App\Entity\OrderTimeLineEntity#storeOwnerProfile refers to the inverse side field App\Entity\StoreOwnerProfileEntity#OrderTimeLineEntity which does not exist. The association App\Entity\OrderTimeLineEntity#storeOwnerBranch refers to the inverse side field App\Entity\StoreOwnerBranchEntity#OrderTimeLineEntity which does not exist.
App\Entity\OrderLogEntity	No errors.
App\Entity\DashboardLocalNotificationEntity	No errors.
App\Entity\OrderDistanceConflictEntity	No errors.
App\Entity\StoreOrderDetailsEntity	No errors.
App\Entity\ExternallyDeliveredOrderEntity	No errors.
App\Entity\OrderDestinationEntity	No errors.
App\Entity\CaptainOrderFinancialEntity	No errors.
App\Entity\CancelledOrderEntity	No errors.
App\Entity\SubscriptionEntity	No errors.
App\Entity\ReCalculatedOrderDeliveryCostEntity	No errors.
App\Entity\OrderStatusEntity	No errors.
App\Entity\OrderGeoEntity	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width