Search for accommodation

Messages Timeline Exceptions Views25 Route Queries90 Models159 Mails Gate Session Request

7.3.21386ms8MBGET en/filter/{location_slug}

Booting (265ms)
Application (121ms)
1 x Booting (68.65%)
265ms
1 x Application (31.36%)
121ms

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

90 statements were executed, 20 of which were duplicated, 70 unique41.32ms

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

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

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

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

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

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

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

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

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

400μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

630μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

Metadata
Bindings	0. 11425
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` = 1000 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. 1000
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

290μ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` = 1000 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. 1000
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` = 1000 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. 1000
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` = 1000 and `service_model` = 1 and `status` = 1 and `reviews`.`deleted_at` is null limit 1

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

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

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

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

330μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

710μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

350μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

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

390μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

350μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

580μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

330μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

390μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

330μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

360μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

590μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

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

310μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

420μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

440μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

390μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

650μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

Metadata
Bindings	0. 11459
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` = 1004 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. 1004
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

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

390μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

320μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

400μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

570μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

Metadata
Bindings	0. 11503
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` = 1011 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. 1011
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

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

420μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

320μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

340μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

620μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

Metadata
Bindings	0. 12221
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` = 1078 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. 1078
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

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

310μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

330μsview::3920ceae5dc74d6491a5266309e279b85f9982d0:23db_cplatintravel

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

610μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:6db_cplatintravel

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

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

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

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

380μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:17db_cplatintravel

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

360μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:35db_cplatintravel

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

300μsview::6d8d8847c41404c33fd920ac893f3a77c400e7a5:43db_cplatintravel

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

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

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

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

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

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

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

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

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

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

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

path_info

/en/filter/matanzas

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

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

request_request

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

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "caseparticularcubalatintravel.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_server

  0 of 0   
array:45 [▼
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "caseparticularcubalatintravel.com"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "caseparticularcubalatintravel.com"
  "HTTP_HOST" => "caseparticularcubalatintravel.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.29 (Ubuntu) Server at caseparticularcubalatintravel.com Port 443</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.29 (Ubuntu)"
  "SERVER_NAME" => "caseparticularcubalatintravel.com"
  "SERVER_ADDR" => "51.91.9.147"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "3.16.78.138"
  "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" => "20265"
  "REDIRECT_URL" => "/en/filter/matanzas"
  "REDIRECT_QUERY_STRING" => "page=3"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=3"
  "REQUEST_URI" => "/en/filter/matanzas?page=3"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744574576.534
  "REQUEST_TIME" => 1744574576
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 13 Apr 2025 20:02:56 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpPenZvSUFpMmFOdFdxYzRHUFR6b1E9PSIsInZhbHVlIjoib1NhdTdXd1FNNW8vc2QrcVROYnZJc3lVK25mcUZWSjQ3N0N4TmJGVDFVUDZaMTg0dyttWXRldDBmRzMzTVA4VTdtRlhoMktwSDd5ZC9oUTI0Nm00N1Q3VEQzUlNzYjVtYlVDMitndlNMVkxWWXRMWkZocnY0MmU5UVR3SmNUbSsiLCJtYWMiOiJiZmZiYjAxNDk1NmQyZDY1NDdmZmU2NDBkZDQ3ZDU4MGNjNzMyZjE3M2VlZjg2NTk1YTg2MmVjMzJlNzM0MjY2In0%3D; expires=Sun, 13-Apr-2025 22:02:56 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImpPenZvSUFpMmFOdFdxYzRHUFR6b1E9PSIsInZhbHVlIjoib1NhdTdXd1FNNW8vc2QrcVROYnZJc3lVK25mcUZWSjQ3N0N4TmJGVDFVUDZaMTg0dyttWXRldDBmRzMzTVA4VTdtRlhoM ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6IjBFZHlhcHl2VnZHeHQ5TzI2ZWx6Ync9PSIsInZhbHVlIjoiQ1RVVmFWNFlQUlZ0TDBkY1o3aUw2eWRPbEpTbWFpaFV5UjhkTld5RVlpYUYrbDFvY3d0Qkh2aGdmRkNyQUZpaW5QV2hOQ1E2d1dWSFJRempydmJobzlxRVA0akpZNmx3eERkSmxoUWwzK0pKdU03Mi81NzVCM3lNaVFZL1BLdkIiLCJtYWMiOiI5ZTU2ODVjMjJhYzlmNzI0ZmI3MWQ3OWE2OTI0ZTViZDdhMjFkZjE1NWEzYjA0N2Q3Mzk1ZWFjNDBiZDYzYmM2In0%3D; expires=Sun, 13-Apr-2025 22:02:56 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cuba_latin_travel_session=eyJpdiI6IjBFZHlhcHl2VnZHeHQ5TzI2ZWx6Ync9PSIsInZhbHVlIjoiQ1RVVmFWNFlQUlZ0TDBkY1o3aUw2eWRPbEpTbWFpaFV5UjhkTld5RVlpYUYrbDFvY3d0Qkh2aGdmRk ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpPenZvSUFpMmFOdFdxYzRHUFR6b1E9PSIsInZhbHVlIjoib1NhdTdXd1FNNW8vc2QrcVROYnZJc3lVK25mcUZWSjQ3N0N4TmJGVDFVUDZaMTg0dyttWXRldDBmRzMzTVA4VTdtRlhoMktwSDd5ZC9oUTI0Nm00N1Q3VEQzUlNzYjVtYlVDMitndlNMVkxWWXRMWkZocnY0MmU5UVR3SmNUbSsiLCJtYWMiOiJiZmZiYjAxNDk1NmQyZDY1NDdmZmU2NDBkZDQ3ZDU4MGNjNzMyZjE3M2VlZjg2NTk1YTg2MmVjMzJlNzM0MjY2In0%3D; expires=Sun, 13-Apr-2025 22:02:56 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpPenZvSUFpMmFOdFdxYzRHUFR6b1E9PSIsInZhbHVlIjoib1NhdTdXd1FNNW8vc2QrcVROYnZJc3lVK25mcUZWSjQ3N0N4TmJGVDFVUDZaMTg0dyttWXRldDBmRzMzTVA4VTdtRlhoM ▶"
    1 => "cuba_latin_travel_session=eyJpdiI6IjBFZHlhcHl2VnZHeHQ5TzI2ZWx6Ync9PSIsInZhbHVlIjoiQ1RVVmFWNFlQUlZ0TDBkY1o3aUw2eWRPbEpTbWFpaFV5UjhkTld5RVlpYUYrbDFvY3d0Qkh2aGdmRkNyQUZpaW5QV2hOQ1E2d1dWSFJRempydmJobzlxRVA0akpZNmx3eERkSmxoUWwzK0pKdU03Mi81NzVCM3lNaVFZL1BLdkIiLCJtYWMiOiI5ZTU2ODVjMjJhYzlmNzI0ZmI3MWQ3OWE2OTI0ZTViZDdhMjFkZjE1NWEzYjA0N2Q3Mzk1ZWFjNDBiZDYzYmM2In0%3D; expires=Sun, 13-Apr-2025 22:02:56 GMT; path=/; httponly ◀cuba_latin_travel_session=eyJpdiI6IjBFZHlhcHl2VnZHeHQ5TzI2ZWx6Ync9PSIsInZhbHVlIjoiQ1RVVmFWNFlQUlZ0TDBkY1o3aUw2eWRPbEpTbWFpaFV5UjhkTld5RVlpYUYrbDFvY3d0Qkh2aGdmRk ▶"
  ]
]

session_attributes

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

Search for space

Get Updates & More

1 x Booting (68.65%)	265ms
1 x Application (31.36%)	121ms