Query Metrics
55
Database Queries
29
Different statements
24.73 ms
Query time
0
Invalid entities
97
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.85 ms (19.63%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.code AS code_2, COUNT(DISTINCT p1_.id) AS sclr_3, IF(b0_.code IN ('bartech'), 1, 0) AS sclr_4 FROM brand b0_ INNER JOIN product p1_ ON b0_.id = p1_.brand_id INNER JOIN product_unit p2_ ON p1_.id = p2_.product_id AND (p1_.default_unit = p2_.value) INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id AND (p2_.default_price_order = p3_.price_order) INNER JOIN currency c4_ ON (c4_.code = p3_.currency) WHERE ((p1_.code LIKE ? OR p1_.equivalent_code LIKE ? OR p2_.barcode LIKE ?) OR (p1_.name LIKE ?)) AND (p1_.id <> '' AND p1_.parent_id IS NULL) GROUP BY b0_.id ORDER BY b0_.name ASC
Parameters:
[ "%%" "%%" "%%" "%%" ] |
|
4.35 ms (17.60%) |
19 |
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"
]
|
|
2.12 ms (8.57%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (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 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id INNER JOIN product_unit p2_ ON p0_.id = p2_.product_id AND (p0_.default_unit = p2_.value) INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id AND (p2_.default_price_order = p3_.price_order) INNER JOIN currency c4_ ON (c4_.code = p3_.currency) WHERE ((p0_.code LIKE ? OR p0_.equivalent_code LIKE ? OR p2_.barcode LIKE ?) OR (p0_.name LIKE ?)) AND (p0_.id <> '' AND p0_.parent_id IS NULL) AND b1_.code IN (?) GROUP BY p0_.id ORDER BY b1_.name DESC) dctrn_table
Parameters:
[ "%%" "%%" "%%" "%%" "bartech" ] |
|
2.00 ms (8.09%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, COUNT(p1_.id) AS sclr_8, c0_.parent_id AS parent_id_9 FROM category c0_ INNER JOIN product_to_category p2_ ON c0_.id = p2_.category_id INNER JOIN product p1_ ON p1_.id = p2_.product_id LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id INNER JOIN product_unit p4_ ON p1_.id = p4_.product_id AND (p1_.default_unit = p4_.value) INNER JOIN product_price p5_ ON p4_.id = p5_.product_unit_id AND (p4_.default_price_order = p5_.price_order) INNER JOIN currency c6_ ON (c6_.code = p5_.currency) WHERE ((p1_.code LIKE ? OR p1_.equivalent_code LIKE ? OR p4_.barcode LIKE ?) OR (p1_.name LIKE ?)) AND c0_.parent_id IS NULL AND (p1_.id <> '' AND p1_.parent_id IS NULL) AND b3_.code IN (?) GROUP BY c0_.id ORDER BY c0_.order ASC
Parameters:
[ "%%" "%%" "%%" "%%" "bartech" ] |
|
1.84 ms (7.42%) |
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
]
|
|
1.48 ms (5.98%) |
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_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id INNER JOIN product_unit p2_ ON p0_.id = p2_.product_id AND (p0_.default_unit = p2_.value) INNER JOIN product_price p3_ ON p2_.id = p3_.product_unit_id AND (p2_.default_price_order = p3_.price_order) INNER JOIN currency c4_ ON (c4_.code = p3_.currency) WHERE ((p0_.code LIKE ? OR p0_.equivalent_code LIKE ? OR p2_.barcode LIKE ?) OR (p0_.name LIKE ?)) AND (p0_.id <> '' AND p0_.parent_id IS NULL) AND b1_.code IN (?) GROUP BY p0_.id ORDER BY b1_.name DESC LIMIT 20
Parameters:
[ "%%" "%%" "%%" "%%" "bartech" ] |
|
1.26 ms (5.09%) |
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"
]
|
|
0.68 ms (2.75%) |
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.55 ms (2.24%) |
1 |
SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.name AS name_2 FROM variant v0_ INNER JOIN variant_value v1_ ON v0_.id = v1_.variant_id INNER JOIN product_to_variant_value p3_ ON v1_.id = p3_.variant_value_id INNER JOIN product p2_ ON p2_.id = p3_.product_id LEFT JOIN brand b4_ ON p2_.brand_id = b4_.id INNER JOIN product_unit p5_ ON p2_.id = p5_.product_id AND (p2_.default_unit = p5_.value) INNER JOIN product_price p6_ ON p5_.id = p6_.product_unit_id AND (p5_.default_price_order = p6_.price_order) INNER JOIN currency c7_ ON (c7_.code = p6_.currency) WHERE ((p2_.code LIKE ? OR p2_.equivalent_code LIKE ? OR p5_.barcode LIKE ?) OR (p2_.name LIKE ?)) AND (p2_.id <> '' AND p2_.parent_id IS NULL) AND b4_.code IN (?) GROUP BY v0_.id ORDER BY v0_.name ASC
Parameters:
[ "%%" "%%" "%%" "%%" "bartech" ] |
|
0.51 ms (2.05%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC
Parameters:
[] |
|
0.49 ms (2.00%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC
Parameters:
[] |
|
0.45 ms (1.83%) |
1 |
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
]
|
|
0.36 ms (1.46%) |
1 |
SELECT m0_.id AS id_0, m0_.childStatus AS childStatus_1, m0_.sortStatus AS sortStatus_2, m0_.name AS name_3, m0_.url AS url_4, m0_.page_id AS page_id_5, m0_.category_id AS category_id_6 FROM menu m0_ ORDER BY m0_.sortStatus ASC
Parameters:
[] |
|
0.32 ms (1.29%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ ORDER BY p0_.id ASC
Parameters:
[] |
|
0.31 ms (1.24%) |
1 |
SELECT DISTINCT s0_.warehouseId AS warehouseId_0, s0_.warehouseName AS warehouseName_1 FROM stock_inventory s0_
Parameters:
[] |
|
0.30 ms (1.20%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.brand_id AS brand_id_3 FROM model t0 WHERE t0.brand_id = ?
Parameters:
[
1
]
|
|
0.28 ms (1.15%) |
1 |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.barcode AS barcode_2, p0_.default_price_order AS default_price_order_3, p0_.list_price_order AS list_price_order_4, p0_.multiplier AS multiplier_5, p0_.length AS length_6, p0_.width AS width_7, p0_.height AS height_8, p0_.weight AS weight_9, p1_.id AS id_10, p1_.value AS value_11, p1_.currency AS currency_12, p1_.price_order AS price_order_13, p0_.product_id AS product_id_14, p1_.product_unit_id AS product_unit_id_15 FROM product_unit p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_unit_id WHERE p0_.product_id IN (?)
Parameters:
[
903
]
|
|
0.27 ms (1.09%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ ORDER BY c0_.order ASC
Parameters:
[] |
|
0.24 ms (0.95%) |
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 IN (?)
Parameters:
[
903
]
|
|
0.23 ms (0.93%) |
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.23 ms (0.93%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.equivalent_code AS equivalent_code_3, t0.name AS name_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.description AS description_8, t0.seo AS seo_9, t0.default_unit AS default_unit_10, t0.quantity AS quantity_11, t0.tax_rate AS tax_rate_12, t0.image AS image_13, t0.currency AS currency_14, t0.comment_count AS comment_count_15, t0.star_rate AS star_rate_16, t0.sales_number AS sales_number_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.brand_id AS brand_id_20 FROM product t0 WHERE t0.parent_id = ?
Parameters:
[
903
]
|
|
0.22 ms (0.90%) |
1 |
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_
Parameters:
[] |
|
0.22 ms (0.87%) |
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:
[
null
]
|
|
0.21 ms (0.86%) |
1 |
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
]
|
|
0.20 ms (0.82%) |
1 |
SELECT s0_.id AS id_0, s0_.quantity AS quantity_1, s0_.warehouseId AS warehouseId_2, s0_.date AS date_3, s0_.warehouseName AS warehouseName_4, s0_.inventoryId AS inventoryId_5, s0_.productId AS productId_6 FROM stock_inventory s0_ WHERE s0_.productId IN (?)
Parameters:
[
903
]
|
|
0.20 ms (0.79%) |
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.19 ms (0.78%) |
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:
[] |
|
0.19 ms (0.76%) |
1 |
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
]
|
|
0.18 ms (0.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM brand 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\Setting | 49 |
| App\Entity\Page | 13 |
| App\Entity\Category | 9 |
| App\Entity\ProductPrice | 6 |
| App\Entity\Menu | 5 |
| App\Entity\Brand | 4 |
| App\Entity\PageCategory | 4 |
| App\Entity\Currency | 3 |
| App\Entity\Product | 1 |
| App\Entity\ProductUnit | 1 |
| App\Entity\StockInventory | 1 |
| 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\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\Variant | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\UserComment | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PageCategory | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\CustomerBranch | No errors. |
| App\Entity\SalesRepresentative | No errors. |