The 7(a) Loan Guaranty Program is the SBA's primary loan program. The SBA reduces risk to lenders by guaranteeing major portions of loans made to small businesses. This enables the lenders to provide financing to small businesses when funding is otherwise unavailable on reasonable terms. The eligibility requirements and credit criteria of the program are very broad in order to accommodate a wide range of financing needs.

When a small business applies to a lending institution for a loan, the lender reviews the application and decides if it merits a loan on its own or if it requires additional support in the form of an SBA guaranty. SBA backing on the loan is then requested by the lender. In guaranteeing the loan, the SBA assures the lender that, in the event the borrower does not repay the loan, the government will reimburse the lending institution for its loss. By providing this guaranty, the SBA is able to help tens of thousands of small businesses every year get financing they would not otherwise obtain.

To qualify for an SBA guaranty, a small business must meet the 7(a) criteria, and the lender must certify that it could not provide funding on reasonable terms except with an SBA guaranty. The SBA can then guarantee as much as 80 percent on loans of up to $100,000 and 75 percent on loans of more than $100,000. In most cases, the maximum guaranty is $750,000 (75 percent of $1 million). Exceptions are the International Trade, DELTA and 504 loan programs, which have higher loan limits.

How It Works

You submit a loan application to a lender for initial review. If the lender approves the loan subject to an SBA guaranty, a copy of the application and a credit analysis are forwarded by the lender to the nearest SBA office. After SBA approval, the lending institution closes the loan and disburses the funds; you make monthly loan payments directly to the lender. As with any loan, you are responsible for repaying the full amount of the loan. There are no balloon payments, prepayment penalties, application fees or points permitted with 7(a) loans. Repayment plans may be tailored to each individual business.

Use of Proceeds

  • You can use a 7(a) loan to:
  • purchase land or buildings;
  • construct commercial buildings;
  • finance seasonal lines of credit;
  • refinance existing debt (with compelling reason);
  • finance receivables and augment working capital;
  • purchase machinery, equipment, fixtures and leasehold improvements;
  • expand or renovate facilities.

Terms, Interest Rates and Fees

The length of time for repayment depends on the use of the proceeds and the ability of your business to repay:

  • usually five to 10 years for working capital, and
  • up to 25 years for fixed assets such as the purchase or major renovation of real estate or purchase of equipment (not to exceed the useful life of the equipment).

Both fixed and variable interest rates are available. Rates are pegged at no more than 2.25 percent over the lowest prime rate (as published in the Wall Street Journal on the day the application is received by the SBA) for loans up to 2.75 percent for seven years or longer. For loans under $50,000, rates may be slightly higher.

The SBA charges the lender a nominal fee to provide a guaranty, and the lender may pass this charge on to you. The fee is based on the maturity of the loan and the dollar amount that the SBA guarantees. On any loan with a maturity of one year or less, the fee is just 0.25 percent of the guaranteed portion of the loan. On loans with maturities of more than one year where the portion that the SBA guarantees is $80,000 or less, the guaranty fee is 2 percent of the guaranteed portion. On loans with maturities of more than one year where the SBA's portion exceeds $80,000, the guaranty fee is figured on an incremental scale, beginning at 3 percent.

Collateral

You must pledge sufficient assets, to the extent that they are reasonably available, to adequately secure the loan. Personal guaranties are required from all the principal owners of the business. Liens on personal assets of the principals also may be required. However, in most cases a loan will not be declined where insufficient collateral is the only unfavorable factor.

Eligibility

Your business generally must be operated for profit and fall within the size standards set by the SBA. The SBA determines if the business qualifies as a small business based on the average number of employees during the preceding 12 months or on sales averaged over the previous three years. Loans cannot be made to businesses engaged in speculation or investment.

Maximum Size Standards

  • Manufacturing -- from 500 to 1,500 employees
  • Wholesaling -- 100 employees
  • Services -- from $2.5 million to $21.5 million in annual receipts
  • Retailing -- from $5 million to $21 million
  • General construction -- from $13.5 million to $17 million
  • Special trade construction -- average annual receipts not to exceed $7 million
  • Agriculture -- from $0.5 million to $9 million

What You Need to Take to the Lender

Documentation requirements may vary; contact your lender for the information you must supply. Common requirements include the following:

  • Projected opening day balance sheet (new business)
  • Aging of accounts receivable and payable (existing businesses)
  • Schedule of term debts (existing businesses)
  • Financial statements for three years (existing businesses)
  • History of the business
  • Purpose of loan
  • Lease details
  • Amount of investment in the business by the owner(s)
  • Projections of income, expenses and cash flow
  • Signed personal financial statements
  • Personal resume(s)

What the SBA Looks For

  • Good character
  • Management expertise and commitment necessary for success
  • Sufficient funds, including the SBA-guaranteed loan, to operate the business on a sound financial basis (for new businesses, this includes the resources to withstand start-up expenses and the initial operating phase)
  • Feasible business plan
  • Adequate equity or investment in the business
  • Sufficient collateral
  • Ability to repay the loan on time from the projected operating cash flow

Specialized Programs Under 7(A)

In addition to the standard loan guaranty, the SBA has two categories of targeted programs under 7(a): those that are designed to meet the specialized needs of borrowers and those that meet the various needs of lenders.

Programs for borrowers include CAPLines, the International Trade Loan and Export Working Capital programs, and DELTA. Lender programs provide the SBA's guaranty in various ways with different responsibilities. These include the Minority and Women's Prequalification Loan programs, LowDoc, FA$TRAK, and the Certified and Preferred Lenders Program.

Unless otherwise indicated, these are governed by the same rules, regulations, interest rates, fees, etc. as the regular 7(a) loan guaranty.

 
 

 

10MBMemory Usage101msRequest Duration
Joomla! Version4.2.8
PHP Version8.0.30
Identityguest
Response200
Templatert_requiem
Database
Server
mysql
Version
10.6.21-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:73 [ "USER" => "cftech5" "HOME" => "/home/cftech5" "SCRIPT_NAME" => "/index.php" "REQU...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743026063 "last" => 1743026063...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (568.66KB) (1.55ms)
  • afterInitialise (2.03MB) (13.53ms)
  • afterRoute (1.37MB) (9.27ms)
  • beforeRenderComponent com_content (38.9KB) (464μs)
  • Before Access::preloadComponents (all components) (137.66KB) (747μs)
  • After Access::preloadComponents (all components) (116.36KB) (805μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (16μs)
  • After Access::preloadPermissions (com_content) (563.66KB) (3.43ms)
  • Before Access::getAssetRules (id:346 name:com_content.article.212) (34.8KB) (41μs)
  • After Access::getAssetRules (id:346 name:com_content.article.212) (9.77KB) (103μs)
  • afterRenderComponent com_content (661.23KB) (11.88ms)
  • Before Access::getAssetRules (id:8 name:com_content) (23.1KB) (1.11ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.95KB) (37μs)
  • afterDispatch (13.23KB) (497μs)
  • beforeRenderRawModule mod_custom (Joomla Header Mobile) (966.56KB) (7.03ms)
  • afterRenderRawModule mod_custom (Joomla Header Mobile) (7.52KB) (473μs)
  • beforeRenderModule mod_custom (Joomla Header Mobile) (720B) (8μs)
  • afterRenderModule mod_custom (Joomla Header Mobile) (4.3KB) (113μs)
  • beforeRenderRawModule mod_custom (Google Search Cftech.com) (1.83KB) (241μs)
  • afterRenderRawModule mod_custom (Google Search Cftech.com) (992B) (75μs)
  • beforeRenderModule mod_custom (Google Search Cftech.com) (736B) (4μs)
  • afterRenderModule mod_custom (Google Search Cftech.com) (2.57KB) (55μs)
  • beforeRenderRawModule mod_custom (Amazon Bottom Banner) (1.16MB) (15.86ms)
  • afterRenderRawModule mod_custom (Amazon Bottom Banner) (1.02KB) (101μs)
  • beforeRenderModule mod_custom (Amazon Bottom Banner) (720B) (4μs)
  • afterRenderModule mod_custom (Amazon Bottom Banner) (2.32KB) (74μs)
  • beforeRenderRawModule mod_gantry5_particle (Footer Navigation) (11.2KB) (1.12ms)
  • afterRenderRawModule mod_gantry5_particle (Footer Navigation) (35.52KB) (1.8ms)
  • beforeRenderModule mod_gantry5_particle (Footer Navigation) (736B) (7μs)
  • afterRenderModule mod_gantry5_particle (Footer Navigation) (10.02KB) (85μs)
  • afterRender (1.35MB) (26.53ms)
  • 1 x afterRender (1.35MB) (26.33%)
    26.53ms
    1 x beforeRenderRawModule mod_custom (Amazon Bottom Banner) (1.16MB) (15.74%)
    15.86ms
    1 x afterInitialise (2.03MB) (13.43%)
    13.53ms
    1 x afterRenderComponent com_content (661.23KB) (11.79%)
    11.88ms
    1 x afterRoute (1.37MB) (9.2%)
    9.27ms
    1 x beforeRenderRawModule mod_custom (Joomla Header Mobile) (966.56KB) (6.97%)
    7.03ms
    1 x After Access::preloadPermissions (com_content) (563.66KB) (3.41%)
    3.43ms
    1 x afterRenderRawModule mod_gantry5_particle (Footer Navigation) (35.52KB) (1.78%)
    1.80ms
    1 x afterLoad (568.66KB) (1.54%)
    1.55ms
    1 x beforeRenderRawModule mod_gantry5_particle (Footer Navigation) (11.2KB) (1.12%)
    1.12ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (23.1KB) (1.1%)
    1.11ms
    1 x After Access::preloadComponents (all components) (116.36KB) (0.8%)
    805μs
    1 x Before Access::preloadComponents (all components) (137.66KB) (0.74%)
    747μs
    1 x afterDispatch (13.23KB) (0.49%)
    497μs
    1 x afterRenderRawModule mod_custom (Joomla Header Mobile) (7.52KB) (0.47%)
    473μs
    1 x beforeRenderComponent com_content (38.9KB) (0.46%)
    464μs
    1 x beforeRenderRawModule mod_custom (Google Search Cftech.com) (1.83KB) (0.24%)
    241μs
    1 x afterRenderModule mod_custom (Joomla Header Mobile) (4.3KB) (0.11%)
    113μs
    1 x After Access::getAssetRules (id:346 name:com_content.article.212) (9.77KB) (0.1%)
    103μs
    1 x afterRenderRawModule mod_custom (Amazon Bottom Banner) (1.02KB) (0.1%)
    101μs
    1 x afterRenderModule mod_gantry5_particle (Footer Navigation) (10.02KB) (0.08%)
    85μs
    1 x afterRenderRawModule mod_custom (Google Search Cftech.com) (992B) (0.07%)
    75μs
    1 x afterRenderModule mod_custom (Amazon Bottom Banner) (2.32KB) (0.07%)
    74μs
    1 x afterRenderModule mod_custom (Google Search Cftech.com) (2.57KB) (0.05%)
    55μs
    1 x Before Access::getAssetRules (id:346 name:com_content.article.212) (34.8KB) (0.04%)
    41μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.95KB) (0.04%)
    37μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.02%)
    16μs
    1 x beforeRenderModule mod_custom (Joomla Header Mobile) (720B) (0.01%)
    8μs
    1 x beforeRenderModule mod_gantry5_particle (Footer Navigation) (736B) (0.01%)
    7μs
    1 x beforeRenderModule mod_custom (Google Search Cftech.com) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Amazon Bottom Banner) (720B) (0%)
    4μs
43 statements were executed, 5 of which were duplicates, 38 unique17.24ms805.16KB
  • SELECT @@SESSION.sql_mode;56μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `gls_session` WHERE `session_id` = ?174μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `gls_session` WHERE `session_id` = :session_id LIMIT 197μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `gls_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.31ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `gls_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1304μs5.36KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `gls_viewlevels`92μs1.11KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `gls_usergroups` AS `a` LEFT JOIN `gls_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest147μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `gls_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`565μs16.8KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • SELECT * FROM `gls_languages` WHERE `published` = 1 ORDER BY `ordering` ASC162μs3.69KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `gls_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1121μs1.22KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `gls_menu` AS `m` LEFT JOIN `gls_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`947μs304.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `gls_categories` AS `s` INNER JOIN `gls_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`509μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `gls_template_styles` AS `s` LEFT JOIN `gls_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1196μs1.69KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM gls_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_requiem' ORDER BY s.id159μs1.42KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `gls_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42)451μs10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `gls_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 02.44ms137.8KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `gls_content` AS `a` INNER JOIN `gls_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `gls_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `gls_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `gls_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `gls_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)320μs27.98KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `gls_categories` AS `s` INNER JOIN `gls_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`338μs6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `gls_contentitem_tag_map` AS `m` INNER JOIN `gls_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)1.6ms5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `gls_categories` AS `s` INNER JOIN `gls_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`323μs6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM gls_fields AS a LEFT JOIN `gls_languages` AS l ON l.lang_code = a.language LEFT JOIN gls_users AS uc ON uc.id=a.checked_out LEFT JOIN gls_viewlevels AS ag ON ag.id = a.access LEFT JOIN gls_users AS ua ON ua.id = a.created_user_id LEFT JOIN gls_fields_groups AS g ON g.id = a.group_id LEFT JOIN `gls_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC776μs6.58KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • SELECT `field_id`,`value` FROM `gls_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid139μs1.69KBParams/administrator/components/com_fields/src/Model/FieldModel.php:724Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `gls_categories` AS `s` INNER JOIN `gls_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`339μs6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `language`,`id` FROM `gls_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0203μs944B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `gls_content` WHERE `id` = :id67μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `gls_content` WHERE `id` = :id50μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `gls_content` AS `c` INNER JOIN `gls_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `gls_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `gls_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `gls_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-03-26 21:54:23') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-26 21:54:23') AND c2.state = 1154μs1.78KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `gls_modules` AS `m` LEFT JOIN `gls_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `gls_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`2.08ms136.66KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `gls_menu_types` AS `a` WHERE `a`.`client_id` = 0118μs1.25KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM gls_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft483μs31.55KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `gls_scheduler_tasks` AS `a` LEFT JOIN `gls_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc392μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `gls_scheduler_tasks` AS `a` LEFT JOIN `gls_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc161μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT * FROM `gls_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'171μs15.09KB/plugins/system/nrframework/NRFramework/Extension.php:124Copy
  • SHOW FULL COLUMNS FROM `gls_gsd_config`284μs2.23KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • SELECT * FROM `gls_gsd_config` WHERE `name` = 'config'67μs944B/libraries/src/Table/Table.php:750Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `gls_content` AS `a` INNER JOIN `gls_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `gls_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `gls_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `gls_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `gls_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)324μs25.38KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT a.* FROM gls_gsd a WHERE a.state = 1 AND a.plugin = 'content' AND a.appview IN ('article','*') AND a.language IN ('en-GB','*') ORDER BY a.id desc176μs2.45KB/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • SELECT count(id) FROM gls_users WHERE id = '994'108μs872B/plugins/system/nrframework/NRFramework/User.php:67Copy
  • SHOW FULL COLUMNS FROM `gls_users`313μs4.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • SELECT * FROM `gls_users` WHERE `id` = :userid111μs4.73KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `gls_usergroups` AS `g` INNER JOIN `gls_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid132μs1.71KBParams/libraries/src/Table/User.php:132Copy
  • SELECT a.* FROM gls_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') AND a.language IN ('en-GB','*') ORDER BY a.id desc155μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • SELECT m.item_id as id, m.item_id, m.description as metadescription, m.description, m.title as metatitle, m.title FROM gls_osmeta_metadata m WHERE m.item_id='21' AND m.item_type='4'123μs1.11KB/administrator/components/com_osmeta/library/Free/Container/AbstractContainer.php:140Copy