Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.48 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.98 ms
(56.77%)

SELECT f0_.id AS id_0, f0_.session_id AS session_id_1, f0_.status AS status_2, f0_.customer_type AS customer_type_3, f0_.amount AS amount_4, f0_.bonus_amount AS bonus_amount_5, f0_.card_type AS card_type_6, f0_.greeting_title AS greeting_title_7, f0_.greeting_message AS greeting_message_8, f0_.first_name AS first_name_9, f0_.last_name AS last_name_10, f0_.email AS email_11, f0_.phone AS phone_12, f0_.company_name AS company_name_13, f0_.vat_number AS vat_number_14, f0_.shipping_same_as_billing AS shipping_same_as_billing_15, f0_.stripe_session_id AS stripe_session_id_16, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17, f0_.accepted_terms AS accepted_terms_18, f0_.accepted_privacy AS accepted_privacy_19, f0_.resume_token AS resume_token_20, f0_.resume_token_sent_at AS resume_token_sent_at_21, f0_.created_at AS created_at_22, f0_.updated_at AS updated_at_23, f0_.completed_at AS completed_at_24, f0_.product_digital_id AS product_digital_id_25, f0_.product_analog_id AS product_analog_id_26, f0_.product_template_id AS product_template_id_27, f0_.billing_address_id AS billing_address_id_28, f0_.shipping_address_id AS shipping_address_id_29, f0_.shipping_option_id AS shipping_option_id_30, f0_.gift_card_id AS gift_card_id_31 FROM frontend_card_order f0_ WHERE f0_.session_id = ? AND f0_.status NOT IN (?, ?) ORDER BY f0_.created_at DESC LIMIT 1

Parameters:

[
  "3524e234599a30af1a4cfc861edf26e4"
  "completed"
  "abandoned"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.session_id AS session_id_1,
  f0_.status AS status_2,
  f0_.customer_type AS customer_type_3,
  f0_.amount AS amount_4,
  f0_.bonus_amount AS bonus_amount_5,
  f0_.card_type AS card_type_6,
  f0_.greeting_title AS greeting_title_7,
  f0_.greeting_message AS greeting_message_8,
  f0_.first_name AS first_name_9,
  f0_.last_name AS last_name_10,
  f0_.email AS email_11,
  f0_.phone AS phone_12,
  f0_.company_name AS company_name_13,
  f0_.vat_number AS vat_number_14,
  f0_.shipping_same_as_billing AS shipping_same_as_billing_15,
  f0_.stripe_session_id AS stripe_session_id_16,
  f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17,
  f0_.accepted_terms AS accepted_terms_18,
  f0_.accepted_privacy AS accepted_privacy_19,
  f0_.resume_token AS resume_token_20,
  f0_.resume_token_sent_at AS resume_token_sent_at_21,
  f0_.created_at AS created_at_22,
  f0_.updated_at AS updated_at_23,
  f0_.completed_at AS completed_at_24,
  f0_.product_digital_id AS product_digital_id_25,
  f0_.product_analog_id AS product_analog_id_26,
  f0_.product_template_id AS product_template_id_27,
  f0_.billing_address_id AS billing_address_id_28,
  f0_.shipping_address_id AS shipping_address_id_29,
  f0_.shipping_option_id AS shipping_option_id_30,
  f0_.gift_card_id AS gift_card_id_31
FROM
  frontend_card_order f0_
WHERE
  f0_.session_id = ?
  AND f0_.status NOT IN (?, ?)
ORDER BY
  f0_.created_at DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.session_id AS session_id_1, f0_.status AS status_2, f0_.customer_type AS customer_type_3, f0_.amount AS amount_4, f0_.bonus_amount AS bonus_amount_5, f0_.card_type AS card_type_6, f0_.greeting_title AS greeting_title_7, f0_.greeting_message AS greeting_message_8, f0_.first_name AS first_name_9, f0_.last_name AS last_name_10, f0_.email AS email_11, f0_.phone AS phone_12, f0_.company_name AS company_name_13, f0_.vat_number AS vat_number_14, f0_.shipping_same_as_billing AS shipping_same_as_billing_15, f0_.stripe_session_id AS stripe_session_id_16, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17, f0_.accepted_terms AS accepted_terms_18, f0_.accepted_privacy AS accepted_privacy_19, f0_.resume_token AS resume_token_20, f0_.resume_token_sent_at AS resume_token_sent_at_21, f0_.created_at AS created_at_22, f0_.updated_at AS updated_at_23, f0_.completed_at AS completed_at_24, f0_.product_digital_id AS product_digital_id_25, f0_.product_analog_id AS product_analog_id_26, f0_.product_template_id AS product_template_id_27, f0_.billing_address_id AS billing_address_id_28, f0_.shipping_address_id AS shipping_address_id_29, f0_.shipping_option_id AS shipping_option_id_30, f0_.gift_card_id AS gift_card_id_31 FROM frontend_card_order f0_ WHERE f0_.session_id = '3524e234599a30af1a4cfc861edf26e4' AND f0_.status NOT IN ('completed', 'abandoned') ORDER BY f0_.created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 35)
7	App\Repository\FrontendCardOrderRepository->findBySessionId (line 45)
8	App\Service\FrontendCardOrderService->getOrCreateOrder (line 39)
9	App\Controller\FrontendCardOrderController->start (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.72 ms
(20.55%)

INSERT INTO frontend_card_order (session_id, status, customer_type, amount, bonus_amount, card_type, greeting_title, greeting_message, first_name, last_name, email, phone, company_name, vat_number, shipping_same_as_billing, stripe_session_id, stripe_payment_intent_id, accepted_terms, accepted_privacy, resume_token, resume_token_sent_at, created_at, updated_at, completed_at, product_digital_id, product_analog_id, product_template_id, billing_address_id, shipping_address_id, shipping_option_id, gift_card_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "3524e234599a30af1a4cfc861edf26e4"
  "step_1_customer_type"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  1
  null
  null
  0
  0
  null
  null
  "2026-03-13 16:13:34"
  null
  null
  null
  null
  null
  null
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO frontend_card_order (
  session_id, status, customer_type,
  amount, bonus_amount, card_type,
  greeting_title, greeting_message,
  first_name, last_name, email, phone,
  company_name, vat_number, shipping_same_as_billing,
  stripe_session_id, stripe_payment_intent_id,
  accepted_terms, accepted_privacy,
  resume_token, resume_token_sent_at,
  created_at, updated_at, completed_at,
  product_digital_id, product_analog_id,
  product_template_id, billing_address_id,
  shipping_address_id, shipping_option_id,
  gift_card_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO frontend_card_order (session_id, status, customer_type, amount, bonus_amount, card_type, greeting_title, greeting_message, first_name, last_name, email, phone, company_name, vat_number, shipping_same_as_billing, stripe_session_id, stripe_payment_intent_id, accepted_terms, accepted_privacy, resume_token, resume_token_sent_at, created_at, updated_at, completed_at, product_digital_id, product_analog_id, product_template_id, billing_address_id, shipping_address_id, shipping_option_id, gift_card_id) VALUES ('3524e234599a30af1a4cfc861edf26e4', 'step_1_customer_type', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0, NULL, NULL, '2026-03-13 16:13:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 255)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 38)
7	App\Service\FrontendCardOrderService->createOrder (line 48)
8	App\Service\FrontendCardOrderService->getOrCreateOrder (line 39)
9	App\Controller\FrontendCardOrderController->start (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.42 ms
(12.09%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 38)
5	App\Service\FrontendCardOrderService->createOrder (line 48)
6	App\Service\FrontendCardOrderService->getOrCreateOrder (line 39)
7	App\Controller\FrontendCardOrderController->start (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.37 ms
(10.59%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 38)
4	App\Service\FrontendCardOrderService->createOrder (line 48)
5	App\Service\FrontendCardOrderService->getOrCreateOrder (line 39)
6	App\Controller\FrontendCardOrderController->start (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\FrontendCardOrder	1

Entities Mapping

Class	Mapping errors
App\Entity\FrontendCardOrder	No errors.
App\Entity\ProductDigital	No errors.
App\Entity\ProductAnalog	No errors.
App\Entity\ProductTemplate	No errors.
App\Entity\FrontendAddress	No errors.
App\Entity\ShippingOption	No errors.
App\Entity\GiftCard	No errors.

Symfony Profiler

GET https://dev.my-waycard.com/kaufen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping