GET https://dev.front.garmon.io/en/auth/login

Query Metrics

6 Database Queries
4 Different statements
6.23 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.68 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 0.54 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.64 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 2.16 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"
]
5 1.76 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_ LEFT JOIN country c1_ ON c0_.id = c1_.currency_id AND (c1_.deleted_at IS NULL) WHERE (c1_.id = ?) AND (c0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  1
]
6 0.45 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
]

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.