SettingsRequest history116msRequest Duration2MBMemory Usage11.x
Laravel Version
11.43.2
PHP Version
8.4.4
Environment
development
Debug Mode
Enabled
URL
sosuke-development.com
Timezone
Asia/Tokyo
Locale
ja
GET search/condition/{condition}/{type}
status
200 OK
full_url
http://sosuke-development.com/search/condition/house_over_4dk/revenue?page=1
action_name
search.condition
controller_action
App\Http\Controllers\SearchController@search
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
    status
    200 OK
    full_url
    http://sosuke-development.com/search/condition/house_over_4dk/revenue?page=1
    action_name
    search.condition
    controller_action
    App\Http\Controllers\SearchController@search
    uri
    GET search/condition/{condition}/{type}
    controller
    App\Http\Controllers\SearchController@search
    prefix
    /search
    file
    app/Http/Controllers/SearchController.php:12-16
    middleware
    web
    duration
    119ms
    peak_memory
    4MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
    0 of 0
    array:1 [ "page" => "1" ]
    request_request
    []
    
    request_headers
    0 of 0
    array:11 [ "host" => array:1 [ 0 => "127.0.0.1:90" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "x-forwarded-for" => array:1 [ 0 => "18.117.101.118" ] "x-forwarded-host" => array:1 [ 0 => "sosuke-development.com" ] "x-forwarded-server" => array:1 [ 0 => "sosuke-development.com" ] "connection" => array:1 [ 0 => "Keep-Alive" ] ]
    request_cookies
    []
    
    response_headers
    0 of 0
    array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 06 May 2025 21:38:42 GMT" ] ]
    session_attributes
    0 of 0
    array:1 [ "_token" => "m0tPBuMLhGRClRCHlqWdVWyx44V94VSdfVTLqGlo" ]
    • Booting (42.55ms)time
    • Application (73.89ms)time
    • Routing (2.19ms)
    • Preparing Response (6.37ms)
    • View: search.indexviews
    • View: components.breadcrumbviews
    • View: components.property-card-for-listviews
    • View: components.property-card-attributeviews
    • View: components.property-card-attributeviews
    • View: pagination::tailwindviews
    • View: components.wrapperviews
    • View: components.register-bannerviews
    • View: components.arrowviews
    • View: components.wrapperviews
    • View: components.gold-wrapper-with-imageviews
    • View: layouts.layoutviews
    • 1 x Application (63.44%)
      73.89ms
      1 x Booting (36.54%)
      42.55ms
      1 x Preparing Response (5.47%)
      6.37ms
      1 x Routing (1.88%)
      2.19ms
      12 x View (0%)
      0μs
      12 templates were rendered
      • search.indexindex.blade.php#?blade
      • components.breadcrumbbreadcrumb.blade.php#?blade
      • components.property-card-for-listproperty-card-for-list.blade.php#?blade
      • components.property-card-attributeproperty-card-attribute.blade.php#?blade
      • components.property-card-attributeproperty-card-attribute.blade.php#?blade
      • pagination::tailwindtailwind.blade.php#?blade
      • components.wrapperwrapper.blade.php#?blade
      • components.register-bannerregister-banner.blade.php#?blade
      • components.arrowarrow.blade.php#?blade
      • components.wrapperwrapper.blade.php#?blade
      • components.gold-wrapper-with-imagegold-wrapper-with-image.blade.php#?blade
      • layouts.layoutlayout.blade.php#?blade
      16 statements were executed (2 duplicates)Show only duplicateslaravelmic_refer33.35ms
      • DatabaseSessionHandler.php#97laravel5.11msselect * from `sessions` where `id` = '5Axmqx0RC5zD8D2zpHUwfWIW5NtYrFrgdklTcUyk' limit 1
        Bindings
        • 0: 5Axmqx0RC5zD8D2zpHUwfWIW5NtYrFrgdklTcUyk
        Backtrace
        • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:97
        • vendor/laravel/framework/src/Illuminate/Session/Store.php:117
        • vendor/laravel/framework/src/Illuminate/Session/Store.php:105
        • vendor/laravel/framework/src/Illuminate/Session/Store.php:89
        • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:147
      • ActionsSearchRepository.php#37mic_referConnection Established
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:37
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#37mic_refer1.68msselect * from `mst_stations` where 0 = 1
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:37
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer4.74msselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `revenue` = 1
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        • 16: 1
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer3.62msselect * from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `revenue` = 1 order by `created_at` desc limit 20 offset 0
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        • 16: 1
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer710μsselect * from `mst_cities` where ((`mst_cities`.`pref_code` = 14 and `mst_cities`.`code` = 104))
        Bindings
        • 0: 14
        • 1: 104
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer9.64msselect * from `mst_towns` where ((`mst_towns`.`city_code` = 104 and `mst_towns`.`code` = 139))
        Bindings
        • 0: 104
        • 1: 139
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer590μsselect * from `mst_stations` where `mst_stations`.`id` in (148)
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer600μsselect * from `relation_article_photos` where `relation_article_photos`.`article_id` in (46)
        Bindings
        • 0: 46
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer1.11msselect `custom_contents`.*, `relation_custom_contents`.`article_id` as `pivot_article_id`, `relation_custom_contents`.`code` as `pivot_code` from `custom_contents` inner join `relation_custom_contents` on `custom_contents`.`code` = `relation_custom_contents`.`code` where `relation_custom_contents`.`article_id` in (46)
        Bindings
        • 0: 46
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#97mic_refer560μsselect * from `relation_price_histories` where `relation_price_histories`.`article_id` in (46)
        Bindings
        • 0: 46
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:97
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#109mic_refer1.02msselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3)
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:109
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#110mic_refer650μsselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `property` is null
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:110
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#111mic_refer1.02msselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `property` = 4 and `property_sub` = 1
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        • 16: 4
        • 17: 1
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:111
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#112mic_refer750μsselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `property` = 4 and `property_sub` = 2
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        • 16: 4
        • 17: 2
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:112
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#113mic_refer560μsselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `property` in (1, 2, 3)
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        • 16: 1
        • 17: 2
        • 18: 3
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:113
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • ActionsSearchRepository.php#114mic_refer990μsselect count(*) as aggregate from `articles` where `floor_plan` >= 4 and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2)) and ((`property` = 4 and `property_sub` = 1) or (`property` = 4 and `property_sub` = 2) or (`property` is null) or (`property` in (1, 2, 3))) and `own_company` = 2 and `status` in (1, 2, 3) and `revenue` = 1
        Bindings
        • 0: 4
        • 1: 4
        • 2: 1
        • 3: 4
        • 4: 2
        • 5: 4
        • 6: 1
        • 7: 4
        • 8: 2
        • 9: 1
        • 10: 2
        • 11: 3
        • 12: 2
        • 13: 1
        • 14: 2
        • 15: 3
        • 16: 1
        Backtrace
        • app/Actions/Search/ActionsSearchRepository.php:114
        • app/Actions/Search/ActionsSearchService.php:25
        • app/Http/Controllers/SearchController.php:14
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      App\Models\Refer\Property
      1Property.php#?
      App\Models\Refer\City
      1City.php#?
      App\Models\Refer\Town
      1Town.php#?
      App\Models\Refer\Station
      1Station.php#?
      App\Models\Refer\PriceHistory
      1PriceHistory.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-05-07 06:38:42GET/search/condition/house_over_4dk/revenue?page=112165