GET https://wwwdev2.satur.sk/darcekove-poukazky

Query Metrics

15 Database Queries
9 Different statements
14.44 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 ms
SELECT t0.image AS image_1, t0.pdf AS pdf_2, t0.is_active AS is_active_3, t0.text AS text_4, t0.version AS version_5, t0.position AS position_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.modified_at AS modified_at_9, t0.created_at AS created_at_10, t0.title AS title_11 FROM gift_voucher_template t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
  1
]
2 0.85 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:
[
  2446
]
3 0.78 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:
[
  2448
]
4 0.76 ms
SELECT t0.image AS image_1, t0.pdf AS pdf_2, t0.is_active AS is_active_3, t0.text AS text_4, t0.version AS version_5, t0.position AS position_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.modified_at AS modified_at_9, t0.created_at AS created_at_10, t0.title AS title_11 FROM gift_voucher_template t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC LIMIT 1
Parameters:
[
  1
]
5 0.67 ms
SELECT t0.is_active AS is_active_1, t0.length_from AS length_from_2, t0.length_to AS length_to_3, t0.days_until_boarding AS days_until_boarding_4, t0.price_from AS price_from_5, t0.price_to AS price_to_6, t0.logo AS logo_7, t0.description AS description_8, t0.everifin_id AS everifin_id_9, t0.id AS id_10, t0.title AS title_11, t0.deleted_at AS deleted_at_12, t0.modified_at AS modified_at_13, t0.created_at AS created_at_14 FROM c_payment_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
6 0.55 ms
SELECT t0.slug AS slug_1, t0.capital_city AS capital_city_2, t0.id AS id_3, t0.title AS title_4, t0.deleted_at AS deleted_at_5, t0.modified_at AS modified_at_6, t0.created_at AS created_at_7 FROM country t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  200
]
7 3.52 ms
SELECT c0_.slug AS slug_0, c0_.capital_city AS capital_city_1, c0_.id AS id_2, c0_.title AS title_3, c0_.deleted_at AS deleted_at_4, c0_.modified_at AS modified_at_5, c0_.created_at AS created_at_6 FROM country c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.title ASC
Parameters:
[]
8 0.56 ms
SELECT c0_.slug AS slug_0, c0_.capital_city AS capital_city_1, c0_.id AS id_2, c0_.title AS title_3, c0_.deleted_at AS deleted_at_4, c0_.modified_at AS modified_at_5, c0_.created_at AS created_at_6 FROM country c0_ WHERE (c0_.id = 200) AND (c0_.deleted_at IS NULL)
Parameters:
[]
9 0.90 ms
SELECT t0.image AS image_1, t0.pdf AS pdf_2, t0.is_active AS is_active_3, t0.text AS text_4, t0.version AS version_5, t0.position AS position_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.modified_at AS modified_at_9, t0.created_at AS created_at_10, t0.title AS title_11 FROM gift_voucher_template t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
  1
]
10 0.79 ms
SELECT t0.is_active AS is_active_1, t0.length_from AS length_from_2, t0.length_to AS length_to_3, t0.days_until_boarding AS days_until_boarding_4, t0.price_from AS price_from_5, t0.price_to AS price_to_6, t0.logo AS logo_7, t0.description AS description_8, t0.everifin_id AS everifin_id_9, t0.id AS id_10, t0.title AS title_11, t0.deleted_at AS deleted_at_12, t0.modified_at AS modified_at_13, t0.created_at AS created_at_14 FROM c_payment_type t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
11 1.03 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:
[
  2447
]
12 0.98 ms
SELECT t0.image AS image_1, t0.pdf AS pdf_2, t0.is_active AS is_active_3, t0.text AS text_4, t0.version AS version_5, t0.position AS position_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.modified_at AS modified_at_9, t0.created_at AS created_at_10, t0.title AS title_11 FROM gift_voucher_template t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
  1
]
13 0.63 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
]
14 0.73 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
]
15 0.54 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\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\GiftVoucherTemplate No errors.
Satur\DatabaseBundle\Entity\Page No errors.
Satur\DatabaseBundle\Entity\PageType No errors.
Satur\DatabaseBundle\Entity\ContentSection 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\News No errors.
Satur\DatabaseBundle\Entity\Country No errors.
Satur\DatabaseBundle\Entity\PaymentType No errors.
Satur\DatabaseBundle\Entity\Operator No errors.
Satur\DatabaseBundle\Entity\SourceCountry No errors.
Satur\DatabaseBundle\Entity\NewsletterCategory No errors.
Satur\DatabaseBundle\Entity\Newsletter No errors.