Показаны 0 отелей в Мульчэн

Отели рядом

Arturo Prat 228, 4510000 Santa Bárbara, Chile
19.25 км от центра
shapes Children friendly
9.2 (12)

Contaba con estacionamiento y el sistema de cerraduras favorecía la autonomía de los visitantes. Habitaciones cómodas, funcionales. El personal respondía rápidamente ante cualquier dificultad.

Av Las Industrias 7305, 4430000 Los Ángeles, Chile
25.76 км от центра
shapes Restaurant
shapes Bar
shapes Room Service
shapes Children friendly
6 (629)
The hotel is located near:
Q-501, Los Ángeles, Chile
28.34 км от центра
shapes Room Service
shapes Family rooms
shapes Children friendly
9.4 (0)

I liked the location, it was out of the way, private, secure, and the staff was really nice. It is my go to place on the way to the south of Chile and I will probably stay again the next time I make the trip to and from the south. The breakfast...

1085 Manuel Rodríguez, Los Ángeles, Chile
28.74 км от центра
shapes Pet Friendly
shapes Children friendly
9.7 (19)

Muy limpio, muy cómodo, bien ubicado, tiene estacionamiento, la persona que te recibe es muy amable, de las personas más amables que e conocido en un hostal. El desayuno es muy bueno.

789 Mendoza, 4450694 Los Ángeles, Chile
29.33 км от центра
shapes Family rooms
shapes Children friendly
9 (0)

Super atentos los dueños, preocupados de que la estancia sea lo más cómoda posible, el lugar está muy bien ubicado, a pasos de supermercado, mall, bajones, etc. Hicieron aseo todos los días y por el precio encuentro que estuvo excelente.

831 Avenida Tucapel, Los Ángeles, Chile
29.77 км от центра
shapes Children friendly
8.5 (221)

Really terrific stay for the price. The owners are delightful. Rooms are newly remodeled. Nice shared kitchen. Perfect place to stop for the night. Good restaurant nearby.

Avenida Los Angeles, 4440000 Los Ángeles, Chile
29.83 км от центра
shapes Room Service
shapes Pet Friendly
shapes Children friendly
6.6 (66)
The hotel is located near:
Panamericana Sur Km 510, 4440000 Los Ángeles, Chile
31.93 км от центра
shapes Restaurant
shapes Bar
shapes Children friendly
7.5 (1322)

Excellent location to use as a stop-over in a long trip

343 Comercio, 4480000 Tucapel, Chile
54.14 км от центра
shapes Children friendly
9.3 (4)

Buena ubicación, muy bien calefaccionado y todo muy ameno

Cerca Mall arauco coronel, 0419000 Coronel, Chile
113.5 км от центра
shapes Children friendly
8.3 (0)

Alojamiento completo, con equipos nuevos y con buena conexión a internet. Muy accesible desde estación del tren y a pasos del mall.

2971 Pasaje Carlos Leon Alvarado, Concepción, Chile
113.81 км от центра
shapes Pet Friendly
shapes Children friendly
0 (0)
The hotel is located near:
Padre Alberto Hurtado 1859a Lagunillas, 4200601 Coronel, Chile
115.89 км от центра
shapes Children friendly
8.4 (20)

Ubicación, la calides en la recepción,la comodidad y tranquilidad del entorno, inmueble impecable, la encargada siempre atenta.

144 Ongolmo Edificio A, 4070118 Concepción, Chile
121.72 км от центра
shapes Room Service
shapes Family rooms
shapes Pet Friendly
shapes Children friendly
8.7 (1553)

The location is excellent; walking distance to everywhere. The kitchen facilities were also great; microwave, toaster and electric kettle.

Castellon 261 A, 4030000 Concepción, Chile
121.94 км от центра
shapes Family rooms
shapes Pet Friendly
shapes Children friendly
7.8 (385)

The location was very good. The service room was good too.

Cochrane 248, 4030000 Concepción, Chile
122.09 км от центра
shapes Restaurant
shapes Room Service
shapes Children friendly
9.2 (116)

It was delicious, efficient (ordered ahead) more than enough. It was ready at expected time.

Chacabuco 156, 4030000 Concepción, Chile
122.17 км от центра
shapes Restaurant
shapes Bar
shapes Children friendly
8.5 (1349)

Great location near a wonderful park. Easy walking to the university and good Peruvian restaurants.. Our room was super comfy.

134 Colo Colo, 4070187 Concepción, Chile
122.24 км от центра
shapes Children friendly
1 (1)
The hotel is located near:
Barros Arana 457, 4030000 Concepción, Chile
122.57 км от центра
shapes Family rooms
shapes Children friendly
8 (1038)

Located in a great location for tourists near the witches market. Clean and nice courtyard.

Barros Arana 348, 4070170 Concepción, Chile
122.61 км от центра
shapes Restaurant
shapes Bar
shapes Room Service
shapes Family rooms
shapes Children friendly
7.9 (2476)

Good value, good breakfast, cleanliness and comfortable beds. Includes business center which is great.

Francisco de Quiñones 132, 4090433 Concepción, Chile
124.96 км от центра
shapes Family rooms
shapes Children friendly
9.2 (0)

Bonito lugar, buen vecindario, todo limpio y muy buen precio

Av. Cataluña 1054 Valle escondido de Paicaví, 4060003 Concepción, Chile
125.47 км от центра
shapes Restaurant
shapes Bar
shapes Children friendly
8.4 (0)

We love this hotel, always revisit when we come to Concepción. Like Goldilocks, everything is just right. One of best places to eat too, unpretensious, but chef prepares only two or three choices beautifully.

Calle G 1179, Concepción, Chile
128.58 км от центра
shapes Children friendly
9.4 (180)

Me gustó la atención de la Señora Hortensia, eso fue lo que me dió mayor seguridad al quedarnos ahí.

Отображены все отели

Всего найдено 0 отелей в Мульчэн. Выберите идеальное размещение для вашего пребывания и наслаждайтесь безупречным бронированием. Бронирование отелей онлайн в Мульчэн никогда не было таким простым

Искать в Google Hotels: Мульчэн

Отели рядом
9.2 (12)
Arturo Prat 228, 4510000 Santa Bárbara, Chile
19.25 км от центра
shapes
6 (629)
Av Las Industrias 7305, 4430000 Los Ángeles, Chile
25.76 км от центра
shapes shapes shapes shapes
9.4 (0)
Q-501, Los Ángeles, Chile
28.34 км от центра
shapes shapes shapes
9.7 (19)
1085 Manuel Rodríguez, Los Ángeles, Chile
28.74 км от центра
shapes shapes
9 (0)
789 Mendoza, 4450694 Los Ángeles, Chile
29.33 км от центра
shapes shapes
8.5 (221)
831 Avenida Tucapel, Los Ángeles, Chile
29.77 км от центра
shapes
6.6 (66)
Avenida Los Angeles, 4440000 Los Ángeles, Chile
29.83 км от центра
shapes shapes shapes
7.5 (1322)
Panamericana Sur Km 510, 4440000 Los Ángeles, Chile
31.93 км от центра
shapes shapes shapes
9.3 (4)
343 Comercio, 4480000 Tucapel, Chile
54.14 км от центра
shapes
8.3 (0)
Cerca Mall arauco coronel, 0419000 Coronel, Chile
113.5 км от центра
shapes
0 (0)
2971 Pasaje Carlos Leon Alvarado, Concepción, Chile
113.81 км от центра
shapes shapes
8.4 (20)
Padre Alberto Hurtado 1859a Lagunillas, 4200601 Coronel, Chile
115.89 км от центра
shapes
8.7 (1553)
144 Ongolmo Edificio A, 4070118 Concepción, Chile
121.72 км от центра
shapes shapes shapes shapes
7.8 (385)
Castellon 261 A, 4030000 Concepción, Chile
121.94 км от центра
shapes shapes shapes
9.2 (116)
Cochrane 248, 4030000 Concepción, Chile
122.09 км от центра
shapes shapes shapes
8.5 (1349)
Chacabuco 156, 4030000 Concepción, Chile
122.17 км от центра
shapes shapes shapes
1 (1)
134 Colo Colo, 4070187 Concepción, Chile
122.24 км от центра
shapes
8 (1038)
Barros Arana 457, 4030000 Concepción, Chile
122.57 км от центра
shapes shapes
7.9 (2476)
Barros Arana 348, 4070170 Concepción, Chile
122.61 км от центра
shapes shapes shapes shapes shapes
9.2 (0)
Francisco de Quiñones 132, 4090433 Concepción, Chile
124.96 км от центра
shapes shapes
8.4 (0)
Av. Cataluña 1054 Valle escondido de Paicaví, 4060003 Concepción, Chile
125.47 км от центра
shapes shapes shapes
9.4 (180)
Calle G 1179, Concepción, Chile
128.58 км от центра
shapes
Отображены все отели

Всего найдено 0 отелей в Мульчэн. Выберите идеальное размещение для вашего пребывания и наслаждайтесь безупречным бронированием. Бронирование отелей онлайн в Мульчэн никогда не было таким простым

Search on Google Hotels: Мульчэн

Отели рядом
9.2 (12)
Arturo Prat 228, 4510000 Santa Bárbara, Chile
19.25 км от центра
shapes
6 (629)
Av Las Industrias 7305, 4430000 Los Ángeles, Chile
25.76 км от центра
shapes shapes shapes shapes
9.4 (0)
Q-501, Los Ángeles, Chile
28.34 км от центра
shapes shapes shapes
9.7 (19)
1085 Manuel Rodríguez, Los Ángeles, Chile
28.74 км от центра
shapes shapes
9 (0)
789 Mendoza, 4450694 Los Ángeles, Chile
29.33 км от центра
shapes shapes
8.5 (221)
831 Avenida Tucapel, Los Ángeles, Chile
29.77 км от центра
shapes
6.6 (66)
Avenida Los Angeles, 4440000 Los Ángeles, Chile
29.83 км от центра
shapes shapes shapes
7.5 (1322)
Panamericana Sur Km 510, 4440000 Los Ángeles, Chile
31.93 км от центра
shapes shapes shapes
9.3 (4)
343 Comercio, 4480000 Tucapel, Chile
54.14 км от центра
shapes
8.3 (0)
Cerca Mall arauco coronel, 0419000 Coronel, Chile
113.5 км от центра
shapes
0 (0)
2971 Pasaje Carlos Leon Alvarado, Concepción, Chile
113.81 км от центра
shapes shapes
8.4 (20)
Padre Alberto Hurtado 1859a Lagunillas, 4200601 Coronel, Chile
115.89 км от центра
shapes
8.7 (1553)
144 Ongolmo Edificio A, 4070118 Concepción, Chile
121.72 км от центра
shapes shapes shapes shapes
7.8 (385)
Castellon 261 A, 4030000 Concepción, Chile
121.94 км от центра
shapes shapes shapes
9.2 (116)
Cochrane 248, 4030000 Concepción, Chile
122.09 км от центра
shapes shapes shapes
8.5 (1349)
Chacabuco 156, 4030000 Concepción, Chile
122.17 км от центра
shapes shapes shapes
1 (1)
134 Colo Colo, 4070187 Concepción, Chile
122.24 км от центра
shapes
8 (1038)
Barros Arana 457, 4030000 Concepción, Chile
122.57 км от центра
shapes shapes
7.9 (2476)
Barros Arana 348, 4070170 Concepción, Chile
122.61 км от центра
shapes shapes shapes shapes shapes
9.2 (0)
Francisco de Quiñones 132, 4090433 Concepción, Chile
124.96 км от центра
shapes shapes
8.4 (0)
Av. Cataluña 1054 Valle escondido de Paicaví, 4060003 Concepción, Chile
125.47 км от центра
shapes shapes shapes
9.4 (180)
Calle G 1179, Concepción, Chile
128.58 км от центра
shapes
All hotels are shown

Всего найдено 0 отелей в Мульчэн. Выберите идеальное размещение для вашего пребывания и наслаждайтесь безупречным бронированием. Бронирование отелей онлайн в Мульчэн никогда не было таким простым

Search on Google Hotels: Мульчэн

Часто задаваемые вопросы

SettingsRequest history161msRequest Duration44MBMemory Usage10.x
Laravel Version
10.48.17
PHP Version
8.2.28
Environment
production
Debug Mode
Enabled
URL
gdeotel.ru
Timezone
UTC
Locale
ru
GET hotels/{country}/{region?}/{city?}/{area?}
status
200 OK
full_url
https://gdeotel.ru/hotels/Chile/Bio-Bio/Mulchen/Pretty-view?reviewScore=116&thingsToDo=332%2C319
action_name
resultHotelsList
controller_action
App\Http\Controllers\MainController@search
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[13:55:21] LOG.warning: Return type of SplMaxHeap@anonymous::compare($a, $b) should either be compat...
status
200 OK
full_url
https://gdeotel.ru/hotels/Chile/Bio-Bio/Mulchen/Pretty-view?reviewScore=116&thingsToDo=332%2C319
action_name
resultHotelsList
controller_action
App\Http\Controllers\MainController@search
uri
GET hotels/{country}/{region?}/{city?}/{area?}
controller
App\Http\Controllers\MainController@search
file
app/Http/Controllers/MainController.php:121-417
middleware
web
duration
162ms
peak_memory
47MB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:7 [ "reviewScore" => "116" "thingsToDo" => "332,319" "place" => "Чили, Био-Био, Мульчэн" "adults" => "2" "children" => "0" "dateStart" => "2025-06-18" "dateEnd" => "2025-06-19" ]
request_request
[]
request_headers
0 of 0
array:18 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpZTFdtUVpvZXlzbVdUa2x1N3pXZVE9PSIsInZhbHVlIjoicjJjS1BIa091aktDNVF0aDJ5NW4vaUNtc09CdTFEWmE5RGFyUjBzeHZGOTZYMWh5RVkzeW1EbHQ5THZYaElQVEgvbUFBdWFyaEc0eFZBbk5KL2xtV203dFZTUUpZVExXSCtLblRCY1BDMzRDM0FsbGRnZEpVS0hva1pmaVVVbHIiLCJtYWMiOiIyMDVkZTJlOTM5OTZjNjY4ODA0NDNkN2U3NmFiMDFiNDQwMzM2ZGU1MDZjMzRkNGQyNzkyNmUxZjJhOTkyOTNiIiwidGFnIjoiIn0%3D; hotelin_session=eyJpdiI6ImNyR2drQ0dRcnhjUGdFVm1pSnBZbUE9PSIsInZhbHVlIjoiVFZKa3kvalpBNktLZUs4V1QzajQrME5mMUJYUG9JN2x3aCtadnBOSUQ3RVhCU0FxUVZLQk9TT1UvTVhudzJKdVpsRnJMbUx6Q3F1Uy80RW1odnFqMUYwaEg1cUV2MkN4WkYxcGIrcjM5elRPOXF6UG1aNVA0UVJiQ3JGK0tzSjEiLCJtYWMiOiI0NGU0MmU3MDQxZTRiY2FiNDQ2ZWU0N2JkNGE1NjQ1ZTJmMDAzMzMxM2IzMzRiYjEzYjYxZGU0OGE5YjljM2JmIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6ImpZTFdtUVpvZXlzbVdUa2x1N3pXZVE9PSIsInZhbHVlIjoicjJjS1BIa091aktDNVF0aDJ5NW4vaUNtc09CdTFEWmE5RGFyUjBzeHZGOTZYMWh5RVkzeW1EbHQ5THZYaElQVEgvbUFBd" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "close" ] "x-real-ip" => array:1 [ 0 => "216.73.216.242" ] "x-forwarded-for" => array:1 [ 0 => "216.73.216.242" ] "host" => array:1 [ 0 => "gdeotel.ru" ] ]
request_cookies
0 of 0
array:2 [ "XSRF-TOKEN" => "0UWMdnAQjfcIGSArtPeokpp9gNnXTjbjz6lU7Y9c" "hotelin_session" => "cqskQ1EDuW9fxpqao0rMErnhb2rMFrWTuubWeNBv" ]
response_headers
0 of 0
array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Wed, 11 Jun 2025 13:55:21 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] ]
session_attributes
0 of 0
array:5 [ "_token" => "0UWMdnAQjfcIGSArtPeokpp9gNnXTjbjz6lU7Y9c" "_flash" => array:2 [ "new" => array:1 [ 0 => "_old_input" ] "old" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [ "url" => "https://gdeotel.ru/hotels/Netherlands/Gelderland/Beneden-Leeuwen/Adults-only?countOfStar=4&hotelChains=190&thingsToDo=325" ] "_old_input" => array:7 [ "reviewScore" => "116" "thingsToDo" => "332,319" "place" => "Чили, Био-Био, Мульчэн" "adults" => "2" "children" => "0" "dateStart" => "2025-06-18" "dateEnd" => "2025-06-19" ] ]
  • Booting (69.8ms)time
  • Application (91.53ms)time
  • Routing (1.05ms)
  • Preparing Response (24.29ms)
  • View: main.searchviews
  • View: components.tags-blockviews
  • View: partials.mapviews
  • View: partials.additionalsearchinfoviews
  • View: partials.additionalTagviews
  • View: partials.faqtagviews
  • View: layouts.mainviews
  • View: partials.searchformviews
  • 1 x Application (56.73%)
    91.53ms
    1 x Booting (43.27%)
    69.80ms
    1 x Preparing Response (15.06%)
    24.29ms
    1 x Routing (0.65%)
    1.05ms
    8 x View (0%)
    0μs
    8 templates were rendered
    • main.searchsearch.blade.php#?blade
    • components.tags-blocktags-block.blade.php#?blade
    • partials.mapmap.blade.php#?blade
    • partials.additionalsearchinfoadditionalsearchinfo.blade.php#?blade
    • partials.additionalTagadditionalTag.blade.php#?blade
    • partials.faqtagfaqtag.blade.php#?blade
    • layouts.mainmain.blade.php#?blade
    • partials.searchformsearchform.blade.php#?blade
    37 statements were executed (19 duplicates)Show only duplicates7.55ms
    • Location.php#41hotelinConnection Established
      Backtrace
      • app/Objects/Location.php:41
      • app/Http/Controllers/MainController.php:127
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • Location.php#41hotelin780μsselect * from `loc_countries` where `link` = 'Chile' limit 1
      Bindings
      • 0: Chile
      Backtrace
      • app/Objects/Location.php:41
      • app/Http/Controllers/MainController.php:127
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • Location.php#53hotelin170μsselect * from `loc_regions` where `link` = 'Bio-Bio' and `loc_country_id` = 1 and (`frequency` != 0 or `frequency` is null) limit 1
      Bindings
      • 0: Bio-Bio
      • 1: 1
      • 2: 0
      Backtrace
      • app/Objects/Location.php:53
      • app/Http/Controllers/MainController.php:127
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • Location.php#61hotelin170μsselect * from `loc_cities` where `link` = 'Mulchen' and `loc_region_id` = 8876 and (`frequency` != 0 or `frequency` is null) limit 1
      Bindings
      • 0: Mulchen
      • 1: 8876
      • 2: 0
      Backtrace
      • app/Objects/Location.php:61
      • app/Http/Controllers/MainController.php:127
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • CitiesHelper.php#30hotelin500μsselect *, ST_Distance_Sphere( point('-72.23329926', '-37.71670151'), point(longitude, latitude) )/1000 AS distance, name, id from `loc_cities` where `longitude` between -73.370204771589 and -71.096393748411 and `latitude` between -38.616023115919 and -36.817379904081 and `id` != 228876 and (`frequency` != 0 or `frequency` is null) order by distance limit 5
      Bindings
      • 0: -72.23329926
      • 1: -37.71670151
      • 2: -73.37020477158924
      • 3: -71.09639374841075
      • 4: -38.616023115918736
      • 5: -36.817379904081264
      • 6: 228876
      • 7: 0
      Backtrace
      • app/Helpers/CitiesHelper/CitiesHelper.php:30
      • app/Http/Controllers/MainController.php:203
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • LandmarksHelper.php#102hotelin250μsselect *, ST_Distance_Sphere( point('-72.23329926', '-37.71670151'), point(longitude, latitude) )/1000 AS distance, name, id, longitude, latitude from `places` where `longitude` between -73.370204771589 and -71.096393748411 and `latitude` between -38.616023115919 and -36.817379904081 and `type` not in ('Rail Stations', 'Metro Stations', 'Coastal Regions', 'Airports', 'Restaurants', 'Bars', 'Cafes, Coffee and Tea Houses') and `id` != 0 and `rank` >= 0 and `loc_country_id` = 1 order by distance limit 5
      Bindings
      • 0: -72.23329926
      • 1: -37.71670151
      • 2: -73.37020477158924
      • 3: -71.09639374841075
      • 4: -38.616023115918736
      • 5: -36.817379904081264
      • 6: Rail Stations
      • 7: Metro Stations
      • 8: Coastal Regions
      • 9: Airports
      • 10: Restaurants
      • 11: Bars
      • 12: Cafes, Coffee and Tea Houses
      • 13: 0
      • 14: 0
      • 15: 1
      Backtrace
      • app/Helpers/LandmarksHelper.php:102
      • app/Helpers/LandmarksHelper.php:37
      • app/Http/Controllers/MainController.php:206
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • LandmarksHelper.php#154hotelin210μsselect *, ST_Distance_Sphere( point('-72.23329926', '-37.71670151'), point(longitude, latitude) )/1000 AS distance, name, id, longitude, latitude from `places` where `longitude` between -73.370204771589 and -71.096393748411 and `latitude` between -38.616023115919 and -36.817379904081 and `type` in ('Airports') and `id` != 0 and `rank` >= 0 and `loc_country_id` = 1 order by distance limit 3
      Bindings
      • 0: -72.23329926
      • 1: -37.71670151
      • 2: -73.37020477158924
      • 3: -71.09639374841075
      • 4: -38.616023115918736
      • 5: -36.817379904081264
      • 6: Airports
      • 7: 0
      • 8: 0
      • 9: 1
      Backtrace
      • app/Helpers/LandmarksHelper.php:154
      • app/Helpers/LandmarksHelper.php:39
      • app/Http/Controllers/MainController.php:206
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • LandmarksHelper.php#128hotelin210μsselect *, ST_Distance_Sphere( point('-72.23329926', '-37.71670151'), point(longitude, latitude) )/1000 AS distance, name, id, longitude, latitude from `places` where `longitude` between -72.346987046695 and -72.119611473305 and `latitude` between -37.806633670592 and -37.626769349408 and `type` in ('Rail Stations', 'Metro Stations') and `id` != 0 and `rank` >= 0 and `loc_country_id` = 1 order by distance limit 3
      Bindings
      • 0: -72.23329926
      • 1: -37.71670151
      • 2: -72.34698704669493
      • 3: -72.11961147330504
      • 4: -37.80663367059187
      • 5: -37.62676934940813
      • 6: Rail Stations
      • 7: Metro Stations
      • 8: 0
      • 9: 0
      • 10: 1
      Backtrace
      • app/Helpers/LandmarksHelper.php:128
      • app/Helpers/LandmarksHelper.php:40
      • app/Http/Controllers/MainController.php:206
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • SearchHotelsHelper.php#43hotelin240μsselect * from `hotel_hotelscom_bookingcoms` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `loc_city_id` = 228876 and exists (select * from `hotels_tags` where `hotel_hotelscom_bookingcoms`.`id` = `hotels_tags`.`hotel_id` and `pretty_view` = 1) limit 150
      Bindings
      • 0: 1
      • 1: 8876
      • 2: 228876
      • 3: 1
      Backtrace
      • app/Helpers/HotelsHelper/SearchHotelsHelper.php:43
      • app/Http/Controllers/MainController.php:218
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • SearchHotelsHelper.php#78hotelin980μsselect * from `hotel_hotelscom_bookingcoms` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `premises_type` in ('aparthotel', 'guest_house', 'hostel', 'hotel', 'motel') limit 100
      Bindings
      • 0: 1
      • 1: 8876
      • 2: aparthotel
      • 3: guest_house
      • 4: hostel
      • 5: hotel
      • 6: motel
      Backtrace
      • app/Helpers/HotelsHelper/SearchHotelsHelper.php:78
      • app/Http/Controllers/MainController.php:222
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • SearchHotelsHelper.php#78hotelin120μsselect * from `loc_countries` where `loc_countries`.`id` in (1)
      Bindings
      • 0: 1
      Backtrace
      • app/Helpers/HotelsHelper/SearchHotelsHelper.php:78
      • app/Http/Controllers/MainController.php:222
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • SearchHotelsHelper.php#78hotelin100μsselect * from `loc_regions` where `loc_regions`.`id` in (8876)
      Bindings
      • 0: 8876
      Backtrace
      • app/Helpers/HotelsHelper/SearchHotelsHelper.php:78
      • app/Http/Controllers/MainController.php:222
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • SearchHotelsHelper.php#78hotelin130μsselect * from `loc_cities` where `loc_cities`.`id` in (228601, 228609, 228819, 229112, 229161)
      Bindings
      • 0: 228601
      • 1: 228609
      • 2: 228819
      • 3: 229112
      • 4: 229161
      Backtrace
      • app/Helpers/HotelsHelper/SearchHotelsHelper.php:78
      • app/Http/Controllers/MainController.php:222
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • AttractionsHelper.php#402hotelin150μsselect * from `places` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `loc_city_id` = 228876
      Bindings
      • 0: 1
      • 1: 8876
      • 2: 228876
      Backtrace
      • app/Helpers/AttractionsHelper.php:402
      • app/Http/Controllers/MainController.php:291
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • MainController.php#338hotelin410μsselect * from `additional_infos` where `model_id` = 228876 and `model` = 'loc_cities' limit 1
      Bindings
      • 0: 228876
      • 1: loc_cities
      Backtrace
      • app/Http/Controllers/MainController.php:338
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:18
    • HotelsHelper.php#109hotelin250μsselect * from `hotel_hotelscom_bookingcoms` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `loc_city_id` = 228876 and `count_of_star` = 5 limit 10
      Bindings
      • 0: 1
      • 1: 8876
      • 2: 228876
      • 3: 5
      Backtrace
      • app/Helpers/HotelsHelper/HotelsHelper.php:109
      • app/Helpers/PageSearchHelper.php:604
      • app/Helpers/PageSearchHelper.php:328
      • app/Helpers/PageSearchHelper.php:68
      • app/Http/Controllers/MainController.php:383
    • HotelsHelper.php#119hotelin200μsselect * from `hotel_hotelscom_bookingcoms` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `loc_city_id` = 228876 and `count_of_star` = 4 limit 10
      Bindings
      • 0: 1
      • 1: 8876
      • 2: 228876
      • 3: 4
      Backtrace
      • app/Helpers/HotelsHelper/HotelsHelper.php:119
      • app/Helpers/PageSearchHelper.php:605
      • app/Helpers/PageSearchHelper.php:328
      • app/Helpers/PageSearchHelper.php:68
      • app/Http/Controllers/MainController.php:383
    • HotelsHelper.php#129hotelin150μsselect * from `hotel_hotelscom_bookingcoms` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `loc_city_id` = 228876 and `count_of_star` = 3 limit 10
      Bindings
      • 0: 1
      • 1: 8876
      • 2: 228876
      • 3: 3
      Backtrace
      • app/Helpers/HotelsHelper/HotelsHelper.php:129
      • app/Helpers/PageSearchHelper.php:606
      • app/Helpers/PageSearchHelper.php:328
      • app/Helpers/PageSearchHelper.php:68
      • app/Http/Controllers/MainController.php:383
    • LocRegion.php#39hotelin150μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • app/Helpers/PageSearchHelper.php:93
      • app/Http/Controllers/MainController.php:383
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • LocCity.php#44hotelin120μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocCity.php:44
      • app/Helpers/PageSearchHelper.php:93
      • app/Http/Controllers/MainController.php:383
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • LocCity.php#44hotelin120μsselect * from `loc_regions` where `loc_regions`.`id` = 8876 limit 1
      Bindings
      • 0: 8876
      Backtrace
      • app/Models/LocCity.php:44
      • app/Helpers/PageSearchHelper.php:93
      • app/Http/Controllers/MainController.php:383
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • HotelsHelper.php#64hotelin120μsselect count(*) as aggregate from `hotel_hotelscom_bookingcoms` where `loc_country_id` = 1 and `loc_region_id` = 8876 and `loc_city_id` = 228876
      Bindings
      • 0: 1
      • 1: 8876
      • 2: 228876
      Backtrace
      • app/Helpers/HotelsHelper/HotelsHelper.php:64
      • app/Http/Controllers/MainController.php:386
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
    • LocRegion.php#39hotelin140μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin150μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin140μsselect * from `loc_regions` where `loc_regions`.`id` = 8876 limit 1
      Bindings
      • 0: 8876
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocRegion.php#39hotelin120μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin140μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin130μsselect * from `loc_regions` where `loc_regions`.`id` = 8876 limit 1
      Bindings
      • 0: 8876
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocRegion.php#39hotelin140μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin130μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin110μsselect * from `loc_regions` where `loc_regions`.`id` = 8876 limit 1
      Bindings
      • 0: 8876
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocRegion.php#39hotelin120μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin120μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin110μsselect * from `loc_regions` where `loc_regions`.`id` = 8876 limit 1
      Bindings
      • 0: 8876
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocRegion.php#39hotelin110μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin130μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocCity.php#44hotelin110μsselect * from `loc_regions` where `loc_regions`.`id` = 8876 limit 1
      Bindings
      • 0: 8876
      Backtrace
      • app/Models/LocCity.php:44
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • LocRegion.php#39hotelin120μsselect * from `loc_countries` where `loc_countries`.`id` = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/LocRegion.php:39
      • view::main.search:31
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    App\Models\HotelHotelscomBookingcom
    22HotelHotelscomBookingcom.php#?
    App\Models\LocCountry
    15LocCountry.php#?
    App\Models\LocCity
    11LocCity.php#?
    App\Models\LocRegion
    8LocRegion.php#?
    App\Models\AdditionalInfo
    1AdditionalInfo.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-06-11 13:55:22GET/hotels/Chile/Bio-Bio/Mulchen/Pretty-view?reviewScore=116&thingsToDo=332%2C319183757
        2025-06-18 - 2025-06-19