Query Metrics
11
Database Queries
6
Different statements
7.68 ms
Query time
1
Invalid entities
Grouped Statements
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 |
|
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. |