K-Tec

NEOCP objects in TheSkyX

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
11 years 3 weeks 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 3 weeks 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 3 weeks 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 4 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.131 seconds
Powered by Kunena Forum
11MBMemory Usage203msRequest Duration
Joomla! Version4.3.4
PHP Version8.1.31
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" => 1739570325 "last" => 1739570325...
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...
plg_system_webauthn
array:1 [ "returnUrl" => "https://www.irishastronomy.org/kunena/28-computers-in-astronomy/99766-ne...
  • afterLoad (536.65KB) (2.06ms)
  • afterInitialise (1.24MB) (15.78ms)
  • afterRoute (131.69KB) (3.17ms)
  • beforeRenderComponent com_kunena (96.94KB) (1.43ms)
  • Before Access::preloadComponents (all components) (1.54MB) (72.92ms)
  • After Access::preloadComponents (all components) (123.45KB) (1.23ms)
  • Before Access::getAssetRules (id:213 name:com_kunena) (3.66KB) (18μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (7.88KB) (60μs)
  • afterRenderComponent com_kunena (2.04MB) (57.23ms)
  • afterDispatch (19.88KB) (242μs)
  • beforeRenderRawModule mod_cblogin (Login) (80.48KB) (686μs)
  • Before Access::getAssetRules (id:1 name:root.1) (836.09KB) (6.84ms)
  • After Access::getAssetRules (id:1 name:root.1) (1.59KB) (10μs)
  • afterRenderRawModule mod_cblogin (Login) (914.35KB) (12.76ms)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (24μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.98KB) (377μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.34KB) (30μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (166.58KB) (1.09ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.59KB) (10μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1.1MB) (6.68ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.7KB) (90μs)
  • afterRenderRawModule mod_menu (Main Menu) (181.14KB) (1.51ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (27μs)
  • afterRenderRawModule mod_finder (Search) (381.51KB) (2.85ms)
  • beforeRenderRawModule mod_banners (Sponsors) (3.2KB) (26μs)
  • afterRenderRawModule mod_banners (Sponsors) (160.44KB) (3.14ms)
  • beforeRenderRawModule mod_menu (footermenu) (176B) (44μs)
  • afterRenderRawModule mod_menu (footermenu) (59.32KB) (673μs)
  • beforeRenderModule mod_menu (footermenu) (11.5KB) (194μs)
  • afterRenderModule mod_menu (footermenu) (3.59KB) (70μs)
  • beforeRenderModule mod_cblogin (Login) (12.27KB) (60μs)
  • afterRenderModule mod_cblogin (Login) (10.51KB) (50μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (15μs)
  • afterRenderModule mod_custom (Network Online!) (5.32KB) (23μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (13.27KB) (26μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (2.32KB) (20μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.98KB) (98μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (44.56KB) (540μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (39μs)
  • beforeRenderModule mod_banners (Sponsors) (9.25KB) (56μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (24μs)
  • beforeRenderModule mod_finder (Search) (4.17KB) (44μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (21μs)
  • beforeRenderModule mod_menu (Main Menu) (8.5KB) (43μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (20μs)
  • afterRender (806.37KB) (7.44ms)
  • 1 x Before Access::preloadComponents (all components) (1.54MB) (35.84%)
    72.92ms
    1 x afterRenderComponent com_kunena (2.04MB) (28.13%)
    57.23ms
    1 x afterInitialise (1.24MB) (7.75%)
    15.78ms
    1 x afterRenderRawModule mod_cblogin (Login) (914.35KB) (6.27%)
    12.76ms
    1 x afterRender (806.37KB) (3.66%)
    7.44ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (836.09KB) (3.36%)
    6.84ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1.1MB) (3.28%)
    6.68ms
    1 x afterRoute (131.69KB) (1.56%)
    3.17ms
    1 x afterRenderRawModule mod_banners (Sponsors) (160.44KB) (1.54%)
    3.14ms
    1 x afterRenderRawModule mod_finder (Search) (381.51KB) (1.4%)
    2.85ms
    1 x afterLoad (536.65KB) (1.01%)
    2.06ms
    1 x afterRenderRawModule mod_menu (Main Menu) (181.14KB) (0.74%)
    1.51ms
    1 x beforeRenderComponent com_kunena (96.94KB) (0.7%)
    1.43ms
    1 x After Access::preloadComponents (all components) (123.45KB) (0.6%)
    1.23ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (166.58KB) (0.53%)
    1.09ms
    1 x beforeRenderRawModule mod_cblogin (Login) (80.48KB) (0.34%)
    686μs
    1 x afterRenderRawModule mod_menu (footermenu) (59.32KB) (0.33%)
    673μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (44.56KB) (0.27%)
    540μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.98KB) (0.19%)
    377μs
    1 x afterDispatch (19.88KB) (0.12%)
    242μs
    1 x beforeRenderModule mod_menu (footermenu) (11.5KB) (0.1%)
    194μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.98KB) (0.05%)
    98μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.7KB) (0.04%)
    90μs
    1 x afterRenderModule mod_menu (footermenu) (3.59KB) (0.03%)
    70μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (7.88KB) (0.03%)
    60μs
    1 x beforeRenderModule mod_cblogin (Login) (12.27KB) (0.03%)
    60μs
    1 x beforeRenderModule mod_banners (Sponsors) (9.25KB) (0.03%)
    56μs
    1 x afterRenderModule mod_cblogin (Login) (10.51KB) (0.02%)
    50μs
    1 x beforeRenderRawModule mod_menu (footermenu) (176B) (0.02%)
    44μs
    1 x beforeRenderModule mod_finder (Search) (4.17KB) (0.02%)
    44μs
    1 x beforeRenderModule mod_menu (Main Menu) (8.5KB) (0.02%)
    43μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    39μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.34KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (3.2KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (13.27KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.01%)
    24μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.01%)
    24μs
    1 x afterRenderModule mod_custom (Network Online!) (5.32KB) (0.01%)
    23μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    21μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (2.32KB) (0.01%)
    20μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    20μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (3.66KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (Network Online!) (8.96KB) (0.01%)
    15μs
    1 x After Access::getAssetRules (id:1 name:root.1) (1.59KB) (0%)
    10μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.59KB) (0%)
    10μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
118 statements were executed, 10 of which were duplicates, 108 unique30.33ms641.38KB
  • SELECT @@SESSION.sql_mode;101μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?160μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 190μs1.61KBParams/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)543μs944BParams/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` = 1296μs34.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`89μs992B/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` = :guest136μs1.61KBParams/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`749μs4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 1133μs2.14KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 1109μs856B/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`473μs21.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '28-computers-in-astronomy%'135μs1KB/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES720μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC126μs2.22KB/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` = 1203μs1.13KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`342μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`445μs5.39KB/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)663μs8KBParams/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)972μs904B/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)843μs904B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)133μs1.09KB/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`376μs23.77KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`430μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'178μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'341μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'138μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'130μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'122μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'123μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'151μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'117μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'120μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'126μs18.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'114μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'118μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'122μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'119μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'119μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'122μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'140μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'128μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'134μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'159μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'125μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'156μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'131μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'123μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'119μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'122μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'304μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'143μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'135μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'140μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'118μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'333μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'142μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'179μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'331μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'136μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'128μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'123μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'133μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'131μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`390μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '99766'152μs12.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`327μs2.2KB/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` = 99860161μs3.78KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '99766' AND `a`.`hold` IN (0)189μs856B/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 6158μs904B/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)461μs3.81KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (99860,99866,99870,101867)275μs1008B/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)276μs36.02KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99860,99866,99870,101867)122μs2.08KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (99766))300μs1.89KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`532μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`83μs1.25KB/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '99766'348μ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`860μs2.17KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`370μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`120μs1.8KB/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` > '1739568525' GROUP BY `userid` ORDER BY `time` DESC158μs896B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99860)115μs2.08KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99860)100μs2.08KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99866)104μs2.08KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99866)92μs2.08KB/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`216μs1.13KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99870)131μs2.08KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99870)100μs2.08KB/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`230μs1.13KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (101867)107μs2.08KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (101867)246μs2.08KB/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 ASC589μs5.28KBParams/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-02-14 21:58:45') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-02-14 21:58:45') ORDER BY `id` DESC LIMIT 196μs2.05KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SELECT `params` FROM `tifas_comprofiler_plugin` WHERE `id` = 183μs856BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `tifas_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1) AND `type` = 'user' ORDER BY `ordering`193μs18.36KBCopy
  • SHOW FULL COLUMNS FROM `tifas_users`1.09ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT f.* FROM tifas_comprofiler_fields f INNER JOIN tifas_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 ORDER BY t.position, t.ordering, f.ordering612μs4.86KBCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0210μs856BCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=pluginclass&plugin=cbconnect%' OR `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbconnect%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0197μs840BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `tifas_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1) ORDER BY `ordering`177μs18.39KBCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0197μs856BCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0194μs856BCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0196μs856BCopy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`441μs2.2KB/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`380μs5.16KBParams/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 asc180μs904B/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 asc165μs856B/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-08-18 00:00:00' AND ev.created <= '2025-08-13 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 10815μs840B/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-08-18 00:00:00' AND ev.created <= '2025-08-13 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 ASC273μs21.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1275μs1.03KB/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)129μs904B/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)208μs7.89KBParams/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 1500μs2.91KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)540μ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` = :trackDate303μ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` asc195μs4.41KBParams/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` asc189μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES838μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy