https://handmade-demo.ru/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Query Metrics

11 Database Queries
6 Different statements
9.92 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3 FROM groups_products t0
Parameters:
[]
2 1.00 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3 FROM materials_products t0
Parameters:
[]
3 1.57 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.stock_depth AS stock_depth_3, p0_.likes AS likes_4, p0_.views AS views_5, p0_.bought AS bought_6, p0_.price AS price_7, p0_.tags AS tags_8, p0_.price_for_seller AS price_for_seller_9, p0_.status AS status_10, p0_.groups_product_id AS groups_product_id_11, p0_.material_product_id AS material_product_id_12, p0_.seller_id AS seller_id_13 FROM products p0_ ORDER BY p0_.price DESC LIMIT 1
Parameters:
[]
4 0.97 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.stock_depth AS stock_depth_3, p0_.likes AS likes_4, p0_.views AS views_5, p0_.bought AS bought_6, p0_.price AS price_7, p0_.tags AS tags_8, p0_.price_for_seller AS price_for_seller_9, p0_.status AS status_10, p0_.groups_product_id AS groups_product_id_11, p0_.material_product_id AS material_product_id_12, p0_.seller_id AS seller_id_13 FROM products p0_ WHERE p0_.status = ?
Parameters:
[
  1
]
5 1.04 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.number AS number_4, t0.product_id AS product_id_5 FROM image_path t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
6 1.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.website AS website_6, t0.about_me AS about_me_7, t0.icon_path AS icon_path_8, t0.address AS address_9, t0.status AS status_10, t0.password AS password_11, t0.is_verified AS is_verified_12, t0.specialties_id AS specialties_id_13 FROM "users" t0 WHERE t0.id = ?
Parameters:
[
  5
]
7 0.63 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.number AS number_4, t0.product_id AS product_id_5 FROM image_path t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
8 0.53 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.number AS number_4, t0.product_id AS product_id_5 FROM image_path t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
9 0.61 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.number AS number_4, t0.product_id AS product_id_5 FROM image_path t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
10 0.67 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.number AS number_4, t0.product_id AS product_id_5 FROM image_path t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
11 0.64 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.number AS number_4, t0.product_id AS product_id_5 FROM image_path t0 WHERE t0.product_id = ?
Parameters:
[
  7
]

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\Entity\GroupProducts No errors.
App\Entity\MaterialProducts No errors.
App\Entity\Product No errors.
App\Entity\User
  • The association App\Entity\User#specialties refers to the inverse side field App\Entity\Specialties#user_id which does not exist.
App\Entity\ImagePath No errors.
App\Entity\ProductsSizes No errors.
App\Entity\Specialties No errors.
App\Entity\ShopCart No errors.
App\Entity\Order No errors.
App\Entity\Roles No errors.
App\Entity\Comment No errors.