Query Metrics
192
Database Queries
8
Different statements
65.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
50.38 ms (77.15%) |
152 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = ? AND t0.category3_id = ?) ORDER BY t0.sort ASC
Parameters:
[ 1 1 ] |
|
9.82 ms (15.05%) |
31 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = ? ORDER BY t0.sort ASC
Parameters:
[
1
]
|
|
1.51 ms (2.31%) |
4 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category1_id AS category1_id_5 FROM category2 t0 WHERE t0.category1_id = ? ORDER BY t0.sort ASC
Parameters:
[
1
]
|
|
0.81 ms (1.25%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.active AS active_4, t0.created AS created_5, t0.updated AS updated_6, t0.address AS address_7, t0.city AS city_8, t0.codepostal AS codepostal_9, t0.phone AS phone_10, t0.mobile AS mobile_11, t0.country AS country_12, t0.logo AS logo_13, t0.description AS description_14, t0.email AS email_15, t0.seotitle AS seotitle_16, t0.seodescription AS seodescription_17, t0.shop AS shop_18 FROM store t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"hometrends"
]
|
|
0.78 ms (1.20%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.price AS price_4, t0.active AS active_5, t0.created AS created_6, t0.updated AS updated_7, t0.description AS description_8, t0.sku AS sku_9, t0.dimension AS dimension_10, t0.detail AS detail_11, t0.quantity AS quantity_12, t0.homepage AS homepage_13, t0.codeurl AS codeurl_14, t0.sort AS sort_15, t0.category_id AS category_id_16, t0.store_id AS store_id_17, t0.secondcategory_id AS secondcategory_id_18, t0.thirdcategory_id AS thirdcategory_id_19, t0.family_id AS family_id_20 FROM product t0 WHERE t0.store_id = ? AND t0.codeurl = ? LIMIT 1
Parameters:
[ 2 "komodo-5-piece-outdoor-sofa-set" ] |
|
0.74 ms (1.13%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.active AS active_3, t0.sort AS sort_4, t0.product_id AS product_id_5 FROM product_image t0 WHERE (t0.active = ? AND t0.product_id = ?) ORDER BY t0.sort ASC
Parameters:
[ 1 113 ] |
|
0.69 ms (1.06%) |
1 |
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.updated AS updated_2, c0_.sort AS sort_3 FROM category1 c0_ WHERE c0_.sort <> 50 ORDER BY c0_.sort ASC LIMIT 7
Parameters:
[] |
|
0.56 ms (0.86%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.active AS active_4, t0.created AS created_5, t0.updated AS updated_6, t0.product_id AS product_id_7 FROM attribute t0 WHERE t0.product_id = ?
Parameters:
[
113
]
|
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\Store | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Family | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\Category1 | No errors. |
| App\Entity\Category2 | No errors. |
| App\Entity\Category3 | No errors. |
| App\Entity\Value | No errors. |