GET https://dev.front.garmon.io/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Query Metrics

10 Database Queries
8 Different statements
18.93 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.40 ms
(23.24%)
1
SELECT p0_.id AS id_0, p0_.deleted_at AS deleted_at_1, p1_.id AS id_2, p1_.content AS content_3, p1_.locale AS locale_4, p0_.page_id AS page_id_5, p0_.country_id AS country_id_6, p1_.translatable_id AS translatable_id_7 FROM page_data p0_ LEFT JOIN page_data_translation p1_ ON p0_.id = p1_.translatable_id WHERE (p0_.page_id = ? AND p0_.country_id = ? AND p1_.locale = ?) AND (p0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  1
  1
  "en"
]
3.71 ms
(19.58%)
1
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.country_id AS country_id_2, m0_.template_id AS template_id_3, m0_.page_id AS page_id_4 FROM meta_data m0_ LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id WHERE (m0_.page_id = ? AND m0_.country_id = ? AND m1_.locale = ?) AND (m0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  1
  1
  "en"
]
3.41 ms
(18.03%)
1
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
]
3.26 ms
(17.20%)
3
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"
]
1.58 ms
(8.36%)
1
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.active AS active_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.name AS name_5, p0_.deleted_at AS deleted_at_6, p0_.materialized_path AS materialized_path_7, p0_.template_id AS template_id_8 FROM page p0_ WHERE (p0_.code = ? AND p0_.active = ?) AND (p0_.deleted_at IS NULL)
Parameters:
[
  "main"
  1
]
1.53 ms
(8.11%)
1
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.country_id AS country_id_2, m0_.template_id AS template_id_3, m0_.page_id AS page_id_4 FROM meta_data m0_ LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id WHERE (m0_.template_id = ? AND m0_.country_id = ? AND m1_.locale = ?) AND (m0_.deleted_at IS NULL) LIMIT 1
Parameters:
[
  1
  1
  "en"
]
0.53 ms
(2.79%)
1
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
]
0.51 ms
(2.70%)
1
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
]

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\Site\Entity\Page
  • The mappings App\Site\Entity\Page#pageDatas and App\Site\Entity\PageData#page are inconsistent with each other.
  • The mappings App\Site\Entity\Page#metaDatas and App\Seo\Entity\MetaData#page are inconsistent with each other.
App\Site\Entity\Template
  • The mappings App\Site\Entity\Template#metaDatas and App\Seo\Entity\MetaData#template are inconsistent with each other.
App\Site\Entity\PageData
  • The association App\Site\Entity\PageData#page refers to the inverse side field App\Site\Entity\Page#pageData which does not exist.
App\Seo\Entity\MetaData
  • The association App\Seo\Entity\MetaData#template refers to the inverse side field App\Site\Entity\Template#metaData which does not exist.
  • The association App\Seo\Entity\MetaData#page refers to the inverse side field App\Site\Entity\Page#metaData which does not exist.
App\Site\Entity\PageDataTranslation No errors.
App\Seo\Entity\MetaDataTranslation No errors.