GET https://wwwdev2.satur.sk/planet-fun/animatori/sofia-kralikova

Query Metrics

13 Database Queries
11 Different statements
13.46 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.name AS name_1, t0.image AS image_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.about_me AS about_me_5, t0.motto AS motto_6, t0.email AS email_7, t0.is_in_filter AS is_in_filter_8, t0.no_index AS no_index_9, t0.phone AS phone_10, t0.subtitle AS subtitle_11, t0.background_image AS background_image_12, t0.background_image_alt AS background_image_alt_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.staff_type_id AS staff_type_id_21 FROM staff t0 WHERE t0.slug = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "sofia-kralikova"
]
2 0.62 ms
SELECT t0.position AS position_1, t0.question AS question_2, t0.answer AS answer_3, t0.image AS image_4, t0.image_alt AS image_alt_5, t0.is_active AS is_active_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.staff_id AS staff_id_11 FROM staff_question t0 WHERE t0.staff_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position DESC
Parameters:
[
  656
]
3 2.59 ms
SELECT t0_.start_date AS start_date_0, t0_.end_date AS end_date_1, t0_.price_original AS price_original_2, t0_.price_final AS price_final_3, t0_.term_id AS term_id_4, t0_.nights AS nights_5, t0_.days AS days_6, t0_.is_lm AS is_lm_7, t0_.is_fm AS is_fm_8, t0_.is_promo AS is_promo_9, t0_.lowest_nigth_original_price AS lowest_nigth_original_price_10, t0_.lm_price AS lm_price_11, t0_.lm_discount AS lm_discount_12, t0_.departure_there_date AS departure_there_date_13, t0_.arrival_there_date AS arrival_there_date_14, t0_.departure_back_date AS departure_back_date_15, t0_.arrival_back_date AS arrival_back_date_16, t0_.transfers_count AS transfers_count_17, t0_.loyalty_prices AS loyalty_prices_18, t0_.unique_key AS unique_key_19, t0_.updated AS updated_20, t0_.is_child_for_euro AS is_child_for_euro_21, t0_.flight_there_tickets_count AS flight_there_tickets_count_22, t0_.flight_there_number AS flight_there_number_23, t0_.flight_back_tickets_count AS flight_back_tickets_count_24, t0_.flight_back_number AS flight_back_number_25, t0_.is_magic_lm AS is_magic_lm_26, t0_.id AS id_27, t0_.deleted_at AS deleted_at_28, t0_.modified_at AS modified_at_29, t0_.created_at AS created_at_30, t0_.tour_season_id AS tour_season_id_31, t0_.food_id AS food_id_32, t0_.transport_id AS transport_id_33, t0_.departure_there_airport_id AS departure_there_airport_id_34, t0_.arrival_there_airport_id AS arrival_there_airport_id_35, t0_.departure_back_airport_id AS departure_back_airport_id_36, t0_.arrival_back_airport_id AS arrival_back_airport_id_37, t0_.package_id AS package_id_38, t0_.source_room_id AS source_room_id_39 FROM tour_term t0_ LEFT JOIN staff_tour_term s1_ ON (s1_.term_id = t0_.id) AND (s1_.deleted_at IS NULL) LEFT JOIN staff_tour s2_ ON (s1_.staff_tour_id = s2_.id) AND (s2_.deleted_at IS NULL) WHERE (s2_.staff_id = ?) AND (t0_.deleted_at IS NULL) ORDER BY t0_.start_date ASC
Parameters:
[
  656
]
4 2.50 ms
SELECT s0_.name AS name_0, s0_.image AS image_1, s0_.is_active AS is_active_2, s0_.slug AS slug_3, s0_.about_me AS about_me_4, s0_.motto AS motto_5, s0_.email AS email_6, s0_.is_in_filter AS is_in_filter_7, s0_.no_index AS no_index_8, s0_.phone AS phone_9, s0_.subtitle AS subtitle_10, s0_.background_image AS background_image_11, s0_.background_image_alt AS background_image_alt_12, s0_.id AS id_13, s0_.deleted_at AS deleted_at_14, s0_.modified_at AS modified_at_15, s0_.created_at AS created_at_16, s0_.seo_title AS seo_title_17, s0_.meta_description AS meta_description_18, s0_.meta_image AS meta_image_19, s0_.staff_type_id AS staff_type_id_20 FROM staff s0_ WHERE (s0_.is_active = 1 AND s0_.staff_type_id IN (?, ?) AND s0_.id <> ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.name ASC LIMIT 6
Parameters:
[
  3
  5
  656
]
5 0.97 ms
SELECT count(s0_.id) AS sclr_0 FROM staff s0_ WHERE (s0_.is_active = 1 AND s0_.staff_type_id = ? AND s0_.id <> ?) AND (s0_.deleted_at IS NULL)
Parameters:
[
  3
  656
]
6 0.42 ms
SELECT t0.plural AS plural_1, t0.slug AS slug_2, t0.is_active AS is_active_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_staff_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  3
]
7 0.52 ms
SELECT t0.position AS position_1, t0.term AS term_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.ski_academy AS ski_academy_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.staff_id AS staff_id_10, t0.tour_id AS tour_id_11 FROM staff_tour t0 WHERE t0.staff_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  656
]
8 1.52 ms
SELECT t0.title AS title_1, t0.force_title AS force_title_2, t0.title_alternative AS title_alternative_3, t0.slug AS slug_4, t0.giata AS giata_5, t0.is_hidden AS is_hidden_6, t0.hidden_slug AS hidden_slug_7, t0.has_custom_giata AS has_custom_giata_8, t0.redirect_url AS redirect_url_9, t0.unique_code AS unique_code_10, t0.score AS score_11, t0.custom_covid AS custom_covid_12, t0.show_custom_covid AS show_custom_covid_13, t0.storno_days AS storno_days_14, t0.is_active AS is_active_15, t0.is_verified AS is_verified_16, t0.no_index AS no_index_17, t0.media_migrated AS media_migrated_18, t0.disable_images_edit AS disable_images_edit_19, t0.imported_at AS imported_at_20, t0.disable_reviews AS disable_reviews_21, t0.return_discount AS return_discount_22, t0.return_discount_magic_code AS return_discount_magic_code_23, t0.allowed_for_dynamic_screen AS allowed_for_dynamic_screen_24, t0.id AS id_25, t0.deleted_at AS deleted_at_26, t0.modified_at AS modified_at_27, t0.created_at AS created_at_28, t0.seo_title AS seo_title_29, t0.meta_description AS meta_description_30, t0.meta_image AS meta_image_31, t0.latitude AS latitude_32, t0.longitude AS longitude_33, t0.parent_id AS parent_id_34, t35.elastic_tour_import AS elastic_tour_import_36, t35.elastic_tour_term_import AS elastic_tour_term_import_37, t35.tmr_import AS tmr_import_38, t35.magic_import AS magic_import_39, t35.travel_data_import AS travel_data_import_40, t35.ignas_import AS ignas_import_41, t35.euro_tours_import AS euro_tours_import_42, t35.plachetnice_import AS plachetnice_import_43, t35.atis_import AS atis_import_44, t35.phobs_import AS phobs_import_45, t35.id AS id_46, t35.deleted_at AS deleted_at_47, t35.modified_at AS modified_at_48, t35.created_at AS created_at_49, t35.tour_id AS tour_id_50, t0.image_tag_category_id AS image_tag_category_id_51, t0.description_season_id AS description_season_id_52, t0.attribute_season_id AS attribute_season_id_53, t54.title AS title_55, t54.json AS json_56, t54.is_active AS is_active_57, t54.id AS id_58, t54.deleted_at AS deleted_at_59, t54.modified_at AS modified_at_60, t54.created_at AS created_at_61, t54.tour_id AS tour_id_62, t0.rating_id AS rating_id_63, t0.main_destination_id AS main_destination_id_64 FROM tour t0 LEFT JOIN tour_log t35 ON t35.tour_id = t0.id LEFT JOIN tour_program t54 ON t54.tour_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  5698
]
9 0.87 ms
SELECT t0.title AS title_1, t0.code AS code_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.alternative_title AS alternative_title_7, t0.is_active AS is_active_8, t0.description AS description_9, t0.capital_city AS capital_city_10, t0.time_shift AS time_shift_11, t0.must_visit_radius AS must_visit_radius_12, t0.title_lokal AS title_lokal_13, t0.title_genitiv AS title_genitiv_14, t0.title_in_search AS title_in_search_15, t0.district_id AS district_id_16, t0.location_id AS location_id_17, t0.images_season AS images_season_18, t0.image AS image_19, t0.popular_image AS popular_image_20, t0.image_alt AS image_alt_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.tree_root AS tree_root_28, t0.parent_id AS parent_id_29, t0.currency_id AS currency_id_30, t0.continent_id AS continent_id_31 FROM destination t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  737
]
10 0.82 ms
SELECT t0.title AS title_1, t0.code AS code_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.slug AS slug_6, t0.alternative_title AS alternative_title_7, t0.is_active AS is_active_8, t0.description AS description_9, t0.capital_city AS capital_city_10, t0.time_shift AS time_shift_11, t0.must_visit_radius AS must_visit_radius_12, t0.title_lokal AS title_lokal_13, t0.title_genitiv AS title_genitiv_14, t0.title_in_search AS title_in_search_15, t0.district_id AS district_id_16, t0.location_id AS location_id_17, t0.images_season AS images_season_18, t0.image AS image_19, t0.popular_image AS popular_image_20, t0.image_alt AS image_alt_21, t0.id AS id_22, t0.deleted_at AS deleted_at_23, t0.modified_at AS modified_at_24, t0.created_at AS created_at_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.tree_root AS tree_root_28, t0.parent_id AS parent_id_29, t0.currency_id AS currency_id_30, t0.continent_id AS continent_id_31 FROM destination t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  167
]
11 0.53 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
]
12 0.68 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
]
13 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\Staff No errors.
Satur\DatabaseBundle\Entity\StaffType No errors.
Satur\DatabaseBundle\Entity\StaffQuestion No errors.
Satur\DatabaseBundle\Entity\StaffTour No errors.
Satur\DatabaseBundle\Entity\User
  • The field Satur\DatabaseBundle\Entity\User#favoriteCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Satur\DatabaseBundle\Entity\UserFavoriteCategory#user does not contain the required 'inversedBy="favoriteCategories"' attribute.
Satur\DatabaseBundle\Entity\AnimationGallery No errors.
Satur\DatabaseBundle\Entity\StaffTourTerm No errors.
Satur\DatabaseBundle\Entity\TourTerm No errors.
Satur\DatabaseBundle\Entity\TourSeason No errors.
Satur\DatabaseBundle\Entity\Airport No errors.
Satur\DatabaseBundle\Entity\Package No errors.
Satur\DatabaseBundle\Entity\SourceRoom No errors.
Satur\DatabaseBundle\Entity\Tour No errors.
Satur\DatabaseBundle\Entity\TourLog No errors.
Satur\DatabaseBundle\Entity\TourImageTagCategory No errors.
Satur\DatabaseBundle\Entity\TourProgram No errors.
Satur\DatabaseBundle\Entity\TourVideo No errors.
Satur\DatabaseBundle\Entity\TourImage No errors.
Satur\DatabaseBundle\Entity\TourTab No errors.
Satur\DatabaseBundle\Entity\TourSale No errors.
Satur\DatabaseBundle\Entity\TourRoom No errors.
Satur\DatabaseBundle\Entity\TourReview No errors.
Satur\DatabaseBundle\Entity\TourMustVisit No errors.
Satur\DatabaseBundle\Entity\ReservationTour No errors.
Satur\DatabaseBundle\Entity\TourInfoMessage No errors.
Satur\DatabaseBundle\Entity\PriceExport No errors.
Satur\DatabaseBundle\Entity\FirstMinuteSetting No errors.
Satur\DatabaseBundle\Entity\ForbiddenSource No errors.
Satur\DatabaseBundle\Entity\CategoryTopDestinationTour No errors.
Satur\DatabaseBundle\Entity\TourStorno No errors.
Satur\DatabaseBundle\Entity\AnimationProgram No errors.
Satur\DatabaseBundle\Entity\TourPackage No errors.
Satur\DatabaseBundle\Entity\OlympicTeam No errors.
Satur\DatabaseBundle\Entity\LastVisitedTour No errors.
Satur\DatabaseBundle\Entity\Blog No errors.
Satur\DatabaseBundle\Entity\Offering No errors.
Satur\DatabaseBundle\Entity\CategoryOffer No errors.
Satur\DatabaseBundle\Entity\DiscountCode
  • The field 'Satur\DatabaseBundle\Entity\DiscountCode#formId' has the property type 'int' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
Satur\DatabaseBundle\Entity\DynamicScreen No errors.
Satur\DatabaseBundle\Entity\Currency No errors.
Satur\DatabaseBundle\Entity\Continent No errors.
Satur\DatabaseBundle\Entity\MustVisit No errors.
Satur\DatabaseBundle\Entity\Climate No errors.
Satur\DatabaseBundle\Entity\SourceDestination No errors.
Satur\DatabaseBundle\Entity\Page No errors.
Satur\DatabaseBundle\Entity\CategorySeoDestination No errors.
Satur\DatabaseBundle\Entity\Region No errors.
Satur\DatabaseBundle\Entity\PaymentType No errors.
Satur\DatabaseBundle\Entity\ExtraService No errors.
Satur\DatabaseBundle\Entity\CheckTerm No errors.
Satur\DatabaseBundle\Entity\FlightDuration No errors.
Satur\DatabaseBundle\Entity\MapItem No errors.
Satur\DatabaseBundle\Entity\CategoryInfoMessage No errors.
Satur\DatabaseBundle\Entity\Bookmark 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\PageType No errors.
Satur\DatabaseBundle\Entity\ContentSection No errors.
Satur\DatabaseBundle\Entity\News No errors.