Symfony Profiler

Query Metrics

14 Database Queries

9 Different statements

2.22 ms Query time

0 Invalid entities

403 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.41 ms
(18.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6,
  t0.is_b2c AS is_b2c_7,
  t0.is_b2b AS is_b2b_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.courier_id AS courier_id_11
FROM
  shipping_method t0
WHERE
  t0.is_default = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = 1 AND t0.status = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\GlobalVariableService->getDefaultShippingMethod (line 42)
4	App\Service\StockIndicatorService->__construct (line 42)
5	ContainerMEUV2Y2\getStockIndicatorServiceService->do (line 34)
6	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
7	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 28)
8	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
9	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
10	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
11	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
12	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
13	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
14	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
15	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
16	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
17	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
18	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	handle (line 143)

0.41 ms
(18.42%)

SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1, DATE(c0_.start_date) AS sclr_2, DATE(c0_.end_date) AS sclr_3 FROM company_calendar c0_ WHERE DATE(c0_.start_date) >= ? AND DATE(c0_.start_date) <= ? AND c0_.start_date IS NOT NULL

Parameters:

[
  "2026-07-31"
  "2026-09-29"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.holiday_type AS holiday_type_1,
  DATE(c0_.start_date) AS sclr_2,
  DATE(c0_.end_date) AS sclr_3
FROM
  company_calendar c0_
WHERE
  DATE(c0_.start_date) >= ?
  AND DATE(c0_.start_date) <= ?
  AND c0_.start_date IS NOT NULL

SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1, DATE(c0_.start_date) AS sclr_2, DATE(c0_.end_date) AS sclr_3 FROM company_calendar c0_ WHERE DATE(c0_.start_date) >= '2026-07-31' AND DATE(c0_.start_date) <= '2026-09-29' AND c0_.start_date IS NOT NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Service\GlobalVariableService->getAllHolidays (line 82)
7	App\Service\StockIndicatorService->__construct (line 43)
8	ContainerMEUV2Y2\getStockIndicatorServiceService->do (line 34)
9	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
10	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 28)
11	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
12	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
13	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
14	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
15	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
16	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
17	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
18	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
19	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
20	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
21	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 208)
31	handle (line 143)

0.40 ms
(18.18%)

SELECT o0_.time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_.name = ? LIMIT 1

Parameters:

[
  "customer order submit time"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.time_line AS time_line_0
FROM
  order_timelines o0_
WHERE
  o0_.name = ?
LIMIT
  1

SELECT o0_.time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_.name = 'customer order submit time' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 802)
7	App\Repository\OrderTimelinesRepository->getCustomerOrderSubmitTime (line 46)
8	App\Service\GlobalVariableService->getCustomerOrderTL (line 21)
9	App\Service\StockIndicatorService->__construct (line 39)
10	ContainerMEUV2Y2\getStockIndicatorServiceService->do (line 34)
11	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
12	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 28)
13	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
14	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
15	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
16	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
17	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
18	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
19	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
20	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
21	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
22	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
23	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
24	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
25	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 208)
33	handle (line 143)

0.36 ms
(16.16%)

SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shipping_key AS shipping_key_2,
  t0.shipping_value AS shipping_value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.shipping_method_id AS shipping_method_id_6
FROM
  shipping_method_settings t0

SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\StockIndicator\IndicatorHelperService->getAllShippingMethodSettings (line 1812)
6	App\Service\StockIndicator\IndicatorHelperService->__construct (line 39)
7	ContainerMEUV2Y2\getIndicatorHelperServiceService->do (line 39)
8	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
9	ContainerMEUV2Y2\getCartCheckoutStockAndStockIndicatorServiceService->do (line 23)
10	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
11	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 33)
12	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
13	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
14	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
15	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
16	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
17	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
18	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
19	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
20	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
21	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
22	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 208)
32	handle (line 143)

0.14 ms
(6.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort AS sort_5, t0.image AS image_6, t0.is_default AS is_default_7, t0.barcode_username AS barcode_username_8, t0.barcode_password AS barcode_password_9, t0.barcode_franking_license AS barcode_franking_license_10, t0.sd_barcode_username AS sd_barcode_username_11, t0.sd_barcode_password AS sd_barcode_password_12, t0.sd_barcode_franking_license AS sd_barcode_franking_license_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM courier t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort AS sort_5,
  t0.image AS image_6,
  t0.is_default AS is_default_7,
  t0.barcode_username AS barcode_username_8,
  t0.barcode_password AS barcode_password_9,
  t0.barcode_franking_license AS barcode_franking_license_10,
  t0.sd_barcode_username AS sd_barcode_username_11,
  t0.sd_barcode_password AS sd_barcode_password_12,
  t0.sd_barcode_franking_license AS sd_barcode_franking_license_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  courier t0
WHERE
  t0.is_default = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort AS sort_5, t0.image AS image_6, t0.is_default AS is_default_7, t0.barcode_username AS barcode_username_8, t0.barcode_password AS barcode_password_9, t0.barcode_franking_license AS barcode_franking_license_10, t0.sd_barcode_username AS sd_barcode_username_11, t0.sd_barcode_password AS sd_barcode_password_12, t0.sd_barcode_franking_license AS sd_barcode_franking_license_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM courier t0 WHERE t0.is_default = 1 AND t0.status = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\GlobalVariableService->getDefaultCourier (line 46)
5	App\Service\ShippingMethodService->__construct (line 43)
6	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 49)
7	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
8	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
9	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
10	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
11	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
12	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
13	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
14	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
15	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
16	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
17	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 208)
27	handle (line 143)

0.14 ms
(6.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = ? AND t0.status = ? AND t0.is_b2b = ? LIMIT 1

Parameters:

[
  "nt-sd-ev"
  "1"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6,
  t0.is_b2c AS is_b2c_7,
  t0.is_b2b AS is_b2b_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.courier_id AS courier_id_11
FROM
  shipping_method t0
WHERE
  t0.alias = ?
  AND t0.status = ?
  AND t0.is_b2b = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = 'nt-sd-ev' AND t0.status = '1' AND t0.is_b2b = '1' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\GlobalVariableService->getNoTimeB2BShippingMethod (line 54)
4	App\Service\ShippingMethodService->__construct (line 45)
5	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 49)
6	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
7	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
8	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
9	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
10	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
11	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
12	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
13	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
14	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
15	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
16	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	handle (line 143)

0.13 ms
(5.86%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = ? AND t0.status = ? AND t0.is_b2c = ? LIMIT 1

Parameters:

[
  "nt-sd-ev"
  "1"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6,
  t0.is_b2c AS is_b2c_7,
  t0.is_b2b AS is_b2b_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.courier_id AS courier_id_11
FROM
  shipping_method t0
WHERE
  t0.alias = ?
  AND t0.status = ?
  AND t0.is_b2c = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = 'nt-sd-ev' AND t0.status = '1' AND t0.is_b2c = '1' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\GlobalVariableService->getNoTimeB2CShippingMethod (line 50)
4	App\Service\ShippingMethodService->__construct (line 44)
5	ContainerMEUV2Y2\getShippingMethodServiceService->do (line 49)
6	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
7	ContainerMEUV2Y2\getAuthenticationEventListenerService->do (line 30)
8	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
9	ContainerMEUV2Y2\getLoginFormAuthenticatorService->do (line 28)
10	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
11	ContainerMEUV2Y2\getSecurity_Authenticator_Manager_MainService->do (line 25)
12	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
13	ContainerMEUV2Y2\getDebug_Security_Firewall_Authenticator_MainService->do (line 24)
14	ContainerMEUV2Y2\App_KernelDevDebugContainer::load (line 754)
15	ContainerMEUV2Y2\getSecurity_Firewall_Map_Context_MainService->ContainerMEUV2Y2\{closure} (line 32)
16	Symfony\Component\Security\Http\Firewall::Symfony\Component\Security\Http\{closure} (line 77)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	handle (line 143)

0.11 ms
(5.14%)

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = ?

Parameters:

[
  "216.73.217.8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2
FROM
  customer_ban_ip t0
WHERE
  t0.ip = ?

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = '216.73.217.8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\EventListener\User\BeforeControllerListener->onKernelController (line 107)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	handle (line 143)

0.11 ms
(4.83%)

SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.current_timezone AS current_timezone_0
FROM
  settings s0_
LIMIT
  1

SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\EventListener\User\BeforeControllerListener->onKernelController (line 128)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	handle (line 143)

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\ShippingMethodSettings	389
App\Entity\ShippingMethod	13
App\Entity\Courier	1

Entities Mapping

Class	Mapping errors
App\Entity\OrderTimelines	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\Courier	No errors.
App\Entity\CompanyCalendar	No errors.
App\Entity\ShippingMethodSettings	No errors.
App\Entity\CustomerBanIp	No errors.
App\Entity\Settings	No errors.

Symfony Profiler

GET https://admin-upgrade.mountainbike-parts.ch/_profiler/f439ce/search/null

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping