Apartamente, case/vile de inchiriat 5 camere

Messages Timeline Exceptions Views13 Route Queries18 Mails Auth Gate Session Request

7.1.33124ms8MBGET apartamente-case-de-inchiriat/{location?}/{rooms?}/{id?}

Booting (30.09ms)
Application (93.82ms)
1 x Application (75.67%)
93.82ms
1 x Booting (24.27%)
30.09ms

13 templates were rendered

search (resources/views/search.blade.php)21blade


page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options

Params
0	`page_title`
1	`page_description`
2	`page_keywords`
3	`search`
4	`search_data`
5	`search_saved`
6	`query_options`
7	`compound`
8	`properties`
9	`filters`
10	`elinks`
11	`markers`
12	`location`
13	`total`
14	`pages`
15	`page`
16	`breadcrumbs`
17	`price_options`
18	`price_sqm_options`
19	`surface_options`
20	`surface_land_options`

inc.breadcrumbs (resources/views/inc/breadcrumbs.blade.php)29blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`

inc.search_results (resources/views/inc/search_results.blade.php)30blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
cols

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`cols`

inc.property (resources/views/inc/property.blade.php)33blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
cols
property
k
search_for

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`cols`
30	`property`
31	`k`
32	`search_for`

inc.property (resources/views/inc/property.blade.php)33blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
cols
property
k
search_for

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`cols`
30	`property`
31	`k`
32	`search_for`

inc.elinks (resources/views/inc/elinks.blade.php)33blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
cols
property
k
nofollow

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`cols`
30	`property`
31	`k`
32	`nofollow`

inc.save_search_popup (resources/views/inc/save_search_popup.blade.php)29blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`

inc.nonverified_popup (resources/views/inc/nonverified_popup.blade.php)29blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`

layouts.default (resources/views/layouts/default.blade.php)32blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
pids
ptype
marker

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`pids`
30	`ptype`
31	`marker`

inc.head (resources/views/inc/head.blade.php)33blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
pids
ptype
marker
hreflangs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`pids`
30	`ptype`
31	`marker`
32	`hreflangs`

inc.header (resources/views/inc/header.blade.php)36blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
pids
ptype
marker
hreflangs
wishlist_count
mega_menu
projects_menu

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`pids`
30	`ptype`
31	`marker`
32	`hreflangs`
33	`wishlist_count`
34	`mega_menu`
35	`projects_menu`

inc.footer (resources/views/inc/footer.blade.php)32blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
pids
ptype
marker

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`pids`
30	`ptype`
31	`marker`

inc.help_popup (resources/views/inc/help_popup.blade.php)33blade


obLevel
__env
app
errors
page_title
page_description
page_keywords
search
search_data
search_saved
query_options
compound
properties
filters
elinks
markers
location
total
pages
page
breadcrumbs
price_options
price_sqm_options
surface_options
surface_land_options
__currentLoopData
loop
oname
oval
pids
ptype
marker
ref

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`page_title`
5	`page_description`
6	`page_keywords`
7	`search`
8	`search_data`
9	`search_saved`
10	`query_options`
11	`compound`
12	`properties`
13	`filters`
14	`elinks`
15	`markers`
16	`location`
17	`total`
18	`pages`
19	`page`
20	`breadcrumbs`
21	`price_options`
22	`price_sqm_options`
23	`surface_options`
24	`surface_land_options`
25	`__currentLoopData`
26	`loop`
27	`oname`
28	`oval`
29	`pids`
30	`ptype`
31	`marker`
32	`ref`

uri: GET apartamente-case-de-inchiriat/{location?}/{rooms?}/{id?}
middleware: web
controller: App\Http\Controllers\WebController@search
namespace: App\Http\Controllers
prefix
where
as: search.allrent-ro
file: app/Http/Controllers/WebController.php:138-359

18 statements were executed54.75ms

select * from `searches` where `url_ro` = '/apartamente-case-de-inchiriat/5-camere' or `url_en` = '/apartamente-case-de-inchiriat/5-camere' limit 1

13.05ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. /apartamente-case-de-inchiriat/5-camere 1. /apartamente-case-de-inchiriat/5-camere
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:167 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 24. /app/Http/Middleware/SetOfficeCookie.php:41 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 27. /app/Http/Middleware/SetUserLocale.php:48 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 30. middleware::bindings:41 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:684

select `id`, `status_id`, `property_type_id`, `apartment_type_id`, `building_id`, `media_id`, `floor`, `no_rooms`, `no_bedrooms`, `constructed_surface`, `useable_surface`, `year_renovated`, `is_good_for_office`, `last_contact_at`, `promotion_type` from `properties` where `id` in (70497, 119781) and `properties`.`deleted_at` is null order by FIELD(id, 70497,119781)

2.6ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 70497 1. 119781
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 15. /app/Http/Controllers/WebController.php:3242 16. /app/Http/Controllers/WebController.php:199 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 24. /app/Http/Middleware/SetOfficeCookie.php:41 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 27. /app/Http/Middleware/SetUserLocale.php:48 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 30. middleware::bindings:41 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:684

Metadata

Bindings

0. 70497
1. 119781

Backtrace

12. /vendor/watson/rememberable/src/Query/Builder.php:56
15. /app/Http/Controllers/WebController.php:3242
16. /app/Http/Controllers/WebController.php:199
19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
24. /app/Http/Middleware/SetOfficeCookie.php:41
25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
27. /app/Http/Middleware/SetUserLocale.php:48
28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
30. middleware::bindings:41
31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
33. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
36. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
39. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
45. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:684

select * from `transactions` where ((`is_rent` = 0 and `is_active` > 0 and (`price_total` > 15000 or `price_total` = 0)) or (`is_rent` = 1 and (`price_total` >= 150 or `price_total` = 0))) and `visible_on_site` = 1 and `transactions`.`property_id` in (70497, 119781) order by `is_active` desc, `is_rent` desc, `updated_at` desc

2.43ms/app/Http/Controllers/WebController.php:3242jaap_dev

Metadata
Bindings	0. 0 1. 0 2. 15000 3. 0 4. 1 5. 150 6. 0 7. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/WebController.php:3242 20. /app/Http/Controllers/WebController.php:199 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 28. /app/Http/Middleware/SetOfficeCookie.php:41 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. /app/Http/Middleware/SetUserLocale.php:48 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. middleware::bindings:41 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66

select * from `media` where `path` is not null and `type_id` = 0 and `object_type` = 'property' and `is_visible` = 1 and `media`.`object_id` in (70497, 119781) order by `position_no` asc

4.15ms/app/Http/Controllers/WebController.php:3242jaap_dev

Metadata
Bindings	0. 0 1. property 2. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/WebController.php:3242 20. /app/Http/Controllers/WebController.php:199 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 28. /app/Http/Middleware/SetOfficeCookie.php:41 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. /app/Http/Middleware/SetUserLocale.php:48 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. middleware::bindings:41 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66

select * from `buildings` where `buildings`.`id` in (173641, 251571) and `buildings`.`deleted_at` is null2ms/app/Http/Controllers/WebController.php:3242jaap_dev

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/WebController.php:3242 20. /app/Http/Controllers/WebController.php:199 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 28. /app/Http/Middleware/SetOfficeCookie.php:41 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. /app/Http/Middleware/SetUserLocale.php:48 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. middleware::bindings:41 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66

Hints

Use SELECT * only if you need all columns from table

Backtrace

19. /app/Http/Controllers/WebController.php:3242
20. /app/Http/Controllers/WebController.php:199
23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
28. /app/Http/Middleware/SetOfficeCookie.php:41
29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
31. /app/Http/Middleware/SetUserLocale.php:48
32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
34. middleware::bindings:41
35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
37. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
40. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66

select * from `districts` where `districts`.`id` in (137, 457)1.56ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 13. /vendor/watson/rememberable/src/Query/Builder.php:249 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:340 15. /vendor/watson/rememberable/src/Query/Builder.php:84 16. /vendor/watson/rememberable/src/Query/Builder.php:53 29. /app/Http/Controllers/WebController.php:3242 30. /app/Http/Controllers/WebController.php:199 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 35. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 38. /app/Http/Middleware/SetOfficeCookie.php:41 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /app/Http/Middleware/SetUserLocale.php:48 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. middleware::bindings:41 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Hints

Use SELECT * only if you need all columns from table

Backtrace

12. /vendor/watson/rememberable/src/Query/Builder.php:56
13. /vendor/watson/rememberable/src/Query/Builder.php:249
14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:340
15. /vendor/watson/rememberable/src/Query/Builder.php:84
16. /vendor/watson/rememberable/src/Query/Builder.php:53
29. /app/Http/Controllers/WebController.php:3242
30. /app/Http/Controllers/WebController.php:199
33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
35. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
38. /app/Http/Middleware/SetOfficeCookie.php:41
39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
41. /app/Http/Middleware/SetUserLocale.php:48
42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
44. middleware::bindings:41
45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `compounds` where `compounds`.`id` in (1046) and `compounds`.`deleted_at` is null1.6ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 25. /app/Http/Controllers/WebController.php:3242 26. /app/Http/Controllers/WebController.php:199 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 32. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 34. /app/Http/Middleware/SetOfficeCookie.php:41 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /app/Http/Middleware/SetUserLocale.php:48 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. middleware::bindings:41 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63

Hints

Use SELECT * only if you need all columns from table

Backtrace

12. /vendor/watson/rememberable/src/Query/Builder.php:56
25. /app/Http/Controllers/WebController.php:3242
26. /app/Http/Controllers/WebController.php:199
29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
32. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
34. /app/Http/Middleware/SetOfficeCookie.php:41
35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
37. /app/Http/Middleware/SetUserLocale.php:48
38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
40. middleware::bindings:41
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63

select * from `cities` where `cities`.`id` in (2454)1.63ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 25. /app/Http/Controllers/WebController.php:3242 26. /app/Http/Controllers/WebController.php:199 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 32. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 34. /app/Http/Middleware/SetOfficeCookie.php:41 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /app/Http/Middleware/SetUserLocale.php:48 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. middleware::bindings:41 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63

Hints

Use SELECT * only if you need all columns from table

Backtrace

12. /vendor/watson/rememberable/src/Query/Builder.php:56
25. /app/Http/Controllers/WebController.php:3242
26. /app/Http/Controllers/WebController.php:199
29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
32. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
34. /app/Http/Middleware/SetOfficeCookie.php:41
35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
37. /app/Http/Middleware/SetUserLocale.php:48
38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
40. middleware::bindings:41
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[1]}' limit 1

2.26ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":[1]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[2]}' limit 1

1.87ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":[2]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[3]}' limit 1

1.7ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":[3]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[4]}' limit 1

2.87ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":[4]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[5]}' limit 1

1.94ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":[5]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[6]}' limit 1

2.5ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":[6]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `searches` where `is_rent` = 1 and `criteria_json` = '{\"is_rent\":1,\"property_types\":[1,2,3],\"rooms\":[\"7+\"]}' limit 1

1.73ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 1 1. {"is_rent":1,"property_types":[1,2,3],"rooms":["7+"]}
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 16. /app/Http/Controllers/WebController.php:2401 17. /app/Http/Controllers/WebController.php:3469 18. /app/Http/Controllers/WebController.php:199 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 26. /app/Http/Middleware/SetOfficeCookie.php:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /app/Http/Middleware/SetUserLocale.php:48 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. middleware::bindings:41 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

update `searches` set `total_searches` = 1070 where `id` = 670876.12ms/app/Http/Controllers/WebController.php:237jaap_dev

Metadata
Bindings	0. 1070 1. 67087
Backtrace	13. /app/Http/Controllers/WebController.php:237 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 20. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 21. /app/Http/Middleware/SetOfficeCookie.php:41 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 24. /app/Http/Middleware/SetUserLocale.php:48 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 27. middleware::bindings:41 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 30. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:684 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:659 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:625 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:614

Metadata

Bindings

0. 1070
1. 67087

Backtrace

13. /app/Http/Controllers/WebController.php:237
16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
20. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
21. /app/Http/Middleware/SetOfficeCookie.php:41
22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
24. /app/Http/Middleware/SetUserLocale.php:48
25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
27. middleware::bindings:41
28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
30. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
33. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
36. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
39. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:684
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:659
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:625
49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:614

select `slug` from `pages` where `browseable_id` = 67087 and `browseable_type` = 'App\Search' and `locale` = 'en' order by `updated_at` desc limit 1

2.58ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 67087 1. App\Search 2. en
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 13. /vendor/watson/rememberable/src/Query/Builder.php:249 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:340 15. /vendor/watson/rememberable/src/Query/Builder.php:84 16. /vendor/watson/rememberable/src/Query/Builder.php:53 21. /app/Search.php:219 26. /app/Http/ViewComposers/HrefLangComposer.php:142 31. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 32. /vendor/laravel/framework/src/Illuminate/View/View.php:123 33. /vendor/laravel/framework/src/Illuminate/View/View.php:90 34. view::layouts.default:5 36. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 37. /vendor/laravel/framework/src/Illuminate/View/View.php:142 38. /vendor/laravel/framework/src/Illuminate/View/View.php:125 39. /vendor/laravel/framework/src/Illuminate/View/View.php:90 40. view::search:642 42. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 43. /vendor/laravel/framework/src/Illuminate/View/View.php:142 44. /vendor/laravel/framework/src/Illuminate/View/View.php:125 45. /vendor/laravel/framework/src/Illuminate/View/View.php:90 46. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 47. /vendor/symfony/http-foundation/Response.php:205 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:750 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:722

Metadata

Bindings

0. 67087
1. App\Search
2. en

Backtrace

12. /vendor/watson/rememberable/src/Query/Builder.php:56
13. /vendor/watson/rememberable/src/Query/Builder.php:249
14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:340
15. /vendor/watson/rememberable/src/Query/Builder.php:84
16. /vendor/watson/rememberable/src/Query/Builder.php:53
21. /app/Search.php:219
26. /app/Http/ViewComposers/HrefLangComposer.php:142
31. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
32. /vendor/laravel/framework/src/Illuminate/View/View.php:123
33. /vendor/laravel/framework/src/Illuminate/View/View.php:90
34. view::layouts.default:5
36. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
37. /vendor/laravel/framework/src/Illuminate/View/View.php:142
38. /vendor/laravel/framework/src/Illuminate/View/View.php:125
39. /vendor/laravel/framework/src/Illuminate/View/View.php:90
40. view::search:642
42. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
43. /vendor/laravel/framework/src/Illuminate/View/View.php:142
44. /vendor/laravel/framework/src/Illuminate/View/View.php:125
45. /vendor/laravel/framework/src/Illuminate/View/View.php:90
46. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
47. /vendor/symfony/http-foundation/Response.php:205
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:750
49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:722

select `slug` from `pages` where `browseable_id` = 67087 and `browseable_type` = 'App\Search' and `locale` = 'ro' order by `updated_at` desc limit 1

2.16ms/vendor/watson/rememberable/src/Query/Builder.php:56jaap_dev

Metadata
Bindings	0. 67087 1. App\Search 2. ro
Backtrace	12. /vendor/watson/rememberable/src/Query/Builder.php:56 13. /vendor/watson/rememberable/src/Query/Builder.php:249 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:340 15. /vendor/watson/rememberable/src/Query/Builder.php:84 16. /vendor/watson/rememberable/src/Query/Builder.php:53 21. /app/Search.php:205 26. /app/Http/ViewComposers/HrefLangComposer.php:142 31. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 32. /vendor/laravel/framework/src/Illuminate/View/View.php:123 33. /vendor/laravel/framework/src/Illuminate/View/View.php:90 34. view::layouts.default:5 36. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 37. /vendor/laravel/framework/src/Illuminate/View/View.php:142 38. /vendor/laravel/framework/src/Illuminate/View/View.php:125 39. /vendor/laravel/framework/src/Illuminate/View/View.php:90 40. view::search:642 42. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 43. /vendor/laravel/framework/src/Illuminate/View/View.php:142 44. /vendor/laravel/framework/src/Illuminate/View/View.php:125 45. /vendor/laravel/framework/src/Illuminate/View/View.php:90 46. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 47. /vendor/symfony/http-foundation/Response.php:205 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:750 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:722

Metadata

Bindings

0. 67087
1. App\Search
2. ro

Backtrace

12. /vendor/watson/rememberable/src/Query/Builder.php:56
13. /vendor/watson/rememberable/src/Query/Builder.php:249
14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:340
15. /vendor/watson/rememberable/src/Query/Builder.php:84
16. /vendor/watson/rememberable/src/Query/Builder.php:53
21. /app/Search.php:205
26. /app/Http/ViewComposers/HrefLangComposer.php:142
31. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
32. /vendor/laravel/framework/src/Illuminate/View/View.php:123
33. /vendor/laravel/framework/src/Illuminate/View/View.php:90
34. view::layouts.default:5
36. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
37. /vendor/laravel/framework/src/Illuminate/View/View.php:142
38. /vendor/laravel/framework/src/Illuminate/View/View.php:125
39. /vendor/laravel/framework/src/Illuminate/View/View.php:90
40. view::search:642
42. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
43. /vendor/laravel/framework/src/Illuminate/View/View.php:142
44. /vendor/laravel/framework/src/Illuminate/View/View.php:125
45. /vendor/laravel/framework/src/Illuminate/View/View.php:90
46. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
47. /vendor/symfony/http-foundation/Response.php:205
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:750
49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:722

web: null
api: null

_token: wIvkwuJspUMtjkajxF3MEmOuKHO2GsdwAIxAn3dv
_previous: array:1 [ "url" => "http://813547.svru.asia/apartamente-case-de-inchiriat/5-camere" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/apartamente-case-de-inchiriat/5-camere

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▶
  "cf-ray" => array:1 [▶
    0 => "926d7e3b3ac8ead8-ORD"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.141.167.128"
  ]
  "host" => array:1 [▶
    0 => "813547.svru.asia"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip"
  ]
  "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"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "http"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"http"}"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.141.167.128"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
]

request_server

  0 of 0   
array:46 [▶
  "REDIRECT_UNIQUE_ID" => "Z@ULTKwfEagAAB6BhnUAAAAK"
  "REDIRECT_SCRIPT_URL" => "/apartamente-case-de-inchiriat/5-camere"
  "REDIRECT_SCRIPT_URI" => "http://813547.svru.asia/apartamente-case-de-inchiriat/5-camere"
  "REDIRECT_STATUS" => "200"
  "UNIQUE_ID" => "Z@ULTKwfEagAAB6BhnUAAAAK"
  "SCRIPT_URL" => "/apartamente-case-de-inchiriat/5-camere"
  "SCRIPT_URI" => "http://813547.svru.asia/apartamente-case-de-inchiriat/5-camere"
  "HTTP_CF_RAY" => "926d7e3b3ac8ead8-ORD"
  "HTTP_X_FORWARDED_FOR" => "3.141.167.128"
  "HTTP_HOST" => "813547.svru.asia"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_ACCEPT_ENCODING" => "gzip"
  "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_X_FORWARDED_PROTO" => "http"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_CF_VISITOR" => "{"scheme":"http"}"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CF_CONNECTING_IP" => "3.141.167.128"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_CONNECTION" => "Keep-Alive"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "SERVER_SIGNATURE" => ""
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_NAME" => "813547.svru.asia"
  "SERVER_ADDR" => "172.31.17.168"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "172.70.127.89"
  "DOCUMENT_ROOT" => "/var/www/html/blissimobiliare/public"
  "REQUEST_SCHEME" => "http"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/blissimobiliare/public"
  "SERVER_ADMIN" => "razvan.iacob@blissimobiliare.ro"
  "SCRIPT_FILENAME" => "/var/www/html/blissimobiliare/public/index.php"
  "REMOTE_PORT" => "50910"
  "REDIRECT_URL" => "/apartamente-case-de-inchiriat/5-camere"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/apartamente-case-de-inchiriat/5-camere"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743063884.215
  "REQUEST_TIME" => 1743063884
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 27 Mar 2025 08:24:44 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImoxSjVjRnVqK0tRdGpkV2x1Ymw2a1E9PSIsInZhbHVlIjoiTkQ3bUVYS0VXekc5aGhYRDJLVjdXMnBUSUl5VWQ4TXpLYVBcL2VabUFKWWxnVGxIenNDNTVjMWdESFZYODhwRmYiLCJtYWMiOiI4M2I3YmNmMzYzODgwYjhhNWFiNDM3ZDU5Nzc1NjljNzFjZDg3MzExYWEwZWUwYTMzYzA0ZGVjMWU5ZTg1ZDdhIn0%3D; expires=Thu, 27-Mar-2025 10:24:44 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImoxSjVjRnVqK0tRdGpkV2x1Ymw2a1E9PSIsInZhbHVlIjoiTkQ3bUVYS0VXekc5aGhYRDJLVjdXMnBUSUl5VWQ4TXpLYVBcL2VabUFKWWxnVGxIenNDNTVjMWdESFZYODhwRmYiLCJtY ▶"
    1 => "laravel_session=eyJpdiI6Im0zQURDV3hoNkQ5ZWN2NzNta1NNZmc9PSIsInZhbHVlIjoiTTRudlpFdGZ6XC9GaldGaXpSc1wvT0hyOVJieG54R3hLQjFxeVc2dERndU8yaTJZT2NXYTRRdUFQSG9XM3hcL3pmMyIsIm1hYyI6ImFhYzU3YzM5YmJiNTUzY2M3ODk3NDg0M2U1M2QwOWY1NjI2YzhkNGIyZDg0MDQ0YWJmNzg2MzNlMjlmMzg4OGUifQ%3D%3D; expires=Thu, 27-Mar-2025 10:24:44 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6Im0zQURDV3hoNkQ5ZWN2NzNta1NNZmc9PSIsInZhbHVlIjoiTTRudlpFdGZ6XC9GaldGaXpSc1wvT0hyOVJieG54R3hLQjFxeVc2dERndU8yaTJZT2NXYTRRdUFQSG9XM3hcL3pm ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImoxSjVjRnVqK0tRdGpkV2x1Ymw2a1E9PSIsInZhbHVlIjoiTkQ3bUVYS0VXekc5aGhYRDJLVjdXMnBUSUl5VWQ4TXpLYVBcL2VabUFKWWxnVGxIenNDNTVjMWdESFZYODhwRmYiLCJtYWMiOiI4M2I3YmNmMzYzODgwYjhhNWFiNDM3ZDU5Nzc1NjljNzFjZDg3MzExYWEwZWUwYTMzYzA0ZGVjMWU5ZTg1ZDdhIn0%3D; expires=Thu, 27-Mar-2025 10:24:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImoxSjVjRnVqK0tRdGpkV2x1Ymw2a1E9PSIsInZhbHVlIjoiTkQ3bUVYS0VXekc5aGhYRDJLVjdXMnBUSUl5VWQ4TXpLYVBcL2VabUFKWWxnVGxIenNDNTVjMWdESFZYODhwRmYiLCJtY ▶"
    1 => "laravel_session=eyJpdiI6Im0zQURDV3hoNkQ5ZWN2NzNta1NNZmc9PSIsInZhbHVlIjoiTTRudlpFdGZ6XC9GaldGaXpSc1wvT0hyOVJieG54R3hLQjFxeVc2dERndU8yaTJZT2NXYTRRdUFQSG9XM3hcL3pmMyIsIm1hYyI6ImFhYzU3YzM5YmJiNTUzY2M3ODk3NDg0M2U1M2QwOWY1NjI2YzhkNGIyZDg0MDQ0YWJmNzg2MzNlMjlmMzg4OGUifQ%3D%3D; expires=Thu, 27-Mar-2025 10:24:44 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Im0zQURDV3hoNkQ5ZWN2NzNta1NNZmc9PSIsInZhbHVlIjoiTTRudlpFdGZ6XC9GaldGaXpSc1wvT0hyOVJieG54R3hLQjFxeVc2dERndU8yaTJZT2NXYTRRdUFQSG9XM3hcL3pm ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▶
  "_token" => "wIvkwuJspUMtjkajxF3MEmOuKHO2GsdwAIxAn3dv"
  "_previous" => array:1 [▶
    "url" => "http://813547.svru.asia/apartamente-case-de-inchiriat/5-camere"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

De inchiriat casa 5 camere
Popasului | Padurea Cretuleasca | Matei Millo, Bucuresti / Ilfov

De inchiriat vila 5 camere
ZenVille, Pipera Nord, Bucuresti / Ilfov

1 x Application (75.67%)	93.82ms
1 x Booting (24.27%)	30.09ms

Apartamente, case/vile de inchiriat 5 camere

De inchiriat casa 5 camere Popasului | Padurea Cretuleasca | Matei Millo, Bucuresti / Ilfov

De inchiriat vila 5 camere ZenVille, Pipera Nord, Bucuresti / Ilfov

De inchiriat casa 5 camere
Popasului | Padurea Cretuleasca | Matei Millo, Bucuresti / Ilfov

De inchiriat vila 5 camere
ZenVille, Pipera Nord, Bucuresti / Ilfov