テスト2テスト2サブ

  • 仲介料なし
渋谷・青山・赤坂 エリア / 最寄り駅から徒歩1分以内 /

Services 「テスト2サブ」のサービス情報

その他サービス

Campaign 「テスト2サブ」のキャンペーン情報

キャンペーン一覧を見る

Contact 「テスト2サブ」の内覧希望・お問合わせ

WEBからのお問合わせ
お問合わせフォーム

「渋谷・青山・赤坂 エリア」のオススメ物件

サービスオフィス一括比較!

サービスオフィスを複数棟、比較検討できます。
気になる物件を選び、条件や設備などの違いを確認してみましょう。一覧表で比較ができる便利な機能です。比較資料としてご利用ください。

オフィス比較
サービスオフィス検索
エリア名から探す
ピックアップ物件
利用人数から探す
月額賃料から探す
賃貸面積から探す
内覧希望・お問合わせ 物件掲載ご希望の方へ
7.4.5Version185msRequest Duration18MBMemory UsageGET offices/{area}/{office}/serviceRoute
  • debuglog[02:05:25] LOG.debug: 2
  • debuglog[02:05:25] LOG.debug: 2
  • infolog[02:05:25] LOG.info: {"current_page":1,"data":[{"id":75,"site":"1","area_id":"shibuya-aoyama","open"...
  • Booting (83.04ms)
  • Application (99.63ms)
  • 1 x Application (53.81%)
    99.63ms
    1 x Booting (44.85%)
    83.04ms
    15 templates were rendered
    • front.offices.service (resources/views/front/offices/service.blade.php)12blade
      Params
      0
      office
      1
      area
      2
      officeid
      3
      lstAreas
      4
      metatag
      5
      other
      6
      banners
      7
      global_right_column
      8
      areas
      9
      persons
      10
      rents
      11
      floor_meters
    • front.common.office_main_image (resources/views/front/common/office_main_image.blade.php)16blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
    • front.offices.head (resources/views/front/offices/head.blade.php)16blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
    • front.common.office_headdet (resources/views/front/common/office_headdet.blade.php)16blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
    • front.offices.sideber (resources/views/front/offices/sideber.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.footer_search_area (resources/views/front/common/footer_search_area.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.layouts.layout (resources/views/front/layouts/layout.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.head_met (resources/views/front/common/head_met.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.header (resources/views/front/common/header.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.head_menu (resources/views/front/common/head_menu.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.contact_office (resources/views/front/common/contact_office.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.sidebar (resources/views/front/common/sidebar.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.footsearch (resources/views/front/common/footsearch.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.footer_menu (resources/views/front/common/footer_menu.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    • front.common.footer (resources/views/front/common/footer.blade.php)18blade
      Params
      0
      obLevel
      1
      __env
      2
      app
      3
      errors
      4
      office
      5
      area
      6
      officeid
      7
      lstAreas
      8
      metatag
      9
      other
      10
      banners
      11
      global_right_column
      12
      areas
      13
      persons
      14
      rents
      15
      floor_meters
      16
      __currentLoopData
      17
      loop
    uri
    GET offices/{area}/{office}/service
    domain
    test.service-office.jp
    middleware
    web
    controller
    App\Http\Controllers\Front\OfficeController@service
    namespace
    App\Http\Controllers
    prefix
    where
    as
    front.offices.office.service
    file
    app/Http/Controllers/Front/OfficeController.php:67-82
    35 statements were executed, 10 of which were duplicated, 25 unique15.54ms
    • select * from `offices` where `url_segment` = 'test2' and `site` = 1 and `offices`.`deleted_at` is null limit 12.01ms/app/Services/OfficeDetailService.php:71service-office-test
      Metadata
      Bindings
      • 0. test2
      • 1. 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
      • 15. /app/Services/OfficeDetailService.php:71
      • 16. /app/Services/OfficeDetailService.php:127
      • 17. /app/Http/Controllers/Front/OfficeController.php:69
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 23. middleware::bindings:41
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 25. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `office_rooms` where `office_id` = 75 and `display` = 1 and `in` = 0 or `office_id` = 75 and `display` = 1 and `in` = 1 and `possible_year` is not null and `possible_month` is not null order by lpad(no, 10, ' ')770μs/app/Services/Office/ItmOfficeRoom.php:51service-office-test
      Metadata
      Bindings
      • 0. 75
      • 1. 1
      • 2. 0
      • 3. 75
      • 4. 1
      • 5. 1
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Services/Office/ItmOfficeRoom.php:51
      • 15. /app/Services/OfficeDetailService.php:132
      • 16. /app/Http/Controllers/Front/OfficeController.php:69
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select * from `contents` where `open` = 1 and `site` = 1 and `type` = 2 and ((`display_from` is null or date(`display_from`) <= '2025/04/09') and (`display_to` is null or date(`display_to`) >= '2025/04/09')) order by `open_date` desc, `id` desc limit 5290μs/app/Services/Office/ItmOfficeCampaignNews.php:72service-office-test
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. 2
      • 3. 2025/04/09
      • 4. 2025/04/09
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Services/Office/ItmOfficeCampaignNews.php:72
      • 15. /app/Services/Office/ItmOfficeCampaignNews.php:38
      • 16. /app/Services/OfficeDetailService.php:133
      • 17. /app/Http/Controllers/Front/OfficeController.php:69
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 23. middleware::bindings:41
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 25. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `office_contents` where `office_contents`.`content_id` in (14)190μs/app/Services/Office/ItmOfficeCampaignNews.php:72service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /app/Services/Office/ItmOfficeCampaignNews.php:72
      • 20. /app/Services/Office/ItmOfficeCampaignNews.php:38
      • 21. /app/Services/OfficeDetailService.php:133
      • 22. /app/Http/Controllers/Front/OfficeController.php:69
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 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:681
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 28. middleware::bindings:41
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 36. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
    • select * from `office_contents` where `office_contents`.`content_id` = 14 and `office_contents`.`content_id` is not null190μs/app/Services/Office/ItmOfficeCampaignNews.php:78service-office-test
      Metadata
      Bindings
      • 0. 14
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /app/Services/Office/ItmOfficeCampaignNews.php:78
      • 20. /app/Services/Office/ItmOfficeCampaignNews.php:38
      • 21. /app/Services/OfficeDetailService.php:133
      • 22. /app/Http/Controllers/Front/OfficeController.php:69
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 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:681
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 28. middleware::bindings:41
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 36. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
    • select * from `office_options` inner join `options` on `options`.`id` = `office_options`.`option_id` where `office_id` = 75 order by `no` asc270μs/app/Services/Office/ItmOfficeService.php:39service-office-test
      Metadata
      Bindings
      • 0. 75
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Services/Office/ItmOfficeService.php:39
      • 15. /app/Services/OfficeDetailService.php:134
      • 16. /app/Http/Controllers/Front/OfficeController.php:69
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select * from `office_interview_questions` left join `office_interview_images` on `office_interview_images`.`office_id` = `office_interview_questions`.`office_id` and `office_interview_images`.`no` = `office_interview_questions`.`no` where `office_interview_questions`.`office_id` = 75 order by `office_interview_questions`.`no` asc3.18ms/app/Services/Office/ItmOfficeService.php:54service-office-test
      Metadata
      Bindings
      • 0. 75
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Services/Office/ItmOfficeService.php:54
      • 15. /app/Services/OfficeDetailService.php:135
      • 16. /app/Http/Controllers/Front/OfficeController.php:69
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select * from `contents` where `open` = 1 and `site` = 1 and `type` = 2 and ((`display_from` is null or date(`display_from`) <= '2025/04/09') and (`display_to` is null or date(`display_to`) >= '2025/04/09')) order by `open_date` desc, `id` desc limit 5290μs/app/Services/Office/ItmOfficeCampaignNews.php:72service-office-test
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. 2
      • 3. 2025/04/09
      • 4. 2025/04/09
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Services/Office/ItmOfficeCampaignNews.php:72
      • 15. /app/Services/Office/ItmOfficeCampaignNews.php:26
      • 16. /app/Services/OfficeDetailService.php:136
      • 17. /app/Http/Controllers/Front/OfficeController.php:69
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 23. middleware::bindings:41
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 25. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `office_contents` where `office_contents`.`content_id` in (14)180μs/app/Services/Office/ItmOfficeCampaignNews.php:72service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /app/Services/Office/ItmOfficeCampaignNews.php:72
      • 20. /app/Services/Office/ItmOfficeCampaignNews.php:26
      • 21. /app/Services/OfficeDetailService.php:136
      • 22. /app/Http/Controllers/Front/OfficeController.php:69
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 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:681
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 28. middleware::bindings:41
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 36. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
    • select * from `office_contents` where `office_contents`.`content_id` = 14 and `office_contents`.`content_id` is not null190μs/app/Services/Office/ItmOfficeCampaignNews.php:78service-office-test
      Metadata
      Bindings
      • 0. 14
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 19. /app/Services/Office/ItmOfficeCampaignNews.php:78
      • 20. /app/Services/Office/ItmOfficeCampaignNews.php:26
      • 21. /app/Services/OfficeDetailService.php:136
      • 22. /app/Http/Controllers/Front/OfficeController.php:69
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 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:681
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 28. middleware::bindings:41
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 36. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
    • select stations.name as station,route.name as route,walking_time from `office_stations` inner join `stations` on `stations`.`id` = `office_stations`.`station_id` inner join `route_station` on `route_station`.`station_id` = `stations`.`id` inner join `route` on `route`.`id` = `route_station`.`route_id` where `office_id` = 75 order by `office_stations`.`id` asc430μs/app/Services/Office/ItmOfficeAccess.php:32service-office-test
      Metadata
      Bindings
      • 0. 75
      Backtrace
      • 14. /app/Services/Office/ItmOfficeAccess.php:32
      • 15. /app/Services/OfficeDetailService.php:226
      • 16. /app/Services/OfficeDetailService.php:138
      • 17. /app/Http/Controllers/Front/OfficeController.php:69
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 23. middleware::bindings:41
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 25. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `office_services` where `office_id` = 75 order by `no` asc350μs/app/Services/Office/ItmOfficeService.php:27service-office-test
      Metadata
      Bindings
      • 0. 75
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Services/Office/ItmOfficeService.php:27
      • 15. /app/Services/OfficeDetailService.php:271
      • 16. /app/Services/OfficeDetailService.php:138
      • 17. /app/Http/Controllers/Front/OfficeController.php:69
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 23. middleware::bindings:41
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 25. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select count(*) as aggregate from `offices` where `open` = 1 and `site` = 1 and `area_id` = 'shibuya-aoyama' and `offices`.`deleted_at` is null240μs/app/Services/OfficeService.php:34service-office-test
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. shibuya-aoyama
      Backtrace
      • 15. /app/Services/OfficeService.php:34
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select * from `offices` where `open` = 1 and `site` = 1 and `area_id` = 'shibuya-aoyama' and `offices`.`deleted_at` is null order by `id` desc limit 10 offset 0530μs/app/Services/OfficeService.php:34service-office-test
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. shibuya-aoyama
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 15. /app/Services/OfficeService.php:34
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 75 and `in` <> 1 and `display` = 1 and `rent` > 0330μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 75
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 75 and `in` <> 1 and `display` = 1330μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 75
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 73 and `in` <> 1 and `display` = 1 and `rent` > 0330μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 73
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 73 and `in` <> 1 and `display` = 1330μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 73
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 36 and `in` <> 1 and `display` = 1 and `rent` > 0320μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 36
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 36 and `in` <> 1 and `display` = 1340μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 36
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 35 and `in` <> 1 and `display` = 1 and `rent` > 0330μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 35
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 35 and `in` <> 1 and `display` = 1330μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 35
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 12 and `in` <> 1 and `display` = 1 and `rent` > 0350μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 12
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 12 and `in` <> 1 and `display` = 1330μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 12
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 11 and `in` <> 1 and `display` = 1 and `rent` > 0320μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 11
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 11 and `in` <> 1 and `display` = 1330μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 11
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`rent`) as aggregate from `office_rooms` where `office_id` = 5 and `in` <> 1 and `display` = 1 and `rent` > 0330μs/app/Office.php:138service-office-test
      Metadata
      Bindings
      • 0. 5
      • 1. 1
      • 2. 1
      • 3. 0
      Backtrace
      • 14. /app/Office.php:138
      • 15. /app/Services/OfficeService.php:36
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select min(`floor_meter`) as aggregate from `office_rooms` where `office_id` = 5 and `in` <> 1 and `display` = 1330μs/app/Office.php:148service-office-test
      Metadata
      Bindings
      • 0. 5
      • 1. 1
      • 2. 1
      Backtrace
      • 14. /app/Office.php:148
      • 15. /app/Services/OfficeService.php:37
      • 16. /app/Http/Controllers/Front/OfficeController.php:78
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select * from `others`240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • The SELECT statement has no WHERE clause and could examine many more rows than intended
      Backtrace
      • 14. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
      • 17. /app/Http/Controllers/Front/FrontBaseController.php:43
      • 18. /app/Http/Controllers/Front/FrontBaseController.php:21
      • 19. /app/Http/Controllers/Front/OfficeController.php:80
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 25. middleware::bindings:41
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 42. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `banners` where `banner_id` in ('banner1', 'banner2') order by `banner_id` asc290μs/app/Http/Controllers/Front/FrontBaseController.php:54service-office-test
      Metadata
      Bindings
      • 0. banner1
      • 1. banner2
      Hints
      • Use SELECT * only if you need all columns from table
      Backtrace
      • 14. /app/Http/Controllers/Front/FrontBaseController.php:54
      • 15. /app/Http/Controllers/Front/FrontBaseController.php:22
      • 16. /app/Http/Controllers/Front/OfficeController.php:80
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 22. middleware::bindings:41
      • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 24. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
    • select * from `banners` where `banner_id` = 'global_right_column' limit 1180μs/app/Http/Controllers/Front/FrontBaseController.php:58service-office-test
      Metadata
      Bindings
      • 0. global_right_column
      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
      • 15. /app/Http/Controllers/Front/FrontBaseController.php:58
      • 16. /app/Http/Controllers/Front/FrontBaseController.php:23
      • 17. /app/Http/Controllers/Front/OfficeController.php:80
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 23. middleware::bindings:41
      • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 25. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 27. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 33. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
      • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
      • 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
      • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `tags` order by `created_at` asc400μsview::front.common.head_menu:17service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • The SELECT statement has no WHERE clause and could examine many more rows than intended
      Backtrace
      • 14. view::front.common.head_menu:17
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 17. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 18. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 20. view::front.layouts.layout:38
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 26. view::front.offices.service:123
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 30. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 31. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 32. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
      • 33. /vendor/symfony/http-foundation/Response.php:205
      • 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:749
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:721
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 38. middleware::bindings:41
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 42. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `tags` order by `created_at` asc290μsview::front.common.footsearch:66service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • The SELECT statement has no WHERE clause and could examine many more rows than intended
      Backtrace
      • 14. view::front.common.footsearch:66
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 17. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 18. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 20. view::front.layouts.layout:61
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 26. view::front.offices.service:123
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 30. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 31. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 32. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
      • 33. /vendor/symfony/http-foundation/Response.php:205
      • 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:749
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:721
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 38. middleware::bindings:41
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 42. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `tags` order by `created_at` asc220μsview::front.common.footer:26service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • The SELECT statement has no WHERE clause and could examine many more rows than intended
      Backtrace
      • 14. view::front.common.footer:26
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 17. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 18. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 20. view::front.layouts.layout:67
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 26. view::front.offices.service:123
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 30. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 31. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 32. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
      • 33. /vendor/symfony/http-foundation/Response.php:205
      • 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:749
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:721
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 38. middleware::bindings:41
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 42. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    • select * from `tags` order by `created_at` asc180μsview::front.common.footer:70service-office-test
      Metadata
      Hints
      • Use SELECT * only if you need all columns from table
      • The SELECT statement has no WHERE clause and could examine many more rows than intended
      Backtrace
      • 14. view::front.common.footer:70
      • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 17. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 18. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 20. view::front.layouts.layout:67
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 25. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 26. view::front.offices.service:123
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
      • 29. /vendor/laravel/framework/src/Illuminate/View/View.php:143
      • 30. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • 31. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • 32. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
      • 33. /vendor/symfony/http-foundation/Response.php:205
      • 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:749
      • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:721
      • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
      • 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
      • 38. middleware::bindings:41
      • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 40. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
      • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 42. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
      • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 44. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
      • 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
      • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
      • 48. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
      • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
    App\Tag
    24
    App\Banner
    3
    App\Other
    4
    App\OfficeStation
    1
    App\OfficeContent
    4
    App\Content
    2
    App\Office
    8
        _token
        ERNNBxTfXtXBqBNT6Dug2ymo1eBQLGRGC8vwqfYB
        _previous
        array:1 [ "url" => "https://test.service-office.jp/offices/shibuya-aoyama/test2/service" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /offices/shibuya-aoyama/test2/service
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "test.service-office.jp" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "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" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
        request_server
        0 of 0
        array:46 [ "REDIRECT_UNIQUE_ID" => "Z_VXVZZekzFpyR6ObELPRQAAAAM" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "test.service-office.jp" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z_VXVZZekzFpyR6ObELPRQAAAAM" "HTTPS" => "on" "SSL_TLS_SNI" => "test.service-office.jp" "HTTP_HOST" => "test.service-office.jp" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "SERVER_SIGNATURE" => "" "SERVER_SOFTWARE" => "Apache/2.4.48 () OpenSSL/1.0.2k-fips PHP/7.4.5" "SERVER_NAME" => "test.service-office.jp" "SERVER_ADDR" => "172.31.38.80" "SERVER_PORT" => "443" "REMOTE_ADDR" => "18.216.229.154" "DOCUMENT_ROOT" => "/var/www/html/service-office.jp/test/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/service-office.jp/test/public" "SERVER_ADMIN" => "root@localhost" "SCRIPT_FILENAME" => "/var/www/html/service-office.jp/test/public/index.php" "REMOTE_PORT" => "15064" "REDIRECT_URL" => "/offices/shibuya-aoyama/test2/service" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/offices/shibuya-aoyama/test2/service" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744131925.242 "REQUEST_TIME" => 1744131925 ]
        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, 08 Apr 2025 17:05:25 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1SeTBqcUx3UU5JaHljZ1g1YzRPSlE9PSIsInZhbHVlIjoiZFJvS3NHZ0VNRk9wZmYwYlFLT3dYSkhPWllxUGMra29LWCtrVUtKYitHcnlHWEtWQ2QyNmRYakFydWRadndxVSIsIm1hYyI6ImRiNWVkZGYxZWRhYTMzYTNiYTIzZDFlMjM3ZWI0N2Y2ZWUwNmU2MWM4OGI0OWFmNWQ2NDNjZDg4ODY0Yzc0YzkifQ%3D%3D; expires=Tue, 08-Apr-2025 19:05:25 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Im1SeTBqcUx3UU5JaHljZ1g1YzRPSlE9PSIsInZhbHVlIjoiZFJvS3NHZ0VNRk9wZmYwYlFLT3dYSkhPWllxUGMra29LWCtrVUtKYitHcnlHWEtWQ2QyNmRYakFydWRadndxVSIsIm1hY" 1 => "laravel_session=eyJpdiI6InBMbjU2M1FFeW9SOGRaSk92ZVlxRlE9PSIsInZhbHVlIjoiVE5UbGNoS3BBU2JQOGkyVnFVU0JsSGo0RXZDcXlVaVN3UENaN3ljVFFWVWN4Uzg1OU1QdittdzhlOUh0amtMQyIsIm1hYyI6IjhmYWE5MzgyOTQzMjMwMDY5MmVlYTYzMWVhNDEwZDUxNWI0ZWY2ODcxMGRmYTlhMTVlZjZmOWYwNzI2NmE5ZTIifQ%3D%3D; expires=Tue, 08-Apr-2025 19:05:25 GMT; Max-Age=7200; path=/; httponlylaravel_session=eyJpdiI6InBMbjU2M1FFeW9SOGRaSk92ZVlxRlE9PSIsInZhbHVlIjoiVE5UbGNoS3BBU2JQOGkyVnFVU0JsSGo0RXZDcXlVaVN3UENaN3ljVFFWVWN4Uzg1OU1QdittdzhlOUh0amtMQyIs" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1SeTBqcUx3UU5JaHljZ1g1YzRPSlE9PSIsInZhbHVlIjoiZFJvS3NHZ0VNRk9wZmYwYlFLT3dYSkhPWllxUGMra29LWCtrVUtKYitHcnlHWEtWQ2QyNmRYakFydWRadndxVSIsIm1hYyI6ImRiNWVkZGYxZWRhYTMzYTNiYTIzZDFlMjM3ZWI0N2Y2ZWUwNmU2MWM4OGI0OWFmNWQ2NDNjZDg4ODY0Yzc0YzkifQ%3D%3D; expires=Tue, 08-Apr-2025 19:05:25 GMT; path=/XSRF-TOKEN=eyJpdiI6Im1SeTBqcUx3UU5JaHljZ1g1YzRPSlE9PSIsInZhbHVlIjoiZFJvS3NHZ0VNRk9wZmYwYlFLT3dYSkhPWllxUGMra29LWCtrVUtKYitHcnlHWEtWQ2QyNmRYakFydWRadndxVSIsIm1hY" 1 => "laravel_session=eyJpdiI6InBMbjU2M1FFeW9SOGRaSk92ZVlxRlE9PSIsInZhbHVlIjoiVE5UbGNoS3BBU2JQOGkyVnFVU0JsSGo0RXZDcXlVaVN3UENaN3ljVFFWVWN4Uzg1OU1QdittdzhlOUh0amtMQyIsIm1hYyI6IjhmYWE5MzgyOTQzMjMwMDY5MmVlYTYzMWVhNDEwZDUxNWI0ZWY2ODcxMGRmYTlhMTVlZjZmOWYwNzI2NmE5ZTIifQ%3D%3D; expires=Tue, 08-Apr-2025 19:05:25 GMT; path=/; httponlylaravel_session=eyJpdiI6InBMbjU2M1FFeW9SOGRaSk92ZVlxRlE9PSIsInZhbHVlIjoiVE5UbGNoS3BBU2JQOGkyVnFVU0JsSGo0RXZDcXlVaVN3UENaN3ljVFFWVWN4Uzg1OU1QdittdzhlOUh0amtMQyIs" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "ERNNBxTfXtXBqBNT6Dug2ymo1eBQLGRGC8vwqfYB" "_previous" => array:1 [ "url" => "https://test.service-office.jp/offices/shibuya-aoyama/test2/service" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]