https://handmade-demo.ru/

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.33 ms
(30.27%)
6
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
]
1.70 ms
(22.12%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3 FROM groups_products t0
Parameters:
[]
1.52 ms
(19.74%)
1
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:
[]
0.94 ms
(12.17%)
1
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
]
0.76 ms
(9.92%)
1
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
]
0.44 ms
(5.78%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3 FROM materials_products t0
Parameters:
[]

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.