Search for accommodation

Messages Timeline Exceptions Views25 Route Queries90 Models239 Mails Gate Session Request

7.3.21690ms9MBGET filter/{location_slug}

Booting (131ms)
Application (559ms)
1 x Application (81.01%)
559ms
1 x Booting (18.99%)
131ms

25 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
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	`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

90 statements were executed, 20 of which were duplicated, 70 unique357ms

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

5.81ms/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)

7.13ms/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 0

2.92ms/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

1.53ms/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

1.32ms/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` = 87 and `cps`.`deleted_at` is null limit 1

1.98msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 87
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` = 87 and `media_files`.`deleted_at` is null order by `index` asc

1.78msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 87
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` = 267 and `media_files`.`deleted_at` is null limit 1

1.68ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 267
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

1.47ms/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` = 87 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

3.87msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 87
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

1.34ms/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` = 87 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

1.3msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 87
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` = 87 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

1.55msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 87
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` = 87 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

2.08ms/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 87 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` = 87 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 87 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` = 414 and `cps`.`deleted_at` is null limit 1

1.15msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 414
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` = 414 and `media_files`.`deleted_at` is null order by `index` asc

2.21msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 414
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` = 14175 and `media_files`.`deleted_at` is null limit 1

1.67ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 14175
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

400μ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` = 414 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

25.26msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 414
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

560μ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` = 414 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

450μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 414
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` = 414 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. 414
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` = 414 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 414 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` = 414 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

5.4ms/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 414 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` = 524 and `cps`.`deleted_at` is null limit 1

410μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 524
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` = 524 and `media_files`.`deleted_at` is null order by `index` asc

3.66msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 524
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` = 7241 and `media_files`.`deleted_at` is null limit 1

16.22ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 7241
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

27.18ms/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` = 524 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

1.87msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 524
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` = 1 and `currency_types`.`deleted_at` is null limit 1

1.4ms/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 1
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` = 524 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

7.23msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 524
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` = 524 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

10.32msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 524
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` = 524 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

4.47ms/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 524 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` = 524 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 524 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` = 527 and `cps`.`deleted_at` is null limit 1

2.28msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 527
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` = 527 and `media_files`.`deleted_at` is null order by `index` asc

8.67msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 527
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` = 7295 and `media_files`.`deleted_at` is null limit 1

7.52ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 7295
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

3.99ms/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` = 527 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

4.72msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 527
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` = 1 and `currency_types`.`deleted_at` is null limit 1

1.79ms/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 1
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` = 527 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

4msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 527
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` = 527 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

2.67msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 527
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` = 527 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

1.78ms/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 527 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` = 527 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 527 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` = 574 and `cps`.`deleted_at` is null limit 1

2.79msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 574
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` = 574 and `media_files`.`deleted_at` is null order by `index` asc

11.91msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 574
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` = 7639 and `media_files`.`deleted_at` is null limit 1

13.26ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 7639
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

5.94ms/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` = 574 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

14.39msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 574
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` = 1 and `currency_types`.`deleted_at` is null limit 1

9.5ms/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 1
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` = 574 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

13.32msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 574
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` = 574 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

2.57msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 574
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` = 574 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

2.35ms/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 574 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` = 574 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

10.11ms/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 574 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` = 658 and `cps`.`deleted_at` is null limit 1

5.37msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 658
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` = 658 and `media_files`.`deleted_at` is null order by `index` asc

5.94msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 658
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` = 8256 and `media_files`.`deleted_at` is null limit 1

2.71ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 8256
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

1.2ms/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` = 658 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

2.05msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 658
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` = 1 and `currency_types`.`deleted_at` is null limit 1

3ms/app/Models/Cp_price.php:68db_cplatintravel

Metadata
Bindings	0. 1
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` = 658 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

8.89msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 658
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` = 658 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

1.66msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 658
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` = 658 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

1.38ms/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 658 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` = 658 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

1.37ms/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 658 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` = 814 and `cps`.`deleted_at` is null limit 1

1.36msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 814
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` = 814 and `media_files`.`deleted_at` is null order by `index` asc

3.41msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 814
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` = 9563 and `media_files`.`deleted_at` is null limit 1

18.36ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 9563
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

750μ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` = 814 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

440μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 814
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

340μ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` = 814 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

450μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 814
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` = 814 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

560μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 814
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` = 814 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

1.08ms/app/Models/Cp.php:527db_cplatintravel

Metadata
Bindings	0. 814 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` = 814 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

1.51ms/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 814 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` = 908 and `cps`.`deleted_at` is null limit 1

1.2msview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

Metadata
Bindings	0. 908
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` = 908 and `media_files`.`deleted_at` is null order by `index` asc

2.36msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

Metadata
Bindings	0. 908
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` = 10494 and `media_files`.`deleted_at` is null limit 1

1.64ms/app/Models/BaseModel.php:113db_cplatintravel

Metadata
Bindings	0. 10494
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

4.18ms/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` = 908 and `cp_prices`.`cp_id` is not null and `cp_prices`.`deleted_at` is null limit 1

390μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

Metadata
Bindings	0. 908
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

2.04ms/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` = 908 and `cp_locations`.`cp_id` is not null and `cp_locations`.`deleted_at` is null limit 1

700μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

Metadata
Bindings	0. 908
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` = 908 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

1.78msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

Metadata
Bindings	0. 908
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` = 908 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 908 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` = 908 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

1.49ms/app/Models/Cp.php:539db_cplatintravel

Metadata
Bindings	0. 908 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

880μ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

1.25ms/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

2.39ms/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

2.12ms/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

450μ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: 16
App\Models\Cp_space: 8
App\Models\Cp_location: 8
App\Models\Cp_price: 8
App\Models\Currency_type: 22
App\Models\MediaFile: 148
App\Models\Cp: 8
App\Models\Settings: 2
App\Models\Location: 19

_token: SDHBKfGmfN1rlVHiIOLsDlMMPYOvY8rKkcqOLu7I
_previous: array:1 [ "url" => "https://caseparticularcubalatintravel.com/filter/vinales" ]
_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

[]

request_request

[]

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:44 [▼
  "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" => "3.131.38.255"
  "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" => "40194"
  "REDIRECT_URL" => "/filter/vinales"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/filter/vinales"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743732196.0724
  "REQUEST_TIME" => 1743732196
]

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 => "Fri, 04 Apr 2025 02:03:16 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IldLTEErRTZBZWVyemVPbU5CS29QY1E9PSIsInZhbHVlIjoiSkllSDRzY1lvenFaeWcva1FrVC9way9neTZnRDZnYWoya3hhUE91TFQxTUpQN2pTb3M4aGR4U0ZYcnViQnIzbUJKOFJ0U0ZhbnhnWk9nNTN0cFFKSkhXem5mWlVsb2Rya25VUkF0S09QZkVFOUVnQnFFQ0FvYmNIZ2dtRFhMaE0iLCJtYWMiOiIzMTZkMDg5NmJlZmM3MDA4N2I0YTU5ZDRiOTIyNmFmNTYzNDcyNDM2ZTMyZjNlMDgxNmMxZjE1MzhhMzQ5MGIzIn0%3D; expires=Fri, 04-Apr-2025 04:03:16 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IldLTEErRTZBZWVyemVPbU5CS29QY1E9PSIsInZhbHVlIjoiSkllSDRzY1lvenFaeWcva1FrVC9way9neTZnRDZnYWoya3hhUE91TFQxTUpQN2pTb3M4aGR4U0ZYcnViQnIzbUJKOFJ0U ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6IldWekFuK25KYzU0UWl0aUdSSGNlcXc9PSIsInZhbHVlIjoiVzVHZFJEVVpoVnMrMTJiR01ITHEyTy9wdVUyNnR6T05xaE5DdXdVWHVGakNBb0t4VkRkUWRkOUFrS2g1aUJYVmgrK2JnVzF2aEs0cUdJR0NyM0hCVXFyL3B3ZWZnZlBaZkU0UGpTblR1MVlJbWVMdXRJdDRsWE80T0hRL00wcHQiLCJtYWMiOiIxYTJkMWE0ZWM4YmFjZWZlODU0NTA1NzY0YTk4MzEyYmUxMzYzM2I4MDQ1MzlhNmIxY2M3YjNhYWJjMDc4MGMzIn0%3D; expires=Fri, 04-Apr-2025 04:03:16 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cuba_latin_travel_session=eyJpdiI6IldWekFuK25KYzU0UWl0aUdSSGNlcXc9PSIsInZhbHVlIjoiVzVHZFJEVVpoVnMrMTJiR01ITHEyTy9wdVUyNnR6T05xaE5DdXdVWHVGakNBb0t4VkRkUWRkOUFrS2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IldLTEErRTZBZWVyemVPbU5CS29QY1E9PSIsInZhbHVlIjoiSkllSDRzY1lvenFaeWcva1FrVC9way9neTZnRDZnYWoya3hhUE91TFQxTUpQN2pTb3M4aGR4U0ZYcnViQnIzbUJKOFJ0U0ZhbnhnWk9nNTN0cFFKSkhXem5mWlVsb2Rya25VUkF0S09QZkVFOUVnQnFFQ0FvYmNIZ2dtRFhMaE0iLCJtYWMiOiIzMTZkMDg5NmJlZmM3MDA4N2I0YTU5ZDRiOTIyNmFmNTYzNDcyNDM2ZTMyZjNlMDgxNmMxZjE1MzhhMzQ5MGIzIn0%3D; expires=Fri, 04-Apr-2025 04:03:16 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IldLTEErRTZBZWVyemVPbU5CS29QY1E9PSIsInZhbHVlIjoiSkllSDRzY1lvenFaeWcva1FrVC9way9neTZnRDZnYWoya3hhUE91TFQxTUpQN2pTb3M4aGR4U0ZYcnViQnIzbUJKOFJ0U ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6IldWekFuK25KYzU0UWl0aUdSSGNlcXc9PSIsInZhbHVlIjoiVzVHZFJEVVpoVnMrMTJiR01ITHEyTy9wdVUyNnR6T05xaE5DdXdVWHVGakNBb0t4VkRkUWRkOUFrS2g1aUJYVmgrK2JnVzF2aEs0cUdJR0NyM0hCVXFyL3B3ZWZnZlBaZkU0UGpTblR1MVlJbWVMdXRJdDRsWE80T0hRL00wcHQiLCJtYWMiOiIxYTJkMWE0ZWM4YmFjZWZlODU0NTA1NzY0YTk4MzEyYmUxMzYzM2I4MDQ1MzlhNmIxY2M3YjNhYWJjMDc4MGMzIn0%3D; expires=Fri, 04-Apr-2025 04:03:16 GMT; path=/; httponly ◀cuba_latin_travel_session=eyJpdiI6IldWekFuK25KYzU0UWl0aUdSSGNlcXc9PSIsInZhbHVlIjoiVzVHZFJEVVpoVnMrMTJiR01ITHEyTy9wdVUyNnR6T05xaE5DdXdVWHVGakNBb0t4VkRkUWRkOUFrS2 ▶"
  ]
]

session_attributes

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

Search for space

Get Updates & More

1 x Application (81.01%)	559ms
1 x Booting (18.99%)	131ms