TEDUH | Sistem Bank Data Perumahan | Jabatan Perumahan Negara, KPKT | Maklumat Pemaju Swasta : 19 DEVELOPMENT SDN. BHD.

Messages4 Timeline Exceptions Views7 Route Queries21 Models10 Mails Gate Session Request

Request history8.1.3095.26ms3MBGET developer-swasta/{id}

warninglog[20:16:23] LOG.warning: Return type of App\Visitor\Visitor::count() should either be compatible with...
warninglog[20:16:23] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
warninglog[20:16:23] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[20:16:23] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...

Booting (19.63ms)time
Application (75.62ms)time
1 x Application (79.38%)
75.62ms
1 x Booting (20.61%)
19.63ms

7 templates were rendered

portal-new.pages.static.keterangan_pemaju_swastaketerangan_pemaju_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 developer-swasta/{id}
middleware: web
controller: App\Http\Controllers\PortalSwastaController@developerSwastaPemaju
namespace: App\Http\Controllers
prefix
where
as: portal.developer-swasta.pemaju
file: app/Http/Controllers/PortalSwastaController.php:75-88

19 statements were executed (3 duplicates)Show only duplicates teduh-production dw_hims_new41.79ms

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.92', null, '2025-06-07 20:16:23')

7.14msteduh-productionDatabaseVisitorRepository.php#57

Bindings	0: 216.73.216.92 1: 2: 2025-06-07 20:16:23
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_newPemajuQuery.php#11

Backtrace

app/Queries/PemajuQuery.php:11
app/Http/Controllers/PortalSwastaController.php:77
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

select * from `pemaju` where exists (select * from `transaksi_lesenpermit` where `pemaju`.`kod_pemaju` = `transaksi_lesenpermit`.`kod_pemaju` and YEAR(tarikh_luput) >= 2015 and `jenis` = 'L' and `taraf` in ('N', 'R', 'A') and `lesen_aktif` = 1) and pemaju.kod_pemaju NOT LIKE "temp%" and pemaju.date_from < now() and pemaju.date_to > now() and `kod_pemaju` = '30053' limit 1

4.71msdw_hims_newPortalSwastaController.php#85

Bindings	0: L 1: N 2: R 3: A 4: 1 5: 30053
Backtrace	app/Http/Controllers/PortalSwastaController.php:85 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 pemajuan.date_from < now() and pemajuan.date_to > now() and `pemajuan`.`kod_pemaju` in ('30053') order by CONVERT(SUBSTRING_INDEX(id, '-', 1), SIGNED) DESC, CONVERT(SUBSTRING_INDEX(id, '-', -1), SIGNED) ASC

1.51msdw_hims_newPortalSwastaController.php#85

Bindings	0: 30053
Backtrace	app/Http/Controllers/PortalSwastaController.php:85 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 `transaksi_lesenpermit` where `transaksi_lesenpermit`.`kod_pemaju` = '30053' and `transaksi_lesenpermit`.`kod_pemaju` is not null and `jenis` = 'L' and `taraf` in ('N', 'R', 'A') and `lesen_aktif` = 1 and transaksi_lesenpermit.date_from < now() and transaksi_lesenpermit.date_to > now() order by `tarikh_luput` desc, `lesen_aktif` desc limit 1

1.16msdw_hims_newketerangan_pemaju_swasta.blade.php#44

Bindings	0: 30053 1: L 2: N 3: R 4: A 5: 1
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:44 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_daerah` where `kod_daerah`.`id` = '1400144' limit 1

740μsdw_hims_newketerangan_pemaju_swasta.blade.php#183

Bindings	0: 1400144
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:183 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_daerah` where `kod_daerah`.`id` = '1401' limit 1

540μsdw_hims_newketerangan_pemaju_swasta.blade.php#185

Bindings	0: 1401
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:185 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_negeri` where `kod_negeri`.`id` = '14' limit 1

480μsdw_hims_newketerangan_pemaju_swasta.blade.php#187

Bindings	0: 14
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:187 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_daerah` where `kod_daerah`.`id` = '1000547' limit 1

480μsdw_hims_newketerangan_pemaju_swasta.blade.php#210

Bindings	0: 1000547
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:210 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_daerah` where `kod_daerah`.`id` = '1005' limit 1

360μsdw_hims_newketerangan_pemaju_swasta.blade.php#212

Bindings	0: 1005
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:212 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_negeri` where `kod_negeri`.`id` = '10' limit 1

430μsdw_hims_newketerangan_pemaju_swasta.blade.php#214

Bindings	0: 10
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:214 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_negeri` where `kod_negeri`.`id` = '01' limit 1

440μsdw_hims_newketerangan_pemaju_swasta.blade.php#253

Bindings	0: 01
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:253 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_daerah` where `kod_daerah`.`id` = '0105' limit 1

400μsdw_hims_newketerangan_pemaju_swasta.blade.php#257

Bindings	0: 0105
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:257 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `pembangunan` where `pembangunan`.`pemajuan_id` = '30053-1' and `pembangunan`.`pemajuan_id` is not null

530μsdw_hims_newketerangan_pemaju_swasta.blade.php#261

Bindings	0: 30053-1
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:261 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `kod_status_projek` where `kod_status_projek`.`id` = 'TM' limit 1

420μsdw_hims_newketerangan_pemaju_swasta.blade.php#275

Bindings	0: TM
Backtrace	view::portal-new.pages.static.keterangan_pemaju_swasta:275 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

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

8.25msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-07 00:00:00 1: 2025-06-07 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-07 00:00:00'

1.17msteduh-productionDatabaseVisitorRepository.php#106

Bindings	0: 2025-06-01 00:00:00 1: 2025-06-07 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-07 00:00:00' and '2025-06-07 23:59:59'

3.33msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-07 00:00:00 1: 2025-06-07 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-07 00:00:00'

5.05msteduh-productionDatabaseVisitorRepository.php#90

Bindings	0: 2025-06-07 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-07 00:00:00' and '2025-06-07 23:59:59'

4.65msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-07 00:00:00 1: 2025-06-07 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\Lookup\Daerah: 3Daerah.php#?
App\Models\Hims\Lookup\Negeri: 3Negeri.php#?
App\Models\Hims\Pemaju: 1Pemaju.php#?
App\Models\Hims\Pemajuan: 1Pemajuan.php#?
App\Models\Hims\TransaksiLesenPermit: 1TransaksiLesenPermit.php#?
App\Models\Hims\Lookup\StatusProjek: 1StatusProjek.php#?

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

telescope

View in Telescope

path_info

/developer-swasta/30053

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.26.101"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-xn8jq (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 => "Sat, 07 Jun 2025 12:16:23 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZlWndLdkZtYkxXbXU5T2RXcFlCc3c9PSIsInZhbHVlIjoiNDFkMnl0VzBsdE5vVEIrMFA1WDM0ZXYrRVRFcnpOU2ZrbC95d2lMOEF3RDNwNzgvSnMrTkx5R2MxSkpZazZ1ZUVJYVBEaGQ3T1NYZ2o1YXFrRit4M2Qxa2hPVWV0Zmt4b1pFM0dwZ3pGV21mNFpVR2dxb2tqWk5hM2s5OXVpYm4iLCJtYWMiOiIxYWY0MzljNDQ1MmVmOTEyMjRjM2U4MTM0ZDZjZmYzM2JkNDI2YjJmNTY5NmQ4NmViZmI4NzdhMTQwZTljNWViIiwidGFnIjoiIn0%3D; expires=Sat, 07 Jun 2025 14:16:24 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjZlWndLdkZtYkxXbXU5T2RXcFlCc3c9PSIsInZhbHVlIjoiNDFkMnl0VzBsdE5vVEIrMFA1WDM0ZXYrRVRFcnpOU2ZrbC95d2lMOEF3RDNwNzgvSnMrTkx5R2MxSkpZazZ1ZUVJYVBEa ▶"
    1 => "laravel_session=eyJpdiI6IkFXWWtiVVNSbGg2MXJFTEVUeDR6bFE9PSIsInZhbHVlIjoieGxmOUh4U2pPN1R0TWxGQzBXQTJ6VndadTQyOXVpaFBxNTVBNGN2clFJMTFUVmh6YVhqcXpWYmd1RHNIdFBxcXdBU1lsdGJKaFlPb2tvdVM1MEdKL0hpK0dQcWljNGFCdFJxNWQvVFBSKzR3M1c2ODhtRHdHdS9lRGxXRyswNTkiLCJtYWMiOiIwOGQwMGI3OTc4ZjI1YTFmOTAwZDFhZTQ5ZTgwMzlkMDRjNjA4NWE0N2YyNmZiOWY4ZTk1YTY4NWJkMGE5NzJkIiwidGFnIjoiIn0%3D; expires=Sat, 07 Jun 2025 14:16:24 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkFXWWtiVVNSbGg2MXJFTEVUeDR6bFE9PSIsInZhbHVlIjoieGxmOUh4U2pPN1R0TWxGQzBXQTJ6VndadTQyOXVpaFBxNTVBNGN2clFJMTFUVmh6YVhqcXpWYmd1RHNIdFBxcXdB ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZlWndLdkZtYkxXbXU5T2RXcFlCc3c9PSIsInZhbHVlIjoiNDFkMnl0VzBsdE5vVEIrMFA1WDM0ZXYrRVRFcnpOU2ZrbC95d2lMOEF3RDNwNzgvSnMrTkx5R2MxSkpZazZ1ZUVJYVBEaGQ3T1NYZ2o1YXFrRit4M2Qxa2hPVWV0Zmt4b1pFM0dwZ3pGV21mNFpVR2dxb2tqWk5hM2s5OXVpYm4iLCJtYWMiOiIxYWY0MzljNDQ1MmVmOTEyMjRjM2U4MTM0ZDZjZmYzM2JkNDI2YjJmNTY5NmQ4NmViZmI4NzdhMTQwZTljNWViIiwidGFnIjoiIn0%3D; expires=Sat, 07-Jun-2025 14:16:24 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZlWndLdkZtYkxXbXU5T2RXcFlCc3c9PSIsInZhbHVlIjoiNDFkMnl0VzBsdE5vVEIrMFA1WDM0ZXYrRVRFcnpOU2ZrbC95d2lMOEF3RDNwNzgvSnMrTkx5R2MxSkpZazZ1ZUVJYVBEa ▶"
    1 => "laravel_session=eyJpdiI6IkFXWWtiVVNSbGg2MXJFTEVUeDR6bFE9PSIsInZhbHVlIjoieGxmOUh4U2pPN1R0TWxGQzBXQTJ6VndadTQyOXVpaFBxNTVBNGN2clFJMTFUVmh6YVhqcXpWYmd1RHNIdFBxcXdBU1lsdGJKaFlPb2tvdVM1MEdKL0hpK0dQcWljNGFCdFJxNWQvVFBSKzR3M1c2ODhtRHdHdS9lRGxXRyswNTkiLCJtYWMiOiIwOGQwMGI3OTc4ZjI1YTFmOTAwZDFhZTQ5ZTgwMzlkMDRjNjA4NWE0N2YyNmZiOWY4ZTk1YTY4NWJkMGE5NzJkIiwidGFnIjoiIn0%3D; expires=Sat, 07-Jun-2025 14:16:24 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkFXWWtiVVNSbGg2MXJFTEVUeDR6bFE9PSIsInZhbHVlIjoieGxmOUh4U2pPN1R0TWxGQzBXQTJ6VndadTQyOXVpaFBxNTVBNGN2clFJMTFUVmh6YVhqcXpWYmd1RHNIdFBxcXdB ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "wCqiSzfaKLu19GYpgHPISFfBsgjnj3GRdQiL3c9c"
  "visit_expired_at" => "O:25:"Illuminate\Support\Carbon":3:{s:4:"date";s:26:"2025-06-07 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/developer-swasta/30053"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-07 20:16:24	GET	/developer-swasta/30053	4 7 21 10

1 x Application (79.38%)	75.62ms
1 x Booting (20.61%)	19.63ms

TEDUH | Transforming & Empowering Data Usage In Housing

Maklumat Pemaju Swasta : 19 DEVELOPMENT SDN. BHD.