Transportation Statistics Bureau

Optimize Your Compliance Strategy with Transportation Statistics Bureau Insights

Part of: Transportation Department

Document Statistics

Documents by Year

Documents by Type (All Time)

Understanding the Transportation Statistics Bureau

The Bureau of Transportation Statistics (BTS), part of the U.S. Department of Transportation, plays a pivotal role in the realm of transportation adminstration and oversight. Established in 1992 by the Intermodal Surface Transportation Efficiency Act of 1991, BTS was created to fulfill crucial functions in data collection, analysis, and reporting. With its incorporation into the Research and Innovative Technology Administration (RITA) in 2005, BTS continues to uphold its commitment to delivering high-quality, reliable transportation data.

BTS is charged with bridging data gaps, ensuring standardization, and enhancing the efficiency of reporting within the transportation sector. This mission is crucial for various stakeholders who depend on transportation data to guide decision-making — from public policy formulation to industry best practices.

Why Monitor the Transportation Statistics Bureau?

Key Benefits for Professionals:

  • Legal Teams & Compliance Officers: Staying informed on transportation regulations and changes can help avoid costly compliance violations. BTS acts as a repository of vital regulatory updates, allowing legal departments to anticipate legislative shifts and prepare in advance.
  • Insurance Providers: For insurers, comprehending transportation trends and safety statistics is fundamental to assessing risk and setting premiums correctly. With BTS data, insurers gain insights into accident rates and other essential metrics.
  • Policy Analysts & Risk Managers: Continuous monitoring of data from BTS helps policy analysts assess potential impacts of transportation policy changes on their domains, while risk managers can identify emerging risks tied to regulatory adjustments.

BTS' work is supported by foundational legislation, notably the Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users (SAFETEA-LU), reflecting its operational significance. Aviation data collection forms another critical aspect of BTS' services, thereby providing comprehensive oversight across different modes of transportation.

Why Industries and Interest Groups Care:

  • Aviation and Commercial Transportation: The statutory role of BTS in collecting aviation data, authorized under the Wendell Ford Aviation Investment Reform Act, underscores its centrality to airline operations and safety assessments. Airline companies and their support industries depend heavily on BTS for insights necessary to adapt to new regulations and trends.
  • Urban Planning and Infrastructure: With its robust database, BTS supports urban planners and civil engineers in making informed decisions to advance city infrastructure and transportation efficiency.

Mitigate Risks and Enhance Compliance with FedMonitor

Keeping abreast of the latest publications from the Federal Register concerning the Transportation Statistics Bureau is essential for industries and professionals seeking to stay compliant and strategically proactive.

Our service, FedMonitor, streamlines this monitoring with AI-powered technology, ensuring you receive the right information at the right time. By filtering for relevance, FedMonitor helps you:

  • Identify and understand critical rule changes.
  • Ensure timely responses to regulations, preventing compliance issues.
  • Gain a competitive edge with strategic foresight into policy shifts.

With support for popular integrations like Slack, Microsoft Teams, and Salesforce, FedMonitor ensures you're alerted instantly in your preferred communication channel, plus email and SMS options are available for urgent updates.

Discover more about how FedMonitor can help you avoid penalties, ensure compliance, and strategize effectively. For further inquiries, feel free to contact us. Your pathway to seamless compliance management starts here.

Agency Details

  • Status: Reorganized

    The Bureau of Transportation Statistics (BTS) became a part of the Research and Innovative Technology Administration (RITA) on February 20, 2005, forming a new organizational structure that includes several former divisions of other transportation-related entities. Although BTS retains its core functions, this incorporation reflects a significant organizational restructuring.

  • Acronym: BTS

Related Searches

Latest Documents

Title Type Published
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Report of Financial and Operating Statistics for Small Aircraft Operators
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of BTS collecting financial, traf...
 Notice Jan 17, 2025
Transportation Department > BTS
Agency Information Collection: Activity Under OMB Review: Report of Financial and Operating Statistics for Large Certificated Air Carriers
In compliance with the Paperwork Reduction Act of 1995, this notice announces that the Information Collection Request (ICR) abstracted below is being forwarded to the Office of Management and Budget (OMB) for an extension of a currently approved coll...
 Notice Nov 14, 2024
Transportation Department > BTS
Notice of Submission of Proposed Information Collection to OMB; Agency Request for Renewal of a Previously Approved Collection: Airline Service Quality Performance-Part 234
In accordance with the Paperwork Reduction Act of 1995, this notice announces DOT's intention to renew Office of Management and Budget (OMB) Control Number 2138-0041 covering Airline Service Quality Performance On-time Performance and Mishandled Bagg...
 Notice Nov 08, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Report of Financial and Operating Statistics for Small Aircraft Operators
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of BTS collecting financial, traf...
 Notice Nov 08, 2024
Transportation Department > BTS
Agency Information Collection: Activity Under OMB Review: Report of Financial and Operating Statistics for Large Certificated Air Carriers
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of BTS collecting financial data...
 Notice Jul 10, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Reporting Required for International Civil Aviation Organization (ICAO)
In compliance with the Paperwork Reduction Act of 1995, this notice announces that the Information Collection Request (ICR) abstracted below has been forwarded to the Office of Management and Budget (OMB) for extension of currently approved collectio...
 Notice Jun 10, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Reporting Required for International Civil Aviation Organization (ICAO)
In compliance with the Paperwork Reduction Act of 1995 this notice announces that the Information Collection Request (ICR) abstracted below has been forwarded to the Office of Management and Budget (OMB) for extension of currently approved collection...
 Notice May 10, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Submission of Audit Reports-Part 248
In compliance with the Paperwork Reduction Act of 1995, Public Law 104-13, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of BTS requiri...
 Notice Mar 19, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Reporting Required for International Civil Aviation Organization (ICAO)
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need and usefulness of BTS collecting supplemental data f...
 Notice Mar 19, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Report of Extension of Credit to Political Candidates-Form 183
In compliance with the Paperwork Reduction Act of 1995, Public Law 104-13, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need and usefulness of BTS collecting...
 Notice Mar 19, 2024
Transportation Department > BTS
Request for Clearance for an Information Collection: Annual Tank Car Survey
This notice announces the Bureau of Transportation Statistics (BTS) intention to request that the Office of Management and Budget (OMB) approves a 3-year extension of a currently approved information collection for the "Annual Tank Car Survey."
 Notice Feb 27, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Submission of Audit Reports-Part 248
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of BTS requiring U.S. large certi...
 Notice Jan 12, 2024
Transportation Department > BTS
Agency Information Collection; Activity Under OMB Review; Report of Extension of Credit to Political Candidates-Form 183
In compliance with the Paperwork Reduction Act of 1995, Public Law 104-13, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need and usefulness of BTS collecting...
 Notice Jan 12, 2024
Transportation Department > BTS
Request for Clearance for an Information Collection: Annual Tank Car Survey
This notice announces the Bureau of Transportation Statistics (BTS) intention to request that the Office of Management and Budget (OMB) approves a 3-year extension of a currently approved information collection for the "Annual Tank Car Survey."
 Notice Dec 14, 2023
Transportation Department > BTS
Agency Information Collection: Activity Under OMB Review: Report of Passengers Denied Confirmed Space-BTS Form 250
In compliance with the Paperwork Reduction Act of 1995, this notice announces that the Information Collection Request (ICR) abstracted below is being forwarded to the Office of Management and Budget (OMB) for an extension of a previously approved col...
 Notice Dec 08, 2023
Transportation Department > BTS
Agency Information Collection: Activity Under OMB Review; Electric Vehicle Inventory and Use Survey (eVIUS)
In accordance with the requirements of the Paperwork Reduction Act of 1995, this notice announces the intention of the Bureau of Transportation Statistics (BTS) to request the Office of Management and Budget's (OMB) approval of a new information coll...
 Notice Nov 06, 2023
Transportation Department > BTS
Agency Information Collection Activity; Notice of Request for Approval To Collect New Information: Safe Maritime Transportation System (SafeMTS)-Voluntary Near-Miss Incident Reporting and Analysis System
On August 8, 2023, the Bureau of Transportation Statistics (BTS) announced its intention in a Federal Register Notice to request that the Office of Management and Budget (OMB) approve the following information collection: SafeMTS--Voluntary Near-Miss...
 Notice Nov 06, 2023
Transportation Department > BTS
Agency Information Collection: Activity Under OMB Review; Report of Passengers Denied Confirmed Space-BTS Form 250
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of DOT collecting reports on the...
 Notice Sep 05, 2023
Transportation Department > BTS
Agency Information Collection Activity; Notice of Request for Approval To Collect New Information: Safe Maritime Transportation System (SafeMTS)-Voluntary Near-Miss Incident Reporting and Analysis System
In accordance with the requirements of section 3506(c)(2)(A) of Title 44 of the U.S. Code (Paperwork Reduction Act of 1995), this notice announces the intention of BTS to request the Office of Management and Budget (OMB) to approve a new data collect...
 Notice Aug 08, 2023
Transportation Department > BTS
Agency Information Collection: Activity Under OMB Review; Report of Traffic and Capacity Statistics-The T-100 System
In compliance with the Paperwork Reduction Act of 1995, the Bureau of Transportation Statistics invites the general public, industry and other governmental parties to comment on the continuing need for and usefulness of DOT requiring U.S. and foreign...
 Notice Apr 21, 2023

No sub-agencies found.

MessagesRequestTimelineExceptionsViews46Queries49Models86Livewire0MailsGate
SettingsRequest history997msRequest Duration4MBMemory Usage12.x
Laravel Version
12.3.0
PHP Version
8.4.1
Environment
production
Debug Mode
Enabled
URL
fedmonitor.com
Timezone
UTC
Locale
en
GET agencies/{agency}
status
200 OK
full_url
https://fedmonitor.com/agencies/transportation-statistics-bureau-bts
action_name
agencies.show
controller_action
App\Http\Controllers\AgencyController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
    status
    200 OK
    full_url
    https://fedmonitor.com/agencies/transportation-statistics-bureau-bts
    action_name
    agencies.show
    controller_action
    App\Http\Controllers\AgencyController@show
    uri
    GET agencies/{agency}
    controller
    App\Http\Controllers\AgencyController@show
    file
    app/Http/Controllers/AgencyController.php:60-125
    middleware
    web
    duration
    999ms
    peak_memory
    6MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
    []
    request_request
    []
    request_headers
      0 of 0   
    array:30 [▼
  "x-laravel-cloud-env" => array:1 [▶
    0 => "env-9e663346-6293-4a92-96f0-67b15beb57a8"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-warp-tag-id" => array:1 [▶
    0 => "7da024d5-7d1b-4fb0-8113-5ff0b4f2f72e"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "cf-ray" => array:1 [▶
    0 => "930641e80e342854-CMH"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "18.222.220.80"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "x-scheme" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-scheme" => array:1 [▶
    0 => "https"
  ]
  "x-original-forwarded-for" => array:1 [▶
    0 => "18.222.220.80, 18.222.220.80"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.222.220.80"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.222.220.80"
  ]
  "x-request-id" => array:1 [▶
    0 => "3b5b4a2a1cd3a67d498b6c06494d14f4"
  ]
  "host" => array:1 [▶
    0 => "fedmonitor.com"
  ]
]
    request_cookies
    []
    response_headers
      0 of 0   
    array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 14 Apr 2025 21:22:14 GMT"
  ]
]
    session_attributes
      0 of 0   
    array:1 [▼
  "_token" => "LD6TZIpMjK5R0PxYE6TIbNounXe3QRVKNxA9qzcs"
]
    • Booting (15.95ms)time
    • Application (981ms)time
    • Routing (959μs)
    • Preparing Response (561ms)
    • View: agencies.showviews
    • View: components.document-chartsviews
    • View: components.sidebarviews
    • View: components.document-tableviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: components.agency-linksviews
    • View: components.document-type-badgeviews
    • View: layouts.publicviews
    • View: components.application-logoviews
    • 1 x Application (98.4%)
      981ms
      1 x Preparing Response (56.26%)
      561ms
      1 x Booting (1.6%)
      15.95ms
      1 x Routing (0.1%)
      959μs
      46 x View (0%)
      0μs
      46 templates were rendered
      • agencies.showshow.blade.php#?blade
      • components.document-chartsdocument-charts.blade.php#?blade
      • components.sidebarsidebar.blade.php#?blade
      • components.document-tabledocument-table.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • components.agency-linksagency-links.blade.php#?blade
      • components.document-type-badgedocument-type-badge.blade.php#?blade
      • layouts.publicpublic.blade.php#?blade
      • components.application-logoapplication-logo.blade.php#?blade
      49 statements were executed (21 duplicates)Show only duplicates919ms
      • ImplicitRouteBinding.php#61mainConnection Established
        Backtrace
        • vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:966
        • vendor/livewire/livewire/src/Features/SupportPageComponents/SupportPageComponents.php:214
        • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:42
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:209
      • ImplicitRouteBinding.php#61main95.9msselect * from "agencies" where "slug" = 'transportation-statistics-bureau-bts' and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: transportation-statistics-bureau-bts
        Backtrace
        • vendor/laravel/framework/src/Illuminate/Routing/ImplicitRouteBinding.php:61
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:966
        • vendor/livewire/livewire/src/Features/SupportPageComponents/SupportPageComponents.php:214
        • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:42
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:209
      • AgencyController.php#69main246msselect "documents"."id", "documents"."title", "documents"."abstract", "documents"."type", "documents"."publication_date", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."document_id" as "pivot_document_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "documents" inner join "agency_document" on "documents"."id" = "agency_document"."document_id" where "agency_document"."agency_id" = 432 order by "publication_date" desc limit 20
        Bindings
        • 0: 432
        Backtrace
        • app/Http/Controllers/AgencyController.php:69
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:64
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AgencyController.php#86main10.14msselect "id", "name", "slug", "short_name", "parent_id", "image_url", "doc_count" from "agencies" where "parent_id" = 432 and "doc_count" > 0 and "latest_publication_date" >= '2020-04-14 21:22:14' order by "name" asc
        Bindings
        • 0: 432
        • 1: 0
        • 2: 2020-04-14 21:22:14
        Backtrace
        • app/Http/Controllers/AgencyController.php:86
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:77
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AgencyController.php#93main9.64msselect * from "related_entities" where "related_entities"."entity_type" = 'App\Models\Agency' and "related_entities"."entity_id" = 432 and "related_entities"."entity_id" is not null and "related_entity_type" = 'App\Models\Topic' order by "common_documents_count" desc, "score" desc
        Bindings
        • 0: App\Models\Agency
        • 1: 432
        • 2: App\Models\Topic
        Backtrace
        • app/Http/Controllers/AgencyController.php:93
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:91
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AgencyController.php#94main7.06msselect * from "related_entities" where "related_entities"."entity_type" = 'App\Models\Agency' and "related_entities"."entity_id" = 432 and "related_entities"."entity_id" is not null and "related_entity_type" = 'App\Models\SuggestedSearch' order by "common_documents_count" desc, "score" desc
        Bindings
        • 0: App\Models\Agency
        • 1: 432
        • 2: App\Models\SuggestedSearch
        Backtrace
        • app/Http/Controllers/AgencyController.php:94
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:91
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AgencyController.php#94main6.93msselect "id", "name", "slug" from "suggested_searches" where "suggested_searches"."id" in (55) and "suggested_searches"."deleted_at" is null
        Backtrace
        • app/Http/Controllers/AgencyController.php:94
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:91
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AgencyController.php#105main6.93msselect * from "agencies" where "id" < 432 and "agencies"."deleted_at" is null order by "id" desc limit 1
        Bindings
        • 0: 432
        Backtrace
        • app/Http/Controllers/AgencyController.php:105
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:103
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AgencyController.php#106main6.98msselect * from "agencies" where "id" > 432 and "agencies"."deleted_at" is null order by "id" asc limit 1
        Bindings
        • 0: 432
        Backtrace
        • app/Http/Controllers/AgencyController.php:106
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:429
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:456
        • app/Http/Controllers/AgencyController.php:103
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • show.blade.php#13main8.19msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • view::agencies.show:13
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • document-table.blade.php#45main9.57msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 2714 and "agencies"."deleted_at" is null
        Bindings
        • 0: 2714
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main7.43msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main10.46msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 9047 and "agencies"."deleted_at" is null
        Bindings
        • 0: 9047
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main8.93msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main11.05msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 9469 and "agencies"."deleted_at" is null
        Bindings
        • 0: 9469
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main7.7msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main7.86msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 9456 and "agencies"."deleted_at" is null
        Bindings
        • 0: 9456
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main16.58msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main19.21msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 20042 and "agencies"."deleted_at" is null
        Bindings
        • 0: 20042
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main9.88msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main17.07msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 22415 and "agencies"."deleted_at" is null
        Bindings
        • 0: 22415
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main8.05msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main10.87msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 24763 and "agencies"."deleted_at" is null
        Bindings
        • 0: 24763
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main8.63msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main8.67msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 29118 and "agencies"."deleted_at" is null
        Bindings
        • 0: 29118
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main7.82msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main12.36msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 29142 and "agencies"."deleted_at" is null
        Bindings
        • 0: 29142
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main15.25msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main11.77msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 29116 and "agencies"."deleted_at" is null
        Bindings
        • 0: 29116
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main15.15msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main14.79msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 30874 and "agencies"."deleted_at" is null
        Bindings
        • 0: 30874
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main24.88msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main20.81msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 34217 and "agencies"."deleted_at" is null
        Bindings
        • 0: 34217
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main8.67msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main8.73msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 34219 and "agencies"."deleted_at" is null
        Bindings
        • 0: 34219
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main7.07msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main22.79msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 36245 and "agencies"."deleted_at" is null
        Bindings
        • 0: 36245
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main9.48msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main19.77msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 36795 and "agencies"."deleted_at" is null
        Bindings
        • 0: 36795
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main9.75msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main19.66msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 39245 and "agencies"."deleted_at" is null
        Bindings
        • 0: 39245
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main14.47msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main8.95msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 39194 and "agencies"."deleted_at" is null
        Bindings
        • 0: 39194
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main8.79msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main24.09msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 44493 and "agencies"."deleted_at" is null
        Bindings
        • 0: 44493
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main6.73msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main17.84msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 46614 and "agencies"."deleted_at" is null
        Bindings
        • 0: 46614
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main6.49msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • document-table.blade.php#45main35.9msselect "agencies".*, "agency_document"."document_id" as "pivot_document_id", "agency_document"."agency_id" as "pivot_agency_id", "agency_document"."is_primary" as "pivot_is_primary", "agency_document"."created_at" as "pivot_created_at", "agency_document"."updated_at" as "pivot_updated_at" from "agencies" inner join "agency_document" on "agencies"."id" = "agency_document"."agency_id" where "agency_document"."document_id" = 54875 and "agencies"."deleted_at" is null
        Bindings
        • 0: 54875
        Backtrace
        • view::components.document-table:45
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • AgencyLinks.php#40main7.11msselect * from "agencies" where "agencies"."id" = 429 and "agencies"."deleted_at" is null limit 1
        Bindings
        • 0: 429
        Backtrace
        • app/View/Components/AgencyLinks.php:40
        • app/View/Components/AgencyLinks.php:21
        • vendor/laravel/framework/src/Illuminate/View/Component.php:143
        • view::components.document-table:51
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      App\Models\Agency
      64Agency.php#?
      App\Models\Document
      20Document.php#?
      App\Models\RelatedEntity
      1RelatedEntity.php#?
      App\Models\SuggestedSearch
      1SuggestedSearch.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-04-14 21:22:15GET/agencies/transportation-statistics-bureau-bts464986