Ruko Wadung Asri Sidoarjo

Messages Timeline Exceptions Views18 Route Queries57 Models382 Mails Gate Session Request

Request history8.3.122.91s7MBGET property/detail/{slug}

Booting (23.42ms)time
Application (2.89s)time
1 x Application (99.2%)
2.89s
1 x Booting (0.8%)
23.42ms

18 templates were rendered

8x main.properties.cardcard.blade.php#?blade
1x main.properties.detaildetail.blade.php#?blade
1x breadcrumbs::json-ldjson-ld.php#?php
1x breadcrumbs::bootstrap5bootstrap5.blade.php#?blade
1x main.layouts.mobile-appsmobile-apps.blade.php#?blade
1x main.layouts.mainmain.blade.php#?blade
1x main.layouts.metameta.blade.php#?blade
1x main.layouts.headerheader.blade.php#?blade
1x main.layouts.navbarnavbar.blade.php#?blade
1x sweetalert::alertalert.blade.php#?blade
1x main.layouts.footerfooter.blade.php#?blade

uri: GET property/detail/{slug}
middleware: web, share.session
controller: App\Http\Controllers\Main\Property\PropertyController@show
namespace
prefix
where
as: front-property-detail
file: app/Http/Controllers/Main/Property/PropertyController.php:444-600

57 statements were executed (29 duplicates)Show only duplicates2.3s

select * from `sessions` where `id` = 'XQlDpHbS8Op9WKAduUiuBVpacWwa8KlZpAJNAyjq' limit 12.6msnew_galaxypropertyDatabaseSessionHandler.php#97
Bindings
Backtrace
select * from `properties` where `slug` = 'ruko-wadung-asri-sidoarjo' and `properties`.`deleted_at` is null limit 12.14snew_galaxypropertyPropertyController.php#453
Bindings
Backtrace
select * from `property_categories` where `property_categories`.`id` in (6)670μsnew_galaxypropertyPropertyController.php#453
Backtrace
select * from `provinces` where `provinces`.`id` in (35)1.44msnew_galaxypropertyPropertyController.php#453
Backtrace
select * from `cities` where `cities`.`id` in (3515)830μsnew_galaxypropertyPropertyController.php#453
Backtrace
select * from `agent_property` where `agent_property`.`property_id` in (108193)2.41msnew_galaxypropertyPropertyController.php#453
Backtrace
select * from `agent_property` where `agent_id` is null and `property_id` = 108193 limit 11.76msnew_galaxypropertyPropertyController.php#457
Bindings
Backtrace
select * from `activity_record_types` where `key` = 'show detail listing' and `activity_record_types`.`deleted_at` is null limit 1840μsnew_galaxypropertyHelpers.php#755
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 108193 limit 11.96msnew_galaxypropertyPropertyController.php#498
Bindings
Backtrace
select * from `properties` where `title` like '%ruko wadung asri sidoarjo%' and `status` = 'active' and `city_id` = 3515 and `property_category_id` = 6 and `id` != 108193 and `price` between 119000000 and 221000000 and `properties`.`deleted_at` is null order by `created_at` desc37.78msnew_galaxypropertyPropertyController.php#531
Bindings
Backtrace
select * from `properties` where `id` in (select `property_id` from `agent_property` where `agent_id` = 1489) and `id` <> 108193 and `status` = 'active' and `properties`.`deleted_at` is null order by `created_at` desc33.25msnew_galaxypropertyPropertyController.php#549
Bindings
Backtrace
select * from `provinces` where `provinces`.`id` in (35)700μsnew_galaxypropertyPropertyController.php#549
Backtrace
select * from `cities` where `cities`.`id` in (3508, 3515, 3520, 3578)1.17msnew_galaxypropertyPropertyController.php#549
Backtrace
select * from `districts` where `districts`.`id` in (3508070, 3515100, 3515110, 3515130, 3515140, 3515150, 3520060, 3578030, 3578040, 3578050, 3578070, 3578080, 3578090, 3578100, 3578110, 3578120, 3578141, 3578180, 3578200, 3578210, 3578220, 3578250)760μsnew_galaxypropertyPropertyController.php#549
Backtrace
select * from `agent_property` where `agent_property`.`property_id` in (63443, 63473, 63475, 63655, 63972, 63975, 64618, 64619, 64621, 64622, 65178, 65180, 65715, 65716, 65931, 65932, 66211, 66503, 66504, 66619, 67194, 67195, 67570, 68228, 68477, 69069, 69302, 71875, 76915, 76916, 76919, 80042, 80043, 80333, 80334, 80614, 80617, 80788, 81154, 81155, 82391, 82731, 83141, 83142, 83146, 83338, 83340, 83803, 83932, 84315, 84676, 85265, 85560, 85562, 100744, 100764, 100847, 101218, 102404, 102802, 102964, 103886, 104967, 105345, 107861, 108624, 109354)21.84msnew_galaxypropertyPropertyController.php#549
Backtrace
select * from `certificates` where `certificates`.`id` in (1, 2, 7, 28, 30)730μsnew_galaxypropertyPropertyController.php#549
Backtrace
select * from `properties` where exists (select * from `agent_property` where `properties`.`id` = `agent_property`.`property_id` and `agent_id` = 1489) and `id` not in (109354, 108624, 107861, 105345) and `id` <> 108193 and `status` = 'active' and `properties`.`deleted_at` is null order by `created_at` desc5.03msnew_galaxypropertyPropertyController.php#569
Bindings
Backtrace
select * from `provinces` where `provinces`.`id` in (35)490μsnew_galaxypropertyPropertyController.php#569
Backtrace
select * from `cities` where `cities`.`id` in (3508, 3515, 3520, 3578)570μsnew_galaxypropertyPropertyController.php#569
Backtrace
select * from `districts` where `districts`.`id` in (3508070, 3515110, 3515130, 3515140, 3515150, 3520060, 3578030, 3578040, 3578050, 3578070, 3578080, 3578090, 3578100, 3578110, 3578120, 3578141, 3578180, 3578200, 3578210, 3578220, 3578250)720μsnew_galaxypropertyPropertyController.php#569
Backtrace
select * from `agent_property` where `agent_property`.`property_id` in (63443, 63473, 63475, 63655, 63972, 63975, 64618, 64619, 64621, 64622, 65178, 65180, 65715, 65716, 65931, 65932, 66211, 66503, 66504, 66619, 67194, 67195, 67570, 68228, 68477, 69069, 69302, 71875, 76915, 76916, 76919, 80042, 80043, 80333, 80334, 80614, 80617, 80788, 81154, 81155, 82391, 82731, 83141, 83142, 83146, 83338, 83340, 83803, 83932, 84315, 84676, 85265, 85560, 85562, 100744, 100764, 100847, 101218, 102404, 102802, 102964, 103886, 104967)1.1msnew_galaxypropertyPropertyController.php#569
Backtrace
select * from `certificates` where `certificates`.`id` in (1, 2, 7, 28, 30)610μsnew_galaxypropertyPropertyController.php#569
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 109354 limit 1940μsnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 11.38msnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 12.07msnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 108624 limit 1840μsnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1610μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 11.08msnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 107861 limit 1560μsnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1510μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 1620μsnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 105345 limit 1740μsnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1590μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 1550μsnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 104967 limit 11.22msnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1810μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 1800μsnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 103886 limit 11.09msnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1600μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 1860μsnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 102964 limit 1580μsnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1890μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 1930μsnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `property_likes` where `user_id` is null and `property_id` = 102802 limit 11msnew_galaxypropertyPropertyController.php#125
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1740μsnew_galaxypropertyPropertyController.php#152
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 1980μsnew_galaxypropertyPropertyController.php#187
Bindings
Backtrace
select * from `districts` where `districts`.`id` = 3515140 limit 1550μsnew_galaxypropertydetail.blade.php#9
Bindings
Backtrace
select count(*) as aggregate from `activity_records` where `sourceable_id` = 108193 and `sourceable_type` = 'App\\Models\\Property' and exists (select * from `activity_record_types` where `activity_records`.`activity_record_type_id` = `activity_record_types`.`id` and `key` = 'show detail listing' and `activity_record_types`.`deleted_at` is null) and `activity_records`.`deleted_at` is null15.7msnew_galaxypropertyHelpers.php#56
Bindings
Backtrace
select count(*) as aggregate from `activity_records` where `sourceable_id` = 108193 and `sourceable_type` = 'App\\Models\\Property' and exists (select * from `activity_record_types` where `activity_records`.`activity_record_type_id` = `activity_record_types`.`id` and `key` = 'show detail listing' and `activity_record_types`.`deleted_at` is null) and `activity_records`.`deleted_at` is null1.2msnew_galaxypropertyHelpers.php#56
Bindings
Backtrace
select * from `result_wishlists` where `property_id` = 1081931.21msnew_galaxypropertyHelpers.php#93
Bindings
Backtrace
select * from `property_likes` where `property_id` = 1081931.02msnew_galaxypropertyHelpers.php#83
Bindings
Backtrace
select * from `certificates` where `certificates`.`id` = 1 limit 1610μsnew_galaxypropertydetail.blade.php#360
Bindings
Backtrace
select * from `agents` where `agents`.`id` = 1489 and `agents`.`deleted_at` is null limit 1510μsnew_galaxypropertydetail.blade.php#546
Bindings
Backtrace
select * from `offices` where `offices`.`id` = 23 limit 11.13msnew_galaxypropertydetail.blade.php#583
Bindings
Backtrace
select * from `offices` where `position` is not null and `status` = 'active' order by `position` asc1.21msnew_galaxypropertyHelpers.php#234
Bindings
Backtrace
select * from `sessions` where `id` = 'XQlDpHbS8Op9WKAduUiuBVpacWwa8KlZpAJNAyjq' limit 11.43msnew_galaxypropertyDatabaseSessionHandler.php#97
Bindings
Backtrace
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiYXpkaEhEampmaHpJQjdVOEJOSDZyZTMxaVRnMlEwOUROVERLWEI0ayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHBzOi8vZ2FsYXh5cHJvcGVydHkuY28uaWQvcHJvcGVydHkvZGV0YWlsL3J1a28td2FkdW5nLWFzcmktc2lkb2Fyam8iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1745314026, null, '3.143.144.209', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'XQlDpHbS8Op9WKAduUiuBVpacWwa8KlZpAJNAyjq')2.33msnew_galaxypropertyDatabaseSessionHandler.php#158
Bindings
Backtrace

App\Models\Property: 131Property.php#?
App\Models\AgentProperty: 131AgentProperty.php#?
App\Models\District: 44District.php#?
App\Models\Office: 42Office.php#?
App\Models\Certificate: 11Certificate.php#?
App\Models\City: 9City.php#?
App\Models\Agent: 9Agent.php#?
App\Models\Province: 3Province.php#?
App\Models\PropertyCategory: 1PropertyCategory.php#?
App\Models\ActivityRecordType: 1ActivityRecordType.php#?

_token: azdhHDjjfhzIB7U8BNH6re31iTg2Q09DNTDKXB4k
_previous: array:1 [ "url" => "https://galaxyproperty.co.id/property/detail/ruko-wadung-asri-sidoarjo" ]
_flash: array:2 [ "old" => [] "new" => [] ]

telescope

View in Telescope

path_info

/property/detail/ruko-wadung-asri-sidoarjo

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "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"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "galaxyproperty.co.id"
  ]
]

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 => "Tue, 22 Apr 2025 09:27:06 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVWSU0wSTJHWlhUZ0pYbjg5SHFwSHc9PSIsInZhbHVlIjoiSkdUQUY2WEtFZHdrTmx6NGIxM1o2eUNodFpXU2xlTU9mNzRTSjREeFZtQ0JCMElDZHdZcXlOT2R2cHVrRFdheDBKK0hVeUhEVGJyZnFkVVEyTXVqWDJuU3Exc0w3TkVmaGVpdjVpQXRrRlZDdzNRaklxQzF6a0NQSU1ib0N5a1EiLCJtYWMiOiJhN2FhNmUwZDY4ZjM3NzAwZTlmOTljOGZjZDlhYThkMjMzNzJjY2VkODllMjQ0YjBkZmJlMmMzNzc1ZjI5MWYzIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 11:27:06 GMT; Max-Age=7200; path=/; domain=.galaxyproperty.co.id; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImVWSU0wSTJHWlhUZ0pYbjg5SHFwSHc9PSIsInZhbHVlIjoiSkdUQUY2WEtFZHdrTmx6NGIxM1o2eUNodFpXU2xlTU9mNzRTSjREeFZtQ0JCMElDZHdZcXlOT2R2cHVrRFdheDBKK0hVe ▶"
    1 => "galaxy_property_session=eyJpdiI6Im12NUh2TjVBVEpuSDEyUVpoOWFtVkE9PSIsInZhbHVlIjoic3RDcGJJWmVRTlZqUGlkUERDNXNSbU50MEdFOGFCVFZCTzdGaklLcW5GUEdLU1hSWWhkVHAvMGlqamF5ZFhicmN0ZVpJTEp0SjVDem9KZlpDQ1BRaVNVMHNpTFVabHoyTURWTXpNU0hrcVJFcU1PNlc4WWhSTS9LQVp1QXhySkUiLCJtYWMiOiI4ZmQ1YzVmN2QxNzJlNjcyYzg3NTlmOGJmZmYwNjk3NTFiMDA1Y2Y3ODdlZDM0YzEzMzk3ZTc1ZGI3MDUwOTllIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 11:27:06 GMT; Max-Age=7200; path=/; domain=.galaxyproperty.co.id; secure; httponly; samesite=lax ◀galaxy_property_session=eyJpdiI6Im12NUh2TjVBVEpuSDEyUVpoOWFtVkE9PSIsInZhbHVlIjoic3RDcGJJWmVRTlZqUGlkUERDNXNSbU50MEdFOGFCVFZCTzdGaklLcW5GUEdLU1hSWWhkVHAvMGlqamF5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVWSU0wSTJHWlhUZ0pYbjg5SHFwSHc9PSIsInZhbHVlIjoiSkdUQUY2WEtFZHdrTmx6NGIxM1o2eUNodFpXU2xlTU9mNzRTSjREeFZtQ0JCMElDZHdZcXlOT2R2cHVrRFdheDBKK0hVeUhEVGJyZnFkVVEyTXVqWDJuU3Exc0w3TkVmaGVpdjVpQXRrRlZDdzNRaklxQzF6a0NQSU1ib0N5a1EiLCJtYWMiOiJhN2FhNmUwZDY4ZjM3NzAwZTlmOTljOGZjZDlhYThkMjMzNzJjY2VkODllMjQ0YjBkZmJlMmMzNzc1ZjI5MWYzIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 11:27:06 GMT; domain=.galaxyproperty.co.id; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImVWSU0wSTJHWlhUZ0pYbjg5SHFwSHc9PSIsInZhbHVlIjoiSkdUQUY2WEtFZHdrTmx6NGIxM1o2eUNodFpXU2xlTU9mNzRTSjREeFZtQ0JCMElDZHdZcXlOT2R2cHVrRFdheDBKK0hVe ▶"
    1 => "galaxy_property_session=eyJpdiI6Im12NUh2TjVBVEpuSDEyUVpoOWFtVkE9PSIsInZhbHVlIjoic3RDcGJJWmVRTlZqUGlkUERDNXNSbU50MEdFOGFCVFZCTzdGaklLcW5GUEdLU1hSWWhkVHAvMGlqamF5ZFhicmN0ZVpJTEp0SjVDem9KZlpDQ1BRaVNVMHNpTFVabHoyTURWTXpNU0hrcVJFcU1PNlc4WWhSTS9LQVp1QXhySkUiLCJtYWMiOiI4ZmQ1YzVmN2QxNzJlNjcyYzg3NTlmOGJmZmYwNjk3NTFiMDA1Y2Y3ODdlZDM0YzEzMzk3ZTc1ZGI3MDUwOTllIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 11:27:06 GMT; domain=.galaxyproperty.co.id; path=/; secure; httponly ◀galaxy_property_session=eyJpdiI6Im12NUh2TjVBVEpuSDEyUVpoOWFtVkE9PSIsInZhbHVlIjoic3RDcGJJWmVRTlZqUGlkUERDNXNSbU50MEdFOGFCVFZCTzdGaklLcW5GUEdLU1hSWWhkVHAvMGlqamF5 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "azdhHDjjfhzIB7U8BNH6re31iTg2Q09DNTDKXB4k"
  "_previous" => array:1 [▶
    "url" => "https://galaxyproperty.co.id/property/detail/ruko-wadung-asri-sidoarjo"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-22 16:27:06	GET	/property/detail/ruko-wadung-asri-sidoarjo	18 57 382

Ruko Wadung Asri Sidoarjo

Hitung KPR

Recommendation Properties

Agent's Properties

Download Aplikasi Galaxy Property
#Unshakeable

1 x Application (99.2%)	2.89s
1 x Booting (0.8%)	23.42ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Ruko Wadung Asri Sidoarjo

Hitung KPR

Recommendation Properties

Agent's Properties

Kalkulator KPR

Download Aplikasi Galaxy Property#Unshakeable

Download Aplikasi Galaxy Property
#Unshakeable