GET https://wwwdev2.satur.sk/blog/20-najlepsich-chorvatskych-plazi

Query Metrics

14 Database Queries
12 Different statements
12.81 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.61 ms
SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM blog_category t0 WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "20-najlepsich-chorvatskych-plazi"
]
2 3.28 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.publish_from AS publish_from_5, t0.views AS views_6, t0.read_time_min AS read_time_min_7, t0.no_index AS no_index_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.deleted_at AS deleted_at_11, t0.modified_at AS modified_at_12, t0.created_at AS created_at_13, t0.seo_title AS seo_title_14, t0.meta_description AS meta_description_15, t0.meta_image AS meta_image_16, t0.blog_category_id AS blog_category_id_17, t0.destination_id AS destination_id_18 FROM blog t0 WHERE t0.slug = ? AND t0.is_active = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "20-najlepsich-chorvatskych-plazi"
  1
]
3 0.16 ms
"START TRANSACTION"
Parameters:
[]
4 0.48 ms
UPDATE blog SET views = ?, modified_at = ? WHERE id = ?
Parameters:
[
  32888
  "2025-04-04 22:51:06"
  1089
]
5 0.27 ms
"COMMIT"
Parameters:
[]
6 0.66 ms
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.title AS title_3, t0.deleted_at AS deleted_at_4, t0.modified_at AS modified_at_5, t0.created_at AS created_at_6 FROM c_blog_tag t0 INNER JOIN blog_blog_tag ON t0.id = blog_blog_tag.blog_tag_id WHERE blog_blog_tag.blog_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1089
]
7 0.56 ms
SELECT t0.title AS title_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.page_id AS page_id_6, t0.career_id AS career_id_7, t0.blog_id AS blog_id_8, t0.map_item_id AS map_item_id_9 FROM content_section t0 WHERE t0.blog_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1089
]
8 3.22 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.modified_user AS modified_user_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.modified_at AS modified_at_8, t0.created_at AS created_at_9, t0.section_id AS section_id_10 FROM content_block t0 WHERE t0.section_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
  7820
]
9 0.47 ms
SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM blog_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
10 0.72 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.is_popular AS is_popular_4, t0.image AS image_5, t0.image_mobile AS image_mobile_6, t0.image_alt AS image_alt_7, t0.video AS video_8, t0.redirect_url AS redirect_url_9, t0.no_index AS no_index_10, t0.canonical_url AS canonical_url_11, t0.video_url AS video_url_12, t0.video_title AS video_title_13, t0.id AS id_14, t0.deleted_at AS deleted_at_15, t0.modified_at AS modified_at_16, t0.created_at AS created_at_17, t0.seo_title AS seo_title_18, t0.meta_description AS meta_description_19, t0.meta_image AS meta_image_20, t0.type_id AS type_id_21, t0.destination_id AS destination_id_22 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1578
]
11 0.60 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.publish_from AS publish_from_5, t0.views AS views_6, t0.read_time_min AS read_time_min_7, t0.no_index AS no_index_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.deleted_at AS deleted_at_11, t0.modified_at AS modified_at_12, t0.created_at AS created_at_13, t0.seo_title AS seo_title_14, t0.meta_description AS meta_description_15, t0.meta_image AS meta_image_16, t0.blog_category_id AS blog_category_id_17, t0.destination_id AS destination_id_18 FROM blog t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1280
]
12 0.62 ms
SELECT t0.is_visible AS is_visible_1, t0.position AS position_2, t0.external_slug AS external_slug_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM c_newsletter_category t0 WHERE t0.is_visible = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
13 0.66 ms
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.is_popular AS is_popular_4, t0.image AS image_5, t0.image_mobile AS image_mobile_6, t0.image_alt AS image_alt_7, t0.video AS video_8, t0.redirect_url AS redirect_url_9, t0.no_index AS no_index_10, t0.canonical_url AS canonical_url_11, t0.video_url AS video_url_12, t0.video_title AS video_title_13, t0.id AS id_14, t0.deleted_at AS deleted_at_15, t0.modified_at AS modified_at_16, t0.created_at AS created_at_17, t0.seo_title AS seo_title_18, t0.meta_description AS meta_description_19, t0.meta_image AS meta_image_20, t0.type_id AS type_id_21, t0.destination_id AS destination_id_22 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  2445
]
14 0.49 ms
SELECT t0.is_visible AS is_visible_1, t0.position AS position_2, t0.external_slug AS external_slug_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM c_newsletter_category t0 WHERE t0.is_visible = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]

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
Satur\DatabaseBundle\Entity\BlogCategory No errors.
Satur\DatabaseBundle\Entity\Category
  • The mappings Satur\DatabaseBundle\Entity\Category#homepageCategories and Satur\DatabaseBundle\Entity\HomepageCategory#category are inconsistent with each other.
Satur\DatabaseBundle\Entity\Food No errors.
Satur\DatabaseBundle\Entity\Transport No errors.
Satur\DatabaseBundle\Entity\Destination No errors.
Satur\DatabaseBundle\Entity\TourAttribute No errors.
Satur\DatabaseBundle\Entity\AccommodationType No errors.
Satur\DatabaseBundle\Entity\HolidayType No errors.
Satur\DatabaseBundle\Entity\TourRating No errors.
Satur\DatabaseBundle\Entity\SeasonEvent No errors.
Satur\DatabaseBundle\Entity\Blog No errors.
Satur\DatabaseBundle\Entity\ContentSection No errors.
Satur\DatabaseBundle\Entity\Tour No errors.
Satur\DatabaseBundle\Entity\BlogTag No errors.
Satur\DatabaseBundle\Entity\MenuItem
  • The field 'Satur\DatabaseBundle\Entity\MenuItem#entityId' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
Satur\DatabaseBundle\Entity\Page No errors.
Satur\DatabaseBundle\Entity\Career No errors.
Satur\DatabaseBundle\Entity\MapItem No errors.
Satur\DatabaseBundle\Entity\ContentBlock No errors.
Satur\DatabaseBundle\Entity\PageType No errors.
Satur\DatabaseBundle\Entity\News No errors.
Satur\DatabaseBundle\Entity\NewsletterCategory No errors.
Satur\DatabaseBundle\Entity\Newsletter No errors.