This plugin enables the handling of restful style requests in Joomla. One or more additional plugins must be deployed to implement specific services. The service plugins must be in the folder restful, and provide details of the URIs and calls to be handled in response to the onRestfulPaths trigger. An  example is:

    public function onRestfulPaths($context, &$paths) {
        if ('plg_system_restful' == $context) {
            $paths['/myrestful/myaction'] = array('POST' => array($this, 'myaction'));
            $paths['/myrestful/test'] = array('GET' => array($this, 'test'));
        }
    }
 
The way this works is that if, for example, a POST request is made to https://example.com/myrestful/myaction then the callable array($this, 'myaction') is invoked. This means that the service plugin must have a method called myaction. The call does not have to be to the service plugin, it can be to anywhere that the service plugin can construct a callable for. Anything that is a valid PHP callable can be used here.
 
 So the service plugin might implement a method:

      public function myaction($uri, $restful) {
        echo "The URI $uri resulted in myaction being called";
        // Do something
    }


The $uri in this case will contain "/myrestful/myaction". The instance of this plugin is passed as the second parameter, $restful. It can be used to call the helpful methods shown here:
 
 authenticateUser($username, $password)
 authenticateUserAndGroup($username, $password, $groups)
 getHeaderUserPass()
 respondAndExit($response_object, $response_code, $response_message)
 

The first two of these return true or false. The third will return an array with two elements - username and password - provided a valid Basic Authorization header is received. The fourth accepts an arbitrary object that is converted to JSON and returned as the HTTP response, along with a result header based on the provided response code and message.


 Note that for getHeaderUserPass to work, an HTTP Basic Authorization header  must be supplied by the caller. Basic Authorization must be used only with  SSL as otherwise username and password are being passed insecurely.

You can find the plugin here. You can also download an example (it doesn't do anything useful but demonstrates how to implement a service) here.
 

Is there anything we can help you with in this morning ?

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

3.532MBMemory Usage189msRequest Duration
Joomla! Version5.2.5
PHP Version8.2.28
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.11.6-MariaDB-0+deb12u1-log
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:2 [ "aliro_auth" => array:5 [ "subj_found" => & [] "permissions" => & [] "access...
$_COOKIE
[]
$_SERVER
array:54 [ "USER" => "remos" "HOME" => "/var/www/remos" "SCRIPT_NAME" => "" "REQUEST_URI" =>...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1742014366 "last" => 1742014366...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
gtag
false
  • afterLoad (73.79KB) (767μs)
  • afterInitialise (1.02MB) (35.47ms)
  • afterRoute (149.22KB) (7.17ms)
  • beforeRenderComponent com_content (117.46KB) (5.77ms)
  • Before Access::preloadComponents (all components) (44.21KB) (6.41ms)
  • After Access::preloadComponents (all components) (122.09KB) (4.65ms)
  • Before Access::preloadPermissions (com_content) (424B) (55μs)
  • After Access::preloadPermissions (com_content) (10.01KB) (1.39ms)
  • Before Access::getAssetRules (id:134 name:com_content.article.3) (744B) (42μs)
  • After Access::getAssetRules (id:134 name:com_content.article.3) (8.16KB) (117μs)
  • Before Access::getAssetRules (id:1 name:root.1) (354.04KB) (34.36ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (99μs)
  • afterRenderComponent com_content (657.52KB) (34.26ms)
  • afterDispatch (2.27KB) (327μs)
  • beforeRenderRawModule mod_menu (Main Menu) (58.57KB) (4.22ms)
  • afterRenderRawModule mod_menu (Main Menu) (93.51KB) (3.71ms)
  • beforeRenderRawModule mod_login (Login Form) (976B) (47μs)
  • afterRenderRawModule mod_login (Login Form) (50.05KB) (1.91ms)
  • beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (42μs)
  • afterRenderRawModule mod_remositorytree (Explore Repository) (71.7KB) (16.43ms)
  • beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (413μs)
  • afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (43.53KB) (978μs)
  • beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (17μs)
  • afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (6.06KB) (8.97ms)
  • beforeRenderModule mod_menu (Main Menu) (12.26KB) (150μs)
  • afterRenderModule mod_menu (Main Menu) (4.19KB) (165μs)
  • beforeRenderModule mod_login (Login Form) (640B) (22μs)
  • afterRenderModule mod_login (Login Form) (6.47KB) (86μs)
  • beforeRenderModule mod_remositorytree (Explore Repository) (5.86KB) (20μs)
  • afterRenderModule mod_remositorytree (Explore Repository) (4.48KB) (76μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.02KB) (134μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.74KB) (1.01ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (29μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.44KB) (177μs)
  • afterRender (229.17KB) (18.41ms)
  • 1 x afterInitialise (1.02MB) (18.81%)
    35.47ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (354.04KB) (18.23%)
    34.36ms
    1 x afterRenderComponent com_content (657.52KB) (18.17%)
    34.26ms
    1 x afterRender (229.17KB) (9.77%)
    18.41ms
    1 x afterRenderRawModule mod_remositorytree (Explore Repository) (71.7KB) (8.72%)
    16.43ms
    1 x afterRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (6.06KB) (4.76%)
    8.97ms
    1 x afterRoute (149.22KB) (3.8%)
    7.17ms
    1 x Before Access::preloadComponents (all components) (44.21KB) (3.4%)
    6.41ms
    1 x beforeRenderComponent com_content (117.46KB) (3.06%)
    5.77ms
    1 x After Access::preloadComponents (all components) (122.09KB) (2.47%)
    4.65ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (58.57KB) (2.24%)
    4.22ms
    1 x afterRenderRawModule mod_menu (Main Menu) (93.51KB) (1.97%)
    3.71ms
    1 x afterRenderRawModule mod_login (Login Form) (50.05KB) (1.01%)
    1.91ms
    1 x After Access::preloadPermissions (com_content) (10.01KB) (0.74%)
    1.39ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.74KB) (0.53%)
    1.01ms
    1 x afterRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (43.53KB) (0.52%)
    978μs
    1 x afterLoad (73.79KB) (0.41%)
    767μs
    1 x beforeRenderRawModule mod_whatsapp_agent (WhatsApp Multi Agent) (4.79KB) (0.22%)
    413μs
    1 x afterDispatch (2.27KB) (0.17%)
    327μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.44KB) (0.09%)
    177μs
    1 x afterRenderModule mod_menu (Main Menu) (4.19KB) (0.09%)
    165μs
    1 x beforeRenderModule mod_menu (Main Menu) (12.26KB) (0.08%)
    150μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.02KB) (0.07%)
    134μs
    1 x After Access::getAssetRules (id:134 name:com_content.article.3) (8.16KB) (0.06%)
    117μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.05%)
    99μs
    1 x afterRenderModule mod_login (Login Form) (6.47KB) (0.05%)
    86μs
    1 x afterRenderModule mod_remositorytree (Explore Repository) (4.48KB) (0.04%)
    76μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.03%)
    55μs
    1 x beforeRenderRawModule mod_login (Login Form) (976B) (0.03%)
    47μs
    1 x Before Access::getAssetRules (id:134 name:com_content.article.3) (744B) (0.02%)
    42μs
    1 x beforeRenderRawModule mod_remositorytree (Explore Repository) (704B) (0.02%)
    42μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0.02%)
    29μs
    1 x beforeRenderModule mod_login (Login Form) (640B) (0.01%)
    22μs
    1 x beforeRenderModule mod_remositorytree (Explore Repository) (5.86KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_whatsapp_agent (WhatsApp Multi Agent) (736B) (0.01%)
    17μs
44 statements were executed, 6 of which were duplicates, 38 unique78.11ms138.56KB
  • SELECT @@SESSION.sql_mode;236μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?744μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1175μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.63ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1863μs17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`333μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest3.49ms1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.07ms4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));223μs640B/administrator/components/com_osmembership/loader.php:95Copy
  • 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 `jos_menu` AS `m` LEFT JOIN `jos_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`1.38ms19.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `config_key`,`config_value` FROM jos_osmembership_configs800μs3.06KB/administrator/components/com_osmembership/libraries/mpf/config/config.php:42Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC344μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_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` = 1614μs832B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_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,:preparedArray43,:preparedArray44)1.19ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0705μs1.98KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.33ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '3'5.48ms1.3KB/libraries/src/Table/Table.php:1348Copy
  • 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 `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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) AND `a`.`state` IN (:preparedArray1,:preparedArray2)1.86ms6.12KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`806μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)784μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT NOW()3.01ms536B/components/com_userpoints/src/Problems/SQL.php:31Copy
  • SELECT UNIX_TIMESTAMP(NOW())318μs536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SHOW TABLES LIKE 'jos_downloads_repository'776μs520B/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:143Copy
  • SELECT COUNT(`id`) FROM `jos_usergroups`373μs536B/libraries/src/Helper/UserGroupsHelper.php:207Copy
  • SELECT * FROM `jos_usergroups` ORDER BY `lft` ASC387μs976B/libraries/src/Helper/UserGroupsHelper.php:266Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`1.13ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC1.94ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT role, subject_id, action FROM jos_permissions WHERE subject_type = 'remosFolder' AND action IN('download','edit')451μs1.13KBsameCopy
  • SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'hidden' THEN 2 ELSE 99 END) menorder, (CASE type WHEN 'url' THEN 2 ELSE 1 END) typorder FROM jos_menu WHERE link LIKE 'index.php?option=com_remository&view=remository%' AND type LIKE 'component%' AND published=1 ORDER BY typorder, menorder481μs656BsameCopy
  • SELECT COUNT(*) FROM `jos_alpha_userpoints`302μs536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SHOW FIELDS FROM `jos_alpha_userpoints`966μs1.05KB/components/com_userpoints/src/Problems/SQL.php:56Copy
  • SELECT *, id AS rid FROM `jos_alpha_userpoints_combined` WHERE userid = 1881.24ms2.78KB/components/com_userpoints/src/Problems/SQL.php:65Copy
  • SELECT referreid FROM jos_alpha_userpoints WHERE `referreid`='SELF6643675544B7D5.01584835' AND `published`='1'398μs3.02KB/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT * FROM `jos_alpha_userpoints_rules`509μs5.05KB/components/com_userpoints/src/Problems/SQL.php:56Copy
  • SHOW FIELDS FROM `jos_alpha_userpoints_rules`1.18ms1.42KB/components/com_userpoints/src/Problems/SQL.php:56Copy
  • SELECT UNIX_TIMESTAMP(NOW())185μs536B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT `id` FROM jos_alpha_userpoints_details WHERE `keyreference`= '3|18.117.114.128|67d5079e1e6c0' AND enabled='1'442μs520B/components/com_userpoints/src/Problems/SQL.php:74Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_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) ORDER BY `m`.`position`,`m`.`ordering`2.21ms1.89KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `path`, `link` FROM `jos_menu` WHERE `link` LIKE '%remository%' AND `published` > 0 AND `client_id` = 0633μs608BsameCopy
  • SELECT * FROM `jos_schemaorg` WHERE `itemId` = :itemId AND `context` = :context1.34ms17.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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) AND `a`.`state` IN (:preparedArray1,:preparedArray2)1.18ms6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1502μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?253μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?32.86ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy