Search for tour

FILTER BY

Filter Price

€1 €5651142283424565

Review Score

Tour Type

Travel Styles

Facilities

Nickerie
1D12H
from
€150,00
Nickerie
3D
from
€345,00
Showing 1 - 2 of 2 Tours
8.3.19PHP Version487msRequest Duration5MBMemory UsageGET tourRouteAuth status
  • warninglog[07:50:14] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\QueryFormatter:...
  • warninglog[07:50:14] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\QueryFormatter:...
  • warninglog[07:50:14] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\SimpleFormatter...
  • warninglog[07:50:14] LOG.warning: Creation of dynamic property Barryvdh\Debugbar\DataFormatter\SimpleFormatter...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is ...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_AttrTransform_NameSync::$idDef is ...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • warninglog[07:50:15] LOG.warning: Creation of dynamic property HTMLPurifier_Lexer_DOMLex::$_entity_parser is d...
  • Booting (93.97ms)
  • Application (393ms)
  • 1 x Application (80.54%)
    392.54ms
    1 x Booting (19.28%)
    93.97ms
    28 templates were rendered
    • Tour::frontend.layouts.search.loop-grid (themes/BC/Tour/Views/frontend/layouts/search/loop-grid.blade.php)3blade
      Params
      0
      row
      1
      disable_lazyload
      2
      wrap_class
    • Tour::frontend.layouts.search.loop-grid (themes/BC/Tour/Views/frontend/layouts/search/loop-grid.blade.php)3blade
      Params
      0
      row
      1
      disable_lazyload
      2
      wrap_class
    • Tour::frontend.search (themes/BC/Tour/Views/frontend/search.blade.php)9blade
      Params
      0
      rows
      1
      tour_category
      2
      tour_location
      3
      tour_min_max_price
      4
      markers
      5
      blank
      6
      seo_meta
      7
      layout
      8
      attributes
    • Tour::frontend.layouts.search.form-search (themes/BC/Tour/Views/frontend/layouts/search/form-search.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
    • Tour::frontend.layouts.search.fields.location (themes/BC/Tour/Views/frontend/layouts/search/fields/location.blade.php)17blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      tour_search_fields
      14
      __currentLoopData
      15
      field
      16
      loop
    • Tour::frontend.layouts.search.fields.date (themes/BC/Tour/Views/frontend/layouts/search/fields/date.blade.php)17blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      tour_search_fields
      14
      __currentLoopData
      15
      field
      16
      loop
    • Tour::frontend.layouts.search.list-item (themes/BC/Tour/Views/frontend/layouts/search/list-item.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
    • Tour::frontend.layouts.search.filter-search (themes/BC/Tour/Views/frontend/layouts/search/filter-search.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
    • Tour::frontend.layouts.search.orderby (themes/BC/Tour/Views/frontend/layouts/search/orderby.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
    • Tour::frontend.layouts.search.loop-grid (themes/BC/Tour/Views/frontend/layouts/search/loop-grid.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      __currentLoopData
      14
      row
      15
      loop
    • Tour::frontend.layouts.search.loop-grid (themes/BC/Tour/Views/frontend/layouts/search/loop-grid.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      __currentLoopData
      14
      row
      15
      loop
    • pagination::tailwind (resources/views/vendor/pagination/tailwind.blade.php)2blade
      Params
      0
      paginator
      1
      elements
    • vendor.pagination.default (resources/views/vendor/pagination/default.blade.php)5blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      paginator
      4
      elements
    • layouts.app (resources/views/layouts/app.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
    • Layout::app (modules/Layout/app.blade.php)13blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
    • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Layout::parts.global-script (modules/Layout/parts/global-script.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Layout::parts.topbar (modules/Layout/parts/topbar.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Layout::parts.header (modules/Layout/parts/header.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
      14
      logo_id
      15
      logo
    • Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)16blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
      14
      logo_id
      15
      logo
    • Layout::parts.footer (modules/Layout/parts/footer.blade.php)14blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
    • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    • Popup::frontend.popup (themes/Base/Popup/Views/frontend/popup.blade.php)19blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      rows
      4
      tour_category
      5
      tour_location
      6
      tour_min_max_price
      7
      markers
      8
      blank
      9
      seo_meta
      10
      layout
      11
      attributes
      12
      bg
      13
      favicon
      14
      list_widget_footers
      15
      __currentLoopData
      16
      item
      17
      key
      18
      loop
    uri
    GET tour
    middleware
    web
    controller
    \Modules\Tour\Controllers\TourController@index
    namespace
    Modules\Tour\Controllers
    prefix
    /tour
    where
    as
    tour.search
    file
    modules/Tour/Controllers/TourController.php:36-93
    20 statements were executed, 2 of which were duplicated, 18 unique225ms
    • select * from `bravo_locations` where `id` = '17' and `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 121.55ms/modules/Tour/Models/Tour.php:985cafebgnu_suran
      Metadata
      Bindings
      • 0. 17
      • 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
      • 15. /modules/Tour/Models/Tour.php:985
      • 16. /modules/Tour/Controllers/TourController.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /modules/Tour/Controllers/TourController.php:33
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `bravo_tour_category` where 0 = 1 and `status` = 'publish' and `bravo_tour_category`.`deleted_at` is null11.14ms/modules/Tour/Models/Tour.php:1008cafebgnu_suran
      Metadata
      Bindings
      • 0. publish
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /modules/Tour/Models/Tour.php:1008
      • 15. /modules/Tour/Controllers/TourController.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /modules/Tour/Controllers/TourController.php:33
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select `bravo_tours`.*, CASE WHEN IFNULL( bravo_tours.sale_price, 0 ) > 0 THEN bravo_tours.sale_price ELSE bravo_tours.price END AS tmp_min_price from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 32 and `bravo_locations`.`_rgt` <= 33 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null group by `bravo_tours`.`id`) as `aggregate_table`7.57ms/modules/Tour/Controllers/TourController.php:46cafebgnu_suran
      Metadata
      Bindings
      • 0. 32
      • 1. 33
      • 2. publish
      Backtrace
      • 15. /modules/Tour/Controllers/TourController.php:46
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /modules/Tour/Controllers/TourController.php:33
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `bravo_tours`.*, CASE WHEN IFNULL( bravo_tours.sale_price, 0 ) > 0 THEN bravo_tours.sale_price ELSE bravo_tours.price END AS tmp_min_price from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 32 and `bravo_locations`.`_rgt` <= 33 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null group by `bravo_tours`.`id` order by `tmp_min_price` asc limit 9 offset 03.4ms/modules/Tour/Controllers/TourController.php:46cafebgnu_suran
      Metadata
      Bindings
      • 0. 32
      • 1. 33
      • 2. publish
      Backtrace
      • 15. /modules/Tour/Controllers/TourController.php:46
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /modules/Tour/Controllers/TourController.php:33
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_locations` where `bravo_locations`.`id` in (17) and `bravo_locations`.`deleted_at` is null1.21ms/modules/Tour/Controllers/TourController.php:46cafebgnu_suran
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 20. /modules/Tour/Controllers/TourController.php:46
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /modules/Tour/Controllers/TourController.php:33
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (17)1.09ms/modules/Tour/Controllers/TourController.php:46cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 25. /modules/Tour/Controllers/TourController.php:46
      • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. /modules/Tour/Controllers/TourController.php:33
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (6, 8)930μs/modules/Tour/Controllers/TourController.php:46cafebgnu_suran
      Metadata
      Bindings
      • 0. tour
      • 1. 0
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 20. /modules/Tour/Controllers/TourController.php:46
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /modules/Tour/Controllers/TourController.php:33
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (6, 8)1.36ms/modules/Tour/Controllers/TourController.php:46cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 20. /modules/Tour/Controllers/TourController.php:46
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. /modules/Tour/Controllers/TourController.php:33
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_tour_category` where `status` = 'publish' and `bravo_tour_category`.`deleted_at` is null14.4ms/modules/Tour/Controllers/TourController.php:68cafebgnu_suran
      Metadata
      Bindings
      • 0. publish
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /modules/Tour/Controllers/TourController.php:68
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /modules/Tour/Controllers/TourController.php:33
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_tour_category_translations` where `locale` = 'en' and `bravo_tour_category_translations`.`origin_id` in (1, 2, 3)11.8ms/modules/Tour/Controllers/TourController.php:68cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /modules/Tour/Controllers/TourController.php:68
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /modules/Tour/Controllers/TourController.php:33
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 100022.98ms/modules/Tour/Controllers/TourController.php:69cafebgnu_suran
      Metadata
      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
      • 14. /modules/Tour/Controllers/TourController.php:69
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /modules/Tour/Controllers/TourController.php:33
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (11, 12, 13, 14, 15, 16, 17)29.1ms/modules/Tour/Controllers/TourController.php:69cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /modules/Tour/Controllers/TourController.php:69
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /modules/Tour/Controllers/TourController.php:33
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select MIN( CASE WHEN sale_price > 0 THEN sale_price ELSE ( price ) END ) AS min_price , MAX( CASE WHEN sale_price > 0 THEN sale_price ELSE ( price ) END ) AS max_price from `bravo_tours` where `status` = 'publish' and `bravo_tours`.`deleted_at` is null limit 140.6ms/modules/Tour/Models/Tour.php:700cafebgnu_suran
      Metadata
      Bindings
      • 0. publish
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /modules/Tour/Models/Tour.php:700
      • 16. /modules/Tour/Controllers/TourController.php:70
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /modules/Tour/Controllers/TourController.php:33
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `bravo_attrs` where `service` = 'tour' and `bravo_attrs`.`deleted_at` is null order by `position` desc8.59ms/modules/Tour/Controllers/TourController.php:86cafebgnu_suran
      Metadata
      Bindings
      • 0. tour
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /modules/Tour/Controllers/TourController.php:86
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /modules/Tour/Controllers/TourController.php:33
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_terms` where `bravo_terms`.`attr_id` in (1, 2) and `bravo_terms`.`deleted_at` is null23.43ms/modules/Tour/Controllers/TourController.php:86cafebgnu_suran
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /modules/Tour/Controllers/TourController.php:86
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /modules/Tour/Controllers/TourController.php:33
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)6.49ms/modules/Tour/Controllers/TourController.php:86cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 24. /modules/Tour/Controllers/TourController.php:86
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 26. /modules/Tour/Controllers/TourController.php:33
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `bravo_attrs_translations` where `locale` = 'en' and `bravo_attrs_translations`.`origin_id` in (1, 2)3.08ms/modules/Tour/Controllers/TourController.php:86cafebgnu_suran
      Metadata
      Bindings
      • 0. en
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /modules/Tour/Controllers/TourController.php:86
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /modules/Tour/Controllers/TourController.php:33
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 11.02ms/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 1
      • 1. en
      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
      • 20. /app/Traits/HasTranslations.php:51
      • 21. /app/Helpers/AppHelper.php:111
      • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 113.22ms/app/Traits/HasTranslations.php:51cafebgnu_suran
      Metadata
      Bindings
      • 0. 1
      • 1. en
      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
      • 20. /app/Traits/HasTranslations.php:51
      • 21. /app/Helpers/AppHelper.php:111
      • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `core_pages` where `core_pages`.`id` = '' and `core_pages`.`deleted_at` is null limit 12.27ms/app/Helpers/AppHelper.php:627cafebgnu_suran
      Metadata
      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
      • 19. /app/Helpers/AppHelper.php:627
      • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:152
    Modules\Core\Models\MenuTranslation
    2
    Modules\Core\Models\Terms
    14
    Modules\Core\Models\Attributes
    2
    Modules\Tour\Models\TourCategory
    3
    Modules\Tour\Models\TourTranslation
    2
    Modules\Location\Models\LocationTranslation
    8
    Modules\Tour\Models\Tour
    3
    Modules\Location\Models\Location
    9
    web
    null
    sanctum
    null
      _token
      Tbd4LsmhI9FmhOnYySoaOKEkPLaFmEC6CviaymDH
      _previous
      array:1 [ "url" => "https://suranadventures.com/tour?location_id=17&orderby=price_low_high" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /tour
      status_code
      200
      
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      0 of 0
      array:2 [ "location_id" => "17" "orderby" => "price_low_high" ]
      request_request
      []
      
      request_headers
      0 of 0
      array:18 [ "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, br, zstd" ] "host" => array:1 [ 0 => "suranadventures.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 => "3.141.244.160" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-https" => array:1 [ 0 => "on" ] ]
      request_server
      0 of 0
      array:46 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "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_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "suranadventures.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_X_FORWARDED_FOR" => "3.141.244.160" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_HTTPS" => "on" "DOCUMENT_ROOT" => "/home/cafebgnu/suranadventures.com" "REMOTE_ADDR" => "3.141.244.160" "REMOTE_PORT" => "42606" "SERVER_ADDR" => "162.0.217.113" "SERVER_NAME" => "suranadventures.com" "SERVER_ADMIN" => "webmaster@suranadventurescom.level-up-lounge.vip" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/tour?location_id=17&orderby=price_low_high" "REDIRECT_URL" => "/public/tour" "REDIRECT_QUERY_STRING" => "location_id=17&orderby=price_low_high" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "162.0.217.98" "HTTPS" => "on" "REDIRECT_STATUS" => "200" "SCRIPT_FILENAME" => "/home/cafebgnu/suranadventures.com/public/index.php" "QUERY_STRING" => "location_id=17&orderby=price_low_high" "SCRIPT_URI" => "https://suranadventures.com/tour" "SCRIPT_URL" => "/tour" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1744530614.7039 "REQUEST_TIME" => 1744530614 ]
      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 => "Sun, 13 Apr 2025 07:50:15 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlF3QUg1U3FZMENzak51eUxobWJFNWc9PSIsInZhbHVlIjoiaDNrNVhackFJekFYSlVjSXVTdnpibnJWY3k3VEFocW9vVTI4MHNLVDl3RE4zaStrVkk0UVdRQmJsMjdiakVRTzlBNUNDbHJyUDRESTZpOEVsN0FRM2FpRU1uRE5lN1pRdmZXMzFpMk13Q2NGSGpYWGVDZHkxbytHQmw0SlhnekciLCJtYWMiOiI4MjkxNGY3ZDE4NWNlNmMyN2RhYzIzODgwYTg5OWFmM2JkMTNkZjViMDk1NTMwYzQ5MzE0MTM2YmRiZjUyZjk0IiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 09:50:15 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlF3QUg1U3FZMENzak51eUxobWJFNWc9PSIsInZhbHVlIjoiaDNrNVhackFJekFYSlVjSXVTdnpibnJWY3k3VEFocW9vVTI4MHNLVDl3RE4zaStrVkk0UVdRQmJsMjdiakVRTzlBNUNDb" 1 => "suranadventures_session=eyJpdiI6IjAyNzF1Tk11LzA5V09sN1VBVE1PTUE9PSIsInZhbHVlIjoia2lZeStlV0szTzdzR044Y1h0eUVLdmJZYXVjaEFyMERxSWVkQ0twYVJOOG9uYjBrSUpZUnNYOHkzRzA1YXl5MEV4ejVYZEdsTmdvcVpoM3NmR0h2RFNzR2ZXKzJBY1RURW0xdU0yUDhZRU5DRlZuK0dlOGNhNTl0bFh2UUxuaW8iLCJtYWMiOiJiOTE5Y2M0YzcyYmRmYTdjNTE1MTMxN2M0YWQyYmRiNTk4M2U2YWY1Mzk3NjlhOTY5NDliMmU1MzIyNzRkOTkwIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 09:50:15 GMT; Max-Age=7200; path=/; httponly; samesite=laxsuranadventures_session=eyJpdiI6IjAyNzF1Tk11LzA5V09sN1VBVE1PTUE9PSIsInZhbHVlIjoia2lZeStlV0szTzdzR044Y1h0eUVLdmJZYXVjaEFyMERxSWVkQ0twYVJOOG9uYjBrSUpZUnNYOHkzRzA1" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlF3QUg1U3FZMENzak51eUxobWJFNWc9PSIsInZhbHVlIjoiaDNrNVhackFJekFYSlVjSXVTdnpibnJWY3k3VEFocW9vVTI4MHNLVDl3RE4zaStrVkk0UVdRQmJsMjdiakVRTzlBNUNDbHJyUDRESTZpOEVsN0FRM2FpRU1uRE5lN1pRdmZXMzFpMk13Q2NGSGpYWGVDZHkxbytHQmw0SlhnekciLCJtYWMiOiI4MjkxNGY3ZDE4NWNlNmMyN2RhYzIzODgwYTg5OWFmM2JkMTNkZjViMDk1NTMwYzQ5MzE0MTM2YmRiZjUyZjk0IiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 09:50:15 GMT; path=/XSRF-TOKEN=eyJpdiI6IlF3QUg1U3FZMENzak51eUxobWJFNWc9PSIsInZhbHVlIjoiaDNrNVhackFJekFYSlVjSXVTdnpibnJWY3k3VEFocW9vVTI4MHNLVDl3RE4zaStrVkk0UVdRQmJsMjdiakVRTzlBNUNDb" 1 => "suranadventures_session=eyJpdiI6IjAyNzF1Tk11LzA5V09sN1VBVE1PTUE9PSIsInZhbHVlIjoia2lZeStlV0szTzdzR044Y1h0eUVLdmJZYXVjaEFyMERxSWVkQ0twYVJOOG9uYjBrSUpZUnNYOHkzRzA1YXl5MEV4ejVYZEdsTmdvcVpoM3NmR0h2RFNzR2ZXKzJBY1RURW0xdU0yUDhZRU5DRlZuK0dlOGNhNTl0bFh2UUxuaW8iLCJtYWMiOiJiOTE5Y2M0YzcyYmRmYTdjNTE1MTMxN2M0YWQyYmRiNTk4M2U2YWY1Mzk3NjlhOTY5NDliMmU1MzIyNzRkOTkwIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 09:50:15 GMT; path=/; httponlysuranadventures_session=eyJpdiI6IjAyNzF1Tk11LzA5V09sN1VBVE1PTUE9PSIsInZhbHVlIjoia2lZeStlV0szTzdzR044Y1h0eUVLdmJZYXVjaEFyMERxSWVkQ0twYVJOOG9uYjBrSUpZUnNYOHkzRzA1" ] ]
      session_attributes
      0 of 0
      array:4 [ "_token" => "Tbd4LsmhI9FmhOnYySoaOKEkPLaFmEC6CviaymDH" "_previous" => array:1 [ "url" => "https://suranadventures.com/tour?location_id=17&orderby=price_low_high" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
      2025-04-13 - 2025-04-14