Query Metrics
102
Database Queries
16
Different statements
36.68 ms
Query time
0
Invalid entities
279
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.38 ms (17.40%) |
20 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.barcode AS barcode_3, t0.default_price_order AS default_price_order_4, t0.list_price_order AS list_price_order_5, t0.multiplier AS multiplier_6, t0.length AS length_7, t0.width AS width_8, t0.height AS height_9, t0.weight AS weight_10, t0.product_id AS product_id_11 FROM product_unit t0 WHERE t0.product_id = ?
Parameters:
[
903
]
|
|
6.22 ms (16.95%) |
20 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.warehouseId AS warehouseId_3, t0.date AS date_4, t0.warehouseName AS warehouseName_5, t0.inventoryId AS inventoryId_6, t0.productId AS productId_7 FROM stock_inventory t0 WHERE t0.productId = ?
Parameters:
[
903
]
|
|
6.04 ms (16.46%) |
21 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.currency AS currency_3, t0.price_order AS price_order_4, t0.product_unit_id AS product_unit_id_5 FROM product_price t0 WHERE t0.product_unit_id = ?
Parameters:
[
1
]
|
|
5.61 ms (15.30%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.seo AS seo_7, t0.order AS order_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
246
]
|
|
4.77 ms (13.01%) |
15 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = ? LIMIT 1
Parameters:
[
"b2b_license_end_date"
]
|
|
1.27 ms (3.46%) |
1 |
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?
Parameters:
[
"maintenance_mode"
]
|
|
1.05 ms (2.86%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.95 ms (2.60%) |
1 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.equivalent_code AS equivalent_code_2, p0_.name AS name_3, p0_.meta_description AS meta_description_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.description AS description_7, p0_.seo AS seo_8, p0_.default_unit AS default_unit_9, p0_.quantity AS quantity_10, p0_.tax_rate AS tax_rate_11, p0_.image AS image_12, p0_.currency AS currency_13, p0_.comment_count AS comment_count_14, p0_.star_rate AS star_rate_15, p0_.sales_number AS sales_number_16, p0_.parent_id AS parent_id_17, p0_.model_id AS model_id_18, p0_.brand_id AS brand_id_19 FROM product p0_ INNER JOIN product_unit p1_ ON p0_.id = p1_.product_id AND (p0_.default_unit = p1_.value) INNER JOIN product_price p2_ ON p1_.id = p2_.product_unit_id AND (p1_.default_price_order = p2_.price_order) WHERE p1_.list_price_order > p1_.default_price_order AND p0_.parent_id IS NULL AND p0_.id <> 0 LIMIT 20
Parameters:
[] |
|
0.94 ms (2.57%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.content AS content_5, t0.seo AS seo_6, t0.sortStatus AS sortStatus_7, t0.page_category_id AS page_category_id_8 FROM page t0 WHERE t0.page_category_id = ?
Parameters:
[
1
]
|
|
0.94 ms (2.56%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.brand_id AS brand_id_3 FROM model t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.60 ms (1.64%) |
1 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.equivalent_code AS equivalent_code_2, p0_.name AS name_3, p0_.meta_description AS meta_description_4, p0_.meta_title AS meta_title_5, p0_.meta_keywords AS meta_keywords_6, p0_.description AS description_7, p0_.seo AS seo_8, p0_.default_unit AS default_unit_9, p0_.quantity AS quantity_10, p0_.tax_rate AS tax_rate_11, p0_.image AS image_12, p0_.currency AS currency_13, p0_.comment_count AS comment_count_14, p0_.star_rate AS star_rate_15, p0_.sales_number AS sales_number_16, p0_.parent_id AS parent_id_17, p0_.model_id AS model_id_18, p0_.brand_id AS brand_id_19 FROM product p0_ WHERE p0_.parent_id IS NULL AND p0_.id <> 0 ORDER BY p0_.id DESC LIMIT 20
Parameters:
[] |
|
0.48 ms (1.31%) |
1 |
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_
Parameters:
[] |
|
0.40 ms (1.08%) |
1 |
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.quantity AS quantity_2, c0_.product_id AS product_id_3, c0_.user_id AS user_id_4, c0_.product_unit_id AS product_unit_id_5 FROM cart c0_ WHERE c0_.session_id = ?
Parameters:
[
"1neh6b7rp52vvnnq5j3boau9he"
]
|
|
0.37 ms (1.01%) |
1 |
SELECT t0.id AS id_1, t0.comment_title AS comment_title_2, t0.comment_description AS comment_description_3, t0.order_no AS order_no_4, t0.star AS star_5, t0.date AS date_6, t0.name AS name_7, t0.user_id AS user_id_8, t0.product_id AS product_id_9 FROM user_comment t0
Parameters:
[] |
|
0.34 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.social_media AS social_media_7, t0.email AS email_8, t0.description AS description_9, t0.logo AS logo_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.32 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0
Parameters:
[] |
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\ProductPrice | 126 |
| App\Entity\Setting | 49 |
| App\Entity\ProductUnit | 21 |
| App\Entity\Product | 20 |
| App\Entity\StockInventory | 20 |
| App\Entity\Page | 13 |
| App\Entity\Category | 9 |
| App\Entity\Menu | 5 |
| App\Entity\Brand | 4 |
| App\Entity\Model | 4 |
| App\Entity\PageCategory | 4 |
| App\Entity\Currency | 3 |
| App\Entity\Store | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\ProductUnit | No errors. |
| App\Entity\StockInventory | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\VariantValue | No errors. |
| App\Entity\Campaign | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\ProductPrice | No errors. |
| App\Entity\Currency | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\UserComment | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PageCategory | No errors. |
| App\Entity\Menu | No errors. |