Search for boat

FILTER BY

Filter Price

$50 $25050100150200250

Review Score

Boat Type

Amenities

San Francisco
4.3/5 Very Good 3 Reviews
13 2 19m 27km/h
from
$230
Showing 1 - 1 of 1 Boats
Request history8.0.30PHP Version1.16sRequest Duration36MBMemory UsageGET egy/boatRouteAuth status
    • Booting (571ms)time
    • Application (594ms)time
    • 1 x Application (50.98%)
      594ms
      1 x Booting (49.02%)
      571ms
      26 templates were rendered
      • 2x Boat::frontend.layouts.search.loop-gridloop-grid.blade.php#?blade
      • 1x Boat::frontend.searchsearch.blade.php#?blade
      • 1x Boat::frontend.layouts.search.form-searchform-search.blade.php#?blade
      • 1x Boat::frontend.layouts.search.fields.locationlocation.blade.php#?blade
      • 1x Boat::frontend.layouts.search.fields.datedate.blade.php#?blade
      • 1x Boat::frontend.layouts.search.list-itemlist-item.blade.php#?blade
      • 1x Boat::frontend.layouts.search.filter-searchfilter-search.blade.php#?blade
      • 1x Boat::frontend.layouts.search.orderbyorderby.blade.php#?blade
      • 1x pagination::tailwindtailwind.blade.php#?blade
      • 1x vendor.pagination.defaultdefault.blade.php#?blade
      • 1x layouts.appapp.blade.php#?blade
      • 1x Layout::appapp.blade.php#?blade
      • 1x Layout::parts.seo-metaseo-meta.blade.php#?blade
      • 1x Layout::parts.global-scriptglobal-script.blade.php#?blade
      • 1x Layout::parts.topbartopbar.blade.php#?blade
      • 2x Core::frontend.currency-switchercurrency-switcher.blade.php#?blade
      • 2x Language::frontend.switcherswitcher.blade.php#?blade
      • 1x Layout::parts.headerheader.blade.php#?blade
      • 1x Layout::parts.footerfooter.blade.php#?blade
      • 1x Layout::parts.login-register-modallogin-register-modal.blade.php#?blade
      • 1x Layout::auth.login-formlogin-form.blade.php#?blade
      • 1x Layout::auth.register-formregister-form.blade.php#?blade
      • 1x Popup::frontend.popuppopup.blade.php#?blade
      uri
      GET egy/boat
      middleware
      web
      controller
      Modules\Boat\Controllers\BoatController@index
      namespace
      Modules\Boat\Controllers
      prefix
      egy/boat
      where
      as
      boat.search
      file
      modules/Boat/Controllers/BoatController.php:30-89
      17 statements were executed (2 duplicates)Show only duplicates23.8ms
      • Boat.php#844aarnatours290425_abhi_tNt3.54msselect * from `bravo_locations` where `id` = '7' and `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 1
        Bindings
        • 0: 7
        • 1: publish
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • modules/Boat/Models/Boat.php:844
        • modules/Boat/Controllers/BoatController.php:41
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BoatController.php#42aarnatours290425_abhi_tNt2.04msselect count(*) as aggregate from (select `bravo_boats`.* from `bravo_boats` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_boats`.`location_id` and `bravo_locations`.`_lft` >= 13 and `bravo_locations`.`_rgt` <= 14 where `bravo_boats`.`status` = 'publish' and `bravo_boats`.`deleted_at` is null group by `bravo_boats`.`id`) as `aggregate_table`
        Bindings
        • 0: 13
        • 1: 14
        • 2: publish
        Backtrace
        • modules/Boat/Controllers/BoatController.php:42
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#42aarnatours290425_abhi_tNt1.92msselect `bravo_boats`.* from `bravo_boats` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_boats`.`location_id` and `bravo_locations`.`_lft` >= 13 and `bravo_locations`.`_rgt` <= 14 where `bravo_boats`.`status` = 'publish' and `bravo_boats`.`deleted_at` is null group by `bravo_boats`.`id` order by `is_featured` desc, `id` desc limit 9 offset 0
        Bindings
        • 0: 13
        • 1: 14
        • 2: publish
        Backtrace
        • modules/Boat/Controllers/BoatController.php:42
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#42aarnatours290425_abhi_tNt680μsselect * from `bravo_locations` where `bravo_locations`.`id` in (7) and `bravo_locations`.`deleted_at` is null
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:42
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#42aarnatours290425_abhi_tNt1.33msselect * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (7)
        Bindings
        • 0: egy
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:42
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#42aarnatours290425_abhi_tNt1.09msselect * from `user_wishlist` where `object_model` = 'boat' and `user_id` = 0 and `user_wishlist`.`object_id` in (10)
        Bindings
        • 0: boat
        • 1: 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:42
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#42aarnatours290425_abhi_tNt1.17msselect * from `bravo_boat_translations` where `locale` = 'egy' and `bravo_boat_translations`.`origin_id` in (10) and `bravo_boat_translations`.`deleted_at` is null
        Bindings
        • 0: egy
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:42
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#64aarnatours290425_abhi_tNt1msselect * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 1000
        Bindings
        • 0: publish
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • modules/Boat/Controllers/BoatController.php:64
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#64aarnatours290425_abhi_tNt840μsselect * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
        Bindings
        • 0: egy
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:64
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • Boat.php#538aarnatours290425_abhi_tNt550μsselect MIN( min_price ) AS min_price , MAX( min_price ) AS max_price from `bravo_boats` where `status` = 'publish' and `bravo_boats`.`deleted_at` is null limit 1
        Bindings
        • 0: publish
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • modules/Boat/Models/Boat.php:538
        • modules/Boat/Controllers/BoatController.php:65
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BoatController.php#80aarnatours290425_abhi_tNt1.17msselect * from `bravo_attrs` where `service` = 'boat' and `bravo_attrs`.`deleted_at` is null order by `position` desc
        Bindings
        • 0: boat
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:80
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#80aarnatours290425_abhi_tNt1.51msselect * from `bravo_terms` where `bravo_terms`.`attr_id` in (14, 15) and `bravo_terms`.`deleted_at` is null
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:80
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#80aarnatours290425_abhi_tNt1.61msselect * from `bravo_terms_translations` where `locale` = 'egy' and `bravo_terms_translations`.`origin_id` in (91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104)
        Bindings
        • 0: egy
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:80
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • BoatController.php#80aarnatours290425_abhi_tNt1.75msselect * from `bravo_attrs_translations` where `locale` = 'egy' and `bravo_attrs_translations`.`origin_id` in (14, 15)
        Bindings
        • 0: egy
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • modules/Boat/Controllers/BoatController.php:80
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • modules/Boat/Controllers/BoatController.php:28
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • HasTranslations.php#51aarnatours290425_abhi_tNt1.2msselect * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'egy' limit 1
        Bindings
        • 0: 1
        • 1: egy
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • app/Traits/HasTranslations.php:51
        • app/Helpers/AppHelper.php:111
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • HasTranslations.php#51aarnatours290425_abhi_tNt1.13msselect * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'egy' limit 1
        Bindings
        • 0: 1
        • 1: egy
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • app/Traits/HasTranslations.php:51
        • app/Helpers/AppHelper.php:111
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • AppHelper.php#627aarnatours290425_abhi_tNt1.27msselect * from `core_pages` where `core_pages`.`id` = '' and `core_pages`.`deleted_at` is null limit 1
        Bindings
        • 0: 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • app/Helpers/AppHelper.php:627
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • vendor/laravel/framework/src/Illuminate/View/View.php:195
      Modules\Core\Models\Terms
      14Terms.php#?
      Modules\Location\Models\Location
      12Location.php#?
      Modules\Boat\Models\Boat
      2Boat.php#?
      Modules\Core\Models\Attributes
      2Attributes.php#?
      Modules\Core\Models\MenuTranslation
      2MenuTranslation.php#?
        web
        null
        sanctum
        null
          _token
          jGZETtbZIEXvjfSFA82ERiL2VNmPux4fYQpoRy5g
          _previous
          array:1 [ "url" => "http://aarnatours.com/public/egy/boat?location_id=7" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /egy/boat
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "location_id" => "7" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:11 [ "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "connection" => array:1 [ 0 => "keep-alive" ] "content-length" => array:1 [ 0 => "0" ] "host" => array:1 [ 0 => "aarnatours.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "x-forwarded-for" => array:1 [ 0 => "10.3.248.112" ] "via" => array:1 [ 0 => "1.1 squid-proxy-5b5d847c96-nltkx (squid/6.10)" ] "upgrade-insecure-requests" => array:1 [ 0 => "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 => "Sat, 28 Jun 2025 08:15:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkovU005UFcvNHhrYUJjVjdIUlgzSXc9PSIsInZhbHVlIjoiZDNrd3F5MTRKOXdqZG95UW1QdG1hUURoNW5Ca20yYUJQSWhnekM0VmR0RVBobmJGNUdlSk5FcGNWb1VwdUNXVHhwTzBvSTZPR1I2NWdZS1QrQ2dHWmx5cDdFSWxTT0t5SzQ3MzZKRWlUQnpZbHg0TjhHaFVCUXh4MEs2c3F2bXgiLCJtYWMiOiJlNDAzMGZhMmI4OGExMjZlYTMyOTI0ODgxNWNkNzYwNzdjMDA1Y2Y1NTIzYjQ1NzMxNzE3N2M2Y2Y3YWE3ZWExIiwidGFnIjoiIn0%3D; expires=Sat, 28-Jun-2025 10:15:50 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkovU005UFcvNHhrYUJjVjdIUlgzSXc9PSIsInZhbHVlIjoiZDNrd3F5MTRKOXdqZG95UW1QdG1hUURoNW5Ca20yYUJQSWhnekM0VmR0RVBobmJGNUdlSk5FcGNWb1VwdUNXVHhwTzBvS" 1 => "booking_core_session=eyJpdiI6IkVlc2xQd3hXSHg1S0lwVXZpYzRMZ2c9PSIsInZhbHVlIjoiUHMrMnNhNDZnNm5XRjBkdHZ4VE5JeXVpMGVUMUFwaFpoTzhuWkFGODJUa2prMU1kMFZvR0ZQRjNLSWM2TmlqclozNVYxcUJLcmhaWDRsbjhveU02cERuSzR0OHZna3Axd2pNYTUyUGtybmYwbDJDa2tYK1plM3Z0NW1XUTBtOXgiLCJtYWMiOiJiZWNhOGVmZDZiYWJlMmEyNGNkOGQwMWIzZTUxOGJhNzFjMDVlNTMxMzllM2U5YWQ3MzhkOTI2OTEwNjQzNTk5IiwidGFnIjoiIn0%3D; expires=Sat, 28-Jun-2025 10:15:50 GMT; Max-Age=7200; path=/; httponly; samesite=laxbooking_core_session=eyJpdiI6IkVlc2xQd3hXSHg1S0lwVXZpYzRMZ2c9PSIsInZhbHVlIjoiUHMrMnNhNDZnNm5XRjBkdHZ4VE5JeXVpMGVUMUFwaFpoTzhuWkFGODJUa2prMU1kMFZvR0ZQRjNLSWM2Tml" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkovU005UFcvNHhrYUJjVjdIUlgzSXc9PSIsInZhbHVlIjoiZDNrd3F5MTRKOXdqZG95UW1QdG1hUURoNW5Ca20yYUJQSWhnekM0VmR0RVBobmJGNUdlSk5FcGNWb1VwdUNXVHhwTzBvSTZPR1I2NWdZS1QrQ2dHWmx5cDdFSWxTT0t5SzQ3MzZKRWlUQnpZbHg0TjhHaFVCUXh4MEs2c3F2bXgiLCJtYWMiOiJlNDAzMGZhMmI4OGExMjZlYTMyOTI0ODgxNWNkNzYwNzdjMDA1Y2Y1NTIzYjQ1NzMxNzE3N2M2Y2Y3YWE3ZWExIiwidGFnIjoiIn0%3D; expires=Sat, 28-Jun-2025 10:15:50 GMT; path=/XSRF-TOKEN=eyJpdiI6IkovU005UFcvNHhrYUJjVjdIUlgzSXc9PSIsInZhbHVlIjoiZDNrd3F5MTRKOXdqZG95UW1QdG1hUURoNW5Ca20yYUJQSWhnekM0VmR0RVBobmJGNUdlSk5FcGNWb1VwdUNXVHhwTzBvS" 1 => "booking_core_session=eyJpdiI6IkVlc2xQd3hXSHg1S0lwVXZpYzRMZ2c9PSIsInZhbHVlIjoiUHMrMnNhNDZnNm5XRjBkdHZ4VE5JeXVpMGVUMUFwaFpoTzhuWkFGODJUa2prMU1kMFZvR0ZQRjNLSWM2TmlqclozNVYxcUJLcmhaWDRsbjhveU02cERuSzR0OHZna3Axd2pNYTUyUGtybmYwbDJDa2tYK1plM3Z0NW1XUTBtOXgiLCJtYWMiOiJiZWNhOGVmZDZiYWJlMmEyNGNkOGQwMWIzZTUxOGJhNzFjMDVlNTMxMzllM2U5YWQ3MzhkOTI2OTEwNjQzNTk5IiwidGFnIjoiIn0%3D; expires=Sat, 28-Jun-2025 10:15:50 GMT; path=/; httponlybooking_core_session=eyJpdiI6IkVlc2xQd3hXSHg1S0lwVXZpYzRMZ2c9PSIsInZhbHVlIjoiUHMrMnNhNDZnNm5XRjBkdHZ4VE5JeXVpMGVUMUFwaFpoTzhuWkFGODJUa2prMU1kMFZvR0ZQRjNLSWM2Tml" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "jGZETtbZIEXvjfSFA82ERiL2VNmPux4fYQpoRy5g" "_previous" => array:1 [ "url" => "http://aarnatours.com/public/egy/boat?location_id=7" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-06-28 08:15:50GET/public/egy/boat?location_id=7261732
          2025-06-28 - 2025-06-28