GET https://bahcematik.com/search?brand=bartech&page=1&sort=-brand

Query Metrics

55 Database Queries
29 Different statements
24.73 ms Query time
0 Invalid entities
97 Managed entities

Grouped Statements

Show all queries

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.