http://komili.com.tr/urunler/sivi-sabun/yeni-komili-ekolojik-konsantre-sivi-sabun-1

Query Metrics

13 Database Queries
9 Different statements
4.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.13 ms
(26.80%)
1
"COMMIT"
Parameters:
[]
0.72 ms
(17.07%)
5
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.mine_type AS mine_type_4, t0.original_name AS original_name_5, t0.name AS name_6, t0.original_extension AS original_extension_7 FROM `file` t0 WHERE t0.id = ?
Parameters:
[
  248
]
0.56 ms
(13.29%)
1
SELECT COUNT(DISTINCT (p0_.id)) AS sclr_0 FROM `product_item_type` p0_ LEFT JOIN `product_item` p1_ ON p0_.item_id = p1_.id WHERE p1_.id = ? AND p0_.locale = ? AND p0_.status = ?
Parameters:
[
  33
  "tr"
  1
]
0.40 ms
(9.53%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.count AS count_3 FROM `traffic` t0 WHERE t0.created_at = ? LIMIT 1
Parameters:
[
  "2024-11-21 10:00:00"
]
0.39 ms
(9.30%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.status AS status_5, p0_.slug AS slug_6, p0_.locale AS locale_7, p0_.short_content AS short_content_8, p0_.image_id AS image_id_9, p0_.item_id AS item_id_10 FROM `product_item_type` p0_ LEFT JOIN `product_item` p1_ ON p0_.item_id = p1_.id WHERE p1_.id = ? AND p0_.locale = ? AND p0_.status = ? ORDER BY p0_.id ASC LIMIT 25
Parameters:
[
  33
  "tr"
  1
]
0.38 ms
(9.06%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.short_content AS short_content_9, t0.image_id AS image_id_10, t0.product_id AS product_id_11 FROM `product_item` t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "yeni-komili-ekolojik-konsantre-sivi-sabun-1"
]
0.30 ms
(7.15%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.short_content AS short_content_9, t0.order_number AS order_number_10, t0.image_id AS image_id_11 FROM `product` t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.20 ms
(4.73%)
1
UPDATE `traffic` SET count = ? WHERE id = ?
Parameters:
[
  2802
  22630
]
0.13 ms
(3.07%)
1
"START TRANSACTION"
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.

Entities Mapping

Class Mapping errors
App\Entity\Main\Traffic No errors.
App\Entity\Main\Product\Item No errors.
App\Entity\Main\Product\ItemType No errors.
App\Entity\Main\File No errors.
App\Entity\Main\Product\Product No errors.
App\Entity\Main\Product\Property No errors.