Query Metrics
14
Database Queries
10
Different statements
2.40 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.54 ms (22.32%) |
4 |
SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.title AS title_3, t0.page AS page_4, t0.path AS path_5, t0.body AS body_6, t0.created AS created_7, t0.updated AS updated_8, t0.uid AS uid_9, t0.status AS status_10 FROM content t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"free_shipping_banner"
]
|
0.41 ms (17.11%) |
1 |
SELECT p0_.id AS id_0, p0_.path AS path_1, p0_.title AS title_2, p1_.id AS id_3, p1_.color AS color_4, p1_.size AS size_5, p2_.image AS image_6, p0_.styledescription AS styledescription_7, p0_.type AS type_8, p1_.price AS price_9, p1_.actual_price AS actual_price_10, p1_.total AS total_11, p0_.totalcount AS totalcount_12 FROM product p0_, product_variation p1_, product_image p2_ WHERE p1_.product_id = p0_.id AND p2_.product_id = p0_.id AND p0_.status = 1 AND p0_.style = ? GROUP BY p0_.id LIMIT 12
Parameters:
[
"1"
]
|
0.25 ms (10.23%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.status AS status_4 FROM attribute t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"collections"
]
|
0.23 ms (9.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template_pack AS template_pack_5, t0.howitwork AS howitwork_6, t0.uid AS uid_7, t0.status AS status_8 FROM global_category t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
0.18 ms (7.66%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template_pack AS template_pack_5, t0.design_width AS design_width_6, t0.design_height AS design_height_7, t0.global_category AS global_category_8, t0.uid AS uid_9, t0.status AS status_10 FROM product_category t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
0.18 ms (7.61%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.description AS description_4, t0.image AS image_5, t0.sizechart AS sizechart_6, t0.howitwork AS howitwork_7, t0.product_category AS product_category_8, t0.uid AS uid_9, t0.status AS status_10 FROM style t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
0.17 ms (7.12%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.howitwork AS howitwork_5, t0.uid AS uid_6, t0.status AS status_7 FROM product_type t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
0.16 ms (6.66%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.country AS country_4, t0.access AS access_5, t0.accessed AS accessed_6, t0.created AS created_7, t0.updated AS updated_8, t0.status AS status_9 FROM city t0 WHERE t0.status = ? ORDER BY t0.access DESC
Parameters:
[
1
]
|
0.15 ms (6.20%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.price AS price_5, t0.uid AS uid_6, t0.status AS status_7 FROM size t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
0.13 ms (5.37%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color_code AS color_code_3, t0.extra_code AS extra_code_4, t0.color_group AS color_group_5, t0.status AS status_6 FROM color t0 WHERE t0.status = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
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\GlobalCategory | No errors. |
App\Entity\ProductCategory | No errors. |
App\Entity\ProductType | No errors. |
App\Entity\Style | No errors. |
App\Entity\Size | No errors. |
App\Entity\Color | No errors. |
App\Entity\Attribute | No errors. |
App\Entity\Product | No errors. |
App\Entity\ProductVariation | No errors. |
App\Entity\ProductImage | No errors. |
App\Entity\Content | No errors. |
App\Entity\City | No errors. |