K-Tec

NEOCP objects in TheSkyX

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
11 years 1 month ago #99860 by albertw
NEOCP objects in TheSkyX was created by albertw
Hi,

I use TheSkyX to control my mount and camera and there is no easy/free way to get objects posted on the MPC NEOCP into TheSkyX. Copying and pasting ephemeris or orbit data gets tiresome very quickly! Once the objects are there it becomes easier to select suitable objects and image them.

So I wrote a little app to download the NEOCP and create asteroid databases for TheSkyX, and also observations for find_orb. If you have a version that includes the TCP server then you can also use it to get the alt, az, rate and position angle.

Download: github.com/albertw/NEOCPhelper/releases/...v1.0/NEOCPHelper.jar
You'll need a recent enough version of Java to run it.

Source code at github.com/albertw/NEOCPhelper

Thanks to Michael O'Connel for helping out with testing. Actually this may only be of interest to myself and Michael as others who do follow up asteroid observations probably are using ACP or the likes!

Cheers,
~Al

Albert White MSc FRAS
Chairperson, International Dark Sky Association - Irish Section
www.darksky.ie/

Please Log in or Create an account to join the conversation.

More
11 years 1 month ago #99866 by michaeloconnell
Replied by michaeloconnell on topic NEOCP objects in TheSkyX
Al,
Thanks for posting this. Been very busy lately.
Hopefully it is helpful to others here too.
I have tried both the small and large functions and they both work.
Thanks very much for producing this tool.
Very useful.
Just one question: How should I use the FindOrb file?
Thanks,
Michael.

Please Log in or Create an account to join the conversation.

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
11 years 1 month ago #99870 by albertw
Replied by albertw on topic NEOCP objects in TheSkyX
Hi Michael,

Download Find Orb from www.projectpluto.com/find_orb.htm and you can load the observations file into that.

Find Orb then uses the observations to estimate an orbit, and you can see the residuals of individual observations from the computed orbit. So if you add your own observations (MPC format) to the file you can see how your observations have refined the orbit, and also from the residuals you can see how far 'off' your observations are from the computed orbit. Or if you have a couple of nights of observations you can use just them to model 'your' orbit and see how that compares to the orbit with other observations.

It's interesting to play with but unless you deeply understand celestial mechanics and modelling probably not that much practical use.

Cheers,
~Al

Albert White MSc FRAS
Chairperson, International Dark Sky Association - Irish Section
www.darksky.ie/

Please Log in or Create an account to join the conversation.

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
10 years 5 months ago #101867 by albertw
Replied by albertw on topic NEOCP objects in TheSkyX
JavaFX was starting to do my head in, so I've reverted to something I know a bit better and rewrote it in python and tk. I don't have a nice packaged up version yet, but if you have python installed this should run fine.

What I've added this time is a very experimental imaging scheduler, so you give it a list of targets, a number of exposures, and an exposure time and it goes and images them using your existing settings in theSkyX for the camera and telescope.

It's restricted to TheSkyX and the corresponding camera add on since that's what I use.

Code is at github.com/albertw/AutoSkyX/ several bugs, lots of additions needed, but I thought I'd share in case anyone is interested

Albert White MSc FRAS
Chairperson, International Dark Sky Association - Irish Section
www.darksky.ie/

Please Log in or Create an account to join the conversation.

Time to create page: 0.129 seconds
Powered by Kunena Forum
9MBMemory Usage181msRequest Duration
Joomla! Version4.3.4
PHP Version8.4.4
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.6.18-MariaDB-0ubuntu0.22.04.1
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:42 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate,...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1742270084 "last" => 1742270084...
registry
array:3 [ "data" => array:3 [ "com_kunena" => array:2 [ "user0_read" => array:32 [ ...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (456.27KB) (814μs)
  • afterInitialise (1.16MB) (12.8ms)
  • afterRoute (187.07KB) (3.47ms)
  • beforeRenderComponent com_kunena (30.37KB) (2ms)
  • Before Access::preloadComponents (all components) (1.37MB) (74.8ms)
  • After Access::preloadComponents (all components) (119.01KB) (837μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (21μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (51μs)
  • afterRenderComponent com_kunena (1.81MB) (54.55ms)
  • afterDispatch (18.34KB) (195μs)
  • beforeRenderRawModule mod_cblogin (Login) (75.99KB) (517μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (171μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (18μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (550μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (30μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.59ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (10μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (7.64ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (48μs)
  • afterRenderRawModule mod_menu (Main Menu) (170.3KB) (1.48ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (28μs)
  • afterRenderRawModule mod_finder (Search) (357.51KB) (3.18ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (27μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.02KB) (3.44ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (42μs)
  • afterRenderRawModule mod_menu (footermenu) (60.16KB) (480μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (160μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (73μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (58μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (54μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (15μs)
  • afterRenderModule mod_custom (Network Online!) (2.82KB) (25μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (25μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (21μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (96μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.87KB) (660μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (44μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (65μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (37μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (45μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (21μs)
  • beforeRenderModule mod_menu (Main Menu) (7.88KB) (41μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (21μs)
  • afterRender (738.01KB) (6.99ms)
  • 1 x Before Access::preloadComponents (all components) (1.37MB) (41.27%)
    74.80ms
    1 x afterRenderComponent com_kunena (1.81MB) (30.1%)
    54.55ms
    1 x afterInitialise (1.16MB) (7.06%)
    12.80ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (4.22%)
    7.64ms
    1 x afterRender (738.01KB) (3.86%)
    6.99ms
    1 x afterRoute (187.07KB) (1.91%)
    3.47ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.02KB) (1.9%)
    3.44ms
    1 x afterRenderRawModule mod_finder (Search) (357.51KB) (1.75%)
    3.18ms
    1 x beforeRenderComponent com_kunena (30.37KB) (1.1%)
    2.00ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.88%)
    1.59ms
    1 x afterRenderRawModule mod_menu (Main Menu) (170.3KB) (0.82%)
    1.48ms
    1 x After Access::preloadComponents (all components) (119.01KB) (0.46%)
    837μs
    1 x afterLoad (456.27KB) (0.45%)
    814μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.87KB) (0.36%)
    660μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.3%)
    550μs
    1 x beforeRenderRawModule mod_cblogin (Login) (75.99KB) (0.29%)
    517μs
    1 x afterRenderRawModule mod_menu (footermenu) (60.16KB) (0.26%)
    480μs
    1 x afterDispatch (18.34KB) (0.11%)
    195μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.09%)
    171μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.09%)
    160μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.05%)
    96μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.04%)
    73μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.04%)
    65μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.03%)
    58μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.03%)
    54μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.03%)
    51μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    48μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.02%)
    45μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    44μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.02%)
    42μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.02%)
    41μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.02%)
    37μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.02%)
    28μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.01%)
    25μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.01%)
    25μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (0.01%)
    21μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.01%)
    21μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    21μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (Network Online!) (8.96KB) (0.01%)
    15μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0.01%)
    10μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    5μs
108 statements were executed, 10 of which were duplicates, 98 unique27.92ms424.45KB
  • SELECT @@SESSION.sql_mode;47μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?108μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 177μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `tifas_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.19ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tifas_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1234μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`86μs672B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `tifas_usergroups` AS `a` LEFT JOIN `tifas_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest99μs1.3KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `tifas_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`949μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 1311μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 1248μs536B/libraries/kunena/src/Forum/KunenaForum.php:372Copy
  • 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 `tifas_menu` AS `m` LEFT JOIN `tifas_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`607μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '28-computers-in-astronomy%'142μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES1.06ms8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC171μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `tifas_template_styles` AS `s` LEFT JOIN `tifas_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` = 1232μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`459μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`645μs3.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tifas_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,:preparedArray45,:preparedArray46)408μs7.69KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT DISTINCT(user_id) FROM `tifas_usergroups` AS `ug1` INNER JOIN `tifas_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt INNER JOIN `tifas_user_usergroup_map` AS `m` ON ug2.id = m.group_id WHERE ug1.id IN ( 8)649μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT DISTINCT(user_id) FROM `tifas_usergroups` AS `ug1` INNER JOIN `tifas_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt INNER JOIN `tifas_user_usergroup_map` AS `m` ON ug2.id = m.group_id WHERE ug1.id IN ( 7)786μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)125μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`318μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`615μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'144μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'140μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'147μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'328μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'152μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'135μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'146μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'275μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'145μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'154μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'158μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'305μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'148μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`358μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '99766'158μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`383μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT m.*,t.message FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages_text` AS `t` ON `m`.`id` = `t`.`mesid` WHERE `m`.`id` = 99860149μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '99766' AND `a`.`hold` IN (0)191μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '99766' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 6162μs584B/libraries/kunena/src/Database/Object/KunenaFinder.php:234Copy
  • SELECT m.*, t.message FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages_text` AS `t` ON m.id = t.mesid WHERE `m`.`id` IN (99866,99870,101867)181μs2.56KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (99860,99866,99870,101867)104μs688B/libraries/kunena/src/Forum/Message/Thankyou/KunenaMessageThankyouHelper.php:116Copy
  • SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid FROM `tifas_users` AS `u` LEFT JOIN `tifas_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid` WHERE `u`.`id` IN (69,95)268μs25.02KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99860,99866,99870,101867)112μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (99766))97μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`360μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`77μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '99766'383μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tifas_modules` AS `m` LEFT JOIN `tifas_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tifas_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)) 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`694μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`350μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`108μs1.48KB/libraries/kunena/src/User/KunenaUser.php:1629Copy
  • SELECT userid, MAX(time) AS time FROM `tifas_session` WHERE `client_id` = 0 AND `userid` > 0 AND `time` > '1742268284' GROUP BY `userid` ORDER BY `time` DESC182μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99860)138μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99860)107μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99866)124μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99866)103μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (99866) GROUP BY `m`.`id`,`mm`.`hold`213μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99870)111μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99870)95μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (99870) GROUP BY `m`.`id`,`mm`.`hold`204μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (101867)103μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (101867)112μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • 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 tifas_fields AS a LEFT JOIN `tifas_languages` AS l ON l.lang_code = a.language LEFT JOIN tifas_users AS uc ON uc.id=a.checked_out LEFT JOIN tifas_viewlevels AS ag ON ag.id = a.access LEFT JOIN tifas_users AS ua ON ua.id = a.created_user_id LEFT JOIN tifas_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC766μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `tifas_kunena_announcement` WHERE `published` = 1 AND (`publish_up` = '1000-01-01 00:00:00' OR `publish_up` <= '2025-03-18 03:54:44') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-03-18 03:54:44') ORDER BY `id` DESC LIMIT 1109μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`624μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • 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 `tifas_categories` AS `c` WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 ORDER BY `c`.`lft`313μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT c.id FROM tifas_categories AS c WHERE c.access IN (1) AND c.published = 1 AND c.language in ('en-GB','*') AND c.extension = 'com_jevents' ORDER BY c.lft asc285μs584B/components/com_jevents/libraries/dbmodel.php:547Copy
  • SELECT c.id FROM tifas_categories AS c WHERE c.access IN (1) AND c.published = 1 AND c.language in ('en-GB','*') AND c.extension = 'com_jevents' AND ((c.lft>=87 AND c.rgt<=88 )) ORDER BY c.lft asc174μs536B/components/com_jevents/libraries/dbmodel.php:547Copy
  • SELECT ev.ev_id FROM tifas_jevents_repetition as rpt INNER JOIN tifas_jevents_vevent as ev ON rpt.eventid = ev.ev_id INNER JOIN tifas_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid INNER JOIN tifas_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN tifas_jevents_rrule as rr ON rr.eventid = rpt.eventid WHERE ev.catid IN(-1,68) AND ev.created >= '2024-09-19 00:00:00' AND ev.created <= '2025-09-14 23:59:59' AND ev.state=1 AND ev.access IN (1) AND icsf.state=1 AND icsf.access IN (1) GROUP BY ev.ev_id ORDER BY ev.created DESC LIMIT 10733μs520B/components/com_jevents/libraries/dbmodel.php:271Copy
  • SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM tifas_jevents_repetition as rpt INNER JOIN tifas_jevents_vevent as ev ON rpt.eventid = ev.ev_id INNER JOIN tifas_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid INNER JOIN tifas_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN tifas_jevents_rrule as rr ON rr.eventid = rpt.eventid WHERE ev.catid IN(-1,68) AND ev.created >= '2024-09-19 00:00:00' AND ev.created <= '2025-09-14 23:59:59' AND ev.state=1 AND ev.access IN (1) AND icsf.state=1 AND icsf.access IN (1) AND ev.ev_id IN (0) ORDER BY ev.created DESC , rpt.startrepeat ASC299μs10.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1318μs736B/administrator/components/com_finder/src/Helper/LanguageHelper.php:134Copy
  • SELECT `title` FROM `tifas_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)123μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM `tifas_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)367μs5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `tifas_banners` AS `a` LEFT JOIN `tifas_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, RAND() LIMIT 1609μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)595μs856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • UPDATE `tifas_banner_tracks` SET `count` = `count` + 1 WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate357μs832BParams/components/com_banners/src/Model/BannersModel.php:352Copy
  • 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 `tifas_scheduler_tasks` AS `a` LEFT JOIN `tifas_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc202μs3.16KBParams/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 `tifas_scheduler_tasks` AS `a` LEFT JOIN `tifas_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc177μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES914μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy