Search for accommodation

Messages Timeline Exceptions Views22 Route Queries60 Models142 Mails Gate Session Request

7.3.21185ms8MBGET filter/{location_slug}

Booting (82.43ms)
Application (102ms)
1 x Application (55.33%)
102ms
1 x Booting (44.66%)
82.43ms

22 templates were rendered

front.space.search (resources/views/front/space/search.blade.php)4blade
Params
0
rows
1
markers
2
seo_meta
3
slug
front.space.blocks.search.form-search (resources/views/front/space/blocks/search/form-search.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.space.blocks.search.list-item (resources/views/front/space/blocks/search/list-item.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.space.blocks.search.loop-gird (resources/views/front/space/blocks/search/loop-gird.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
8
__currentLoopData
9
item
10
loop
11
row
front.space.blocks.search.loop-gird (resources/views/front/space/blocks/search/loop-gird.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
8
__currentLoopData
9
item
10
loop
11
row
front.space.blocks.search.loop-gird (resources/views/front/space/blocks/search/loop-gird.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
8
__currentLoopData
9
item
10
loop
11
row
front.space.blocks.search.loop-gird (resources/views/front/space/blocks/search/loop-gird.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
8
__currentLoopData
9
item
10
loop
11
row
front.space.blocks.search.loop-gird (resources/views/front/space/blocks/search/loop-gird.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
8
__currentLoopData
9
item
10
loop
11
row
pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements
front.layout.app (resources/views/front/layout/app.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.parts.seo-meta (resources/views/front/parts/seo-meta.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.parts.custom-css (resources/views/front/parts/custom-css.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.parts.topbar (resources/views/front/parts/topbar.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.parts.header (resources/views/front/parts/header.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug

Params
0	`rows`
1	`markers`
2	`seo_meta`
3	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`
8	`__currentLoopData`
9	`item`
10	`loop`
11	`row`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`
8	`__currentLoopData`
9	`item`
10	`loop`
11	`row`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`
8	`__currentLoopData`
9	`item`
10	`loop`
11	`row`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`
8	`__currentLoopData`
9	`item`
10	`loop`
11	`row`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`
8	`__currentLoopData`
9	`item`
10	`loop`
11	`row`

Params
0	`paginator`
1	`elements`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

front.parts.main-menu (resources/views/front/parts/main-menu.blade.php)15blade


obLevel
__env
app
errors
rows
markers
seo_meta
slug
currencies
current_currency
__currentLoopData
item
loop
properties
localeCode

front.includes.fb-chat (resources/views/front/includes/fb-chat.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.parts.footer (resources/views/front/parts/footer.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.includes.branch-footer (resources/views/front/includes/branch-footer.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.includes.main-footer (resources/views/front/includes/main-footer.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.parts.login-register-modal (resources/views/front/parts/login-register-modal.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.auth.login-user-form (resources/views/front/auth/login-user-form.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug
front.auth.register-user-form (resources/views/front/auth/register-user-form.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
rows
5
markers
6
seo_meta
7
slug

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`
8	`currencies`
9	`current_currency`
10	`__currentLoopData`
11	`item`
12	`loop`
13	`properties`
14	`localeCode`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`rows`
5	`markers`
6	`seo_meta`
7	`slug`

uri: GET filter/{location_slug}
middleware: web
controller: App\Http\Controllers\CpController@filter
namespace: App\Http\Controllers
prefix
where
as: cps.search
file: app/Http/Controllers/CpController.php:193-275

60 statements were executed, 14 of which were duplicated, 46 unique35.52ms

select * from `locations` where `slug` = 'vinales' and `locations`.`deleted_at` is null limit 1

3.83ms/app/Http/Controllers/CpController.php:221db_cplatintravel

Metadata
Bindings	0. vinales
Backtrace	15. /app/Http/Controllers/CpController.php:221 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select count(*) as aggregate from `cps` inner join `cp_spaces` on `cp_spaces`.`cp_id` = `cps`.`id` and `cp_spaces`.`number_guests` >= 1 inner join `cp_locations` on `cp_locations`.`cp_id` = `cps`.`id` and `cp_locations`.`location_id` = 2 where (`approved` = 1 and `data_completed` = 1 and `last_step_completed` = 21 and `cps`.`deleted_at` is null)

3.25ms/app/Http/Controllers/CpController.php:267db_cplatintravel

Metadata
Bindings	0. 1 1. 2 2. 1 3. 1 4. 21
Backtrace	15. /app/Http/Controllers/CpController.php:267 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `cps` inner join `cp_spaces` on `cp_spaces`.`cp_id` = `cps`.`id` and `cp_spaces`.`number_guests` >= 1 inner join `cp_locations` on `cp_locations`.`cp_id` = `cps`.`id` and `cp_locations`.`location_id` = 2 where (`approved` = 1 and `data_completed` = 1 and `last_step_completed` = 21 and `cps`.`deleted_at` is null) limit 8 offset 16

2.8ms/app/Http/Controllers/CpController.php:267db_cplatintravel

Metadata
Bindings	0. 1 1. 2 2. 1 3. 1 4. 21
Backtrace	13. /app/Http/Controllers/CpController.php:267 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select * from `locations` where `locations`.`deleted_at` is null

530μs/app/Helpers/AppHelper.php:597db_cplatintravel

Metadata
Backtrace	15. /app/Helpers/AppHelper.php:597 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `settings` where `name` = 'space_location_search_style' limit 1

450μs/app/Models/Settings.php:30db_cplatintravel

Metadata
Bindings	0. space_location_search_style
Backtrace	15. /app/Models/Settings.php:30 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 19. /app/Models/Settings.php:32 20. /app/Helpers/AppHelper.php:19

select * from `cps` where `cps`.`id` = 1322 and `cps`.`deleted_at` is null limit 1

460μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 1322
Backtrace	19. view::3920ceae5dc74d6491a5266309e279b85f9982d0:23 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `media_files`.*, `cp_has_media_files`.`cp_id` as `pivot_cp_id`, `cp_has_media_files`.`media_file_id` as `pivot_media_file_id`, `cp_has_media_files`.`caption` as `pivot_caption`, `cp_has_media_files`.`status` as `pivot_status`, `cp_has_media_files`.`index` as `pivot_index`, `cp_has_media_files`.`created_at` as `pivot_created_at`, `cp_has_media_files`.`updated_at` as `pivot_updated_at` from `media_files` inner join `cp_has_media_files` on `media_files`.`id` = `cp_has_media_files`.`media_file_id` where `cp_has_media_files`.`cp_id` = 1322 and `media_files`.`deleted_at` is null order by `index` asc

1.05msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 1322
Backtrace	19. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `media_files` where `media_files`.`id` = 15114 and `media_files`.`deleted_at` is null limit 1

380μs/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 15114
Backtrace	18. /app/Models/BaseModel.php:113 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 22. /app/Models/BaseModel.php:114 23. /app/Helpers/FileHelper.php:39

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

540μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_prices` where `cp_prices`.`cp_id` = 1322 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

540μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 1322
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `currency_types`.`id` = 2 and `currency_types`.`deleted_at` is null limit 1

380μs/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 2
Backtrace	20. /app/Models/Cp_price.php:68 21. /app/Models/Cp_price.php:100 22. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `cp_locations` where `cp_locations`.`cp_id` = 1322 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

490μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 1322
Backtrace	21. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 25. /vendor/laravel/framework/src/Illuminate/View/View.php:139 26. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_spaces` where `cp_spaces`.`cp_id` = 1322 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

430μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 1322
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select  AVG(rate_avg) as score_total , COUNT(id) as total_review  from `reviews` where `service_id` = 1322 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

460μs/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 1322 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:527 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select COUNT( CASE WHEN rate_avg = 5 THEN rate_avg ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_avg = 4 THEN rate_avg ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_avg = 3 THEN rate_avg ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_avg = 2 THEN rate_avg ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_avg = 1 THEN rate_avg ELSE NULL END ) AS rate_1  from `reviews` where `service_id` = 1322 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

400μs/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 1322 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:539 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `cps` where `cps`.`id` = 1332 and `cps`.`deleted_at` is null limit 1

390μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 1332
Backtrace	19. view::3920ceae5dc74d6491a5266309e279b85f9982d0:23 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `media_files`.*, `cp_has_media_files`.`cp_id` as `pivot_cp_id`, `cp_has_media_files`.`media_file_id` as `pivot_media_file_id`, `cp_has_media_files`.`caption` as `pivot_caption`, `cp_has_media_files`.`status` as `pivot_status`, `cp_has_media_files`.`index` as `pivot_index`, `cp_has_media_files`.`created_at` as `pivot_created_at`, `cp_has_media_files`.`updated_at` as `pivot_updated_at` from `media_files` inner join `cp_has_media_files` on `media_files`.`id` = `cp_has_media_files`.`media_file_id` where `cp_has_media_files`.`cp_id` = 1332 and `media_files`.`deleted_at` is null order by `index` asc

730μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 1332
Backtrace	19. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `media_files` where `media_files`.`id` = 15244 and `media_files`.`deleted_at` is null limit 1

390μs/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 15244
Backtrace	18. /app/Models/BaseModel.php:113 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 22. /app/Models/BaseModel.php:114 23. /app/Helpers/FileHelper.php:39

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

430μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_prices` where `cp_prices`.`cp_id` = 1332 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

430μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 1332
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `currency_types`.`id` = 2 and `currency_types`.`deleted_at` is null limit 1

360μs/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 2
Backtrace	20. /app/Models/Cp_price.php:68 21. /app/Models/Cp_price.php:100 22. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `cp_locations` where `cp_locations`.`cp_id` = 1332 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

420μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 1332
Backtrace	21. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 25. /vendor/laravel/framework/src/Illuminate/View/View.php:139 26. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_spaces` where `cp_spaces`.`cp_id` = 1332 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

400μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 1332
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select  AVG(rate_avg) as score_total , COUNT(id) as total_review  from `reviews` where `service_id` = 1332 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

390μs/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 1332 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:527 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select COUNT( CASE WHEN rate_avg = 5 THEN rate_avg ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_avg = 4 THEN rate_avg ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_avg = 3 THEN rate_avg ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_avg = 2 THEN rate_avg ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_avg = 1 THEN rate_avg ELSE NULL END ) AS rate_1  from `reviews` where `service_id` = 1332 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

440μs/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 1332 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:539 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `cps` where `cps`.`id` = 1333 and `cps`.`deleted_at` is null limit 1

400μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 1333
Backtrace	19. view::3920ceae5dc74d6491a5266309e279b85f9982d0:23 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `media_files`.*, `cp_has_media_files`.`cp_id` as `pivot_cp_id`, `cp_has_media_files`.`media_file_id` as `pivot_media_file_id`, `cp_has_media_files`.`caption` as `pivot_caption`, `cp_has_media_files`.`status` as `pivot_status`, `cp_has_media_files`.`index` as `pivot_index`, `cp_has_media_files`.`created_at` as `pivot_created_at`, `cp_has_media_files`.`updated_at` as `pivot_updated_at` from `media_files` inner join `cp_has_media_files` on `media_files`.`id` = `cp_has_media_files`.`media_file_id` where `cp_has_media_files`.`cp_id` = 1333 and `media_files`.`deleted_at` is null order by `index` asc

680μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 1333
Backtrace	19. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `media_files` where `media_files`.`id` = 15253 and `media_files`.`deleted_at` is null limit 1

460μs/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 15253
Backtrace	18. /app/Models/BaseModel.php:113 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 22. /app/Models/BaseModel.php:114 23. /app/Helpers/FileHelper.php:39

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

410μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_prices` where `cp_prices`.`cp_id` = 1333 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

420μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 1333
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `currency_types`.`id` = 2 and `currency_types`.`deleted_at` is null limit 1

370μs/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 2
Backtrace	20. /app/Models/Cp_price.php:68 21. /app/Models/Cp_price.php:100 22. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `cp_locations` where `cp_locations`.`cp_id` = 1333 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

430μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 1333
Backtrace	21. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 25. /vendor/laravel/framework/src/Illuminate/View/View.php:139 26. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_spaces` where `cp_spaces`.`cp_id` = 1333 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

330μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 1333
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select  AVG(rate_avg) as score_total , COUNT(id) as total_review  from `reviews` where `service_id` = 1333 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

360μs/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 1333 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:527 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select COUNT( CASE WHEN rate_avg = 5 THEN rate_avg ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_avg = 4 THEN rate_avg ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_avg = 3 THEN rate_avg ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_avg = 2 THEN rate_avg ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_avg = 1 THEN rate_avg ELSE NULL END ) AS rate_1  from `reviews` where `service_id` = 1333 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

430μs/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 1333 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:539 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `cps` where `cps`.`id` = 1337 and `cps`.`deleted_at` is null limit 1

350μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 1337
Backtrace	19. view::3920ceae5dc74d6491a5266309e279b85f9982d0:23 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `media_files`.*, `cp_has_media_files`.`cp_id` as `pivot_cp_id`, `cp_has_media_files`.`media_file_id` as `pivot_media_file_id`, `cp_has_media_files`.`caption` as `pivot_caption`, `cp_has_media_files`.`status` as `pivot_status`, `cp_has_media_files`.`index` as `pivot_index`, `cp_has_media_files`.`created_at` as `pivot_created_at`, `cp_has_media_files`.`updated_at` as `pivot_updated_at` from `media_files` inner join `cp_has_media_files` on `media_files`.`id` = `cp_has_media_files`.`media_file_id` where `cp_has_media_files`.`cp_id` = 1337 and `media_files`.`deleted_at` is null order by `index` asc

770μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 1337
Backtrace	19. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `media_files` where `media_files`.`id` = 15290 and `media_files`.`deleted_at` is null limit 1

420μs/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 15290
Backtrace	18. /app/Models/BaseModel.php:113 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 22. /app/Models/BaseModel.php:114 23. /app/Helpers/FileHelper.php:39

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

440μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_prices` where `cp_prices`.`cp_id` = 1337 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

450μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 1337
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `currency_types`.`id` = 2 and `currency_types`.`deleted_at` is null limit 1

420μs/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 2
Backtrace	20. /app/Models/Cp_price.php:68 21. /app/Models/Cp_price.php:100 22. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `cp_locations` where `cp_locations`.`cp_id` = 1337 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

430μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 1337
Backtrace	21. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 25. /vendor/laravel/framework/src/Illuminate/View/View.php:139 26. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_spaces` where `cp_spaces`.`cp_id` = 1337 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

370μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 1337
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select  AVG(rate_avg) as score_total , COUNT(id) as total_review  from `reviews` where `service_id` = 1337 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

340μs/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 1337 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:527 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select COUNT( CASE WHEN rate_avg = 5 THEN rate_avg ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_avg = 4 THEN rate_avg ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_avg = 3 THEN rate_avg ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_avg = 2 THEN rate_avg ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_avg = 1 THEN rate_avg ELSE NULL END ) AS rate_1  from `reviews` where `service_id` = 1337 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

430μs/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 1337 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:539 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `cps` where `cps`.`id` = 1338 and `cps`.`deleted_at` is null limit 1

380μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 1338
Backtrace	19. view::3920ceae5dc74d6491a5266309e279b85f9982d0:23 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select `media_files`.*, `cp_has_media_files`.`cp_id` as `pivot_cp_id`, `cp_has_media_files`.`media_file_id` as `pivot_media_file_id`, `cp_has_media_files`.`caption` as `pivot_caption`, `cp_has_media_files`.`status` as `pivot_status`, `cp_has_media_files`.`index` as `pivot_index`, `cp_has_media_files`.`created_at` as `pivot_created_at`, `cp_has_media_files`.`updated_at` as `pivot_updated_at` from `media_files` inner join `cp_has_media_files` on `media_files`.`id` = `cp_has_media_files`.`media_file_id` where `cp_has_media_files`.`cp_id` = 1338 and `media_files`.`deleted_at` is null order by `index` asc

710μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 1338
Backtrace	19. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139 24. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `media_files` where `media_files`.`id` = 15306 and `media_files`.`deleted_at` is null limit 1

400μs/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 15306
Backtrace	18. /app/Models/BaseModel.php:113 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 22. /app/Models/BaseModel.php:114 23. /app/Helpers/FileHelper.php:39

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

390μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_prices` where `cp_prices`.`cp_id` = 1338 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

480μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 1338
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `currency_types`.`id` = 2 and `currency_types`.`deleted_at` is null limit 1

400μs/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 2
Backtrace	20. /app/Models/Cp_price.php:68 21. /app/Models/Cp_price.php:100 22. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `cp_locations` where `cp_locations`.`cp_id` = 1338 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

520μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 1338
Backtrace	21. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 25. /vendor/laravel/framework/src/Illuminate/View/View.php:139 26. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `cp_spaces` where `cp_spaces`.`cp_id` = 1338 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

400μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 1338
Backtrace	20. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139 25. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select  AVG(rate_avg) as score_total , COUNT(id) as total_review  from `reviews` where `service_id` = 1338 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

360μs/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 1338 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:527 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select COUNT( CASE WHEN rate_avg = 5 THEN rate_avg ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_avg = 4 THEN rate_avg ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_avg = 3 THEN rate_avg ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_avg = 2 THEN rate_avg ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_avg = 1 THEN rate_avg ELSE NULL END ) AS rate_1  from `reviews` where `service_id` = 1338 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

440μs/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 1338 1. 1 2. 1
Backtrace	15. /app/Models/Cp.php:539 16. view::6d8d8847c41404c33fd920ac893f3a77c400e7a5:62 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

360μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `abbr` = 'EUR' and `currency_types`.`deleted_at` is null limit 1

450μs/app/Helpers/AppHelper.php:609db_cplatintravel

Metadata
Bindings	0. EUR
Backtrace	15. /app/Helpers/AppHelper.php:609 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 20. /vendor/laravel/framework/src/Illuminate/View/View.php:139 21. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `status` = 1 and `currency_types`.`deleted_at` is null

370μs/app/Helpers/AppHelper.php:603db_cplatintravel

Metadata
Bindings	0. 1
Backtrace	14. /app/Helpers/AppHelper.php:603 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 19. /vendor/laravel/framework/src/Illuminate/View/View.php:139 20. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `currency_types` where `status` = 1 and `currency_types`.`deleted_at` is null

370μs/app/Helpers/AppHelper.php:603db_cplatintravel

Metadata
Bindings	0. 1
Backtrace	14. /app/Helpers/AppHelper.php:603 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37 19. /vendor/laravel/framework/src/Illuminate/View/View.php:139 20. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select * from `settings` where `name` = 'cookie_agreement_enable' limit 1

410μs/app/Models/Settings.php:30db_cplatintravel

Metadata
Bindings	0. cookie_agreement_enable
Backtrace	15. /app/Models/Settings.php:30 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:383 19. /app/Models/Settings.php:32 20. /app/Helpers/AppHelper.php:19

App\Models\Reviews: 10
App\Models\Cp_space: 5
App\Models\Cp_location: 5
App\Models\Cp_price: 5
App\Models\Currency_type: 16
App\Models\MediaFile: 75
App\Models\Cp: 5
App\Models\Settings: 2
App\Models\Location: 19

_token: jp7aTRf2AEMshVr3cbAOt10MAEeYwX6o1DceOh6x
_previous: array:1 [ "url" => "https://caseparticularcubalatintravel.com/filter/vinales?page=3" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/filter/vinales

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "3"
]

request_request

  0 of 0   
array:1 [▼
  "page" => "3"
]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "caseparticularcubalatintravel.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "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"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_server

  0 of 0   
array:45 [▼
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "caseparticularcubalatintravel.com"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "caseparticularcubalatintravel.com"
  "HTTP_HOST" => "caseparticularcubalatintravel.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "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_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.29 (Ubuntu) Server at caseparticularcubalatintravel.com Port 443</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.29 (Ubuntu)"
  "SERVER_NAME" => "caseparticularcubalatintravel.com"
  "SERVER_ADDR" => "51.91.9.147"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "18.190.159.202"
  "DOCUMENT_ROOT" => "/usr/deploy/bnbit/public/"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/usr/deploy/bnbit/public/"
  "SERVER_ADMIN" => "admin@example.com"
  "SCRIPT_FILENAME" => "/usr/deploy/bnbit/public/index.php"
  "REMOTE_PORT" => "19859"
  "REDIRECT_URL" => "/filter/vinales"
  "REDIRECT_QUERY_STRING" => "page=3"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=3"
  "REQUEST_URI" => "/filter/vinales?page=3"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743964000.9164
  "REQUEST_TIME" => 1743964000
]

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, 06 Apr 2025 18:26:41 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjcvRlFVZzFkcGxXTFlkdmdlMWh5ZkE9PSIsInZhbHVlIjoiZ29hcUNQNU1sQTBKdFZ1K0NJN1JGUUNsV2dFTnIvcTZYNjN5ZTVkTGVld0JmQWdZOC95RktkdzVuTnppVDhxWmRSNHhpMkUvaGNySjA3VDRMZ0JXNVU3b1NNZkhDNFJLRWxPQkpPSktZSFFpeVF6em5NejE1SHMrd0llbkRPc0ciLCJtYWMiOiIyMDM0MWYwYzQ2Njg2YTFjZDc3NmNmOTEzODkyMzQ5MWMwMzc2ODJkNjhlNGZiODI0NmRiMjRkYWNhMjBiMDA5In0%3D; expires=Sun, 06-Apr-2025 20:26:41 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjcvRlFVZzFkcGxXTFlkdmdlMWh5ZkE9PSIsInZhbHVlIjoiZ29hcUNQNU1sQTBKdFZ1K0NJN1JGUUNsV2dFTnIvcTZYNjN5ZTVkTGVld0JmQWdZOC95RktkdzVuTnppVDhxWmRSNHhpM ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6IndHS1U0QVdHRHZFcXhYZ3p1dTRZUlE9PSIsInZhbHVlIjoiYitqTUo2TEZPYUZmZUpUQ1EwRGNLN203WkNIVGc2WklWaDZ6eTVQc3VTbEQ4U2N6L1hJaGsxUGU1dXY2azVhMXlsWVRqZEFrTUtLRk5tOXBzSkNrc3pIMXZFSUlxOEN5YVdjdi9lcVRVbU9nSUhoMFdNU2FtcW51c1lGczdRcVoiLCJtYWMiOiI2OGUwNzM0YWU4MDQ2YWI2YjE5NWQ3YTVmYTZlODQ0MTRhMDgyMGVmOWU1ZGZmNmM3NjllODJmOWYzY2E2NzhkIn0%3D; expires=Sun, 06-Apr-2025 20:26:41 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cuba_latin_travel_session=eyJpdiI6IndHS1U0QVdHRHZFcXhYZ3p1dTRZUlE9PSIsInZhbHVlIjoiYitqTUo2TEZPYUZmZUpUQ1EwRGNLN203WkNIVGc2WklWaDZ6eTVQc3VTbEQ4U2N6L1hJaGsxUGU1dX ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjcvRlFVZzFkcGxXTFlkdmdlMWh5ZkE9PSIsInZhbHVlIjoiZ29hcUNQNU1sQTBKdFZ1K0NJN1JGUUNsV2dFTnIvcTZYNjN5ZTVkTGVld0JmQWdZOC95RktkdzVuTnppVDhxWmRSNHhpMkUvaGNySjA3VDRMZ0JXNVU3b1NNZkhDNFJLRWxPQkpPSktZSFFpeVF6em5NejE1SHMrd0llbkRPc0ciLCJtYWMiOiIyMDM0MWYwYzQ2Njg2YTFjZDc3NmNmOTEzODkyMzQ5MWMwMzc2ODJkNjhlNGZiODI0NmRiMjRkYWNhMjBiMDA5In0%3D; expires=Sun, 06-Apr-2025 20:26:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjcvRlFVZzFkcGxXTFlkdmdlMWh5ZkE9PSIsInZhbHVlIjoiZ29hcUNQNU1sQTBKdFZ1K0NJN1JGUUNsV2dFTnIvcTZYNjN5ZTVkTGVld0JmQWdZOC95RktkdzVuTnppVDhxWmRSNHhpM ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6IndHS1U0QVdHRHZFcXhYZ3p1dTRZUlE9PSIsInZhbHVlIjoiYitqTUo2TEZPYUZmZUpUQ1EwRGNLN203WkNIVGc2WklWaDZ6eTVQc3VTbEQ4U2N6L1hJaGsxUGU1dXY2azVhMXlsWVRqZEFrTUtLRk5tOXBzSkNrc3pIMXZFSUlxOEN5YVdjdi9lcVRVbU9nSUhoMFdNU2FtcW51c1lGczdRcVoiLCJtYWMiOiI2OGUwNzM0YWU4MDQ2YWI2YjE5NWQ3YTVmYTZlODQ0MTRhMDgyMGVmOWU1ZGZmNmM3NjllODJmOWYzY2E2NzhkIn0%3D; expires=Sun, 06-Apr-2025 20:26:41 GMT; path=/; httponly ◀cuba_latin_travel_session=eyJpdiI6IndHS1U0QVdHRHZFcXhYZ3p1dTRZUlE9PSIsInZhbHVlIjoiYitqTUo2TEZPYUZmZUpUQ1EwRGNLN203WkNIVGc2WklWaDZ6eTVQc3VTbEQ4U2N6L1hJaGsxUGU1dX ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "jp7aTRf2AEMshVr3cbAOt10MAEeYwX6o1DceOh6x"
  "_previous" => array:1 [▶
    "url" => "https://caseparticularcubalatintravel.com/filter/vinales?page=3"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Search for space

Get Updates & More

1 x Application (55.33%)	102ms
1 x Booting (44.66%)	82.43ms