Query Metrics
270
Database Queries
5
Different statements
384.27 ms
Query time
0
Invalid entities
593
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
216.39 ms (56.31%) |
149 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.price AS price_6, t0.special_price AS special_price_7, t0.max_discount AS max_discount_8, t0.sku AS sku_9, t0.featured_image AS featured_image_10, t0.image_gallery AS image_gallery_11, t0.tabs AS tabs_12, t0.seo_meta AS seo_meta_13, t0.is_publish AS is_publish_14, t0.is_archived AS is_archived_15, t0.is_featured AS is_featured_16, t0.is_homepage_slider AS is_homepage_slider_17, t0.show_in_category AS show_in_category_18, t0.is_highlighted AS is_highlighted_19, t0.is_b2_c AS is_b2_c_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.documents AS documents_23, t0.related_products AS related_products_24, t0.stock_quantity AS stock_quantity_25, t0.category_id AS category_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.id = ?
Parameters:
[
"72eb4293-ec1c-43cd-84bf-d56abdfd0364"
]
|
|
122.96 ms (32.00%) |
100 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.order_ref_id AS order_ref_id_4 FROM order_item t0 WHERE t0.order_ref_id = ?
Parameters:
[
7340
]
|
|
22.58 ms (5.88%) |
19 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.oib AS oib_3, t0.phone AS phone_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.address AS address_8, t0.delivery_address AS delivery_address_9, t0.payment_type AS payment_type_10, t0.discounts AS discounts_11, t0.is_verified AS is_verified_12, t0.city AS city_13, t0.postal_code AS postal_code_14 FROM company t0 WHERE t0.id = ?
Parameters:
[
"7f129f22-79ba-41e9-a50a-65c9070b559d"
]
|
|
14.55 ms (3.79%) |
1 |
SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.status AS status_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.delivery AS delivery_5, o0_.delivery_price AS delivery_price_6, o0_.customer_note AS customer_note_7, o0_.company_id AS company_id_8, o0_.user_id AS user_id_9 FROM `order` o0_ WHERE o0_.status = ? ORDER BY o0_.created_at DESC LIMIT 100
Parameters:
[
"order"
]
|
|
7.80 ms (2.03%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status = ?
Parameters:
[
"order"
]
|
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\OrderItem | 261 |
| App\Entity\Product | 149 |
| App\Entity\Order | 100 |
| App\Entity\ProductCategory | 33 |
| App\Entity\Company | 19 |
| App\Entity\User | 19 |
| App\Entity\Brand | 12 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Order | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\User | No errors. |