ricerca di alloggio

Messages Timeline Exceptions Views25 Route Queries90 Models253 Mails Gate Session Request

7.3.21212ms9MBGET it/filter/{location_slug}

Booting (67.4ms)
Application (145ms)
1 x Application (68.27%)
145ms
1 x Booting (31.73%)
67.40ms

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 it/filter/{location_slug}
middleware: web
controller: App\Http\Controllers\CpController@filter
namespace: App\Http\Controllers
prefix: /it
where
as: cps.search
file: app/Http/Controllers/CpController.php:193-275

90 statements were executed, 20 of which were duplicated, 70 unique49.53ms

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

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

Metadata
Bindings	0. villa-clara
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` = 9 where (`approved` = 1 and `data_completed` = 1 and `last_step_completed` = 21 and `cps`.`deleted_at` is null)

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

Metadata
Bindings	0. 1 1. 9 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` = 9 where (`approved` = 1 and `data_completed` = 1 and `last_step_completed` = 21 and `cps`.`deleted_at` is null) limit 8 offset 0

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

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

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

480μ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` = 64 and `cps`.`deleted_at` is null limit 1

400μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

1.13msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

440μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

380μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

400μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

1msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

Metadata
Bindings	0. 221
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` = 85 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. 85
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

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

440μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

380μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

450μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

710μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

470μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

420μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

390μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

780μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

340μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

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

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

360μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

780μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

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

370μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

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

410μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

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

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

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

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

360μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

1.05msview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

420μ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` = 317 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. 317
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

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

440μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

360μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

430μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

630μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

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

400μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

410μ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` = 546 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. 546
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` = 546 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

420μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

370μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

890μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

400μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

430μ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` = 762 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. 762
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` = 762 and `cp_spaces`.`cp_id` is not null and `cp_spaces`.`deleted_at` is null limit 1

350μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

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

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

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

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

390μ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: 162
App\Models\Cp: 8
App\Models\Settings: 2
App\Models\Location: 19

_token: BZRFho4KH16RivdF2VpyRDIMYzbu7dZ1ljJiD58d
_previous: array:1 [ "url" => "https://caseparticularcubalatintravel.com/it/filter/villa-clara" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/it/filter/villa-clara

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.15.173.49"
  "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" => "3285"
  "REDIRECT_URL" => "/it/filter/villa-clara"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/it/filter/villa-clara"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744216205.4693
  "REQUEST_TIME" => 1744216205
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 09 Apr 2025 16:30:05 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InQ4SjVBejdWSGgvbDMycFZSUnY3Nnc9PSIsInZhbHVlIjoiMUtJMXJpYm1yTXJJWE52eXFIQnNLUWtFR3NqMlRzeWdxT01lVzlxWjY2S3dYZmNFNWd4TldXTWUxOFNJWXRKWVZVUjVZamp1NGtTM093K3hhakNXemV2MXNDeGpNdWxrZHpsSW4vZ1dOWEN3cUlvbWh1TTlrSUFjNkN5VHU5aE4iLCJtYWMiOiI4OTRlNzg0YTEyZGE3NTY4NWViYjlhZjJiNDUxYWViYmM3ZThiOGUzYjVhOTZjNzE5MmMzMzZmMDg5OTNjMzJhIn0%3D; expires=Wed, 09-Apr-2025 18:30:05 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InQ4SjVBejdWSGgvbDMycFZSUnY3Nnc9PSIsInZhbHVlIjoiMUtJMXJpYm1yTXJJWE52eXFIQnNLUWtFR3NqMlRzeWdxT01lVzlxWjY2S3dYZmNFNWd4TldXTWUxOFNJWXRKWVZVUjVZa ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6Ik01WDZ4WWRuMWNjT2ZPQ2JuYXV3R2c9PSIsInZhbHVlIjoiZUkzeWhtNXVyaC82bnJVMUpuSHkwWnNNUnhJVk1GaEpUYUNsNjRVMVltb0hDOXZiSzBRSGZYRnB2UTdjMFptVWh3MEd6WklWQndUdnZoODZjcVJuUENlYW8wSW11SG94aXV4eE14T1YwUGdCTlZoRnliS1dMTkNiM2ZkQzJXZnAiLCJtYWMiOiIzZGU5YWViYjRhYWZiMzRiNTRkZGU3YjE2Y2ZmYzgxOGFhZGRiN2RmMjcyMmM4ODU3ZDMwYjY1ZTE1MGFkYjAzIn0%3D; expires=Wed, 09-Apr-2025 18:30:05 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cuba_latin_travel_session=eyJpdiI6Ik01WDZ4WWRuMWNjT2ZPQ2JuYXV3R2c9PSIsInZhbHVlIjoiZUkzeWhtNXVyaC82bnJVMUpuSHkwWnNNUnhJVk1GaEpUYUNsNjRVMVltb0hDOXZiSzBRSGZYRnB2UT ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InQ4SjVBejdWSGgvbDMycFZSUnY3Nnc9PSIsInZhbHVlIjoiMUtJMXJpYm1yTXJJWE52eXFIQnNLUWtFR3NqMlRzeWdxT01lVzlxWjY2S3dYZmNFNWd4TldXTWUxOFNJWXRKWVZVUjVZamp1NGtTM093K3hhakNXemV2MXNDeGpNdWxrZHpsSW4vZ1dOWEN3cUlvbWh1TTlrSUFjNkN5VHU5aE4iLCJtYWMiOiI4OTRlNzg0YTEyZGE3NTY4NWViYjlhZjJiNDUxYWViYmM3ZThiOGUzYjVhOTZjNzE5MmMzMzZmMDg5OTNjMzJhIn0%3D; expires=Wed, 09-Apr-2025 18:30:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InQ4SjVBejdWSGgvbDMycFZSUnY3Nnc9PSIsInZhbHVlIjoiMUtJMXJpYm1yTXJJWE52eXFIQnNLUWtFR3NqMlRzeWdxT01lVzlxWjY2S3dYZmNFNWd4TldXTWUxOFNJWXRKWVZVUjVZa ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6Ik01WDZ4WWRuMWNjT2ZPQ2JuYXV3R2c9PSIsInZhbHVlIjoiZUkzeWhtNXVyaC82bnJVMUpuSHkwWnNNUnhJVk1GaEpUYUNsNjRVMVltb0hDOXZiSzBRSGZYRnB2UTdjMFptVWh3MEd6WklWQndUdnZoODZjcVJuUENlYW8wSW11SG94aXV4eE14T1YwUGdCTlZoRnliS1dMTkNiM2ZkQzJXZnAiLCJtYWMiOiIzZGU5YWViYjRhYWZiMzRiNTRkZGU3YjE2Y2ZmYzgxOGFhZGRiN2RmMjcyMmM4ODU3ZDMwYjY1ZTE1MGFkYjAzIn0%3D; expires=Wed, 09-Apr-2025 18:30:05 GMT; path=/; httponly ◀cuba_latin_travel_session=eyJpdiI6Ik01WDZ4WWRuMWNjT2ZPQ2JuYXV3R2c9PSIsInZhbHVlIjoiZUkzeWhtNXVyaC82bnJVMUpuSHkwWnNNUnhJVk1GaEpUYUNsNjRVMVltb0hDOXZiSzBRSGZYRnB2UT ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "BZRFho4KH16RivdF2VpyRDIMYzbu7dZ1ljJiD58d"
  "_previous" => array:1 [▶
    "url" => "https://caseparticularcubalatintravel.com/it/filter/villa-clara"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Cerca un alloggio

Ricevi aggiornamenti

1 x Application (68.27%)	145ms
1 x Booting (31.73%)	67.40ms