Query Metrics
30
Database Queries
7
Different statements
21.93 ms
Query time
0
Invalid entities
32
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.48 ms (61.44%) |
24 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
"32e5e517-acc6-468a-9c23-fec971f0a12e"
]
|
|
3.45 ms (15.72%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.max_discount AS max_discount_7, p0_.sku AS sku_8, p0_.featured_image AS featured_image_9, p0_.image_gallery AS image_gallery_10, p0_.tabs AS tabs_11, p0_.seo_meta AS seo_meta_12, p0_.is_publish AS is_publish_13, p0_.is_archived AS is_archived_14, p0_.is_featured AS is_featured_15, p0_.is_homepage_slider AS is_homepage_slider_16, p0_.show_in_category AS show_in_category_17, p0_.is_highlighted AS is_highlighted_18, p0_.is_b2_c AS is_b2_c_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.documents AS documents_22, p0_.related_products AS related_products_23, p0_.stock_quantity AS stock_quantity_24, p0_.category_id AS category_id_25, p0_.brand_id AS brand_id_26 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.is_publish = ? AND p0_.is_archived = ? ORDER BY p0_.created_at DESC LIMIT 24
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#971 : "376bdc99-9aec-4b6b-bb5d-49405c98a9e3" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1067 : "3a99e14c-f5ff-407e-be25-283ddd693e16" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1051 : "402585e7-283b-48c9-a986-05fd86db5332" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1086 : "2ce6232c-f4c0-4d3d-babd-498acbf27845" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1082 : "d1d48b9d-49f8-4403-89fc-ddd65aabba5e" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1069 : "c836e3c2-631b-447e-ae8c-09a39316fc0a" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1099 : "bcfbb288-cfad-4d86-a9e8-01742a2ef059" } 1 0 ] |
|
1.81 ms (8.24%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.is_publish = ? AND p0_.is_archived = ?
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#971 : "376bdc99-9aec-4b6b-bb5d-49405c98a9e3" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1067 : "3a99e14c-f5ff-407e-be25-283ddd693e16" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1051 : "402585e7-283b-48c9-a986-05fd86db5332" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1086 : "2ce6232c-f4c0-4d3d-babd-498acbf27845" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1082 : "d1d48b9d-49f8-4403-89fc-ddd65aabba5e" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1069 : "c836e3c2-631b-447e-ae8c-09a39316fc0a" } Ramsey\Uuid\Lazy\LazyUuidFromString {#1099 : "bcfbb288-cfad-4d86-a9e8-01742a2ef059" } 1 0 ] |
|
0.98 ms (4.48%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.subtitle AS subtitle_3, p0_.description AS description_4, p0_.position AS position_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.is_publish AS is_publish_9, p0_.is_archived AS is_archived_10, p0_.tree_root AS tree_root_11, p0_.parent_id AS parent_id_12 FROM product_category p0_ WHERE p0_.parent_id = ? AND p0_.is_archived = ? ORDER BY p0_.position ASC
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#971 : "376bdc99-9aec-4b6b-bb5d-49405c98a9e3" } 0 ] |
|
0.79 ms (3.61%) |
1 |
SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery AS delivery_6, t0.delivery_price AS delivery_price_7, t0.customer_note AS customer_note_8, t0.company_id AS company_id_9, t0.user_id AS user_id_10 FROM `order` t0 WHERE t0.id IS NULL AND t0.status = ? LIMIT 1
Parameters:
[
"cart"
]
|
|
0.74 ms (3.38%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.featured_image AS featured_image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.web_url AS web_url_8, t0.color AS color_9 FROM brand t0 WHERE t0.id = ?
Parameters:
[
"3c2fbdcc-431e-4555-b0ce-11c3cf5a5fc4"
]
|
|
0.68 ms (3.12%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"ambijentalno-ozvucenje"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product | 24 |
| App\Entity\ProductCategory | 7 |
| App\Entity\Brand | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductCategory | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\User | No errors. |