iqamti - إقامتي

الفنادق

(وادي الدواسر)

الرئيسية الفنادق

الفئة

مدينة

أختر وجهتك

أختر وجهتك
تبوك
الرياض
الطائف
مكة المكرمة
حائل
بريدة
الهفوف
الدمام
المدينة المنورة
ابها
جازان
جدة
المجمعة
الخبر
حفر الباطن
خميس مشيط
احد رفيده
القطيف
عنيزة
قرية العليا
الجبيل
النعيرية
الظهران
الوجه
بقيق
الزلفي
خيبر
الغاط
املج
رابغ
عفيف
ثادق
سيهات
تاروت
ينبع
شقراء
الدوادمي
الدرعية
القويعية
المزاحمية
بدر
الخرج
الدلم
الشنان
الخرمة
الجموم
المجاردة
السليل
تثليث
بيشة
الباحة
القنفذة
محايل
ثول
ضبا
تربه
صفوى
عنك
طريف
عرعر
القريات
سكاكا
رفحاء
دومة الجندل
الرس
المذنب
الخفجي
رياض الخبراء
البدائع
رأس تنورة
البكيرية
الشماسية
الحريق
حوطة بني تميم
ليلى
بللسمر
شرورة
نجران
صبيا
ابو عريش
صامطة
احد المسارحة
مدينة الملك عبدالله الاقتصادية
الاحساء
العلا
القصيم
حقل
وادي الدواسر

بحث عن مكان محدد

بحث بأسم الفندق

التاريخ :

عدد الأشخاص

وجدنا لك : 1 فندق

ترتيب النتائج حسب:

ترتيب

ترتيب
الاعلي تقييماً
الاقل تقييماً
الاعلي كاش باك
الترتيب من الاعلي سعرا
الترتيب من الاقل سعرا

0 التقييمات

فندق ارجان بارك

شارع وادي الدواسر العام، وادي الدواسر

يقع "فندق ارجان بارك Argan Park Hotel" في القويز، ويوفر خدمة الواي فاي مجاناً، كما يتميز مكان الإقام...

غير متاح

حجز الفندق

Messages2 Timeline Exceptions Views6 Route Queries29 Models291 Mails Gate Session Request

8.1.33569ms3MBGET hotels

warninglog[20:11:20] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
warninglog[20:11:20] LOG.warning: Return type of Grimzy\LaravelMysqlSpatial\Types\Point::jsonSerialize() shoul...

Booting (89.14ms)
Application (479ms)
1 x Application (84.08%)
478.59ms
1 x Booting (15.66%)
89.14ms

6 templates were rendered

frontend.filters (resources/views/frontend/filters.blade.php)8blade
Params
0
page
1
hotels
2
from_date
3
to_date
4
filters
5
array
6
lat
7
lng

Params
0	`page`
1	`hotels`
2	`from_date`
3	`to_date`
4	`filters`
5	`array`
6	`lat`
7	`lng`

frontend.layout (resources/views/frontend/layout.blade.php)26blade


__env
app
errors
page
hotels
from_date
to_date
filters
array
lat
lng
lang
code
__currentLoopData
item
loop
__empty_1
hotel
promotion
roomIds
promotions
displayI
price
data
q
availabilities

Params
0	`__env`
1	`app`
2	`errors`
3	`page`
4	`hotels`
5	`from_date`
6	`to_date`
7	`filters`
8	`array`
9	`lat`
10	`lng`
11	`lang`
12	`code`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`__empty_1`
17	`hotel`
18	`promotion`
19	`roomIds`
20	`promotions`
21	`displayI`
22	`price`
23	`data`
24	`q`
25	`availabilities`

frontend.includes.head (resources/views/frontend/includes/head.blade.php)26blade


__env
app
errors
page
hotels
from_date
to_date
filters
array
lat
lng
lang
code
__currentLoopData
item
loop
__empty_1
hotel
promotion
roomIds
promotions
displayI
price
data
q
availabilities

Params
0	`__env`
1	`app`
2	`errors`
3	`page`
4	`hotels`
5	`from_date`
6	`to_date`
7	`filters`
8	`array`
9	`lat`
10	`lng`
11	`lang`
12	`code`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`__empty_1`
17	`hotel`
18	`promotion`
19	`roomIds`
20	`promotions`
21	`displayI`
22	`price`
23	`data`
24	`q`
25	`availabilities`

frontend.includes.header (resources/views/frontend/includes/header.blade.php)26blade


__env
app
errors
page
hotels
from_date
to_date
filters
array
lat
lng
lang
code
__currentLoopData
item
loop
__empty_1
hotel
promotion
roomIds
promotions
displayI
price
data
q
availabilities

Params
0	`__env`
1	`app`
2	`errors`
3	`page`
4	`hotels`
5	`from_date`
6	`to_date`
7	`filters`
8	`array`
9	`lat`
10	`lng`
11	`lang`
12	`code`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`__empty_1`
17	`hotel`
18	`promotion`
19	`roomIds`
20	`promotions`
21	`displayI`
22	`price`
23	`data`
24	`q`
25	`availabilities`

frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)26blade


__env
app
errors
page
hotels
from_date
to_date
filters
array
lat
lng
lang
code
__currentLoopData
item
loop
__empty_1
hotel
promotion
roomIds
promotions
displayI
price
data
q
availabilities

Params
0	`__env`
1	`app`
2	`errors`
3	`page`
4	`hotels`
5	`from_date`
6	`to_date`
7	`filters`
8	`array`
9	`lat`
10	`lng`
11	`lang`
12	`code`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`__empty_1`
17	`hotel`
18	`promotion`
19	`roomIds`
20	`promotions`
21	`displayI`
22	`price`
23	`data`
24	`q`
25	`availabilities`

frontend.includes.foot (resources/views/frontend/includes/foot.blade.php)26blade


__env
app
errors
page
hotels
from_date
to_date
filters
array
lat
lng
lang
code
__currentLoopData
item
loop
__empty_1
hotel
promotion
roomIds
promotions
displayI
price
data
q
availabilities

Params
0	`__env`
1	`app`
2	`errors`
3	`page`
4	`hotels`
5	`from_date`
6	`to_date`
7	`filters`
8	`array`
9	`lat`
10	`lng`
11	`lang`
12	`code`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`__empty_1`
17	`hotel`
18	`promotion`
19	`roomIds`
20	`promotions`
21	`displayI`
22	`price`
23	`data`
24	`q`
25	`availabilities`

uri: GET hotels
middleware: web, not_deleted_scope
controller: App\Http\Controllers\Frontend\HomeController@filters
namespace
prefix
where
as: filters
file: app/Http/Controllers/Frontend/HomeController.php:221-695

29 statements were executed, 9 of which were duplicated, 20 unique378ms

select distinct `id`, `city_id`, `title`, `title_en`, `address`, `email`, `phone`, `description`, `rate`, `check_in`, `check_out`, `rate_title`, `location`, `facilities`, `policies`, `special_policy`, `wallet_discount`, `latitude`, `longitude`, `active_wallet_discount`, `active_cashback`, `pay_with_cashback`, `cashback_discount`, (select SUM(percentage) from `taxes` inner join `hotel_tax` on `taxes`.`id` = `hotel_tax`.`tax_id` where `hotels`.`id` = `hotel_tax`.`hotel_id` and `status` = 1) as `tax_percentage` from `hotels` where exists (select * from `availabilities` where `hotels`.`id` = `availabilities`.`hotel_id` and `locked` = 0) and `city_id` = '88' and `published` = 1 and `is_deleted` = 0

8.13ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Bindings	0. 1 1. 0 2. 88 3. 1 4. 0
Backtrace	14. /app/Http/Controllers/Frontend/HomeController.php:492 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `hotel_facility_types`.`id`, `hotel_facility_types`.`title`, `hotel_facility_types`.`title_en`, `hotel_facility_types`.`icon`, `hotel_facility_types`.`notes`, `hotel_facility_relation`.`hotel_id` as `pivot_hotel_id`, `hotel_facility_relation`.`facility_id` as `pivot_facility_id` from `hotel_facility_types` inner join `hotel_facility_relation` on `hotel_facility_types`.`id` = `hotel_facility_relation`.`facility_id` where `hotel_facility_relation`.`hotel_id` in (654)

1.76ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	18. /app/Http/Controllers/Frontend/HomeController.php:492 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `hotel_policies`.`id`, `hotel_policies`.`title`, `hotel_policies`.`title_en`, `hotel_policies`.`notes`, `hotel_policies_relation`.`hotel_id` as `pivot_hotel_id`, `hotel_policies_relation`.`policy_id` as `pivot_policy_id` from `hotel_policies` inner join `hotel_policies_relation` on `hotel_policies`.`id` = `hotel_policies_relation`.`policy_id` where `hotel_policies_relation`.`hotel_id` in (654)

1.38ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	18. /app/Http/Controllers/Frontend/HomeController.php:492 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `title_en`, `province_id` from `cities` where `cities`.`id` in (88)

730μs/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	19. /app/Http/Controllers/Frontend/HomeController.php:492 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `url`, `tag`, `model_id` from `images` where `owner_model` = 'App\Models\Hotel' and `images`.`model_id` in (654)

2.81ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Bindings	0. App\Models\Hotel
Backtrace	19. /app/Http/Controllers/Frontend/HomeController.php:492 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `availabilities` where `availabilities`.`hotel_id` in (654) and `locked` = 0 and date(`availabilities`.`at_date`) >= '2025-08-13' and date(`availabilities`.`at_date`) <= '2025-08-14' and date(`at_date`) = '2025-08-13' or date(`at_date`) = '2025-08-14'

332ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Bindings	0. 0 1. 2025-08-13 2. 2025-08-14 3. 2025-08-13 4. 2025-08-14
Backtrace	19. /app/Http/Controllers/Frontend/HomeController.php:492 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `room_type_id`, `notes` from `rooms` where `rooms`.`id` in (846, 1799, 1800, 1801, 1867, 1868, 1869, 1870, 1871, 1872, 1873)

1.25ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	24. /app/Http/Controllers/Frontend/HomeController.php:492 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 27. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `title_en`, `notes`, `capacity` from `room_types` where `room_types`.`id` in (1, 2, 5, 6, 9, 13, 14, 18, 19, 23)

790μs/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	29. /app/Http/Controllers/Frontend/HomeController.php:492 30. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 31. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 32. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 33. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `room_facility_types`.`id`, `room_facility_types`.`title`, `room_facility_types`.`title_en`, `room_facility_types`.`notes`, `room_facility_types`.`icon`, `rooms_facilities`.`room_id` as `pivot_room_id`, `rooms_facilities`.`facility_id` as `pivot_facility_id` from `room_facility_types` inner join `rooms_facilities` on `room_facility_types`.`id` = `rooms_facilities`.`facility_id` where `rooms_facilities`.`room_id` in (846, 1799, 1800, 1801, 1867, 1868, 1869, 1870, 1871, 1872, 1873)

2.35ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	28. /app/Http/Controllers/Frontend/HomeController.php:492 29. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 30. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 32. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `promotions`.*, `hotel_promotion_relation`.`room_id` as `pivot_room_id`, `hotel_promotion_relation`.`promotion_id` as `pivot_promotion_id`, `hotel_promotion_relation`.`description` as `pivot_description`, `hotel_promotion_relation`.`discount` as `pivot_discount`, `hotel_promotion_relation`.`from_date` as `pivot_from_date`, `hotel_promotion_relation`.`to_date` as `pivot_to_date` from `promotions` inner join `hotel_promotion_relation` on `promotions`.`id` = `hotel_promotion_relation`.`promotion_id` where `hotel_promotion_relation`.`room_id` in (846, 1799, 1800, 1801, 1867, 1868, 1869, 1870, 1871, 1872, 1873) and `from_date` <= '2025-08-13' and `to_date` >= '2025-08-14'

1.21ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Bindings	0. 2025-08-13 1. 2025-08-14
Backtrace	28. /app/Http/Controllers/Frontend/HomeController.php:492 29. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 30. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 32. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `availability_meal` where `availability_meal`.`availability_id` in (357141, 357690, 358239, 367078, 367468, 367858, 368248, 368638, 369028, 369418, 377489) and `locked` = 0 and `book_id` is null order by `price` asc

11.5ms/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Bindings	0. 0
Backtrace	24. /app/Http/Controllers/Frontend/HomeController.php:492 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 27. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `meal_types` where `meal_types`.`id` in (1, 4, 7)

860μs/app/Http/Controllers/Frontend/HomeController.php:492iqamtico_updated

Metadata
Backtrace	29. /app/Http/Controllers/Frontend/HomeController.php:492 30. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 31. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 32. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 33. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `cities` where `cities`.`id` = '88' limit 1

530μsview::6cf1e65020906080266b7bf53b350da5557ab13b:50iqamtico_updated

Metadata
Bindings	0. 88
Backtrace	19. view::6cf1e65020906080266b7bf53b350da5557ab13b:50 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `cities`

900μsview::6cf1e65020906080266b7bf53b350da5557ab13b:145iqamtico_updated

Metadata
Backtrace	15. view::6cf1e65020906080266b7bf53b350da5557ab13b:145 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

820μsview::6cf1e65020906080266b7bf53b350da5557ab13b:244iqamtico_updated

Metadata
Backtrace	18. view::6cf1e65020906080266b7bf53b350da5557ab13b:244 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `rooms` where `rooms`.`hotel_id` = 654 and `rooms`.`hotel_id` is not null

1.81msview::6cf1e65020906080266b7bf53b350da5557ab13b:281iqamtico_updated

Metadata
Bindings	0. 654
Backtrace	20. view::6cf1e65020906080266b7bf53b350da5557ab13b:281 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `room_id` from `hotel_promotion_relation` where `hotel_id` = 654 and `room_id` in (1824, 1825) and ((`from_date` <= '2025-08-13' and `to_date` >= '2025-08-14'))

1msview::6cf1e65020906080266b7bf53b350da5557ab13b:291iqamtico_updated

Metadata
Bindings	0. 654 1. 1824 2. 1825 3. 2025-08-13 4. 2025-08-14
Backtrace	13. view::6cf1e65020906080266b7bf53b350da5557ab13b:291 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `hotel_promotion_relation` where `hotel_id` = 654 and `room_id` in (1824, 1825) and ((`from_date` <= '2025-08-13' and `to_date` >= '2025-08-14')) limit 1

600μsview::6cf1e65020906080266b7bf53b350da5557ab13b:300iqamtico_updated

Metadata
Bindings	0. 654 1. 1824 2. 1825 3. 2025-08-13 4. 2025-08-14
Backtrace	15. view::6cf1e65020906080266b7bf53b350da5557ab13b:300 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `images` where `images`.`model_id` = 654 and `images`.`model_id` is not null and `owner_model` = 'App\Models\Hotel' and `tag` = 'front' limit 1

680μsview::6cf1e65020906080266b7bf53b350da5557ab13b:330iqamtico_updated

Metadata
Bindings	0. 654 1. App\Models\Hotel 2. front
Backtrace	19. view::6cf1e65020906080266b7bf53b350da5557ab13b:330 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `simple_hotel_rates`.*, `books`.`hotel_id` as `laravel_through_key` from `simple_hotel_rates` inner join `books` on `books`.`id` = `simple_hotel_rates`.`book_id` where `books`.`hotel_id` = 654 order by `id` desc

1.82msview::6cf1e65020906080266b7bf53b350da5557ab13b:339iqamtico_updated

Metadata
Bindings	0. 654
Backtrace	19. view::6cf1e65020906080266b7bf53b350da5557ab13b:339 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

630μsview::6cf1e65020906080266b7bf53b350da5557ab13b:416iqamtico_updated

Metadata
Backtrace	18. view::6cf1e65020906080266b7bf53b350da5557ab13b:416 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `availabilities` where `hotel_id` = 654 and `locked` = 0 and date(`at_date`) = '2025-08-13' or (`at_date` = '2025-08-14' and `hotel_id` = 654) and exists (select * from `rooms` where `availabilities`.`room_id` = `rooms`.`id` and exists (select * from `room_types` where `rooms`.`room_type_id` = `room_types`.`id` and `capacity` >= 1)) order by (SELECT MIN(price) FROM availability_meal WHERE availability_meal.availability_id = availabilities.id) asc

1.31msview::6cf1e65020906080266b7bf53b350da5557ab13b:488iqamtico_updated

Metadata
Bindings	0. 654 1. 0 2. 2025-08-13 3. 2025-08-14 4. 654 5. 1
Backtrace	14. view::6cf1e65020906080266b7bf53b350da5557ab13b:488 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

570μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:18iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:18 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

460μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:22iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:22 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

500μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:24iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:24 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

500μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:25iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:25 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

450μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:45iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:45 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

450μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:46iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:46 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `generals` limit 1

460μsview::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:48iqamtico_updated

Metadata
Backtrace	18. view::c2c38e867cd2fd4cb6aa597d5a184833c0c91110:48 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

App\Models\General: 9
App\Models\MealType: 3
App\Models\AvailabilityMeal: 29
App\Models\RoomFacilityType: 91
App\Models\RoomType: 10
App\Models\Room: 13
App\Models\Availability: 11
App\Models\Image: 26
App\Models\City: 90
App\Models\HotelPolicy: 2
App\Models\HotelFacilityType: 6
App\Models\Hotel: 1

_token: rYD6jb7MOs0JIvAbmFR8ElhcZbTCP2aO69zc4ozc
_previous: array:1 [ "url" => "https://iqamti.net/hotels?city_id=88" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/hotels

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "city_id" => "88"
]

request_request

  0 of 0   
array:1 [▼
  "city_id" => "88"
]

request_headers

  0 of 0   
array:16 [▼
  "x-https" => array:1 [▶
    0 => "1"
  ]
  "host" => array:1 [▶
    0 => "iqamti.net"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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"
  ]
]

request_server

  0 of 0   
array:85 [▼
  "USER" => "iqamtico"
  "HOME" => "/home/iqamtico"
  "SCRIPT_NAME" => "/public/index.php"
  "REQUEST_URI" => "/hotels?city_id=88"
  "QUERY_STRING" => "city_id=88"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "city_id=88"
  "REDIRECT_URL" => "/public/hotels"
  "REMOTE_PORT" => "33176"
  "SCRIPT_FILENAME" => "/home/iqamtico/public_html/public/index.php"
  "SERVER_ADMIN" => "webmaster@iqamti.net"
  "CONTEXT_DOCUMENT_ROOT" => "/home/iqamtico/public_html"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/iqamtico/public_html"
  "REMOTE_ADDR" => "216.73.216.163"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "69.16.204.74"
  "SERVER_NAME" => "iqamti.net"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶"
  "HTTP_X_HTTPS" => "1"
  "HTTP_HOST" => "iqamti.net"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "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"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "proxy-nokeepalive" => "1"
  "H2_STREAM_TAG" => "54136-2-1"
  "H2_STREAM_ID" => "1"
  "H2_PUSHED_ON" => ""
  "H2_PUSHED" => ""
  "H2_PUSH" => "off"
  "H2PUSH" => "off"
  "HTTP2" => "on"
  "SSL_TLS_SNI" => "iqamti.net"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://iqamti.net/hotels"
  "SCRIPT_URL" => "/hotels"
  "UNIQUE_ID" => "aJzHOJGhQNlV3tkDFiSNNQAAjwM"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_H2_STREAM_TAG" => "54136-2-1"
  "REDIRECT_H2_STREAM_ID" => "1"
  "REDIRECT_H2_PUSHED_ON" => ""
  "REDIRECT_H2_PUSHED" => ""
  "REDIRECT_H2_PUSH" => "off"
  "REDIRECT_H2PUSH" => "off"
  "REDIRECT_HTTP2" => "on"
  "REDIRECT_SSL_TLS_SNI" => "iqamti.net"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://iqamti.net/hotels"
  "REDIRECT_SCRIPT_URL" => "/hotels"
  "REDIRECT_UNIQUE_ID" => "aJzHOJGhQNlV3tkDFiSNNQAAjwM"
  "REDIRECT_REDIRECT_STATUS" => "200"
  "REDIRECT_REDIRECT_H2_STREAM_TAG" => "54136-2-1"
  "REDIRECT_REDIRECT_H2_STREAM_ID" => "1"
  "REDIRECT_REDIRECT_H2_PUSHED_ON" => ""
  "REDIRECT_REDIRECT_H2_PUSHED" => ""
  "REDIRECT_REDIRECT_H2_PUSH" => "off"
  "REDIRECT_REDIRECT_H2PUSH" => "off"
  "REDIRECT_REDIRECT_HTTP2" => "on"
  "REDIRECT_REDIRECT_SSL_TLS_SNI" => "iqamti.net"
  "REDIRECT_REDIRECT_HTTPS" => "on"
  "REDIRECT_REDIRECT_SCRIPT_URI" => "https://iqamti.net/hotels"
  "REDIRECT_REDIRECT_SCRIPT_URL" => "/hotels"
  "REDIRECT_REDIRECT_UNIQUE_ID" => "aJzHOJGhQNlV3tkDFiSNNQAAjwM"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/public/index.php"
  "REQUEST_TIME_FLOAT" => 1755105080.595
  "REQUEST_TIME" => 1755105080
  "argv" => array:1 [▶
    0 => "city_id=88"
  ]
  "argc" => 1
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 17:11:21 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjB0SU80UmQrNUs0eDVwOXFZUEtNYnc9PSIsInZhbHVlIjoiZlZlSGp1RTFWaXdkZmw5MWE5SUhRa0EwWlB0QTZ6dTVyQm9GcVpKQk1sVkt0Um8xSkpxbDd0MWlYSU1jWklXa2J4eWp0VWd4M25pdXdzeitTL3FmalVSSVBPc00yb1BUZUFkdDVBbllpeno1endnLzUzbHBqR3ovRk9wNGw2cWsiLCJtYWMiOiI5MjVkOTZkNGIzNjAxMjZiZTYwOGIzMTgxODliNGUzYTVmZTE4N2M4NzhjNWE1ZTBhYmQ1NDlkMTBhNDk2ZWQ1IiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 19:11:21 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjB0SU80UmQrNUs0eDVwOXFZUEtNYnc9PSIsInZhbHVlIjoiZlZlSGp1RTFWaXdkZmw5MWE5SUhRa0EwWlB0QTZ6dTVyQm9GcVpKQk1sVkt0Um8xSkpxbDd0MWlYSU1jWklXa2J4eWp0V ▶"
    1 => "laravel_session=eyJpdiI6InlMUWVzZ3lUczh1aHIvSU9CWXBXWXc9PSIsInZhbHVlIjoiS0xjZ0tubUI0Z2l2MUkydWRYUGhyZmVoaXBpckZ5YkZaeDNKbC9sMFYreWh3dUMrSzUvWkFEaUlPQUt2WVcyV3BpeDIyMEZHRjRlZ2VMVUxGZEtDdWhVRHpPckJ2UXFscW5OcWI2T0xxMDg0YVE0WTRDak40QTE5ZGNFVTZVcjIiLCJtYWMiOiJhNzUzZGNmZDQ3ZWNiNzUzZDkwYzk3ZTJhMDFhMzc4Mjk5MDg4Y2UyYzFhZmU2YzljOTg1MzU5ZTliZTBkNGFiIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 19:11:21 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6InlMUWVzZ3lUczh1aHIvSU9CWXBXWXc9PSIsInZhbHVlIjoiS0xjZ0tubUI0Z2l2MUkydWRYUGhyZmVoaXBpckZ5YkZaeDNKbC9sMFYreWh3dUMrSzUvWkFEaUlPQUt2WVcyV3Bp ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjB0SU80UmQrNUs0eDVwOXFZUEtNYnc9PSIsInZhbHVlIjoiZlZlSGp1RTFWaXdkZmw5MWE5SUhRa0EwWlB0QTZ6dTVyQm9GcVpKQk1sVkt0Um8xSkpxbDd0MWlYSU1jWklXa2J4eWp0VWd4M25pdXdzeitTL3FmalVSSVBPc00yb1BUZUFkdDVBbllpeno1endnLzUzbHBqR3ovRk9wNGw2cWsiLCJtYWMiOiI5MjVkOTZkNGIzNjAxMjZiZTYwOGIzMTgxODliNGUzYTVmZTE4N2M4NzhjNWE1ZTBhYmQ1NDlkMTBhNDk2ZWQ1IiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 19:11:21 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjB0SU80UmQrNUs0eDVwOXFZUEtNYnc9PSIsInZhbHVlIjoiZlZlSGp1RTFWaXdkZmw5MWE5SUhRa0EwWlB0QTZ6dTVyQm9GcVpKQk1sVkt0Um8xSkpxbDd0MWlYSU1jWklXa2J4eWp0V ▶"
    1 => "laravel_session=eyJpdiI6InlMUWVzZ3lUczh1aHIvSU9CWXBXWXc9PSIsInZhbHVlIjoiS0xjZ0tubUI0Z2l2MUkydWRYUGhyZmVoaXBpckZ5YkZaeDNKbC9sMFYreWh3dUMrSzUvWkFEaUlPQUt2WVcyV3BpeDIyMEZHRjRlZ2VMVUxGZEtDdWhVRHpPckJ2UXFscW5OcWI2T0xxMDg0YVE0WTRDak40QTE5ZGNFVTZVcjIiLCJtYWMiOiJhNzUzZGNmZDQ3ZWNiNzUzZDkwYzk3ZTJhMDFhMzc4Mjk5MDg4Y2UyYzFhZmU2YzljOTg1MzU5ZTliZTBkNGFiIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 19:11:21 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InlMUWVzZ3lUczh1aHIvSU9CWXBXWXc9PSIsInZhbHVlIjoiS0xjZ0tubUI0Z2l2MUkydWRYUGhyZmVoaXBpckZ5YkZaeDNKbC9sMFYreWh3dUMrSzUvWkFEaUlPQUt2WVcyV3Bp ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "rYD6jb7MOs0JIvAbmFR8ElhcZbTCP2aO69zc4ozc"
  "_previous" => array:1 [▶
    "url" => "https://iqamti.net/hotels?city_id=88"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (84.08%)	478.59ms
1 x Booting (15.66%)	89.14ms

الفنادق

(وادي الدواسر)

وجدنا لك : 1 فندق

فندق ارجان بارك

ماسة المجد الفندقية