Redirect 302 redirect from GET @order_confirm (d1c0f7)

Query Metrics

38 Database Queries
8 Different statements
107.27 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 2.87 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "RU"
]
2 1.62 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
3 0.54 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "RU"
]
4 4.92 ms
SELECT o0_.id AS id_0, o0_.promo_code AS promo_code_1, o0_.status AS status_2, o0_.cancel_reason AS cancel_reason_3, o0_.state AS state_4, o0_.tax_invoice AS tax_invoice_5, o0_.country AS country_6, o0_.city AS city_7, o0_.fiscal_number AS fiscal_number_8, o0_.event_hash AS event_hash_9, o0_.price AS price_10, o0_.insurance_amount AS insurance_amount_11, o0_.total AS total_12, o0_.discount AS discount_13, o0_.paid_amount AS paid_amount_14, o0_.fee AS fee_15, o0_.net AS net_16, o0_.commission AS commission_17, o0_.profit AS profit_18, o0_.paid AS paid_19, o0_.paid_at AS paid_at_20, o0_.created_at AS created_at_21, o0_.published_at AS published_at_22, o0_.expired_at AS expired_at_23, o0_.canceled_at AS canceled_at_24, o0_.edited_at AS edited_at_25, o0_.deleted_at AS deleted_at_26, o0_.hash AS hash_27, o0_.user_id AS user_id_28, o0_.currency_id AS currency_id_29, o0_.payment_method_id AS payment_method_id_30 FROM `order` o0_ WHERE (o0_.hash = ?) AND (o0_.deleted_at IS NULL)
Parameters:
[
  "b6R9b"
]
5 3.92 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
6 2.47 ms
"START TRANSACTION"
Parameters:
[]
7 10.95 ms
INSERT INTO `order` (promo_code, status, cancel_reason, state, tax_invoice, country, city, fiscal_number, event_hash, price, insurance_amount, total, discount, paid_amount, fee, net, commission, profit, paid, paid_at, created_at, published_at, expired_at, canceled_at, edited_at, deleted_at, hash, user_id, currency_id, payment_method_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "new"
  null
  "draft"
  0
  null
  null
  null
  null
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  null
  "2024-09-28 22:19:49"
  null
  null
  null
  "2024-09-28 22:19:49"
  null
  null
  null
  1
  null
]
8 11.84 ms
"COMMIT"
Parameters:
[]
9 0.52 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
10 0.87 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.active = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  1
]
11 3.81 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
12 0.56 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
13 3.79 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
14 2.28 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
15 0.55 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
16 5.06 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
17 0.47 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
18 4.85 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
19 1.03 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
20 4.42 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
21 3.74 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
22 0.39 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
23 2.40 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
24 3.34 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
25 0.49 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
26 2.00 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
27 3.82 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
28 0.41 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
29 1.29 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
30 1.43 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
31 1.83 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
32 2.72 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
33 0.29 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
34 4.25 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
35 0.30 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
36 4.96 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
37 0.95 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]
38 5.30 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = ?) AND (c0_.deleted_at IS NULL)
Parameters:
[
  "EUR"
]

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\Geo\Entity\Country
  • The association App\Geo\Entity\Country#paymentMethods refers to the owning side field App\Shop\Payment\Entity\PaymentMethod#country which does not exist.
  • If association App\Geo\Entity\Country#currency is many-to-one, then the inversed side App\Shop\Price\Entity\Currency#countries has to be one-to-many.
App\Shop\Price\Entity\Currency No errors.
App\Shop\Payment\Entity\PaymentMethod
  • The mappings App\Shop\Payment\Entity\PaymentMethod#countries and App\Geo\Entity\Country#paymentMethods are inconsistent with each other.
App\Geo\Entity\CountryTranslation No errors.
App\Shop\Order\Entity\Order
  • The mappings App\Shop\Order\Entity\Order#user and App\User\Entity\User#orders are inconsistent with each other.
App\User\Entity\User
  • The association App\User\Entity\User#orders refers to the owning side field App\Shop\Order\Entity\Order#client which does not exist.
App\Shop\Order\Entity\OrderProduct
  • The association App\Shop\Order\Entity\OrderProduct#product refers to the inverse side field App\Shop\Catalog\Entity\Product#orderProducts which does not exist.
App\Shop\Payment\Entity\Payment No errors.