GET https://rakerplus.com/beyaz-klasik-metal-tokali-rugan-erkek-cocuk-kemer-r210-b-32436-p-32436

Query Metrics

52 Database Queries
23 Different statements
53.60 ms Query time
0 Invalid entities
154 Managed entities

Grouped Statements

Show all queries

Time Count Info
16.90 ms
(31.53%)
8
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:
[
  32436
]
5.72 ms
(10.67%)
1
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 INNER JOIN product_to_category ON t0.id = product_to_category.category_id WHERE product_to_category.product_id = ?
Parameters:
[
  32436
]
4.25 ms
(7.93%)
8
SELECT t0.id AS id_1, t0.image AS image_2, t0.name AS name_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  32436
]
4.13 ms
(7.71%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sortstatus AS sortstatus_2, c0_.product_id AS product_id_3 FROM campaign c0_ WHERE c0_.product_id = ?
Parameters:
[
  32436
]
3.93 ms
(7.34%)
8
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:
[
  4528
]
2.77 ms
(5.17%)
7
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 WHERE p2_.id = ?
Parameters:
[
  39445
]
2.75 ms
(5.13%)
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:
[]
2.40 ms
(4.48%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.commision_fee AS commision_fee_3, t0.installment AS installment_4, t0.is_default AS is_default_5, t0.virtual_pos_id AS virtual_pos_id_6 FROM pos_plan t0 WHERE t0.virtual_pos_id = ?
Parameters:
[
  15
]
1.92 ms
(3.59%)
1
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?
Parameters:
[
  "firstPageIsLogin"
]
1.63 ms
(3.05%)
3
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:
[
  "showPaymentPlanPrice"
]
1.03 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1
Parameters:
[]
0.99 ms
(1.85%)
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.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.parent_id = ?
Parameters:
[
  32436
]
0.97 ms
(1.80%)
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.ozelkod AS ozelkod_15, t0.ozelkod2 AS ozelkod2_16, t0.ozelkod3 AS ozelkod3_17, t0.ozelkod4 AS ozelkod4_18, t0.ozelkod5 AS ozelkod5_19, t0.ozelkod6 AS ozelkod6_20, t0.ozelkod7 AS ozelkod7_21, t0.ozelkod8 AS ozelkod8_22, t0.ozelkod9 AS ozelkod9_23, t0.ozelkod10 AS ozelkod10_24, t0.parent_id AS parent_id_25, t0.model_id AS model_id_26, t0.brand_id AS brand_id_27 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "32436"
]
0.58 ms
(1.09%)
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.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.51 ms
(0.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.secure_url AS secure_url_4, t0.store AS store_5, t0.mid AS mid_6, t0.posnet_id AS posnet_id_7, t0.username AS username_8, t0.password AS password_9, t0.is_secure AS is_secure_10, t0.secure_key AS secure_key_11 FROM virtual_pos t0
Parameters:
[]
0.50 ms
(0.94%)
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.47 ms
(0.88%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC
Parameters:
[]
0.47 ms
(0.87%)
1
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0
Parameters:
[]
0.40 ms
(0.74%)
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:
[
  32436
]
0.36 ms
(0.67%)
1
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5, c0_.product_unit_id AS product_unit_id_6 FROM cart c0_ WHERE c0_.session_id = ?
Parameters:
[
  null
]
0.31 ms
(0.58%)
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_ GROUP BY p0_.page_category_id
Parameters:
[]
0.31 ms
(0.58%)
1
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.28 ms
(0.52%)
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\Setting 56
App\Entity\ProductPrice 24
App\Entity\Image 24
App\Entity\PosPlan 12
App\Entity\Category 10
App\Entity\Product 8
App\Entity\ProductUnit 8
App\Entity\Page 4
App\Entity\Currency 3
App\Entity\Brand 1
App\Entity\Variant 1
App\Entity\VirtualPos 1
App\Entity\Store 1
App\Entity\StockInventory 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Setting No errors.
App\Entity\Product No errors.
App\Entity\Model No errors.
App\Entity\Brand 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\ProductPrice No errors.
App\Entity\Variant No errors.
App\Entity\VirtualPos No errors.
App\Entity\PosPlan No errors.
App\Entity\Store No errors.
App\Entity\Currency No errors.
App\Entity\Cart No errors.
App\Entity\Page No errors.
App\Entity\PageCategory No errors.