GET https://wwwdev2.satur.sk/odporucania

Query Metrics

4 Database Queries
3 Different statements
3.05 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.41 ms
(46.13%)
2
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
]
0.84 ms
(27.41%)
1
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
]
0.81 ms
(26.46%)
1
SELECT t0.title AS title_1, t0.subtitle AS subtitle_2, t0.text_icon1 AS text_icon1_3, t0.text_icon2 AS text_icon2_4, t0.text_icon3 AS text_icon3_5, t0.icon1 AS icon1_6, t0.icon2 AS icon2_7, t0.icon3 AS icon3_8, t0.url AS url_9, t0.image AS image_10, t0.image_mobile AS image_mobile_11, t0.tag_text AS tag_text_12, t0.tag_color AS tag_color_13, t0.is_active AS is_active_14, t0.date_from AS date_from_15, t0.date_to AS date_to_16, t0.is_satur AS is_satur_17, t0.is_exclusive AS is_exclusive_18, t0.position AS position_19, t0.id AS id_20, t0.deleted_at AS deleted_at_21, t0.modified_at AS modified_at_22, t0.created_at AS created_at_23 FROM recommendation t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position DESC
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\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\BlogCategory No errors.
Satur\DatabaseBundle\Entity\Recommendation 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\NewsletterCategory No errors.
Satur\DatabaseBundle\Entity\Newsletter No errors.
Satur\DatabaseBundle\Entity\Page No errors.
Satur\DatabaseBundle\Entity\PageType No errors.
Satur\DatabaseBundle\Entity\ContentSection No errors.
Satur\DatabaseBundle\Entity\News No errors.