Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.source_path AS source_path_2,
  t0.target_url AS target_url_3,
  t0.status_code AS status_code_4,
  t0.hits_count AS hits_count_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  redirect_rules t0
WHERE
  t0.source_path = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.source_path AS source_path_2, t0.target_url AS target_url_3, t0.status_code AS status_code_4, t0.hits_count AS hits_count_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM redirect_rules t0 WHERE t0.source_path = '/oferty/house/zakopane/apartament-dia-ksiezycowe-apartamenty-spa' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.lead AS lead_5,
  t0.country AS country_6,
  t0.city AS city_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.image_path AS image_path_10,
  t0.image_variants AS image_variants_11,
  t0.featured AS featured_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.meta_title AS meta_title_15,
  t0.meta_description AS meta_description_16,
  t0.canonical_url AS canonical_url_17,
  t0.robots AS robots_18,
  t0.og_title AS og_title_19,
  t0.og_description AS og_description_20,
  t0.og_image AS og_image_21
FROM
  locations t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lead AS lead_5, t0.country AS country_6, t0.city AS city_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.image_path AS image_path_10, t0.image_variants AS image_variants_11, t0.featured AS featured_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.canonical_url AS canonical_url_17, t0.robots AS robots_18, t0.og_title AS og_title_19, t0.og_description AS og_description_20, t0.og_image AS og_image_21 FROM locations t0 WHERE t0.slug = 'zakopane' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4
FROM
  room_type_categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4 FROM room_type_categories t0 WHERE t0.slug = 'house' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type_id AS type_id_2,
  t0.oid AS oid_3,
  t0.title AS title_4,
  t0.advert AS advert_5,
  t0.single_beds AS single_beds_6,
  t0.double_beds AS double_beds_7,
  t0.sofa_beds AS sofa_beds_8,
  t0.sofa_single_beds AS sofa_single_beds_9,
  t0.fold_out_armchairs AS fold_out_armchairs_10,
  t0.extra_beds AS extra_beds_11,
  t0.area AS area_12,
  t0.bedroom_count AS bedroom_count_13,
  t0.bathroom_count AS bathroom_count_14,
  t0.rooms_count AS rooms_count_15,
  t0.floor AS floor_16,
  t0.floor_display AS floor_display_17,
  t0.distance_from_center AS distance_from_center_18,
  t0.tourist_tax AS tourist_tax_19,
  t0.deposit AS deposit_20,
  t0.has_balcony_terrace AS has_balcony_terrace_21,
  t0.exposure AS exposure_22,
  t0.check_in_out_hours AS check_in_out_hours_23,
  t0.garage AS garage_24,
  t0.vat_invoice AS vat_invoice_25,
  t0.price_from AS price_from_26,
  t0.address AS address_27,
  t0.contact_phone AS contact_phone_28,
  t0.city AS city_29,
  t0.zip AS zip_30,
  t0.google_x AS google_x_31,
  t0.google_y AS google_y_32,
  t0.yt_url AS yt_url_33,
  t0.panorama_iframe_html AS panorama_iframe_html_34,
  t0.page_custom_css AS page_custom_css_35,
  t0.page_custom_js AS page_custom_js_36,
  t0.photo AS photo_37,
  t0.photo_s AS photo_s_38,
  t0.category AS category_39,
  t0.tags AS tags_40,
  t0.niceurl AS niceurl_41,
  t0.extrainfo AS extrainfo_42,
  t0.promo AS promo_43,
  t0.description AS description_44,
  t0.instructions AS instructions_45,
  t0.meta_title AS meta_title_46,
  t0.meta_description AS meta_description_47,
  t0.is_active AS is_active_48,
  t0.listing_sort_order AS listing_sort_order_49,
  t0.discount AS discount_50,
  t0.show_discount AS show_discount_51,
  t0.listing_badge_new AS listing_badge_new_52,
  t0.listing_badge_recommend AS listing_badge_recommend_53,
  t0.listing_badge_highlight AS listing_badge_highlight_54,
  t0.pin_home_featured AS pin_home_featured_55,
  t0.pin_home_day_offer AS pin_home_day_offer_56,
  t0.pin_home_recent AS pin_home_recent_57,
  t0.home_featured_sort_order AS home_featured_sort_order_58,
  t0.home_day_offer_sort_order AS home_day_offer_sort_order_59,
  t0.home_recent_sort_order AS home_recent_sort_order_60,
  t0.home_tile_variant AS home_tile_variant_61,
  t0.photos AS photos_62,
  t0.raw_data AS raw_data_63,
  t0.created_at AS created_at_64,
  t0.updated_at AS updated_at_65,
  t0.hotres_account_id AS hotres_account_id_66,
  t0.location_id AS location_id_67,
  t0.category_id AS category_id_68
FROM
  hotres_room_types t0
WHERE
  t0.location_id = ?
  AND t0.niceurl = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_id AS type_id_2, t0.oid AS oid_3, t0.title AS title_4, t0.advert AS advert_5, t0.single_beds AS single_beds_6, t0.double_beds AS double_beds_7, t0.sofa_beds AS sofa_beds_8, t0.sofa_single_beds AS sofa_single_beds_9, t0.fold_out_armchairs AS fold_out_armchairs_10, t0.extra_beds AS extra_beds_11, t0.area AS area_12, t0.bedroom_count AS bedroom_count_13, t0.bathroom_count AS bathroom_count_14, t0.rooms_count AS rooms_count_15, t0.floor AS floor_16, t0.floor_display AS floor_display_17, t0.distance_from_center AS distance_from_center_18, t0.tourist_tax AS tourist_tax_19, t0.deposit AS deposit_20, t0.has_balcony_terrace AS has_balcony_terrace_21, t0.exposure AS exposure_22, t0.check_in_out_hours AS check_in_out_hours_23, t0.garage AS garage_24, t0.vat_invoice AS vat_invoice_25, t0.price_from AS price_from_26, t0.address AS address_27, t0.contact_phone AS contact_phone_28, t0.city AS city_29, t0.zip AS zip_30, t0.google_x AS google_x_31, t0.google_y AS google_y_32, t0.yt_url AS yt_url_33, t0.panorama_iframe_html AS panorama_iframe_html_34, t0.page_custom_css AS page_custom_css_35, t0.page_custom_js AS page_custom_js_36, t0.photo AS photo_37, t0.photo_s AS photo_s_38, t0.category AS category_39, t0.tags AS tags_40, t0.niceurl AS niceurl_41, t0.extrainfo AS extrainfo_42, t0.promo AS promo_43, t0.description AS description_44, t0.instructions AS instructions_45, t0.meta_title AS meta_title_46, t0.meta_description AS meta_description_47, t0.is_active AS is_active_48, t0.listing_sort_order AS listing_sort_order_49, t0.discount AS discount_50, t0.show_discount AS show_discount_51, t0.listing_badge_new AS listing_badge_new_52, t0.listing_badge_recommend AS listing_badge_recommend_53, t0.listing_badge_highlight AS listing_badge_highlight_54, t0.pin_home_featured AS pin_home_featured_55, t0.pin_home_day_offer AS pin_home_day_offer_56, t0.pin_home_recent AS pin_home_recent_57, t0.home_featured_sort_order AS home_featured_sort_order_58, t0.home_day_offer_sort_order AS home_day_offer_sort_order_59, t0.home_recent_sort_order AS home_recent_sort_order_60, t0.home_tile_variant AS home_tile_variant_61, t0.photos AS photos_62, t0.raw_data AS raw_data_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.hotres_account_id AS hotres_account_id_66, t0.location_id AS location_id_67, t0.category_id AS category_id_68 FROM hotres_room_types t0 WHERE t0.location_id = 4 AND t0.niceurl = 'apartament-dia-ksiezycowe-apartamenty-spa' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.auth_code AS auth_code_4,
  t0.api_key AS api_key_5,
  t0.webhook_secret AS webhook_secret_6,
  t0.last_synced_at AS last_synced_at_7,
  t0.last_sync_status AS last_sync_status_8,
  t0.last_sync_message AS last_sync_message_9,
  t0.last_object_data AS last_object_data_10,
  t0.last_room_types_data AS last_room_types_data_11,
  t0.last_room_type_details_data AS last_room_type_details_data_12,
  t0.last_facilities_definitions_data AS last_facilities_definitions_data_13,
  t0.last_rates_data AS last_rates_data_14,
  t0.default_address AS default_address_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.default_location_id AS default_location_id_18
FROM
  hotres_accounts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.auth_code AS auth_code_4, t0.api_key AS api_key_5, t0.webhook_secret AS webhook_secret_6, t0.last_synced_at AS last_synced_at_7, t0.last_sync_status AS last_sync_status_8, t0.last_sync_message AS last_sync_message_9, t0.last_object_data AS last_object_data_10, t0.last_room_types_data AS last_room_types_data_11, t0.last_room_type_details_data AS last_room_type_details_data_12, t0.last_facilities_definitions_data AS last_facilities_definitions_data_13, t0.last_rates_data AS last_rates_data_14, t0.default_address AS default_address_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.default_location_id AS default_location_id_18 FROM hotres_accounts t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4
FROM
  room_type_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4 FROM room_type_categories t0 WHERE t0.id = 1;