TEDUH | Sistem Bank Data Perumahan | Jabatan Perumahan Negara, KPKT

Bil	No PT/Lot/Plot	No Unit	Harga Jualan(RM)	Harga SPJB(RM)	Status Jualan	Kuota Bumi
1	HSM 12528	PT 18000	371,800.00	-	Belum Dijual	Tidak
2	HSM 12531	PT 18003	388,750.00	328,000.00	Telah Dijual	Tidak
3	HSM 12533	PT 18005	311,300.00	298,000.00	Telah Dijual	Tidak
4	HSM 12534	PT 18006	387,500.00	-	Belum Dijual	Tidak
5	HSM 12535	PT 18007	386,000.00	-	Belum Dijual	Tidak
6	HSM 12536	PT 18008	386,000.00	325,000.00	Telah Dijual	Tidak
7	HSM 12537	PT 18009	337,700.00	-	Belum Dijual	Tidak
8	HSM 12529	PT 18001	386,250.00	328,000.00	Telah Dijual	Tidak
9	HSM 12530	PT 18002	386,250.00	365,000.00	Telah Dijual	Tidak
10	HSM 12532	PT 18004	388,750.00	365,000.00	Telah Dijual	Tidak

Messages1 Timeline Exceptions Views7 Route Queries12 Models13 Mails Gate Session Request

Request history8.1.3084.02ms3MBGET unit-project-swasta/{id}/{total_bil_unit?}

warninglog[09:56:03] LOG.warning: Return type of App\Visitor\Visitor::count() should either be compatible with...

Booting (23.54ms)time
Application (60.47ms)time
1 x Application (71.97%)
60.47ms
1 x Booting (28.02%)
23.54ms

7 templates were rendered

portal-new.pages.static.unit_projek_swastaunit_projek_swasta.blade.php#?blade
portal-new.portalportal.blade.php#?blade
portal-new.themes.headerheader.blade.php#?blade
portal-new.themes.navbarnavbar.blade.php#?blade
portal-new.themes.breadcrumbbreadcrumb.blade.php#?blade
portal-new.themes.titletitle.blade.php#?blade
portal-new.themes.footerfooter.blade.php#?blade

uri: GET unit-project-swasta/{id}/{total_bil_unit?}
middleware: web
controller: App\Http\Controllers\PortalSwastaController@unitprojectswasta
namespace: App\Http\Controllers
prefix
where
as: portal.project-swasta.unit
file: app/Http/Controllers/PortalSwastaController.php:623-668

10 statements were executed (3 duplicates)Show only duplicates teduh-production dw_hims_new40.76ms

Connection Establishedteduh-productionDatabaseVisitorRepository.php#57

Backtrace

app/Visitor/Repos/DatabaseVisitorRepository.php:57
app/Visitor/Visitor.php:100
app/Visitor/Middleware/LogVisitor.php:25
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
app/Http/Middleware/SetLocale.php:24

insert into `visitor_registry` (`ip`, `country`, `visited_at`) values ('216.73.216.136', null, '2025-06-24 09:56:03')

9.02msteduh-productionDatabaseVisitorRepository.php#57

Bindings	0: 216.73.216.136 1: 2: 2025-06-24 09:56:03
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:57 app/Visitor/Visitor.php:100 app/Visitor/Middleware/LogVisitor.php:25 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SetLocale.php:24

Connection Establisheddw_hims_newPortalSwastaController.php#625

Backtrace

app/Http/Controllers/PortalSwastaController.php:625
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `pemajuan` where `id` = '11565-23' and date_from < now() and date_to > now() limit 1

3.15msdw_hims_newPortalSwastaController.php#625

Bindings	0: 11565-23
Backtrace	app/Http/Controllers/PortalSwastaController.php:625 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `nolot_unit` where `pemajuan_id` = '11565-23' and `pembangunan_id` != '53384' and date_from < now() and date_to > now()

15.66msdw_hims_newPortalSwastaController.php#652

Bindings	0: 11565-23 1: 53384
Backtrace	app/Http/Controllers/PortalSwastaController.php:652 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `pembangunan` where `pembangunan`.`id` in (48482)

940μsdw_hims_newPortalSwastaController.php#652

Backtrace

app/Http/Controllers/PortalSwastaController.php:652
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `kod_jenis_rumah` where `kod_jenis_rumah`.`id` in (5)

760μsdw_hims_newPortalSwastaController.php#652

Bindings	0: 5
Backtrace	app/Http/Controllers/PortalSwastaController.php:652 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `visitor_registry` where `visited_at` between '2025-06-24 00:00:00' and '2025-06-24 23:59:59'

2.82msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-24 00:00:00 1: 2025-06-24 23:59:59
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:98 app/Visitor/Visitor.php:121 view::portal-new.themes.footer:97 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select sum(`visitors`) as aggregate from `visitor_daily` where `id` >= '2025-06-01 00:00:00' and `id` < '2025-06-24 00:00:00'

980μsteduh-productionDatabaseVisitorRepository.php#106

Bindings	0: 2025-06-01 00:00:00 1: 2025-06-24 00:00:00
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:106 app/Visitor/Visitor.php:132 view::portal-new.themes.footer:109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as aggregate from `visitor_registry` where `visited_at` between '2025-06-24 00:00:00' and '2025-06-24 23:59:59'

2.39msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-24 00:00:00 1: 2025-06-24 23:59:59
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:98 app/Visitor/Repos/DatabaseVisitorRepository.php:108 app/Visitor/Visitor.php:132 view::portal-new.themes.footer:109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

select sum(`visitors`) as aggregate from `visitor_daily` where `id` < '2025-06-24 00:00:00'

2.74msteduh-productionDatabaseVisitorRepository.php#90

Bindings	0: 2025-06-24 00:00:00
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:90 app/Visitor/Visitor.php:110 view::portal-new.themes.footer:121 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as aggregate from `visitor_registry` where `visited_at` between '2025-06-24 00:00:00' and '2025-06-24 23:59:59'

2.3msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-24 00:00:00 1: 2025-06-24 23:59:59
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:98 app/Visitor/Repos/DatabaseVisitorRepository.php:91 app/Visitor/Visitor.php:110 view::portal-new.themes.footer:121 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

App\Models\Hims\NoLotUnit: 10NoLotUnit.php#?
App\Models\Hims\Pemajuan: 1Pemajuan.php#?
App\Models\Hims\Pembangunan: 1Pembangunan.php#?
App\Models\Hims\Lookup\JenisRumah: 1JenisRumah.php#?

_token: iBFKVpvQSyIRjXJtR2fQLmoEsTeylNeGOsUYrYg1
visit_expired_at: O:25:"Illuminate\Support\Carbon":3:{s:4:"date";s:26:"2025-06-24 23:59:59.999999";s:13:"timezone_type...
_previous: array:1 [ "url" => "http://103.156.83.178/unit-project-swasta/11565-23/10" ]
_flash: array:2 [ "old" => [] "new" => [] ]

telescope

View in Telescope

path_info

/unit-project-swasta/11565-23/10

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:10 [▼
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.207.161"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-ldtmg (squid/6.10)"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "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"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "103.156.83.178"
  ]
]

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, 24 Jun 2025 01:56:03 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktVWnJrZ0RvcEptK0NFbFBQeUJPYmc9PSIsInZhbHVlIjoicWVmcWVNQlY0b25LSGdVY0gyT1k5ZDE0WUlxRnAwRFpEQ0hBaGQ4ZmpwU2ZWRldMY25zcTNtYlY4VEI3bEdDQnphaDhHVFFHSDIyNDVDMFB5RjRzM3Z0cDlac3E0SytMYjVaeEN6ZkZBN0diUnZ4Umc4dUttek9LdjhLbHNKbWgiLCJtYWMiOiJjMzkwMzE0MTE5ODQ2YzVlN2U3ZTFjOGFhZDI4ODdiZTRmYzQ0MGY0YjVjYjdiMTRkZDIyYWIxZjM5ODNhNmI3IiwidGFnIjoiIn0%3D; expires=Tue, 24 Jun 2025 03:56:03 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IktVWnJrZ0RvcEptK0NFbFBQeUJPYmc9PSIsInZhbHVlIjoicWVmcWVNQlY0b25LSGdVY0gyT1k5ZDE0WUlxRnAwRFpEQ0hBaGQ4ZmpwU2ZWRldMY25zcTNtYlY4VEI3bEdDQnphaDhHV ▶"
    1 => "laravel_session=eyJpdiI6ImphU0tzbFBmLzk2YzFFU2NsS2JWTGc9PSIsInZhbHVlIjoieitCYjMvTERQMjQrTXBKWkwrMnpMOUVLWFVyZzljb1hBYnh3aTlGK2JCVEUxSHd3QkZPbklxN1JqUTNlSlhqZUFDY3pheGlEN0ptdmsvTW1NMWt5SmFZb3VMV1ZFVis4TWswenMvRXpJMk01K3Y1SFlyVTRuU3VKZHloZmVOZ00iLCJtYWMiOiJmOTU1ZmVhYTUzMmRmNzRiMjhmMmY2MWQ4MzY2Y2VkOWJjYTZhYjdjN2VkNmJiNTE1OTU3Yzg5YTY0NTM2OTk3IiwidGFnIjoiIn0%3D; expires=Tue, 24 Jun 2025 03:56:03 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImphU0tzbFBmLzk2YzFFU2NsS2JWTGc9PSIsInZhbHVlIjoieitCYjMvTERQMjQrTXBKWkwrMnpMOUVLWFVyZzljb1hBYnh3aTlGK2JCVEUxSHd3QkZPbklxN1JqUTNlSlhqZUFD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktVWnJrZ0RvcEptK0NFbFBQeUJPYmc9PSIsInZhbHVlIjoicWVmcWVNQlY0b25LSGdVY0gyT1k5ZDE0WUlxRnAwRFpEQ0hBaGQ4ZmpwU2ZWRldMY25zcTNtYlY4VEI3bEdDQnphaDhHVFFHSDIyNDVDMFB5RjRzM3Z0cDlac3E0SytMYjVaeEN6ZkZBN0diUnZ4Umc4dUttek9LdjhLbHNKbWgiLCJtYWMiOiJjMzkwMzE0MTE5ODQ2YzVlN2U3ZTFjOGFhZDI4ODdiZTRmYzQ0MGY0YjVjYjdiMTRkZDIyYWIxZjM5ODNhNmI3IiwidGFnIjoiIn0%3D; expires=Tue, 24-Jun-2025 03:56:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IktVWnJrZ0RvcEptK0NFbFBQeUJPYmc9PSIsInZhbHVlIjoicWVmcWVNQlY0b25LSGdVY0gyT1k5ZDE0WUlxRnAwRFpEQ0hBaGQ4ZmpwU2ZWRldMY25zcTNtYlY4VEI3bEdDQnphaDhHV ▶"
    1 => "laravel_session=eyJpdiI6ImphU0tzbFBmLzk2YzFFU2NsS2JWTGc9PSIsInZhbHVlIjoieitCYjMvTERQMjQrTXBKWkwrMnpMOUVLWFVyZzljb1hBYnh3aTlGK2JCVEUxSHd3QkZPbklxN1JqUTNlSlhqZUFDY3pheGlEN0ptdmsvTW1NMWt5SmFZb3VMV1ZFVis4TWswenMvRXpJMk01K3Y1SFlyVTRuU3VKZHloZmVOZ00iLCJtYWMiOiJmOTU1ZmVhYTUzMmRmNzRiMjhmMmY2MWQ4MzY2Y2VkOWJjYTZhYjdjN2VkNmJiNTE1OTU3Yzg5YTY0NTM2OTk3IiwidGFnIjoiIn0%3D; expires=Tue, 24-Jun-2025 03:56:03 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImphU0tzbFBmLzk2YzFFU2NsS2JWTGc9PSIsInZhbHVlIjoieitCYjMvTERQMjQrTXBKWkwrMnpMOUVLWFVyZzljb1hBYnh3aTlGK2JCVEUxSHd3QkZPbklxN1JqUTNlSlhqZUFD ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "iBFKVpvQSyIRjXJtR2fQLmoEsTeylNeGOsUYrYg1"
  "visit_expired_at" => "O:25:"Illuminate\Support\Carbon":3:{s:4:"date";s:26:"2025-06-24 23:59:59.999999";s:13:"timezone_type";i:3;s:8:"timezone";s:17:"Asia/Kuala_Lumpur";}"
  "_previous" => array:1 [▶
    "url" => "http://103.156.83.178/unit-project-swasta/11565-23/10"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-24 09:56:03	GET	/unit-project-swasta/11565-23/10	1 7 12 13

TEDUH | Transforming & Empowering Data Usage In Housing

Senarai Unit Perumahan Swasta

Keterangan Unit

1 x Application (71.97%)	60.47ms
1 x Booting (28.02%)	23.54ms