Query Metrics
11
Database Queries
6
Different statements
6.82 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.94 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3 FROM groups_products t0
Parameters:
[] |
2 | 0.53 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3 FROM materials_products t0
Parameters:
[] |
3 | 1.36 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.66 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 | 0.76 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 | 0.91 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.45 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.34 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.32 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.30 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.26 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 |
|
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. |