GET https://dev.petso.halisz.pl/blog/tag/pies?page=2

Query Metrics

12 Database Queries
10 Different statements
10.70 ms Query time
1 Invalid entities
27 Managed entities

Queries

Group similar statements

# Time Info
1 2.16 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t1_.resource_type AS resource_type_3, t1_.resource_id AS resource_id_4, t1_.tag_id AS tag_id_5 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id WHERE t1_.resource_type = ?
Parameters:
[
  "App\Entity\Blog"
]
2 0.77 ms
SELECT t0_.resource_id AS resource_id_0 FROM tag t1_ INNER JOIN tagging t0_ ON t1_.id = t0_.tag_id WHERE t0_.resource_type = ? AND t1_.slug = ?
Parameters:
[
  "App\Entity\Blog"
  "pies"
]
3 1.10 ms
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ WHERE b0_.active = 1 AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  3
  9
  11
  12
  13
  15
  17
  19
  20
  23
  24
]
4 0.59 ms
SELECT DISTINCT b0_.id AS id_0, b0_.date_created_at AS date_created_at_1 FROM blog b0_ WHERE b0_.active = 1 AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.date_created_at DESC LIMIT 9 OFFSET 9
Parameters:
[
  3
  9
  11
  12
  13
  15
  17
  19
  20
  23
  24
]
5 0.87 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.content AS content_4, b0_.date_created_at AS date_created_at_5, b0_.date_updated_at AS date_updated_at_6, b0_.active AS active_7, b0_.is_featured AS is_featured_8, b0_.position AS position_9, b0_.title AS title_10, b0_.meta_title AS meta_title_11, b0_.meta_keywords AS meta_keywords_12, b0_.meta_description AS meta_description_13, b0_.image_id AS image_id_14, b0_.big_image_id AS big_image_id_15, b0_.author_id AS author_id_16 FROM blog b0_ WHERE b0_.active = 1 AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND b0_.id IN (?, ?) ORDER BY b0_.date_created_at DESC
Parameters:
[
  3
  9
  11
  12
  13
  15
  17
  19
  20
  23
  24
  9
  3
]
6 0.87 ms
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
Parameters:
[]
7 0.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.file AS file_4, t0.uuid AS uuid_5, t0.type AS type_6, t0.temp AS temp_7, t0.path AS path_8, t0.width AS width_9, t0.height AS height_10, t0.extension AS extension_11, t0.position AS position_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_15 FROM image t0 WHERE t0.id = ?
Parameters:
[
  1507
]
8 0.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.display_name AS display_name_7 FROM employee t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.file AS file_4, t0.uuid AS uuid_5, t0.type AS type_6, t0.temp AS temp_7, t0.path AS path_8, t0.width AS width_9, t0.height AS height_10, t0.extension AS extension_11, t0.position AS position_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_15 FROM image t0 WHERE t0.id = ?
Parameters:
[
  58
]
10 0.70 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.location AS location_2, a0_.advert_height AS advert_height_3, a0_.advert_width AS advert_width_4, a0_.active AS active_5, a0_.max_quantity AS max_quantity_6 FROM advert_group a0_ WHERE a0_.location = ? AND a0_.active = ?
Parameters:
[
  "blog_list_content"
  1
]
11 0.87 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.location AS location_2, a0_.advert_height AS advert_height_3, a0_.advert_width AS advert_width_4, a0_.active AS active_5, a0_.max_quantity AS max_quantity_6 FROM advert_group a0_ WHERE a0_.location = ? AND a0_.active = ?
Parameters:
[
  "blog_list_content"
  1
]
12 0.87 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.url AS url_2, a0_.image AS image_3, a0_.code AS code_4, a0_.start_at AS start_at_5, a0_.end_at AS end_at_6, a0_.views AS views_7, a0_.clicks AS clicks_8, a0_.unique_views AS unique_views_9, a0_.uuid AS uuid_10, a0_.extension AS extension_11, a0_.alt AS alt_12, a0_.title AS title_13, a0_.weight AS weight_14, a0_.active AS active_15, a0_.advert_group_id AS advert_group_id_16 FROM advert a0_ WHERE a0_.advert_group_id = ? AND a0_.active = ? AND a0_.start_at < ? AND a0_.end_at > ? ORDER BY a0_.weight ASC
Parameters:
[
  15
  1
  "2025-12-06 09:33:35"
  "2025-12-06 09:33:35"
]

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\Tagging 19
App\Entity\Tag 2
App\Entity\Blog 2
App\Entity\Image 2
App\Entity\Employee 1
App\Entity\AdvertGroup 1

Entities Mapping

Class Mapping errors
App\Entity\Tag No errors.
App\Entity\Tagging No errors.
App\Entity\Blog No errors.
App\Entity\Image No errors.
App\Entity\Employee No errors.
App\Entity\Setting No errors.
App\Entity\User
  • The mappings App\Entity\User#plans and App\Entity\UserPlan#owner are inconsistent with each other.
App\Entity\AdvertGroup No errors.
App\Entity\Advert No errors.