Query Metrics
14
Database Queries
10
Different statements
2.40 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.23 ms |
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
]
|
2 | 0.18 ms |
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
]
|
3 | 0.17 ms |
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
]
|
4 | 0.18 ms |
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
]
|
5 | 0.15 ms |
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
]
|
6 | 0.13 ms |
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
]
|
7 | 0.13 ms |
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"
]
|
8 | 0.12 ms |
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:
[
"category"
]
|
9 | 0.41 ms |
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"
]
|
10 | 0.15 ms |
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"
]
|
11 | 0.16 ms |
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
]
|
12 | 0.14 ms |
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:
[
"site_insta_page"
]
|
13 | 0.13 ms |
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:
[
"site_fb_page"
]
|
14 | 0.12 ms |
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:
[
"site_yt_page"
]
|
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. |