http://www.komili.com.tr/

Query Metrics

29 Database Queries
11 Different statements
7.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.81 ms
(49.42%)
19
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:
[
  397
]
1.23 ms
(15.89%)
1
"COMMIT"
Parameters:
[]
0.47 ms
(6.05%)
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-23 08:00:00"
]
0.44 ms
(5.65%)
1
SELECT COUNT(DISTINCT (p0_.id)) AS sclr_0 FROM `product` p0_ WHERE p0_.locale = ? AND p0_.status = ?
Parameters:
[
  "tr"
  1
]
0.37 ms
(4.79%)
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_.order_number AS order_number_9, p0_.image_id AS image_id_10 FROM `product` p0_ WHERE p0_.locale = ? AND p0_.status = ? ORDER BY p0_.order_number ASC LIMIT 25
Parameters:
[
  "tr"
  1
]
0.31 ms
(3.99%)
1
SELECT s0_.id AS id_0, s0_.order_number AS order_number_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.locale AS locale_4, s0_.path AS path_5, s0_.image_id AS image_id_6, s0_.slider_id AS slider_id_7 FROM `slider_item` s0_ LEFT JOIN `slider` s1_ ON s0_.slider_id = s1_.id WHERE s1_.slug = ? ORDER BY s0_.order_number ASC LIMIT 25
Parameters:
[
  "homepage"
]
0.27 ms
(3.44%)
1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.status AS status_5, b0_.slug AS slug_6, b0_.locale AS locale_7, b0_.short_content AS short_content_8, b0_.image_id AS image_id_9 FROM `blog` b0_ WHERE b0_.locale = ? AND b0_.status = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
  "tr"
  1
]
0.26 ms
(3.41%)
1
SELECT COUNT(DISTINCT (s0_.id)) AS sclr_0 FROM `slider_item` s0_ LEFT JOIN `slider` s1_ ON s0_.slider_id = s1_.id WHERE s1_.slug = ?
Parameters:
[
  "homepage"
]
0.26 ms
(3.39%)
1
SELECT COUNT(DISTINCT (b0_.id)) AS sclr_0 FROM `blog` b0_ WHERE b0_.locale = ? AND b0_.status = ?
Parameters:
[
  "tr"
  1
]
0.21 ms
(2.69%)
1
UPDATE `traffic` SET count = ? WHERE id = ?
Parameters:
[
  3106
  22676
]
0.10 ms
(1.27%)
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\Product No errors.
App\Entity\Main\Blog No errors.
App\Entity\Main\Slider\Item No errors.
App\Entity\Main\File No errors.
App\Entity\Main\Slider\Slider No errors.