GET https://dev.petso.halisz.pl/blog/jak-nauczyc-psa-chodzic-na-smyczy-klucz-do-komfortowego-spaceru-z-psem

Query Metrics

18 Database Queries
9 Different statements
13.97 ms Query time
1 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.date_created_at AS date_created_at_6, t0.date_updated_at AS date_updated_at_7, t0.active AS active_8, t0.is_featured AS is_featured_9, t0.position AS position_10, t0.title AS title_11, t0.meta_title AS meta_title_12, t0.meta_keywords AS meta_keywords_13, t0.meta_description AS meta_description_14, t0.image_id AS image_id_15, t0.big_image_id AS big_image_id_16, t0.author_id AS author_id_17 FROM blog t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "jak-nauczyc-psa-chodzic-na-smyczy-klucz-do-komfortowego-spaceru-z-psem"
]
2 0.82 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id AND (t1_.resource_id = ? AND t1_.resource_type = ?) ORDER BY t0_.name ASC
Parameters:
[
  11
  "App\Entity\Blog"
]
3 0.99 ms
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
Parameters:
[]
4 0.79 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:
[
  3395
]
5 0.67 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
]
6 0.65 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_single_content"
  1
]
7 0.60 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_single_content"
  1
]
8 0.82 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:
[
  16
  1
  "2025-12-06 06:22:50"
  "2025-12-06 06:22:50"
]
9 0.73 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id AND (t1_.resource_id = ? AND t1_.resource_type = ?) ORDER BY t0_.name ASC
Parameters:
[
  11
  "App\Entity\Blog"
]
10 0.71 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 IN (?) ORDER BY RAND() ASC
Parameters:
[
  "App\Entity\Blog"
  "pies"
]
11 1.62 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_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY RAND() ASC LIMIT 3
Parameters:
[
  17
  15
  23
  19
  12
  24
  3
  20
  13
  9
]
12 0.65 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id AND (t1_.resource_id = ? AND t1_.resource_type = ?) ORDER BY t0_.name ASC
Parameters:
[
  11
  "App\Entity\Blog"
]
13 0.66 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 IN (?) ORDER BY RAND() ASC
Parameters:
[
  "App\Entity\Blog"
  "pies"
]
14 1.00 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_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY RAND() ASC LIMIT 3
Parameters:
[
  15
  20
  23
  12
  3
  13
  17
  24
  9
  19
]
15 0.59 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:
[
  15755
]
16 0.54 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:
[
  2
]
17 0.65 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
]
18 0.59 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:
[
  27518
]

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

Entities Mapping

Class Mapping errors
App\Entity\Blog No errors.
App\Entity\Image No errors.
App\Entity\Employee No errors.
App\Entity\Tag No errors.
App\Entity\Tagging 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.