Vonyarcvashegyi irodaként sokrétű szolgáltatással segítjük a balatoni nyaralását. Az év minden napján készséggel állunk rendelkezésére Frissítettük adatvédelmi szabályzatunkat. Oldalunk sütiket használ. Részletek... The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.
Kiemelt szállásajánlataink
Top ajánlataink
Rangsoroltuk legjobb szállásainkat
#Birotours
Fedezze fel a Nyugat-Balaton és Hévíz szépségeit!Kérdése van?
Notice
Undefined index: slide_order on line 45 in file /home/birotours.hu/public_html/wp-content/plugins/revslider/includes/slide.class.php
No entries found.
0.0970
SELECT option_value
FROM wp_options
WHERE option_name = 'uninstall_plugins'
LIMIT 1
0.0970
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_flag_location'
LIMIT 1
0.0870
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_locales_html'
LIMIT 1
0.0911
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_url_mode'
LIMIT 1
0.0880
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_use_strftime'
LIMIT 1
0.0851
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_hide_untranslated'
LIMIT 1
0.0620
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_show_displayed_language_prefix'
LIMIT 1
0.0579
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_show_alternative_content'
LIMIT 1
0.0589
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_hide_default_language'
LIMIT 1
0.0598
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_use_secure_cookie'
LIMIT 1
0.0832
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_header_css'
LIMIT 1
0.0660
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_text_field_filters'
LIMIT 1
0.0679
SELECT option_value
FROM wp_options
WHERE option_name = 'qtranslate_disable_client_cookies'
LIMIT 1
6.1438
SELECT option_name
FROM wp_options
WHERE FALSE OR option_name LIKE "blogname" OR option_name LIKE "blogdescription" OR option_name LIKE "widget_%" OR option_name LIKE "peadig_eucookie"
0.5541
show tables like 'wp_revslider_sliders'
0.2689
show tables like 'wp_revslider_slides'
0.2089
show tables like 'wp_revslider_static_slides'
0.2010
show tables like 'wp_revslider_css'
0.1969
show tables like 'wp_revslider_layer_animations'
0.2141
show tables like 'wp_revslider_navigations'
0.2549
show tables like 'wp_mappress_maps'
0.1750
show tables like 'wp_mappress_posts'
0.0880
SELECT option_value
FROM wp_options
WHERE option_name = '_transient_timeout_aiosp_sitemap_rules_flushed'
LIMIT 1
0.0401
SELECT option_value
FROM wp_options
WHERE option_name = '_transient_aiosp_sitemap_rules_flushed'
LIMIT 1
0.1011
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1
AND wp_posts.ID = 2
AND wp_posts.post_type = 'page'
ORDER BY wp_posts.post_date DESC
0.0510
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (2)
ORDER BY meta_id ASC
0.0851
SELECT p.ID, pm.meta_value, p.post_type, p.post_status
FROM wp_posts AS p
INNER JOIN wp_postmeta AS pm ON (pm.post_id = p.ID)
WHERE pm.meta_key = 'custom_permalink'
AND (pm.meta_value = '' OR pm.meta_value = '/')
AND p.post_status != 'trash'
AND p.post_type != 'nav_menu_item'
ORDER BY FIELD(post_status,'publish','private','draft','auto-draft','inherit'), FIELD(post_type,'post','page')
LIMIT 1
0.0429
SELECT p.ID, pm.meta_value, p.post_type, p.post_status
FROM wp_posts AS p LEFT JOIN wp_postmeta AS pm ON (p.ID = pm.post_id)
WHERE meta_key = 'custom_permalink'
AND meta_value != ''
AND ( LOWER(meta_value) = LEFT(LOWER(''), LENGTH(meta_value)) OR LOWER(meta_value) = LEFT(LOWER('/'), LENGTH(meta_value)) )
AND post_status != 'trash'
AND post_type != 'nav_menu_item'
ORDER BY LENGTH(meta_value) DESC, FIELD(post_status,'publish','private','draft','auto-draft','inherit'), FIELD(post_type,'post','page'), p.ID ASC
LIMIT 1
0.0820
SELECT post_name
FROM wp_posts
WHERE post_name = 'fooldal'
AND post_type IN ( 'page', 'attachment' )
AND ID != 2
AND post_parent = 0
LIMIT 1
0.0918
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('post_tag')
AND tr.object_id IN (2)
ORDER BY t.name ASC
0.0839
SELECT *
FROM wp_users
WHERE ID = '1'
0.0532
SELECT user_id, meta_key, meta_value
FROM wp_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC
0.0820
SELECT option_value
FROM wp_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
0.0851
SELECT *
FROM wp_posts
WHERE (post_type = 'page'
AND post_status = 'publish')
AND post_parent = 2
ORDER BY wp_posts.post_title ASC
LIMIT 0,1
0.0880
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('varosok')
ORDER BY t.name ASC
0.1421
SELECT term_id, meta_key, meta_value
FROM wp_termmeta
WHERE term_id IN (46,9,180,27,6)
ORDER BY meta_id ASC
0.0889
SELECT *
FROM wp_posts
WHERE ID = 10
LIMIT 1
0.0880
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (10)
ORDER BY meta_id ASC
0.1180
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE tt.taxonomy IN ('szallashely-tipusok')
ORDER BY t.name ASC
0.0410
SELECT term_id, meta_key, meta_value
FROM wp_termmeta
WHERE term_id IN (8,192,7)
ORDER BY meta_id ASC
0.0908
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 4
0.0870
SELECT tr.object_id
FROM wp_term_relationships AS tr
INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu')
AND tt.term_id IN ('4')
ORDER BY tr.object_id ASC
0.0961
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1
AND wp_posts.ID IN (15,16,102,103)
AND wp_posts.post_type = 'nav_menu_item'
AND ((wp_posts.post_status = 'publish'))
ORDER BY wp_posts.menu_order ASC
0.0892
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (16,103,102,15)
ORDER BY meta_id ASC
0.2019
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1
AND wp_posts.ID IN (10,44,46,12)
AND wp_posts.post_type = 'page'
AND ((wp_posts.post_status = 'publish'))
ORDER BY wp_posts.post_date DESC
0.0882
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (46,44,12)
ORDER BY meta_id ASC
0.1519
select * from wp_revslider_sliders where alias='fooldal_hu'
AND `type` != 'template'
0.1681
select * from wp_revslider_slides where slider_id=1 order by slide_order
0.0930
SELECT *
FROM wp_posts
WHERE ID = 189
LIMIT 1
0.0851
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (189)
ORDER BY meta_id ASC
0.0730
SELECT *
FROM wp_posts
WHERE ID = 1512
LIMIT 1
0.0870
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1512)
ORDER BY meta_id ASC
0.0949
SELECT *
FROM wp_posts
WHERE ID = 1499
LIMIT 1
0.0880
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1499)
ORDER BY meta_id ASC
0.1152
select * from wp_revslider_layer_animations
0.0529
select * from wp_revslider_layer_animations
0.1001
select * from wp_revslider_layer_animations
0.0820
select * from wp_revslider_layer_animations
0.0398
select * from wp_revslider_layer_animations
0.0901
select * from wp_revslider_layer_animations
0.0830
select * from wp_revslider_layer_animations
0.0389
select * from wp_revslider_layer_animations
0.0832
select * from wp_revslider_layer_animations
0.0961
select * from wp_revslider_static_slides where slider_id=1
0.0429
select * from wp_revslider_static_slides where id=1
0.0730
SELECT post_id
FROM wp_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = ''
0.0439
select * from wp_revslider_layer_animations
0.0379
select * from wp_revslider_layer_animations
0.0851
select * from wp_revslider_layer_animations
0.2129
select * from wp_revslider_css
0.0870
SELECT *
FROM wp_revslider_navigations
5.2788
SELECT ID, post_title
FROM wp_posts
WHERE post_type = 'szallasok'
AND post_status = 'publish'
AND ID IN ( SELECT pm1.post_id
FROM wp_postmeta AS pm1
INNER JOIN wp_postmeta AS pm2 ON pm2.post_id = pm1.post_id
AND pm2.meta_key = 'main_page_featured_date_from'
AND pm2.meta_value <= '2019-02-22'
INNER JOIN wp_postmeta AS pm3 ON pm3.post_id = pm1.post_id
AND pm3.meta_key = 'main_page_featured_date_till'
AND pm3.meta_value >= '2019-02-22'
INNER JOIN wp_postmeta AS pm4 ON pm4.post_id = pm1.post_id
AND pm4.meta_key = 'main_page_featured_position'
AND pm4.meta_value >= '1'
WHERE pm1.meta_key = 'main_page_featured_status'
AND pm1.meta_value = '1'
GROUP BY post_id )
ORDER BY rand()
LIMIT 6;
0.6909
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1857, 281, 510, 1818, 506, 1823)
AND meta_key IN ('gCube_Hotels_ar', 'gallery_id', 'gCube_Hotels_reklam')
ORDER BY post_id, meta_key;
5.9600
SELECT g.gid, g.path, pic.filename, pic.sortorder
FROM wp_ngg_pictures AS pic
INNER JOIN wp_ngg_gallery AS g ON g.gid = pic.galleryid
WHERE pic.galleryid IN (25, 81, 83, 145, 147, 154)
ORDER BY g.gid, pic.sortorder;
0.1118
SELECT *
FROM wp_posts
WHERE ID = 1857
LIMIT 1
0.1099
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1857)
ORDER BY meta_id ASC
0.1011
SELECT *
FROM wp_posts
WHERE ID = 281
LIMIT 1
0.1590
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (281)
ORDER BY meta_id ASC
0.0942
SELECT *
FROM wp_posts
WHERE ID = 510
LIMIT 1
0.1090
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (510)
ORDER BY meta_id ASC
0.0970
SELECT *
FROM wp_posts
WHERE ID = 1818
LIMIT 1
0.0930
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1818)
ORDER BY meta_id ASC
0.0901
SELECT *
FROM wp_posts
WHERE ID = 506
LIMIT 1
0.0670
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (506)
ORDER BY meta_id ASC
0.0708
SELECT *
FROM wp_posts
WHERE ID = 1823
LIMIT 1
0.0651
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1823)
ORDER BY meta_id ASC
0.0620
SELECT t.*, tt.term_taxonomy_id, p.ID, p.post_name
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy tt ON tt.term_id = t.term_id
INNER JOIN wp_posts AS p ON p.post_name = t.slug
WHERE tt.taxonomy = 'topten';
0.0629
SELECT *
FROM wp_posts
WHERE ID = 1475
LIMIT 1
0.0589
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1475)
ORDER BY meta_id ASC
0.0632
SELECT *
FROM wp_posts
WHERE ID = 91
LIMIT 1
0.0551
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (91)
ORDER BY meta_id ASC
0.0658
SELECT *
FROM wp_posts
WHERE ID = 87
LIMIT 1
0.0532
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (87)
ORDER BY meta_id ASC
0.0601
SELECT *
FROM wp_posts
WHERE ID = 85
LIMIT 1
0.0529
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (85)
ORDER BY meta_id ASC
0.0589
SELECT *
FROM wp_posts
WHERE ID = 93
LIMIT 1
0.0582
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (93)
ORDER BY meta_id ASC
0.0720
SELECT *
FROM wp_posts
WHERE ID = 1405
LIMIT 1
0.0741
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1405)
ORDER BY meta_id ASC
0.0601
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 28
0.0570
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 29
0.0579
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 30
0.0708
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 31
0.0589
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 32
0.0582
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 181
0.0548
SELECT option_value
FROM wp_options
WHERE option_name = '_transient_timeout_jr_insta_e8f30bde2c4d5e8bfe8ff29fdcd4606e'
LIMIT 1
0.0651
SELECT option_value
FROM wp_options
WHERE option_name = '_transient_jr_insta_e8f30bde2c4d5e8bfe8ff29fdcd4606e'
LIMIT 1
0.0629
SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 5
0.0570
SELECT tr.object_id
FROM wp_term_relationships AS tr
INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('nav_menu')
AND tt.term_id IN ('5')
ORDER BY tr.object_id ASC
0.0660
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1
AND wp_posts.ID IN (18,50,51,52,1383,1418)
AND wp_posts.post_type = 'nav_menu_item'
AND ((wp_posts.post_status = 'publish'))
ORDER BY wp_posts.menu_order ASC
0.0591
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (50,52,1383,1418,51,18)
ORDER BY meta_id ASC
0.4199
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1
AND wp_posts.ID IN (2,40,1381,1415,42,12)
AND wp_posts.post_type = 'page'
AND ((wp_posts.post_status = 'publish'))
ORDER BY wp_posts.post_date DESC
0.0601
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (1415,1381,42,40)
ORDER BY meta_id ASC[0] => themes/birotours/template-main.php
[1] => themes/birotours/header.php
[2] => themes/birotours/footer.php
$_GET = array (
);
$_POST = array (
);
$_COOKIE = array (
);
$_SESSION = array (
);
$_SERVER = array (
'SERVER_SOFTWARE' => 'Apache',
'REQUEST_URI' => '/',
'PHPRC' => '/home/birotours.hu/fcgi-bin/../etc/php5',
'SCRIPT_FILENAME' => '/home/birotours.hu/public_html/index.php',
'PWD' => '/home/birotours.hu/fcgi-bin',
'PHP_FCGI_MAX_REQUESTS' => '99999',
'SHLVL' => '0',
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',
'CONTENT_LENGTH' => '0',
'SCRIPT_NAME' => '/index.php',
'QUERY_STRING' => '',
'REQUEST_METHOD' => 'GET',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'REMOTE_PORT' => '36724',
'SERVER_ADMIN' => '[no address given]',
'CONTEXT_DOCUMENT_ROOT' => '/home/birotours.hu/public_html',
'CONTEXT_PREFIX' => '',
'REQUEST_SCHEME' => 'https',
'DOCUMENT_ROOT' => '/home/birotours.hu/public_html',
'REMOTE_ADDR' => '18.212.206.217',
'SERVER_PORT' => '443',
'SERVER_ADDR' => '79.172.209.105',
'SERVER_NAME' => 'birotours.hu',
'SERVER_SIGNATURE' => '',
'HTTP_ACCEPT_ENCODING' => 'gzip',
'HTTP_CONNECTION' => 'close',
'HTTP_HOST' => 'birotours.hu',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'SSL_TLS_SNI' => 'birotours.hu',
'HTTPS' => 'on',
'SCRIPT_URI' => 'https://birotours.hu/',
'SCRIPT_URL' => '/',
'FCGI_ROLE' => 'RESPONDER',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => '1550821814.0514',
'REQUEST_TIME' => '1550821814',
);
- Település
- Balatongyörök
- Gyenesdiás
- Hévíz
- Keszthely
- Vonyarcvashegy
- Szállás típus
- Apartman
- Apartmanház (több lakóegység)
- Nyaraló
új!
Nr. 28-2 Ernő apartman klímával, medencével
3 883 Ft /fő /éj-től
egész évben foglalható
Nr. 18-2/b-2 Krisztián apartman 1 hálószobával, medencével
3 487 Ft /fő /éj-től
egész évben foglalható!
Nr. 152 / B János apartman gyönyörű balatoni panorámával
3 623 Ft /fő /éj-től
új!
Nr. 102 "Hangulat Ház" - Villa egyedülálló szolgáltatásokkal
8 813 Ft /fő /éj-től
egész évben foglalható!
Nr. 152 / A - 1 János apartman gyönyörű balatoni panorámával
3 550 Ft /fő /éj-től
új!
Nr. 23- 1 Sonnenresidenz apartman medencével, klímával
4 121 Ft /fő /éj-től
Összes szállásajánlat megtekintéseÖsszes kép megtekintése
Toggle
Console (1)
Profiler (0 ms)
SQL (113 queries | 28.63 ms)
Templates
Globals
Close